PREVIEW / futures_daily / 2021-11-17
file: by_date/futures_daily/2021/2021-11-17.parquet size: 10 KB rows: 123
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-11-17 | ES | Futures | 5283.05 | 5288.12 | 5263.65 | 5271.52 | 1056696.0 |
| 2021-11-17 | NQ | Futures | 18793.68 | 18907.55 | 18761.68 | 18809.53 | 455992.0 |
| 2021-11-17 | YM | Futures | 39249.7 | 39283.4 | 38975.5 | 39024.5 | 133056.0 |
| 2021-11-17 | CL | Futures | 59.87 | 59.95 | 57.86 | 58.33 | 504939.0 |
| 2021-11-17 | GC | Futures | 2160.2 | 2182.3 | 2159.6 | 2181.9 | 172417.0 |
| 2021-11-17 | ZN | Futures | 132.367174 | 132.812105 | 132.255941 | 132.669092 | 1289899.0 |
| 2021-11-17 | A6 | Futures | 0.74849 | 0.7489 | 0.74409 | 0.74429 | 79540.0 |
| 2021-11-17 | AD | Futures | 0.80811 | 0.80948 | 0.8042 | 0.80476 | 69525.0 |
| 2021-11-17 | ALI | Futures | 2885.86 | 2945.39 | 2882.79 | 2940.64 | 983.0 |
| 2021-11-17 | B | Futures | 56.09 | 56.21 | 54.54 | 54.88 | 406749.0 |
| 2021-11-17 | B6 | Futures | 1.3626 | 1.37 | 1.3599 | 1.3689 | 83782.0 |
| 2021-11-17 | BFX | Futures | 4370.7 | 4370.7 | 4365.6 | 4365.6 | 34.0 |
| 2021-11-17 | BR | Futures | 0.14687 | 0.1482 | 0.14634 | 0.14646 | 6526.0 |
| 2021-11-17 | BTC | Futures | 79962.4 | 80212.7 | 77031.3 | 79679.2 | 6300.0 |
| 2021-11-17 | BZ | Futures | 54.96 | 54.98 | 53.25 | 53.59 | 38038.0 |
| 2021-11-17 | C | Futures | 1447.0 | 1457.0 | 1442.0 | 1447.0 | 1276.0 |
| 2021-11-17 | CB | Futures | 153.009 | 154.447 | 152.871 | 153.659 | 29.0 |
| 2021-11-17 | CC | Futures | 1611.0 | 1627.0 | 1601.0 | 1616.0 | 19914.0 |
| 2021-11-17 | CNH | Futures | 6.1306 | 6.1332 | 6.1146 | 6.1161 | 180.0 |
| 2021-11-17 | CSC | Futures | 2.319 | 2.324 | 2.305 | 2.306 | 178.0 |
| 2021-11-17 | CT | Futures | 110.05 | 113.52 | 109.77 | 111.72 | 8447.0 |
| 2021-11-17 | DC | Futures | 22.24 | 22.41 | 22.08 | 22.11 | 584.0 |
| 2021-11-17 | DX | Futures | 92.685 | 93.018 | 92.491 | 92.592 | 18176.0 |
| 2021-11-17 | E1 | Futures | 1.20477 | 1.20813 | 1.20119 | 1.2069 | 23333.0 |
| 2021-11-17 | E6 | Futures | 1.20336 | 1.20458 | 1.19725 | 1.20272 | 196271.0 |
| 2021-11-17 | E7 | Futures | 1.1968 | 1.1979 | 1.1907 | 1.1961 | 4405.0 |
| 2021-11-17 | EBM | Futures | 425.81 | 437.94 | 424.71 | 434.26 | 21251.0 |
| 2021-11-17 | ED | Futures | 96.5223 | 96.5247 | 96.515 | 96.5223 | 177744.0 |
| 2021-11-17 | ER | Futures | 98.499 | 98.504 | 98.494 | 98.499 | 67983.0 |
| 2021-11-17 | ESG | Futures | 442.45 | 442.45 | 440.67 | 441.26 | 487.0 |
| 2021-11-17 | EW | Futures | 3128.6 | 3129.5 | 3088.3 | 3105.0 | 11225.0 |
| 2021-11-17 | FBON | Futures | 148.76 | 148.96 | 148.57 | 148.65 | 85.0 |
| 2021-11-17 | FBTP | Futures | 137.96 | 138.26 | 137.64 | 137.83 | 104941.0 |
| 2021-11-17 | FBTS | Futures | 110.361 | 110.38 | 110.303 | 110.351 | 39861.0 |
| 2021-11-17 | FCE | Futures | 7227.4 | 7245.2 | 7213.3 | 7233.0 | 68718.0 |
| 2021-11-17 | FDAX | Futures | 17357.0 | 17399.7 | 17320.6 | 17365.5 | 41867.0 |
| 2021-11-17 | FDIV | Futures | 187.75 | 188.24 | 187.75 | 188.24 | 20.0 |
| 2021-11-17 | FDXM | Futures | 17405.3 | 17448.2 | 17372.1 | 17414.9 | 23304.0 |
| 2021-11-17 | FDXS | Futures | 17258.6 | 17286.2 | 17211.8 | 17253.3 | 11214.0 |
| 2021-11-17 | FESX | Futures | 4209.8 | 4216.9 | 4202.1 | 4209.3 | 478534.0 |
| 2021-11-17 | FGBL | Futures | 168.1 | 168.44 | 168.03 | 168.25 | 536995.0 |
| 2021-11-17 | FGBM | Futures | 134.75 | 134.85 | 134.7 | 134.77 | 331226.0 |
| 2021-11-17 | FGBS | Futures | 112.775 | 112.8 | 112.759 | 112.775 | 273493.0 |
| 2021-11-17 | FGBX | Futures | 228.35 | 229.5 | 227.45 | 228.61 | 73695.0 |
| 2021-11-17 | FMWO | Futures | 11485.5 | 11486.6 | 11446.5 | 11458.3 | 4878.0 |
| 2021-11-17 | FOAT | Futures | 155.61 | 155.88 | 155.39 | 155.61 | 122981.0 |
| 2021-11-17 | FTDX | Futures | 4036.5 | 4080.1 | 4031.4 | 4050.9 | 255.0 |
| 2021-11-17 | FTI | Futures | 789.01 | 791.06 | 787.25 | 789.3 | 16937.0 |
| 2021-11-17 | FTUK | Futures | 7220.1 | 7220.1 | 7174.2 | 7189.5 | 77791.0 |
| 2021-11-17 | FVSA | Futures | 61.42 | 62.05 | 60.31 | 60.95 | 17882.0 |
> showing 50 of 123 rows — these rows as CSV