PREVIEW / futures_daily / 2014-10-31
file: by_date/futures_daily/2014/2014-10-31.parquet size: 9 KB rows: 107
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-10-31 | ES | Futures | 2076.38 | 2106.67 | 2075.33 | 2101.18 | 1924396.0 |
| 2014-10-31 | NQ | Futures | 4741.95 | 4825.4 | 4739.92 | 4810.33 | 313263.0 |
| 2014-10-31 | YM | Futures | 17364.6 | 17607.1 | 17353.4 | 17562.4 | 172671.0 |
| 2014-10-31 | CL | Futures | 155.6 | 156.04 | 152.73 | 154.64 | 294183.0 |
| 2014-10-31 | GC | Futures | 1573.3 | 1577.1 | 1522.2 | 1536.7 | 300192.0 |
| 2014-10-31 | ZN | Futures | 118.671177 | 118.773682 | 118.275802 | 118.422237 | 1391551.0 |
| 2014-10-31 | A6 | Futures | 0.85644 | 0.85693 | 0.84916 | 0.85217 | 136514.0 |
| 2014-10-31 | AD | Futures | 0.90696 | 0.90717 | 0.89528 | 0.90006 | 100070.0 |
| 2014-10-31 | ALI | Futures | 3096.94 | 3096.94 | 3096.94 | 3096.94 | 34.0 |
| 2014-10-31 | B | Futures | 89.37 | 89.64 | 87.94 | 89.27 | 111854.0 |
| 2014-10-31 | B6 | Futures | 1.6814 | 1.6825 | 1.6751 | 1.6802 | 101253.0 |
| 2014-10-31 | BFX | Futures | 3788.4 | 3833.4 | 3787.9 | 3814.3 | 53.0 |
| 2014-10-31 | BR | Futures | 0.22241 | 0.22241 | 0.21615 | 0.21709 | 26374.0 |
| 2014-10-31 | BZ | Futures | 90.48 | 90.48 | 88.83 | 90.18 | 9662.0 |
| 2014-10-31 | C | Futures | 2061.0 | 2064.0 | 2024.0 | 2034.0 | 5455.0 |
| 2014-10-31 | CB | Futures | 135.078 | 135.656 | 135.078 | 135.463 | 7.0 |
| 2014-10-31 | CC | Futures | 2170.0 | 2176.0 | 2132.0 | 2140.0 | 16590.0 |
| 2014-10-31 | CNH | Futures | 7.0277 | 7.0476 | 7.0277 | 7.0437 | 2.0 |
| 2014-10-31 | CSC | Futures | 4.959 | 4.964 | 4.893 | 4.893 | 29.0 |
| 2014-10-31 | CT | Futures | 81.65 | 82.14 | 80.16 | 81.67 | 18698.0 |
| 2014-10-31 | DC | Futures | 40.12 | 40.39 | 39.35 | 39.53 | 389.0 |
| 2014-10-31 | DX | Futures | 81.875 | 82.819 | 81.856 | 82.602 | 64771.0 |
| 2014-10-31 | E1 | Futures | 1.33786 | 1.33837 | 1.32379 | 1.32878 | 64540.0 |
| 2014-10-31 | E6 | Futures | 1.48504 | 1.48539 | 1.47009 | 1.47492 | 356853.0 |
| 2014-10-31 | E7 | Futures | 1.4759 | 1.4759 | 1.4608 | 1.4656 | 5596.0 |
| 2014-10-31 | ED | Futures | 95.4422 | 95.447 | 95.4374 | 95.4374 | 57246.0 |
| 2014-10-31 | ER | Futures | 97.984 | 97.994 | 97.979 | 97.989 | 26610.0 |
| 2014-10-31 | EW | Futures | 1458.2 | 1479.6 | 1457.4 | 1475.2 | 25911.0 |
| 2014-10-31 | FBTP | Futures | 94.91 | 95.48 | 94.83 | 95.21 | 92004.0 |
| 2014-10-31 | FBTS | Futures | 98.188 | 98.348 | 98.188 | 98.277 | 16976.0 |
| 2014-10-31 | FCE | Futures | 3388.8 | 3425.9 | 3371.1 | 3413.0 | 137515.0 |
| 2014-10-31 | FDAX | Futures | 10195.3 | 10235.9 | 10096.8 | 10197.5 | 145173.0 |
| 2014-10-31 | FDIV | Futures | 132.1 | 133.26 | 132.1 | 133.26 | 17.0 |
| 2014-10-31 | FESX | Futures | 2233.2 | 2255.0 | 2212.2 | 2246.3 | 1551552.0 |
| 2014-10-31 | FGBL | Futures | 132.81 | 133.16 | 132.63 | 132.95 | 814480.0 |
| 2014-10-31 | FGBM | Futures | 122.98 | 123.18 | 122.95 | 123.09 | 450478.0 |
| 2014-10-31 | FGBS | Futures | 110.908 | 110.953 | 110.898 | 110.928 | 206877.0 |
| 2014-10-31 | FGBX | Futures | 145.14 | 145.8 | 144.42 | 144.94 | 34267.0 |
| 2014-10-31 | FMWO | Futures | 5669.9 | 5691.2 | 5669.9 | 5678.6 | 220.0 |
| 2014-10-31 | FOAT | Futures | 122.22 | 122.78 | 122.22 | 122.6 | 112718.0 |
| 2014-10-31 | FTDX | Futures | 1171.9 | 1181.9 | 1169.6 | 1173.8 | 285.0 |
| 2014-10-31 | FTI | Futures | 357.28 | 359.73 | 355.26 | 358.85 | 36064.0 |
| 2014-10-31 | FTUK | Futures | 4994.4 | 5055.9 | 4989.8 | 5030.0 | 123368.0 |
| 2014-10-31 | FVSA | Futures | 1612.49 | 1637.49 | 1574.99 | 1620.82 | 5275.0 |
| 2014-10-31 | FXXP | Futures | 255.3 | 255.6 | 252.6 | 254.7 | 11070.0 |
| 2014-10-31 | G | Futures | 98.68 | 98.89 | 98.57 | 98.63 | 164604.0 |
| 2014-10-31 | GF | Futures | 368.199 | 370.077 | 365.616 | 366.516 | 3084.0 |
| 2014-10-31 | GSCI | Futures | 909.44 | 918.69 | 907.14 | 917.93 | 375.0 |
| 2014-10-31 | HE | Futures | 118.103 | 118.978 | 117.363 | 118.473 | 12231.0 |
| 2014-10-31 | HG | Futures | 3.8813 | 3.9232 | 3.8553 | 3.8648 | 57960.0 |
> showing 50 of 107 rows — these rows as CSV