PREVIEW / futures_daily / 2020-11-03
file: by_date/futures_daily/2020/2020-11-03.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 |
|---|---|---|---|---|---|---|---|
| 2020-11-03 | ES | Futures | 3711.98 | 3800.45 | 3708.89 | 3776.58 | 1664690.0 |
| 2020-11-03 | NQ | Futures | 12821.34 | 13136.52 | 12809.47 | 13042.46 | 509496.0 |
| 2020-11-03 | YM | Futures | 28908.3 | 29642.5 | 28859.9 | 29472.4 | 179266.0 |
| 2020-11-03 | CL | Futures | 26.4 | 27.32 | 26.07 | 26.85 | 410611.0 |
| 2020-11-03 | GC | Futures | 2239.7 | 2258.3 | 2229.3 | 2256.2 | 171368.0 |
| 2020-11-03 | ZN | Futures | 137.179913 | 137.210907 | 136.82348 | 136.962954 | 1270460.0 |
| 2020-11-03 | A6 | Futures | 0.72393 | 0.73666 | 0.72168 | 0.73328 | 118970.0 |
| 2020-11-03 | AD | Futures | 0.76637 | 0.77342 | 0.76587 | 0.76946 | 76475.0 |
| 2020-11-03 | ALI | Futures | 2235.07 | 2273.87 | 2235.07 | 2273.87 | 86.0 |
| 2020-11-03 | B | Futures | 24.74 | 25.49 | 24.35 | 25.02 | 278628.0 |
| 2020-11-03 | B6 | Futures | 1.3099 | 1.3267 | 1.3099 | 1.3211 | 96430.0 |
| 2020-11-03 | BR | Futures | 0.13637 | 0.13904 | 0.13625 | 0.13664 | 8247.0 |
| 2020-11-03 | BTC | Futures | 18119.9 | 18410.2 | 17671.2 | 18271.6 | 3731.0 |
| 2020-11-03 | BZ | Futures | 24.19 | 24.94 | 23.84 | 24.49 | 39534.0 |
| 2020-11-03 | C | Futures | 1402.0 | 1418.0 | 1391.0 | 1416.0 | 7459.0 |
| 2020-11-03 | CB | Futures | 152.459 | 154.237 | 152.459 | 153.729 | 8.0 |
| 2020-11-03 | CC | Futures | 1484.0 | 1507.0 | 1476.0 | 1504.0 | 18691.0 |
| 2020-11-03 | CNH | Futures | 6.5664 | 6.5718 | 6.5523 | 6.5653 | 3081.0 |
| 2020-11-03 | CSC | Futures | 3.868 | 3.933 | 3.868 | 3.913 | 94.0 |
| 2020-11-03 | CT | Futures | 67.93 | 69.5 | 67.92 | 69.42 | 18580.0 |
| 2020-11-03 | DC | Futures | 31.76 | 32.49 | 31.63 | 32.2 | 514.0 |
| 2020-11-03 | DX | Futures | 90.834 | 90.859 | 90.12 | 90.376 | 18238.0 |
| 2020-11-03 | E1 | Futures | 1.23401 | 1.24352 | 1.23333 | 1.24239 | 19735.0 |
| 2020-11-03 | E6 | Futures | 1.24801 | 1.25877 | 1.24774 | 1.25508 | 155328.0 |
| 2020-11-03 | E7 | Futures | 1.2417 | 1.2524 | 1.2414 | 1.2487 | 5361.0 |
| 2020-11-03 | EBM | Futures | 248.94 | 250.45 | 246.23 | 247.43 | 22931.0 |
| 2020-11-03 | ED | Futures | 96.4939 | 96.4939 | 96.4842 | 96.4842 | 98043.0 |
| 2020-11-03 | ER | Futures | 98.46 | 98.46 | 98.455 | 98.455 | 31106.0 |
| 2020-11-03 | ESG | Futures | 309.54 | 314.05 | 309.43 | 312.51 | 842.0 |
| 2020-11-03 | EW | Futures | 2065.7 | 2121.4 | 2065.1 | 2113.1 | 13072.0 |
| 2020-11-03 | FBON | Futures | 149.42 | 149.87 | 149.4 | 149.76 | 316.0 |
| 2020-11-03 | FBTP | Futures | 136.86 | 137.42 | 136.77 | 137.23 | 94209.0 |
| 2020-11-03 | FBTS | Futures | 109.74 | 109.817 | 109.72 | 109.788 | 59353.0 |
| 2020-11-03 | FCE | Futures | 4571.4 | 4678.2 | 4567.5 | 4643.4 | 78415.0 |
| 2020-11-03 | FDAX | Futures | 12583.0 | 12983.8 | 12583.0 | 12869.8 | 85627.0 |
| 2020-11-03 | FDIV | Futures | 140.66 | 141.66 | 140.62 | 141.66 | 300.0 |
| 2020-11-03 | FDXM | Futures | 12505.7 | 12918.4 | 12505.7 | 12804.9 | 58335.0 |
| 2020-11-03 | FESX | Futures | 2794.8 | 2882.6 | 2794.8 | 2861.3 | 1171913.0 |
| 2020-11-03 | FGBL | Futures | 171.44 | 171.52 | 170.99 | 171.18 | 584729.0 |
| 2020-11-03 | FGBM | Futures | 135.83 | 135.84 | 135.69 | 135.74 | 281887.0 |
| 2020-11-03 | FGBS | Futures | 112.94 | 112.95 | 112.92 | 112.93 | 211728.0 |
| 2020-11-03 | FGBX | Futures | 239.28 | 239.46 | 237.54 | 238.34 | 68017.0 |
| 2020-11-03 | FMWO | Futures | 8217.5 | 8388.1 | 8217.5 | 8373.9 | 3712.0 |
| 2020-11-03 | FOAT | Futures | 159.21 | 159.31 | 158.91 | 159.18 | 158873.0 |
| 2020-11-03 | FTDX | Futures | 2928.4 | 2980.4 | 2928.4 | 2960.3 | 136.0 |
| 2020-11-03 | FTI | Futures | 507.24 | 516.11 | 506.36 | 513.71 | 25013.0 |
| 2020-11-03 | FTUK | Futures | 5404.3 | 5528.1 | 5404.3 | 5501.3 | 98019.0 |
| 2020-11-03 | FVSA | Futures | 213.29 | 214.36 | 198.26 | 205.06 | 18350.0 |
| 2020-11-03 | FXXP | Futures | 323.4 | 330.8 | 323.2 | 329.1 | 86109.0 |
| 2020-11-03 | G | Futures | 126.83 | 126.83 | 126.2 | 126.27 | 274813.0 |
> showing 50 of 120 rows — these rows as CSV