PREVIEW / futures_daily / 2014-03-31
file: by_date/futures_daily/2014/2014-03-31.parquet size: 9 KB rows: 105
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2014-03-31 | ES | Futures | 1919.25 | 1932.7 | 1919.25 | 1929.08 | 1572419.0 |
| 2014-03-31 | NQ | Futures | 4112.32 | 4156.93 | 4112.32 | 4128.15 | 297696.0 |
| 2014-03-31 | YM | Futures | 16342.7 | 16471.3 | 16342.7 | 16440.1 | 136908.0 |
| 2014-03-31 | CL | Futures | 181.47 | 181.97 | 180.03 | 181.28 | 167570.0 |
| 2014-03-31 | GC | Futures | 1706.3 | 1711.9 | 1690.1 | 1691.5 | 133250.0 |
| 2014-03-31 | ZN | Futures | 114.461151 | 114.548073 | 114.156926 | 114.504612 | 1290581.0 |
| 2014-03-31 | A6 | Futures | 0.88415 | 0.88674 | 0.88107 | 0.88626 | 71009.0 |
| 2014-03-31 | AD | Futures | 0.91522 | 0.91988 | 0.91451 | 0.91633 | 60257.0 |
| 2014-03-31 | B | Futures | 111.42 | 111.76 | 110.46 | 111.18 | 88661.0 |
| 2014-03-31 | B6 | Futures | 1.7486 | 1.7526 | 1.745 | 1.7512 | 86889.0 |
| 2014-03-31 | BFX | Futures | 3790.8 | 3790.8 | 3786.5 | 3786.5 | 15.0 |
| 2014-03-31 | BR | Futures | 0.22854 | 0.23004 | 0.22809 | 0.22865 | 1300.0 |
| 2014-03-31 | BZ | Futures | 113.42 | 113.92 | 112.58 | 113.31 | 7766.0 |
| 2014-03-31 | C | Futures | 1970.0 | 1987.0 | 1953.0 | 1958.0 | 11111.0 |
| 2014-03-31 | CB | Futures | 95.18 | 95.192 | 95.065 | 95.065 | 13.0 |
| 2014-03-31 | CC | Futures | 2206.0 | 2231.0 | 2186.0 | 2194.0 | 20713.0 |
| 2014-03-31 | CNH | Futures | 7.1299 | 7.1372 | 7.1299 | 7.1331 | 11.0 |
| 2014-03-31 | CSC | Futures | 4.475 | 4.488 | 4.462 | 4.479 | 28.0 |
| 2014-03-31 | CT | Futures | 105.55 | 106.55 | 103.98 | 105.11 | 11572.0 |
| 2014-03-31 | DC | Futures | 35.58 | 35.62 | 35.34 | 35.46 | 125.0 |
| 2014-03-31 | DX | Futures | 76.335 | 76.548 | 76.111 | 76.243 | 21111.0 |
| 2014-03-31 | E1 | Futures | 1.4479 | 1.45522 | 1.44418 | 1.45252 | 34574.0 |
| 2014-03-31 | E6 | Futures | 1.62336 | 1.63009 | 1.61935 | 1.62608 | 209837.0 |
| 2014-03-31 | E7 | Futures | 1.6125 | 1.6195 | 1.6087 | 1.6152 | 4548.0 |
| 2014-03-31 | EBM | Futures | 295.22 | 297.34 | 292.4 | 292.76 | 17701.0 |
| 2014-03-31 | ED | Futures | 95.3995 | 95.4043 | 95.3947 | 95.3947 | 90748.0 |
| 2014-03-31 | ER | Futures | 97.847 | 97.852 | 97.837 | 97.842 | 89596.0 |
| 2014-03-31 | EW | Futures | 1399.2 | 1420.9 | 1399.2 | 1418.7 | 20582.0 |
| 2014-03-31 | FBTP | Futures | 87.2 | 87.38 | 86.95 | 87.27 | 45471.0 |
| 2014-03-31 | FBTS | Futures | 97.249 | 97.284 | 97.188 | 97.276 | 10231.0 |
| 2014-03-31 | FCE | Futures | 3439.2 | 3445.4 | 3411.9 | 3414.7 | 95259.0 |
| 2014-03-31 | FDAX | Futures | 10647.8 | 10662.1 | 10559.4 | 10586.5 | 89061.0 |
| 2014-03-31 | FESX | Futures | 2239.1 | 2242.7 | 2220.5 | 2226.9 | 863296.0 |
| 2014-03-31 | FEU3 | Futures | 98.458 | 98.463 | 98.458 | 98.463 | 5.0 |
| 2014-03-31 | FGBL | Futures | 123.88 | 123.99 | 123.42 | 123.73 | 768860.0 |
| 2014-03-31 | FGBM | Futures | 119.72 | 119.83 | 119.48 | 119.64 | 468806.0 |
| 2014-03-31 | FGBS | Futures | 110.548 | 110.573 | 110.483 | 110.518 | 366937.0 |
| 2014-03-31 | FGBX | Futures | 127.09 | 127.31 | 126.42 | 126.91 | 16865.0 |
| 2014-03-31 | FMWO | Futures | 5515.3 | 5530.4 | 5515.3 | 5530.4 | 42.0 |
| 2014-03-31 | FOAT | Futures | 112.86 | 113.0 | 112.45 | 112.77 | 55482.0 |
| 2014-03-31 | FTDX | Futures | 1173.3 | 1180.8 | 1172.8 | 1175.2 | 88.0 |
| 2014-03-31 | FTI | Futures | 343.94 | 345.69 | 343.64 | 344.32 | 25717.0 |
| 2014-03-31 | FTUK | Futures | 5004.7 | 5034.1 | 4973.8 | 4989.5 | 112345.0 |
| 2014-03-31 | FVSA | Futures | 1795.53 | 1810.57 | 1765.43 | 1790.51 | 4518.0 |
| 2014-03-31 | FXXP | Futures | 247.9 | 248.3 | 246.5 | 247.0 | 9509.0 |
| 2014-03-31 | G | Futures | 93.47 | 93.5 | 93.12 | 93.38 | 163110.0 |
| 2014-03-31 | GF | Futures | 285.399 | 286.239 | 283.198 | 283.398 | 1399.0 |
| 2014-03-31 | GSCI | Futures | 1072.73 | 1074.72 | 1065.79 | 1072.73 | 489.0 |
| 2014-03-31 | HE | Futures | 142.547 | 145.346 | 142.547 | 144.646 | 368.0 |
| 2014-03-31 | HG | Futures | 3.8614 | 3.8652 | 3.8272 | 3.8342 | 41031.0 |
> showing 50 of 105 rows — these rows as CSV