PREVIEW / futures_daily / 2020-11-12
file: by_date/futures_daily/2020/2020-11-12.parquet size: 10 KB rows: 121
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 |
|---|---|---|---|---|---|---|---|
| 2020-11-12 | ES | Futures | 4015.88 | 4015.88 | 3946.79 | 3968.7 | 1685890.0 |
| 2020-11-12 | NQ | Futures | 13775.0 | 13864.43 | 13632.89 | 13684.12 | 554930.0 |
| 2020-11-12 | YM | Futures | 31614.8 | 31615.9 | 31021.6 | 31212.2 | 185689.0 |
| 2020-11-12 | CL | Futures | 29.56 | 30.07 | 29.13 | 29.31 | 401031.0 |
| 2020-11-12 | GC | Futures | 2201.3 | 2223.8 | 2197.5 | 2212.4 | 209934.0 |
| 2020-11-12 | ZN | Futures | 136.498042 | 137.102427 | 136.482545 | 137.024942 | 1742283.0 |
| 2020-11-12 | A6 | Futures | 0.74734 | 0.74888 | 0.74169 | 0.74313 | 80309.0 |
| 2020-11-12 | AD | Futures | 0.77575 | 0.7763 | 0.77068 | 0.77139 | 59819.0 |
| 2020-11-12 | ALI | Futures | 2290.16 | 2294.9 | 2285.42 | 2291.34 | 34.0 |
| 2020-11-12 | B | Futures | 27.55 | 28.04 | 27.26 | 27.43 | 266038.0 |
| 2020-11-12 | B6 | Futures | 1.3412 | 1.3416 | 1.3291 | 1.3304 | 88690.0 |
| 2020-11-12 | BR | Futures | 0.14541 | 0.14682 | 0.14321 | 0.14411 | 7098.0 |
| 2020-11-12 | BTC | Futures | 21115.6 | 21511.6 | 20482.2 | 21432.4 | 6412.0 |
| 2020-11-12 | BZ | Futures | 27.0 | 27.44 | 26.7 | 26.85 | 36578.0 |
| 2020-11-12 | C | Futures | 1421.0 | 1423.0 | 1401.0 | 1419.0 | 2767.0 |
| 2020-11-12 | CB | Futures | 155.254 | 155.762 | 154.491 | 155.762 | 37.0 |
| 2020-11-12 | CC | Futures | 1555.0 | 1558.0 | 1532.0 | 1549.0 | 18331.0 |
| 2020-11-12 | CNH | Futures | 6.4902 | 6.5083 | 6.4766 | 6.4881 | 761.0 |
| 2020-11-12 | CSC | Futures | 3.586 | 3.65 | 3.461 | 3.564 | 174.0 |
| 2020-11-12 | CT | Futures | 68.55 | 68.6 | 67.57 | 67.68 | 25217.0 |
| 2020-11-12 | DC | Futures | 29.73 | 30.32 | 28.44 | 29.4 | 947.0 |
| 2020-11-12 | DX | Futures | 89.806 | 89.955 | 89.598 | 89.792 | 23307.0 |
| 2020-11-12 | E1 | Futures | 1.23594 | 1.24103 | 1.23571 | 1.23888 | 16663.0 |
| 2020-11-12 | E6 | Futures | 1.26225 | 1.26734 | 1.26049 | 1.26563 | 123009.0 |
| 2020-11-12 | E7 | Futures | 1.2561 | 1.2609 | 1.2541 | 1.2592 | 5549.0 |
| 2020-11-12 | EBM | Futures | 253.76 | 255.87 | 252.56 | 252.56 | 24278.0 |
| 2020-11-12 | ED | Futures | 96.4745 | 96.489 | 96.4745 | 96.489 | 127853.0 |
| 2020-11-12 | ER | Futures | 98.45 | 98.455 | 98.445 | 98.45 | 36612.0 |
| 2020-11-12 | ESG | Futures | 329.87 | 330.98 | 326.72 | 327.94 | 588.0 |
| 2020-11-12 | EW | Futures | 2253.2 | 2253.2 | 2192.5 | 2209.5 | 13165.0 |
| 2020-11-12 | FBON | Futures | 148.92 | 149.68 | 148.92 | 149.61 | 408.0 |
| 2020-11-12 | FBTP | Futures | 137.09 | 137.82 | 137.09 | 137.74 | 113516.0 |
| 2020-11-12 | FBTS | Futures | 109.846 | 109.933 | 109.846 | 109.913 | 81212.0 |
| 2020-11-12 | FCE | Futures | 5264.2 | 5279.8 | 5179.8 | 5221.7 | 2639.0 |
| 2020-11-12 | FDAX | Futures | 14094.8 | 14099.6 | 13786.7 | 13931.1 | 71226.0 |
| 2020-11-12 | FDIV | Futures | 154.22 | 154.41 | 154.22 | 154.41 | 100.0 |
| 2020-11-12 | FDXM | Futures | 14023.7 | 14023.7 | 13717.1 | 13860.9 | 49352.0 |
| 2020-11-12 | FESX | Futures | 3203.4 | 3203.4 | 3136.8 | 3172.9 | 1011178.0 |
| 2020-11-12 | FEU3 | Futures | 99.183 | 99.183 | 99.183 | 99.183 | 100.0 |
| 2020-11-12 | FGBL | Futures | 169.63 | 170.16 | 169.47 | 169.94 | 667318.0 |
| 2020-11-12 | FGBM | Futures | 135.14 | 135.29 | 135.08 | 135.2 | 356509.0 |
| 2020-11-12 | FGBS | Futures | 112.78 | 112.8 | 112.754 | 112.775 | 261600.0 |
| 2020-11-12 | FGBX | Futures | 232.16 | 234.25 | 231.55 | 233.39 | 75202.0 |
| 2020-11-12 | FMWO | Futures | 8832.3 | 8908.1 | 8775.4 | 8880.8 | 6175.0 |
| 2020-11-12 | FOAT | Futures | 158.23 | 158.49 | 158.02 | 158.39 | 158410.0 |
| 2020-11-12 | FTDX | Futures | 3098.7 | 3136.8 | 3091.5 | 3115.7 | 320.0 |
| 2020-11-12 | FTI | Futures | 557.23 | 563.68 | 556.67 | 560.54 | 139.0 |
| 2020-11-12 | FTUK | Futures | 6060.5 | 6076.3 | 5978.3 | 6057.6 | 115284.0 |
| 2020-11-12 | FVSA | Futures | 163.19 | 175.03 | 162.82 | 163.19 | 17632.0 |
| 2020-11-12 | FXXP | Futures | 357.4 | 359.0 | 352.9 | 357.1 | 78828.0 |
> showing 50 of 121 rows — these rows as CSV