PREVIEW / futures_daily / 2015-12-28
file: by_date/futures_daily/2015/2015-12-28.parquet size: 9 KB rows: 102
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-28 | ES | Futures | 2191.01 | 2194.49 | 2173.92 | 2188.34 | 696448.0 |
| 2015-12-28 | NQ | Futures | 5405.51 | 5415.48 | 5359.2 | 5408.73 | 113567.0 |
| 2015-12-28 | YM | Futures | 18060.4 | 18086.2 | 17944.5 | 18044.9 | 67110.0 |
| 2015-12-28 | CL | Futures | 56.52 | 56.65 | 54.44 | 54.75 | 220644.0 |
| 2015-12-28 | GC | Futures | 1386.7 | 1388.3 | 1374.4 | 1377.8 | 70863.0 |
| 2015-12-28 | ZN | Futures | 121.385506 | 121.686338 | 121.310298 | 121.550964 | 327705.0 |
| 2015-12-28 | A6 | Futures | 0.72654 | 0.72715 | 0.72354 | 0.72394 | 23923.0 |
| 2015-12-28 | AD | Futures | 0.73914 | 0.73965 | 0.73484 | 0.73597 | 23663.0 |
| 2015-12-28 | ALI | Futures | 2203.52 | 2203.52 | 2203.52 | 2203.52 | 0.0 |
| 2015-12-28 | B | Futures | 33.02 | 33.13 | 31.82 | 32.0 | 33597.0 |
| 2015-12-28 | B6 | Futures | 1.5704 | 1.5717 | 1.5653 | 1.5665 | 30531.0 |
| 2015-12-28 | BR | Futures | 0.15592 | 0.1595 | 0.15592 | 0.1595 | 502.0 |
| 2015-12-28 | BZ | Futures | 32.73 | 32.95 | 31.54 | 31.66 | 5778.0 |
| 2015-12-28 | CB | Futures | 254.69 | 254.844 | 254.69 | 254.844 | 14.0 |
| 2015-12-28 | CC | Futures | 2367.0 | 2376.0 | 2352.0 | 2355.0 | 5653.0 |
| 2015-12-28 | CNH | Futures | 7.26 | 7.2852 | 7.26 | 7.2836 | 6.0 |
| 2015-12-28 | CSC | Futures | 3.77 | 3.856 | 3.77 | 3.853 | 64.0 |
| 2015-12-28 | CT | Futures | 74.57 | 75.48 | 74.25 | 74.93 | 12018.0 |
| 2015-12-28 | DC | Futures | 29.72 | 30.9 | 29.72 | 30.47 | 183.0 |
| 2015-12-28 | DX | Futures | 91.518 | 91.598 | 91.392 | 91.5 | 10771.0 |
| 2015-12-28 | E1 | Futures | 1.2842 | 1.28559 | 1.27953 | 1.28281 | 7141.0 |
| 2015-12-28 | E6 | Futures | 1.28461 | 1.28812 | 1.28367 | 1.28613 | 71560.0 |
| 2015-12-28 | E7 | Futures | 1.2768 | 1.281 | 1.2766 | 1.2789 | 2502.0 |
| 2015-12-28 | EBM | Futures | 245.78 | 246.48 | 244.01 | 244.36 | 6623.0 |
| 2015-12-28 | ED | Futures | 95.5591 | 95.5639 | 95.5543 | 95.5543 | 60329.0 |
| 2015-12-28 | ER | Futures | 98.205 | 98.22 | 98.205 | 98.215 | 8571.0 |
| 2015-12-28 | EW | Futures | 1487.9 | 1488.8 | 1471.6 | 1486.4 | 13147.0 |
| 2015-12-28 | FBON | Futures | 114.94 | 115.13 | 114.94 | 115.13 | 9.0 |
| 2015-12-28 | FBTP | Futures | 104.19 | 104.69 | 104.19 | 104.66 | 24073.0 |
| 2015-12-28 | FBTS | Futures | 100.597 | 100.757 | 100.597 | 100.739 | 8572.0 |
| 2015-12-28 | FCE | Futures | 3893.6 | 3910.3 | 3857.2 | 3862.2 | 39012.0 |
| 2015-12-28 | FDAX | Futures | 11632.6 | 11683.6 | 11525.2 | 11550.7 | 43020.0 |
| 2015-12-28 | FDXM | Futures | 11125.0 | 11171.7 | 11020.3 | 11043.1 | 7004.0 |
| 2015-12-28 | FESX | Futures | 2493.9 | 2500.0 | 2465.8 | 2469.6 | 329484.0 |
| 2015-12-28 | FEU3 | Futures | 98.873 | 98.873 | 98.873 | 98.873 | 12.0 |
| 2015-12-28 | FGBL | Futures | 139.26 | 140.14 | 139.15 | 140.05 | 171648.0 |
| 2015-12-28 | FGBM | Futures | 125.4 | 125.6 | 125.33 | 125.58 | 103848.0 |
| 2015-12-28 | FGBS | Futures | 111.398 | 111.418 | 111.388 | 111.418 | 62740.0 |
| 2015-12-28 | FGBX | Futures | 155.95 | 158.52 | 155.95 | 158.36 | 10417.0 |
| 2015-12-28 | FMWO | Futures | 5627.9 | 5627.9 | 5603.0 | 5606.7 | 369.0 |
| 2015-12-28 | FOAT | Futures | 127.51 | 128.31 | 127.46 | 128.22 | 22831.0 |
| 2015-12-28 | FTDX | Futures | 1742.0 | 1742.0 | 1731.5 | 1737.2 | 79.0 |
| 2015-12-28 | FTI | Futures | 388.33 | 389.51 | 383.83 | 384.88 | 11861.0 |
| 2015-12-28 | FVSA | Futures | 2173.9 | 2239.78 | 2159.78 | 2230.37 | 5087.0 |
| 2015-12-28 | FXXP | Futures | 288.5 | 289.6 | 284.7 | 285.1 | 11147.0 |
| 2015-12-28 | GF | Futures | 315.552 | 317.337 | 312.318 | 313.959 | 2293.0 |
| 2015-12-28 | GSCI | Futures | 486.61 | 486.61 | 483.55 | 484.02 | 102.0 |
| 2015-12-28 | HE | Futures | 84.002 | 85.58 | 83.787 | 84.827 | 8612.0 |
| 2015-12-28 | HG | Futures | 2.6671 | 2.6683 | 2.6031 | 2.6069 | 23076.0 |
| 2015-12-28 | HH | Futures | 23.054 | 24.457 | 23.054 | 24.349 | 6389.0 |
> showing 50 of 102 rows — these rows as CSV