PREVIEW / futures_daily / 2015-09-18
file: by_date/futures_daily/2015/2015-09-18.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 |
|---|---|---|---|---|---|---|---|
| 2015-09-18 | ES | Futures | 2102.51 | 2109.42 | 2065.01 | 2074.85 | 2423501.0 |
| 2015-09-18 | NQ | Futures | 5110.61 | 5124.06 | 5027.01 | 5058.87 | 333044.0 |
| 2015-09-18 | YM | Futures | 17081.1 | 17131.6 | 16750.9 | 16836.5 | 227179.0 |
| 2015-09-18 | CL | Futures | 75.76 | 76.04 | 71.62 | 72.31 | 283487.0 |
| 2015-09-18 | GC | Futures | 1458.7 | 1473.5 | 1454.7 | 1468.8 | 151718.0 |
| 2015-09-18 | ZN | Futures | 122.090016 | 122.628847 | 122.075049 | 122.583944 | 1103335.0 |
| 2015-09-18 | A6 | Futures | 0.71383 | 0.72473 | 0.71353 | 0.71873 | 93325.0 |
| 2015-09-18 | AD | Futures | 0.7768 | 0.78695 | 0.77404 | 0.77732 | 85155.0 |
| 2015-09-18 | ALI | Futures | 2207.73 | 2207.73 | 2207.73 | 2207.73 | 0.0 |
| 2015-09-18 | B | Futures | 44.64 | 45.09 | 42.74 | 43.02 | 225724.0 |
| 2015-09-18 | B6 | Futures | 1.6406 | 1.6482 | 1.6331 | 1.6371 | 94924.0 |
| 2015-09-18 | BFX | Futures | 4100.4 | 4118.4 | 4100.4 | 4118.4 | 1.0 |
| 2015-09-18 | BR | Futures | 0.15558 | 0.15558 | 0.15256 | 0.15256 | 173.0 |
| 2015-09-18 | BZ | Futures | 44.6 | 45.13 | 42.75 | 43.02 | 20464.0 |
| 2015-09-18 | C | Futures | 2339.0 | 2361.0 | 2336.0 | 2354.0 | 8266.0 |
| 2015-09-18 | CB | Futures | 193.378 | 193.87 | 193.378 | 193.87 | 7.0 |
| 2015-09-18 | CC | Futures | 2414.0 | 2450.0 | 2414.0 | 2428.0 | 15339.0 |
| 2015-09-18 | CNH | Futures | 7.172 | 7.172 | 7.1481 | 7.1501 | 82.0 |
| 2015-09-18 | CSC | Futures | 4.401 | 4.401 | 4.368 | 4.381 | 6.0 |
| 2015-09-18 | CT | Futures | 75.63 | 75.63 | 72.85 | 73.24 | 20.0 |
| 2015-09-18 | DC | Futures | 34.86 | 34.99 | 34.83 | 34.88 | 33.0 |
| 2015-09-18 | DX | Futures | 88.616 | 89.35 | 88.097 | 88.846 | 35456.0 |
| 2015-09-18 | E1 | Futures | 1.32273 | 1.33529 | 1.31093 | 1.31968 | 18500.0 |
| 2015-09-18 | E6 | Futures | 1.3393 | 1.34434 | 1.32196 | 1.33169 | 233620.0 |
| 2015-09-18 | E7 | Futures | 1.3318 | 1.3369 | 1.3148 | 1.3243 | 4967.0 |
| 2015-09-18 | EBM | Futures | 243.71 | 245.17 | 241.15 | 244.44 | 26409.0 |
| 2015-09-18 | ED | Futures | 95.7015 | 95.7208 | 95.6967 | 95.7159 | 263959.0 |
| 2015-09-18 | ER | Futures | 98.122 | 98.126 | 98.122 | 98.122 | 56918.0 |
| 2015-09-18 | EW | Futures | 1507.8 | 1511.9 | 1480.5 | 1486.2 | 20910.0 |
| 2015-09-18 | FBTP | Futures | 101.53 | 102.24 | 101.45 | 102.01 | 111814.0 |
| 2015-09-18 | FBTS | Futures | 100.15 | 100.293 | 100.114 | 100.257 | 26955.0 |
| 2015-09-18 | FCE | Futures | 3854.1 | 3862.8 | 3734.5 | 3768.7 | 147729.0 |
| 2015-09-18 | FDAX | Futures | 11234.5 | 11254.9 | 10856.2 | 10913.4 | 155165.0 |
| 2015-09-18 | FESX | Futures | 2424.5 | 2425.3 | 2342.8 | 2354.8 | 2064268.0 |
| 2015-09-18 | FEU3 | Futures | 98.774 | 98.774 | 98.774 | 98.774 | 4.0 |
| 2015-09-18 | FGBL | Futures | 137.71 | 138.32 | 137.61 | 138.01 | 736018.0 |
| 2015-09-18 | FGBM | Futures | 124.89 | 125.04 | 124.84 | 124.96 | 446893.0 |
| 2015-09-18 | FGBS | Futures | 111.223 | 111.263 | 111.198 | 111.253 | 314301.0 |
| 2015-09-18 | FGBX | Futures | 155.64 | 157.9 | 155.61 | 156.67 | 33447.0 |
| 2015-09-18 | FMWO | Futures | 5492.6 | 5492.6 | 5423.4 | 5438.2 | 679.0 |
| 2015-09-18 | FOAT | Futures | 125.9 | 126.63 | 125.9 | 126.4 | 91636.0 |
| 2015-09-18 | FTDX | Futures | 1671.3 | 1679.9 | 1657.1 | 1666.1 | 731.0 |
| 2015-09-18 | FTI | Futures | 378.46 | 379.07 | 367.17 | 371.08 | 58099.0 |
| 2015-09-18 | FTUK | Futures | 4950.4 | 4950.4 | 4847.9 | 4878.0 | 149492.0 |
| 2015-09-18 | FVSA | Futures | 2311.72 | 2459.67 | 2260.86 | 2367.2 | 23294.0 |
| 2015-09-18 | FXXP | Futures | 279.3 | 279.4 | 273.7 | 275.4 | 33594.0 |
| 2015-09-18 | G | Futures | 104.48 | 104.79 | 104.29 | 104.62 | 190206.0 |
| 2015-09-18 | GF | Futures | 333.625 | 334.424 | 327.81 | 329.94 | 5053.0 |
| 2015-09-18 | GSCI | Futures | 590.38 | 591.69 | 583.53 | 583.61 | 13.0 |
| 2015-09-18 | HE | Futures | 95.795 | 96.543 | 94.636 | 95.945 | 12203.0 |
> showing 50 of 107 rows — these rows as CSV