PREVIEW / futures_daily / 2019-12-05
file: by_date/futures_daily/2019/2019-12-05.parquet size: 10 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2019-12-05 | ES | Futures | 3367.87 | 3382.75 | 3359.48 | 3375.17 | 1318780.0 |
| 2019-12-05 | NQ | Futures | 9560.77 | 9611.19 | 9534.26 | 9575.75 | 370987.0 |
| 2019-12-05 | YM | Futures | 29020.4 | 29155.8 | 28930.1 | 29056.1 | 164776.0 |
| 2019-12-05 | CL | Futures | 59.59 | 60.37 | 59.33 | 59.66 | 649461.0 |
| 2019-12-05 | GC | Futures | 1820.8 | 1827.8 | 1818.3 | 1824.6 | 240014.0 |
| 2019-12-05 | ZN | Futures | 128.319323 | 128.443198 | 127.932212 | 128.148994 | 26072.0 |
| 2019-12-05 | A6 | Futures | 0.70266 | 0.70348 | 0.69999 | 0.70112 | 101479.0 |
| 2019-12-05 | AD | Futures | 0.76328 | 0.76559 | 0.76317 | 0.76469 | 85957.0 |
| 2019-12-05 | ALI | Futures | 2144.5 | 2144.5 | 2139.03 | 2141.46 | 70.0 |
| 2019-12-05 | B | Futures | 50.79 | 51.54 | 50.61 | 51.13 | 294838.0 |
| 2019-12-05 | B6 | Futures | 1.333 | 1.3391 | 1.3328 | 1.3386 | 114012.0 |
| 2019-12-05 | BR | Futures | 0.19271 | 0.19328 | 0.19178 | 0.19316 | 50.0 |
| 2019-12-05 | BTC | Futures | 10916.0 | 11322.2 | 10803.1 | 11164.3 | 4442.0 |
| 2019-12-05 | BZ | Futures | 50.17 | 50.85 | 49.93 | 50.44 | 38903.0 |
| 2019-12-05 | C | Futures | 1740.0 | 1750.0 | 1732.0 | 1745.0 | 4866.0 |
| 2019-12-05 | CB | Futures | 243.886 | 244.122 | 241.705 | 243.798 | 96.0 |
| 2019-12-05 | CC | Futures | 1674.0 | 1696.0 | 1668.0 | 1688.0 | 14460.0 |
| 2019-12-05 | CNH | Futures | 7.0398 | 7.0455 | 7.0283 | 7.0288 | 626.0 |
| 2019-12-05 | CSC | Futures | 3.398 | 3.398 | 3.342 | 3.342 | 41.0 |
| 2019-12-05 | CT | Futures | 61.54 | 62.03 | 61.27 | 61.36 | 13374.0 |
| 2019-12-05 | DC | Futures | 28.62 | 28.67 | 28.27 | 28.28 | 166.0 |
| 2019-12-05 | DX | Futures | 94.27 | 94.29 | 94.053 | 94.112 | 10055.0 |
| 2019-12-05 | E1 | Futures | 1.16439 | 1.16646 | 1.16324 | 1.166 | 22412.0 |
| 2019-12-05 | E6 | Futures | 1.20125 | 1.20461 | 1.20125 | 1.20374 | 199336.0 |
| 2019-12-05 | E7 | Futures | 1.1952 | 1.1983 | 1.1947 | 1.1975 | 2692.0 |
| 2019-12-05 | EBM | Futures | 202.75 | 203.03 | 200.83 | 201.1 | 19439.0 |
| 2019-12-05 | ED | Futures | 95.3545 | 95.3569 | 95.3472 | 95.352 | 192105.0 |
| 2019-12-05 | ER | Futures | 98.396 | 98.401 | 98.391 | 98.396 | 45342.0 |
| 2019-12-05 | ESG | Futures | 277.95 | 277.95 | 276.69 | 277.67 | 57.0 |
| 2019-12-05 | EW | Futures | 2100.4 | 2109.9 | 2096.4 | 2104.3 | 9628.0 |
| 2019-12-05 | FBON | Futures | 143.06 | 143.06 | 142.23 | 142.39 | 1010.0 |
| 2019-12-05 | FBTP | Futures | 127.99 | 128.14 | 127.01 | 127.09 | 113693.0 |
| 2019-12-05 | FBTS | Futures | 108.066 | 108.076 | 107.807 | 107.826 | 78720.0 |
| 2019-12-05 | FCE | Futures | 5247.5 | 5292.3 | 5243.4 | 5247.5 | 59366.0 |
| 2019-12-05 | FDAX | Futures | 13867.9 | 13918.0 | 13763.5 | 13802.0 | 98633.0 |
| 2019-12-05 | FDIV | Futures | 159.54 | 160.33 | 159.03 | 159.03 | 160.0 |
| 2019-12-05 | FDXM | Futures | 13692.0 | 13735.8 | 13583.7 | 13621.8 | 39540.0 |
| 2019-12-05 | FESX | Futures | 3209.7 | 3229.0 | 3195.7 | 3202.7 | 754593.0 |
| 2019-12-05 | FGBL | Futures | 164.9 | 164.99 | 164.2 | 164.46 | 719291.0 |
| 2019-12-05 | FGBM | Futures | 133.89 | 133.91 | 133.64 | 133.73 | 488141.0 |
| 2019-12-05 | FGBS | Futures | 112.709 | 112.714 | 112.669 | 112.679 | 268075.0 |
| 2019-12-05 | FGBX | Futures | 214.22 | 214.53 | 212.25 | 213.26 | 67343.0 |
| 2019-12-05 | FMWO | Futures | 7572.4 | 7617.9 | 7571.2 | 7588.3 | 2118.0 |
| 2019-12-05 | FOAT | Futures | 152.26 | 152.33 | 151.53 | 151.77 | 231822.0 |
| 2019-12-05 | FTDX | Futures | 3001.3 | 3006.7 | 2996.9 | 3000.3 | 24.0 |
| 2019-12-05 | FTI | Futures | 566.64 | 570.52 | 565.69 | 566.12 | 22061.0 |
| 2019-12-05 | FTUK | Futures | 6667.5 | 6675.4 | 6607.7 | 6619.3 | 111788.0 |
| 2019-12-05 | FVSA | Futures | 141.9 | 145.45 | 139.37 | 143.42 | 24165.0 |
| 2019-12-05 | FXXP | Futures | 365.1 | 366.7 | 363.7 | 364.4 | 50388.0 |
| 2019-12-05 | G | Futures | 120.61 | 120.61 | 120.05 | 120.25 | 204436.0 |
> showing 50 of 119 rows — these rows as CSV