PREVIEW / futures_daily / 2015-06-18
file: by_date/futures_daily/2015/2015-06-18.parquet size: 9 KB rows: 106
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-06-18 | ES | Futures | 2213.96 | 2246.02 | 2206.54 | 2241.25 | 1902148.0 |
| 2015-06-18 | NQ | Futures | 5200.42 | 5294.7 | 5183.78 | 5289.74 | 275557.0 |
| 2015-06-18 | YM | Futures | 18313.8 | 18587.0 | 18257.4 | 18531.6 | 166272.0 |
| 2015-06-18 | CL | Futures | 100.38 | 102.43 | 99.66 | 101.58 | 171476.0 |
| 2015-06-18 | GC | Futures | 1546.6 | 1574.6 | 1545.1 | 1569.8 | 190686.0 |
| 2015-06-18 | ZN | Futures | 120.258072 | 120.720087 | 119.781153 | 120.04942 | 1599281.0 |
| 2015-06-18 | A6 | Futures | 0.76397 | 0.77397 | 0.7601 | 0.76852 | 87637.0 |
| 2015-06-18 | AD | Futures | 0.83498 | 0.84203 | 0.83355 | 0.83477 | 74021.0 |
| 2015-06-18 | ALI | Futures | 2341.57 | 2341.57 | 2341.57 | 2341.57 | 0.0 |
| 2015-06-18 | B | Futures | 59.97 | 61.11 | 59.68 | 60.46 | 217210.0 |
| 2015-06-18 | B6 | Futures | 1.6658 | 1.676 | 1.6626 | 1.6696 | 109529.0 |
| 2015-06-18 | BFX | Futures | 4296.9 | 4335.0 | 4296.9 | 4335.0 | 30.0 |
| 2015-06-18 | BR | Futures | 0.1916 | 0.19211 | 0.19109 | 0.19109 | 58.0 |
| 2015-06-18 | BZ | Futures | 60.14 | 61.23 | 59.81 | 60.58 | 18570.0 |
| 2015-06-18 | C | Futures | 2294.0 | 2321.0 | 2289.0 | 2318.0 | 4393.0 |
| 2015-06-18 | CB | Futures | 159.258 | 159.764 | 159.258 | 159.258 | 17.0 |
| 2015-06-18 | CC | Futures | 2388.0 | 2422.0 | 2383.0 | 2419.0 | 17052.0 |
| 2015-06-18 | CSC | Futures | 4.528 | 4.531 | 4.45 | 4.457 | 149.0 |
| 2015-06-18 | CT | Futures | 80.87 | 81.16 | 80.38 | 80.72 | 4082.0 |
| 2015-06-18 | DC | Futures | 36.72 | 36.72 | 35.64 | 35.67 | 403.0 |
| 2015-06-18 | DX | Futures | 88.32 | 88.404 | 87.337 | 88.218 | 52556.0 |
| 2015-06-18 | E1 | Futures | 1.3818 | 1.39221 | 1.3776 | 1.38167 | 26231.0 |
| 2015-06-18 | E6 | Futures | 1.33397 | 1.34513 | 1.33244 | 1.33726 | 269124.0 |
| 2015-06-18 | E7 | Futures | 1.326 | 1.3378 | 1.3252 | 1.3299 | 5748.0 |
| 2015-06-18 | EBM | Futures | 290.2 | 293.07 | 289.79 | 292.25 | 5509.0 |
| 2015-06-18 | ED | Futures | 95.6079 | 95.6222 | 95.6031 | 95.6079 | 259464.0 |
| 2015-06-18 | ER | Futures | 98.053 | 98.073 | 98.048 | 98.063 | 141512.0 |
| 2015-06-18 | EW | Futures | 1598.0 | 1620.0 | 1594.6 | 1616.8 | 18458.0 |
| 2015-06-18 | FBTP | Futures | 96.22 | 96.74 | 95.9 | 96.48 | 98840.0 |
| 2015-06-18 | FBTS | Futures | 99.207 | 99.367 | 99.1 | 99.234 | 21570.0 |
| 2015-06-18 | FCE | Futures | 3960.7 | 4057.0 | 3921.2 | 3997.0 | 59767.0 |
| 2015-06-18 | FDAX | Futures | 12030.2 | 12489.5 | 11951.7 | 12286.1 | 79151.0 |
| 2015-06-18 | FESX | Futures | 2512.5 | 2616.2 | 2492.6 | 2551.0 | 1291580.0 |
| 2015-06-18 | FEU3 | Futures | 98.7 | 98.705 | 98.7 | 98.705 | 12.0 |
| 2015-06-18 | FGBL | Futures | 135.67 | 136.03 | 134.36 | 135.14 | 763319.0 |
| 2015-06-18 | FGBM | Futures | 123.92 | 123.92 | 123.49 | 123.7 | 511941.0 |
| 2015-06-18 | FGBS | Futures | 111.158 | 111.173 | 111.128 | 111.153 | 213782.0 |
| 2015-06-18 | FGBX | Futures | 153.73 | 155.16 | 150.67 | 152.56 | 30541.0 |
| 2015-06-18 | FMWO | Futures | 5832.3 | 5900.0 | 5832.3 | 5900.0 | 1821.0 |
| 2015-06-18 | FOAT | Futures | 123.22 | 123.78 | 122.56 | 123.19 | 125675.0 |
| 2015-06-18 | FTDX | Futures | 1522.2 | 1563.2 | 1502.0 | 1544.4 | 140.0 |
| 2015-06-18 | FTI | Futures | 409.48 | 418.13 | 405.33 | 412.8 | 20821.0 |
| 2015-06-18 | FTUK | Futures | 5254.7 | 5318.7 | 5224.9 | 5286.9 | 111329.0 |
| 2015-06-18 | FVSA | Futures | 1943.87 | 2040.46 | 1871.43 | 1931.8 | 15656.0 |
| 2015-06-18 | FXXP | Futures | 292.3 | 297.7 | 289.6 | 294.1 | 36459.0 |
| 2015-06-18 | G | Futures | 101.42 | 101.91 | 100.86 | 101.26 | 186382.0 |
| 2015-06-18 | GF | Futures | 382.543 | 382.586 | 376.72 | 377.315 | 4979.0 |
| 2015-06-18 | GSCI | Futures | 731.65 | 731.65 | 727.24 | 729.57 | 19.0 |
| 2015-06-18 | HE | Futures | 84.842 | 85.304 | 84.216 | 84.869 | 12274.0 |
| 2015-06-18 | HG | Futures | 3.2672 | 3.3022 | 3.2523 | 3.2591 | 16132.0 |
> showing 50 of 106 rows — these rows as CSV