PREVIEW / futures_daily / 2015-08-24
file: by_date/futures_daily/2015/2015-08-24.parquet size: 9 KB rows: 108
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-08-24 | ES | Futures | 2082.01 | 2082.28 | 1940.53 | 1983.18 | 5258752.0 |
| 2015-08-24 | NQ | Futures | 4884.61 | 4899.2 | 4562.96 | 4673.87 | 746533.0 |
| 2015-08-24 | YM | Futures | 16848.3 | 16855.5 | 15698.0 | 16133.5 | 556006.0 |
| 2015-08-24 | CL | Futures | 65.73 | 66.01 | 61.57 | 62.37 | 468366.0 |
| 2015-08-24 | GC | Futures | 1497.7 | 1510.1 | 1478.2 | 1489.2 | 264142.0 |
| 2015-08-24 | ZN | Futures | 122.896029 | 123.894578 | 122.791703 | 123.238815 | 2440534.0 |
| 2015-08-24 | A6 | Futures | 0.72296 | 0.72356 | 0.69661 | 0.70939 | 171624.0 |
| 2015-08-24 | AD | Futures | 0.77588 | 0.78119 | 0.76923 | 0.77168 | 114864.0 |
| 2015-08-24 | ALI | Futures | 2074.5 | 2074.5 | 2074.5 | 2074.5 | 0.0 |
| 2015-08-24 | B | Futures | 41.98 | 42.08 | 39.09 | 39.51 | 305733.0 |
| 2015-08-24 | B6 | Futures | 1.6509 | 1.6632 | 1.6449 | 1.6602 | 152621.0 |
| 2015-08-24 | BFX | Futures | 4054.4 | 4054.4 | 3898.4 | 3952.8 | 16.0 |
| 2015-08-24 | BR | Futures | 0.16778 | 0.16919 | 0.16718 | 0.16802 | 4140.0 |
| 2015-08-24 | BZ | Futures | 41.94 | 42.03 | 39.04 | 39.48 | 38819.0 |
| 2015-08-24 | C | Futures | 2167.0 | 2196.0 | 2117.0 | 2186.0 | 4260.0 |
| 2015-08-24 | CB | Futures | 189.245 | 189.245 | 187.966 | 187.966 | 4.0 |
| 2015-08-24 | CC | Futures | 2239.0 | 2279.0 | 2192.0 | 2264.0 | 36760.0 |
| 2015-08-24 | CNH | Futures | 7.2976 | 7.3255 | 7.2932 | 7.3255 | 42.0 |
| 2015-08-24 | CSC | Futures | 4.462 | 4.462 | 4.407 | 4.424 | 38.0 |
| 2015-08-24 | CT | Futures | 81.63 | 81.63 | 79.1 | 79.1 | 18.0 |
| 2015-08-24 | DC | Futures | 35.97 | 36.07 | 35.26 | 35.3 | 268.0 |
| 2015-08-24 | DX | Futures | 88.816 | 88.891 | 86.607 | 87.389 | 142820.0 |
| 2015-08-24 | E1 | Futures | 1.3418 | 1.37253 | 1.33964 | 1.36414 | 44248.0 |
| 2015-08-24 | E6 | Futures | 1.33702 | 1.37661 | 1.33608 | 1.3631 | 563021.0 |
| 2015-08-24 | E7 | Futures | 1.3298 | 1.3737 | 1.3288 | 1.3556 | 18883.0 |
| 2015-08-24 | EBM | Futures | 269.71 | 269.71 | 263.97 | 268.07 | 6452.0 |
| 2015-08-24 | ED | Futures | 95.6582 | 95.6798 | 95.6558 | 95.675 | 351194.0 |
| 2015-08-24 | ER | Futures | 98.122 | 98.126 | 98.117 | 98.122 | 58997.0 |
| 2015-08-24 | EW | Futures | 1487.8 | 1487.8 | 1384.7 | 1412.0 | 55982.0 |
| 2015-08-24 | FBTP | Futures | 100.97 | 101.02 | 100.37 | 100.53 | 95021.0 |
| 2015-08-24 | FBTS | Futures | 100.053 | 100.053 | 99.981 | 99.99 | 15772.0 |
| 2015-08-24 | FCE | Futures | 3761.3 | 3803.6 | 3538.6 | 3670.5 | 335491.0 |
| 2015-08-24 | FDAX | Futures | 10841.2 | 10984.9 | 10300.6 | 10646.6 | 243408.0 |
| 2015-08-24 | FDIV | Futures | 131.13 | 131.13 | 130.39 | 130.39 | 23.0 |
| 2015-08-24 | FESX | Futures | 2321.6 | 2359.4 | 2184.0 | 2269.8 | 3378387.0 |
| 2015-08-24 | FEU3 | Futures | 98.769 | 98.769 | 98.764 | 98.764 | 5.0 |
| 2015-08-24 | FGBL | Futures | 139.17 | 139.62 | 138.44 | 138.9 | 777408.0 |
| 2015-08-24 | FGBM | Futures | 125.22 | 125.26 | 124.99 | 125.07 | 472994.0 |
| 2015-08-24 | FGBS | Futures | 111.313 | 111.318 | 111.288 | 111.293 | 309399.0 |
| 2015-08-24 | FGBX | Futures | 162.16 | 163.74 | 160.25 | 161.85 | 40415.0 |
| 2015-08-24 | FMWO | Futures | 5338.8 | 5357.2 | 5181.2 | 5261.2 | 3071.0 |
| 2015-08-24 | FOAT | Futures | 126.16 | 126.81 | 125.71 | 126.19 | 77259.0 |
| 2015-08-24 | FTDX | Futures | 1481.3 | 1520.8 | 1411.6 | 1485.5 | 1515.0 |
| 2015-08-24 | FTI | Futures | 370.97 | 372.52 | 344.72 | 361.12 | 100097.0 |
| 2015-08-24 | FTUK | Futures | 4769.5 | 4818.3 | 4579.1 | 4691.6 | 339940.0 |
| 2015-08-24 | FVSA | Futures | 2569.91 | 2574.18 | 2232.66 | 2356.46 | 38964.0 |
| 2015-08-24 | FXXP | Futures | 268.2 | 270.7 | 253.7 | 262.3 | 65048.0 |
| 2015-08-24 | G | Futures | 104.82 | 105.26 | 104.27 | 104.59 | 381438.0 |
| 2015-08-24 | GF | Futures | 343.105 | 345.433 | 337.243 | 341.51 | 3789.0 |
| 2015-08-24 | GSCI | Futures | 560.11 | 563.9 | 550.54 | 555.32 | 400.0 |
> showing 50 of 108 rows — these rows as CSV