PREVIEW / futures_daily / 2015-08-12
file: by_date/futures_daily/2015/2015-08-12.parquet size: 9 KB rows: 104
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-12 | ES | Futures | 2205.22 | 2209.98 | 2168.92 | 2208.92 | 2364321.0 |
| 2015-08-12 | NQ | Futures | 5268.72 | 5295.28 | 5173.57 | 5292.95 | 358454.0 |
| 2015-08-12 | YM | Futures | 17833.2 | 17866.1 | 17540.5 | 17836.3 | 214480.0 |
| 2015-08-12 | CL | Futures | 71.84 | 72.84 | 71.06 | 71.89 | 492271.0 |
| 2015-08-12 | GC | Futures | 1430.6 | 1452.9 | 1421.4 | 1450.4 | 193697.0 |
| 2015-08-12 | ZN | Futures | 121.927288 | 122.746992 | 121.808058 | 122.061421 | 1579174.0 |
| 2015-08-12 | A6 | Futures | 0.72237 | 0.73049 | 0.71325 | 0.7293 | 170615.0 |
| 2015-08-12 | AD | Futures | 0.77966 | 0.78937 | 0.777 | 0.78682 | 88057.0 |
| 2015-08-12 | ALI | Futures | 2182.5 | 2182.5 | 2182.5 | 2182.5 | 0.0 |
| 2015-08-12 | B | Futures | 46.11 | 46.77 | 45.61 | 46.45 | 264689.0 |
| 2015-08-12 | B6 | Futures | 1.6388 | 1.6479 | 1.6347 | 1.643 | 105502.0 |
| 2015-08-12 | BR | Futures | 0.16922 | 0.17203 | 0.16778 | 0.17125 | 2476.0 |
| 2015-08-12 | BZ | Futures | 46.14 | 46.73 | 45.57 | 46.4 | 24271.0 |
| 2015-08-12 | C | Futures | 2194.0 | 2197.0 | 2151.0 | 2158.0 | 5201.0 |
| 2015-08-12 | CC | Futures | 2261.0 | 2275.0 | 2228.0 | 2238.0 | 29333.0 |
| 2015-08-12 | CNH | Futures | 7.2249 | 7.3891 | 7.2234 | 7.3158 | 19.0 |
| 2015-08-12 | CSC | Futures | 4.445 | 4.46 | 4.432 | 4.46 | 85.0 |
| 2015-08-12 | CT | Futures | 76.74 | 80.41 | 75.59 | 80.41 | 103.0 |
| 2015-08-12 | DC | Futures | 35.64 | 35.75 | 35.47 | 35.75 | 199.0 |
| 2015-08-12 | DX | Futures | 91.021 | 91.152 | 89.813 | 90.141 | 68809.0 |
| 2015-08-12 | E1 | Futures | 1.2858 | 1.31373 | 1.28516 | 1.30472 | 31103.0 |
| 2015-08-12 | E6 | Futures | 1.29767 | 1.31811 | 1.29555 | 1.3127 | 312509.0 |
| 2015-08-12 | E7 | Futures | 1.2905 | 1.3107 | 1.2885 | 1.3055 | 6460.0 |
| 2015-08-12 | EBM | Futures | 291.43 | 296.35 | 286.92 | 288.97 | 16712.0 |
| 2015-08-12 | ED | Futures | 95.627 | 95.651 | 95.627 | 95.6366 | 293756.0 |
| 2015-08-12 | ER | Futures | 98.117 | 98.122 | 98.117 | 98.122 | 21677.0 |
| 2015-08-12 | EW | Futures | 1564.2 | 1568.6 | 1536.5 | 1562.0 | 23606.0 |
| 2015-08-12 | FBTP | Futures | 101.7 | 101.83 | 100.79 | 101.46 | 68059.0 |
| 2015-08-12 | FBTS | Futures | 100.204 | 100.222 | 100.159 | 100.195 | 10118.0 |
| 2015-08-12 | FCE | Futures | 4254.2 | 4254.2 | 4111.4 | 4126.5 | 1707.0 |
| 2015-08-12 | FDAX | Futures | 12381.7 | 12383.9 | 12041.8 | 12100.9 | 156756.0 |
| 2015-08-12 | FESX | Futures | 2653.2 | 2653.2 | 2569.5 | 2584.3 | 2259610.0 |
| 2015-08-12 | FGBL | Futures | 138.5 | 138.72 | 138.12 | 138.55 | 630362.0 |
| 2015-08-12 | FGBM | Futures | 125.06 | 125.12 | 124.97 | 125.07 | 398120.0 |
| 2015-08-12 | FGBS | Futures | 111.318 | 111.338 | 111.308 | 111.323 | 224426.0 |
| 2015-08-12 | FGBX | Futures | 159.32 | 160.35 | 158.2 | 159.32 | 33142.0 |
| 2015-08-12 | FMWO | Futures | 5737.5 | 5737.5 | 5706.7 | 5721.5 | 251.0 |
| 2015-08-12 | FOAT | Futures | 126.65 | 126.9 | 126.32 | 126.54 | 66789.0 |
| 2015-08-12 | FTDX | Futures | 1649.9 | 1649.9 | 1597.6 | 1616.4 | 497.0 |
| 2015-08-12 | FTI | Futures | 420.84 | 420.84 | 407.71 | 409.52 | 265.0 |
| 2015-08-12 | FTUK | Futures | 5230.1 | 5238.0 | 5158.5 | 5184.4 | 141639.0 |
| 2015-08-12 | FVSA | Futures | 1754.54 | 1878.34 | 1754.54 | 1839.92 | 8689.0 |
| 2015-08-12 | FXXP | Futures | 300.0 | 300.0 | 292.7 | 293.6 | 32195.0 |
| 2015-08-12 | G | Futures | 103.73 | 103.96 | 103.2 | 103.6 | 183385.0 |
| 2015-08-12 | GF | Futures | 363.321 | 367.028 | 360.605 | 362.2 | 3319.0 |
| 2015-08-12 | GSCI | Futures | 607.11 | 612.47 | 607.11 | 608.51 | 2051.0 |
| 2015-08-12 | HE | Futures | 85.978 | 87.653 | 85.944 | 86.661 | 16314.0 |
| 2015-08-12 | HG | Futures | 2.9153 | 2.9428 | 2.861 | 2.9328 | 81071.0 |
| 2015-08-12 | HH | Futures | 35.028 | 35.935 | 35.028 | 35.935 | 4149.0 |
| 2015-08-12 | HO | Futures | 1.2537 | 1.2839 | 1.2464 | 1.2752 | 67213.0 |
> showing 50 of 104 rows — these rows as CSV