PREVIEW / futures_daily / 2021-12-03
file: by_date/futures_daily/2021/2021-12-03.parquet size: 10 KB rows: 122
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-03 | ES | Futures | 5160.16 | 5181.81 | 5053.01 | 5104.2 | 2747667.0 |
| 2021-12-03 | NQ | Futures | 18473.39 | 18590.72 | 17917.57 | 18124.85 | 898849.0 |
| 2021-12-03 | YM | Futures | 37771.0 | 37858.1 | 37261.8 | 37608.9 | 269198.0 |
| 2021-12-03 | CL | Futures | 50.77 | 52.06 | 49.34 | 49.84 | 449974.0 |
| 2021-12-03 | GC | Futures | 2064.3 | 2086.0 | 2060.3 | 2081.2 | 175176.0 |
| 2021-12-03 | ZN | Futures | 133.701969 | 134.51238 | 133.36827 | 134.369366 | 21444.0 |
| 2021-12-03 | A6 | Futures | 0.72712 | 0.72722 | 0.71687 | 0.71738 | 114157.0 |
| 2021-12-03 | AD | Futures | 0.79268 | 0.79658 | 0.78968 | 0.7908 | 96724.0 |
| 2021-12-03 | ALI | Futures | 2945.39 | 2956.56 | 2935.33 | 2937.56 | 1441.0 |
| 2021-12-03 | B | Futures | 48.71 | 50.37 | 48.03 | 48.47 | 331824.0 |
| 2021-12-03 | B6 | Futures | 1.3499 | 1.3513 | 1.3408 | 1.3429 | 106933.0 |
| 2021-12-03 | BR | Futures | 0.14319 | 0.14459 | 0.14277 | 0.14352 | 112.0 |
| 2021-12-03 | BTC | Futures | 74733.8 | 75932.8 | 67598.5 | 70166.9 | 11175.0 |
| 2021-12-03 | BZ | Futures | 47.06 | 48.47 | 46.22 | 46.65 | 43639.0 |
| 2021-12-03 | C | Futures | 1392.0 | 1400.0 | 1382.0 | 1385.0 | 1332.0 |
| 2021-12-03 | CB | Futures | 158.402 | 158.402 | 158.402 | 158.402 | 36.0 |
| 2021-12-03 | CC | Futures | 1541.0 | 1558.0 | 1532.0 | 1552.0 | 16485.0 |
| 2021-12-03 | CNH | Futures | 6.1073 | 6.1125 | 6.1017 | 6.1064 | 645.0 |
| 2021-12-03 | CSC | Futures | 2.482 | 2.492 | 2.468 | 2.492 | 10.0 |
| 2021-12-03 | CT | Futures | 100.72 | 102.62 | 100.66 | 101.2 | 12515.0 |
| 2021-12-03 | DC | Futures | 23.57 | 24.0 | 23.57 | 23.89 | 39.0 |
| 2021-12-03 | DX | Futures | 92.902 | 93.187 | 92.699 | 92.867 | 18383.0 |
| 2021-12-03 | E1 | Futures | 1.2172 | 1.22404 | 1.2153 | 1.22079 | 20554.0 |
| 2021-12-03 | E6 | Futures | 1.20102 | 1.20442 | 1.19725 | 1.20203 | 195525.0 |
| 2021-12-03 | E7 | Futures | 1.1945 | 1.1978 | 1.1907 | 1.1955 | 5221.0 |
| 2021-12-03 | EBM | Futures | 425.08 | 425.81 | 414.06 | 415.89 | 1166.0 |
| 2021-12-03 | ED | Futures | 96.5296 | 96.5368 | 96.5247 | 96.5271 | 206107.0 |
| 2021-12-03 | ER | Futures | 98.504 | 98.504 | 98.494 | 98.499 | 87366.0 |
| 2021-12-03 | ESG | Futures | 434.29 | 436.25 | 425.23 | 429.37 | 494.0 |
| 2021-12-03 | EW | Futures | 2943.8 | 2959.9 | 2882.0 | 2905.7 | 23440.0 |
| 2021-12-03 | FBON | Futures | 150.3 | 150.61 | 149.92 | 150.36 | 1715.0 |
| 2021-12-03 | FBTP | Futures | 138.35 | 138.95 | 137.84 | 138.5 | 234817.0 |
| 2021-12-03 | FBTS | Futures | 110.351 | 110.4 | 110.283 | 110.332 | 109542.0 |
| 2021-12-03 | FCE | Futures | 6926.3 | 6952.2 | 6802.9 | 6842.8 | 64897.0 |
| 2021-12-03 | FDAX | Futures | 16327.7 | 16495.5 | 16118.2 | 16164.1 | 92532.0 |
| 2021-12-03 | FDXM | Futures | 16383.8 | 16542.4 | 16164.1 | 16210.1 | 58673.0 |
| 2021-12-03 | FDXS | Futures | 16238.0 | 16388.8 | 16014.0 | 16059.6 | 39706.0 |
| 2021-12-03 | FESX | Futures | 3939.2 | 3976.1 | 3881.8 | 3895.7 | 980209.0 |
| 2021-12-03 | FGBL | Futures | 170.28 | 170.58 | 169.86 | 170.22 | 1122100.0 |
| 2021-12-03 | FGBM | Futures | 135.24 | 135.32 | 135.07 | 135.21 | 871105.0 |
| 2021-12-03 | FGBS | Futures | 112.8 | 112.835 | 112.775 | 112.81 | 446397.0 |
| 2021-12-03 | FGBX | Futures | 236.92 | 238.36 | 235.71 | 236.98 | 176581.0 |
| 2021-12-03 | FMWO | Futures | 11091.6 | 11137.6 | 10891.1 | 10966.6 | 6914.0 |
| 2021-12-03 | FOAT | Futures | 157.36 | 157.75 | 157.11 | 157.44 | 264805.0 |
| 2021-12-03 | FTDX | Futures | 3893.9 | 3924.7 | 3844.6 | 3846.7 | 117.0 |
| 2021-12-03 | FTI | Futures | 749.46 | 750.32 | 732.05 | 736.61 | 22696.0 |
| 2021-12-03 | FTUK | Futures | 7042.3 | 7107.5 | 7002.3 | 7022.5 | 94340.0 |
| 2021-12-03 | FVSA | Futures | 87.07 | 102.1 | 83.27 | 90.07 | 48764.0 |
| 2021-12-03 | FXXP | Futures | 445.2 | 447.3 | 439.0 | 440.6 | 73764.0 |
| 2021-12-03 | G | Futures | 122.78 | 123.36 | 122.6 | 123.05 | 189738.0 |
> showing 50 of 122 rows — these rows as CSV