PREVIEW / futures_daily / 2015-07-01
file: by_date/futures_daily/2015/2015-07-01.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-07-01 | ES | Futures | 2177.39 | 2201.77 | 2177.39 | 2194.88 | 1252317.0 |
| 2015-07-01 | NQ | Futures | 5128.62 | 5185.83 | 5127.74 | 5162.77 | 155244.0 |
| 2015-07-01 | YM | Futures | 18014.0 | 18192.7 | 18005.7 | 18148.5 | 106283.0 |
| 2015-07-01 | CL | Futures | 98.51 | 98.51 | 94.67 | 95.14 | 297050.0 |
| 2015-07-01 | GC | Futures | 1531.1 | 1533.8 | 1523.7 | 1527.1 | 144729.0 |
| 2015-07-01 | ZN | Futures | 120.153746 | 120.213361 | 119.497982 | 119.676827 | 1206973.0 |
| 2015-07-01 | A6 | Futures | 0.75991 | 0.76347 | 0.75347 | 0.75416 | 80620.0 |
| 2015-07-01 | AD | Futures | 0.81759 | 0.81811 | 0.81074 | 0.81126 | 79482.0 |
| 2015-07-01 | ALI | Futures | 2360.52 | 2360.52 | 2360.52 | 2360.52 | 0.0 |
| 2015-07-01 | B | Futures | 59.18 | 59.41 | 57.94 | 58.13 | 200673.0 |
| 2015-07-01 | B6 | Futures | 1.6516 | 1.6556 | 1.6398 | 1.6412 | 64146.0 |
| 2015-07-01 | BFX | Futures | 4416.1 | 4435.4 | 4400.3 | 4404.0 | 9.0 |
| 2015-07-01 | BR | Futures | 0.18845 | 0.18878 | 0.18557 | 0.18665 | 336.0 |
| 2015-07-01 | BZ | Futures | 59.18 | 59.37 | 57.94 | 58.09 | 22364.0 |
| 2015-07-01 | C | Futures | 2302.0 | 2334.0 | 2296.0 | 2329.0 | 4613.0 |
| 2015-07-01 | CB | Futures | 158.042 | 158.447 | 156.846 | 156.846 | 7.0 |
| 2015-07-01 | CC | Futures | 2387.0 | 2422.0 | 2382.0 | 2409.0 | 14398.0 |
| 2015-07-01 | CNH | Futures | 7.0097 | 7.0097 | 7.0097 | 7.0097 | 87.0 |
| 2015-07-01 | CSC | Futures | 4.414 | 4.465 | 4.389 | 4.442 | 10.0 |
| 2015-07-01 | CT | Futures | 83.95 | 83.95 | 81.76 | 82.36 | 327.0 |
| 2015-07-01 | DC | Futures | 35.41 | 36.16 | 35.3 | 35.99 | 46.0 |
| 2015-07-01 | DX | Futures | 89.673 | 90.384 | 89.527 | 90.341 | 45906.0 |
| 2015-07-01 | E1 | Futures | 1.36199 | 1.363 | 1.34154 | 1.3418 | 16189.0 |
| 2015-07-01 | E6 | Futures | 1.30918 | 1.31423 | 1.29861 | 1.29919 | 174067.0 |
| 2015-07-01 | E7 | Futures | 1.3017 | 1.3069 | 1.2913 | 1.292 | 6278.0 |
| 2015-07-01 | EBM | Futures | 335.7 | 338.98 | 328.32 | 329.55 | 23337.0 |
| 2015-07-01 | ED | Futures | 95.6318 | 95.6366 | 95.6175 | 95.627 | 250539.0 |
| 2015-07-01 | ER | Futures | 98.082 | 98.087 | 98.073 | 98.082 | 55411.0 |
| 2015-07-01 | EW | Futures | 1572.9 | 1589.6 | 1569.6 | 1575.6 | 17290.0 |
| 2015-07-01 | FBTP | Futures | 96.42 | 97.42 | 96.38 | 96.87 | 97760.0 |
| 2015-07-01 | FBTS | Futures | 99.261 | 99.447 | 99.261 | 99.367 | 21665.0 |
| 2015-07-01 | FCE | Futures | 4033.2 | 4117.8 | 4007.8 | 4067.4 | 169737.0 |
| 2015-07-01 | FDAX | Futures | 12247.9 | 12478.4 | 12136.8 | 12345.8 | 135268.0 |
| 2015-07-01 | FDIV | Futures | 151.03 | 152.7 | 151.03 | 151.82 | 16.0 |
| 2015-07-01 | FESX | Futures | 2554.7 | 2613.2 | 2539.9 | 2582.9 | 1609910.0 |
| 2015-07-01 | FGBL | Futures | 135.62 | 135.81 | 134.81 | 135.22 | 721060.0 |
| 2015-07-01 | FGBM | Futures | 124.05 | 124.16 | 123.89 | 124.05 | 630960.0 |
| 2015-07-01 | FGBS | Futures | 111.213 | 111.238 | 111.198 | 111.228 | 389055.0 |
| 2015-07-01 | FGBX | Futures | 150.93 | 151.26 | 147.87 | 149.41 | 30488.0 |
| 2015-07-01 | FMWO | Futures | 5768.3 | 5815.0 | 5767.0 | 5781.8 | 768.0 |
| 2015-07-01 | FOAT | Futures | 123.44 | 123.52 | 122.64 | 122.92 | 88526.0 |
| 2015-07-01 | FTDX | Futures | 1559.9 | 1585.3 | 1559.9 | 1570.7 | 174.0 |
| 2015-07-01 | FTI | Futures | 416.07 | 424.41 | 413.67 | 421.44 | 59905.0 |
| 2015-07-01 | FTUK | Futures | 5161.7 | 5234.4 | 5161.7 | 5203.8 | 138417.0 |
| 2015-07-01 | FVSA | Futures | 2100.83 | 2100.83 | 1903.63 | 1939.85 | 20602.0 |
| 2015-07-01 | FXXP | Futures | 294.1 | 298.7 | 293.4 | 296.6 | 18967.0 |
| 2015-07-01 | G | Futures | 101.29 | 101.35 | 100.41 | 100.81 | 151921.0 |
| 2015-07-01 | GF | Futures | 364.011 | 372.682 | 364.011 | 371.492 | 3744.0 |
| 2015-07-01 | GSCI | Futures | 730.82 | 730.82 | 719.23 | 719.82 | 842.0 |
| 2015-07-01 | HE | Futures | 82.884 | 84.699 | 82.884 | 83.61 | 17664.0 |
> showing 50 of 106 rows — these rows as CSV