PREVIEW / futures_daily / 2019-12-06
file: by_date/futures_daily/2019/2019-12-06.parquet size: 10 KB rows: 120
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-06 | ES | Futures | 3375.17 | 3411.17 | 3374.36 | 3405.76 | 1300299.0 |
| 2019-12-06 | NQ | Futures | 9577.77 | 9691.28 | 9574.02 | 9680.62 | 302782.0 |
| 2019-12-06 | YM | Futures | 29066.6 | 29435.1 | 29053.0 | 29408.8 | 150639.0 |
| 2019-12-06 | CL | Futures | 59.55 | 61.11 | 58.92 | 60.45 | 679609.0 |
| 2019-12-06 | GC | Futures | 1822.0 | 1827.3 | 1800.3 | 1802.5 | 317315.0 |
| 2019-12-06 | ZN | Futures | 128.056088 | 128.210932 | 127.529618 | 127.746399 | 20825.0 |
| 2019-12-06 | A6 | Futures | 0.70122 | 0.70379 | 0.7003 | 0.70173 | 106802.0 |
| 2019-12-06 | AD | Futures | 0.76443 | 0.76484 | 0.75909 | 0.7595 | 113656.0 |
| 2019-12-06 | ALI | Futures | 2148.14 | 2148.45 | 2148.14 | 2148.45 | 45.0 |
| 2019-12-06 | B | Futures | 51.14 | 52.33 | 50.67 | 51.93 | 314600.0 |
| 2019-12-06 | B6 | Futures | 1.3385 | 1.3391 | 1.3324 | 1.3361 | 131398.0 |
| 2019-12-06 | BR | Futures | 0.19344 | 0.19531 | 0.19344 | 0.19494 | 127.0 |
| 2019-12-06 | BTC | Futures | 11186.8 | 11517.8 | 11036.4 | 11224.4 | 3514.0 |
| 2019-12-06 | BZ | Futures | 50.36 | 51.61 | 50.0 | 51.24 | 43303.0 |
| 2019-12-06 | C | Futures | 1761.0 | 1780.0 | 1755.0 | 1763.0 | 2514.0 |
| 2019-12-06 | CB | Futures | 243.798 | 243.798 | 242.943 | 242.943 | 18.0 |
| 2019-12-06 | CC | Futures | 1694.0 | 1737.0 | 1692.0 | 1705.0 | 20889.0 |
| 2019-12-06 | CNH | Futures | 7.0272 | 7.0358 | 7.0098 | 7.0098 | 1464.0 |
| 2019-12-06 | CSC | Futures | 3.346 | 3.346 | 3.312 | 3.331 | 49.0 |
| 2019-12-06 | CT | Futures | 61.36 | 63.08 | 61.36 | 62.78 | 24205.0 |
| 2019-12-06 | DC | Futures | 28.11 | 28.27 | 27.96 | 28.2 | 131.0 |
| 2019-12-06 | DX | Futures | 94.12 | 94.541 | 93.946 | 94.392 | 26388.0 |
| 2019-12-06 | E1 | Futures | 1.16588 | 1.1668 | 1.16048 | 1.16266 | 30424.0 |
| 2019-12-06 | E6 | Futures | 1.20412 | 1.20472 | 1.19708 | 1.19887 | 240326.0 |
| 2019-12-06 | E7 | Futures | 1.198 | 1.1984 | 1.1909 | 1.1926 | 3003.0 |
| 2019-12-06 | EBM | Futures | 200.83 | 201.93 | 200.83 | 201.38 | 14479.0 |
| 2019-12-06 | ED | Futures | 95.3496 | 95.352 | 95.3326 | 95.3423 | 191280.0 |
| 2019-12-06 | ER | Futures | 98.391 | 98.396 | 98.391 | 98.391 | 20475.0 |
| 2019-12-06 | ESG | Futures | 278.27 | 280.28 | 278.27 | 280.09 | 2.0 |
| 2019-12-06 | EW | Futures | 2105.6 | 2132.6 | 2105.5 | 2125.0 | 14354.0 |
| 2019-12-06 | FBON | Futures | 142.34 | 142.51 | 142.09 | 142.32 | 990.0 |
| 2019-12-06 | FBTP | Futures | 127.11 | 127.55 | 126.94 | 127.39 | 76712.0 |
| 2019-12-06 | FBTS | Futures | 107.836 | 107.999 | 107.768 | 107.932 | 52460.0 |
| 2019-12-06 | FCE | Futures | 5271.5 | 5314.9 | 5258.8 | 5314.0 | 57760.0 |
| 2019-12-06 | FDAX | Futures | 13810.4 | 13906.4 | 13764.5 | 13894.8 | 84721.0 |
| 2019-12-06 | FDIV | Futures | 159.03 | 160.06 | 159.03 | 160.06 | 50.0 |
| 2019-12-06 | FDXM | Futures | 13635.8 | 13726.4 | 13585.8 | 13713.4 | 36888.0 |
| 2019-12-06 | FESX | Futures | 3206.2 | 3239.5 | 3203.6 | 3236.0 | 735695.0 |
| 2019-12-06 | FGBL | Futures | 164.46 | 164.71 | 164.12 | 164.37 | 567095.0 |
| 2019-12-06 | FGBM | Futures | 133.72 | 133.8 | 133.62 | 133.69 | 337109.0 |
| 2019-12-06 | FGBS | Futures | 112.684 | 112.694 | 112.664 | 112.684 | 167211.0 |
| 2019-12-06 | FGBX | Futures | 213.11 | 213.95 | 212.19 | 212.67 | 45693.0 |
| 2019-12-06 | FMWO | Futures | 7613.3 | 7670.2 | 7608.8 | 7665.6 | 3550.0 |
| 2019-12-06 | FOAT | Futures | 151.7 | 151.84 | 151.36 | 151.61 | 126260.0 |
| 2019-12-06 | FTDX | Futures | 2990.9 | 3014.6 | 2988.0 | 3014.6 | 60.0 |
| 2019-12-06 | FTI | Futures | 569.37 | 577.37 | 568.37 | 576.58 | 30649.0 |
| 2019-12-06 | FTUK | Futures | 6635.0 | 6715.7 | 6625.3 | 6710.6 | 93098.0 |
| 2019-12-06 | FVSA | Futures | 140.38 | 142.41 | 134.3 | 136.84 | 23537.0 |
| 2019-12-06 | FXXP | Futures | 365.4 | 368.8 | 364.8 | 368.7 | 38029.0 |
| 2019-12-06 | G | Futures | 120.21 | 120.61 | 120.14 | 120.37 | 163438.0 |
> showing 50 of 120 rows — these rows as CSV