prices = load 'NYSE_daily' as (exchange, symbol, date, open, high, low, close,
volume, adj_close);
gain = foreach prices generate close - open;
volume, adj_close);
gain = foreach prices generate close - open;
gain2 = foreach prices generate $6 - $3;
Field references can be by name (as shown in the preceding example) or by position. Posi-
tional references are preceded by a $ (dollar sign) and start from 0: