PREVIEW / futures_daily / 2022-12-27
file: by_date/futures_daily/2022/2022-12-27.parquet size: 10 KB rows: 128
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-27 | ES | Futures | 4287.95 | 4312.83 | 4242.89 | 4262.52 | 1006414.0 |
| 2022-12-27 | NQ | Futures | 12462.3 | 12551.8 | 12228.85 | 12250.74 | 499799.0 |
| 2022-12-27 | YM | Futures | 36094.3 | 36325.6 | 35918.2 | 36112.7 | 125976.0 |
| 2022-12-27 | CL | Futures | 69.76 | 70.88 | 69.12 | 69.44 | 199601.0 |
| 2022-12-27 | GC | Futures | 2046.3 | 2084.5 | 2046.1 | 2063.2 | 159616.0 |
| 2022-12-27 | ZN | Futures | 116.302379 | 116.318434 | 115.403299 | 115.419354 | 691957.0 |
| 2022-12-27 | A6 | Futures | 0.68759 | 0.6933 | 0.68759 | 0.68902 | 50920.0 |
| 2022-12-27 | AD | Futures | 0.74718 | 0.75296 | 0.74718 | 0.75058 | 53536.0 |
| 2022-12-27 | ALI | Futures | 2698.56 | 2698.56 | 2698.56 | 2698.56 | 63.0 |
| 2022-12-27 | B | Futures | 74.28 | 75.24 | 73.57 | 74.0 | 160090.0 |
| 2022-12-27 | B6 | Futures | 1.2173 | 1.2234 | 1.2121 | 1.2151 | 43012.0 |
| 2022-12-27 | BFX | Futures | 3988.1 | 3988.1 | 3988.1 | 3988.1 | 0.0 |
| 2022-12-27 | BR | Futures | 0.16926 | 0.16926 | 0.16694 | 0.16752 | 525.0 |
| 2022-12-27 | BTC | Futures | 22886.1 | 23057.5 | 22413.0 | 22536.4 | 4684.0 |
| 2022-12-27 | BZ | Futures | 73.3 | 74.48 | 72.8 | 73.22 | 15704.0 |
| 2022-12-27 | CB | Futures | 232.711 | 232.711 | 231.977 | 231.977 | 20.0 |
| 2022-12-27 | CC | Futures | 1535.0 | 1553.0 | 1527.0 | 1537.0 | 16555.0 |
| 2022-12-27 | CNH | Futures | 6.5826 | 6.5864 | 6.5692 | 6.5778 | 438.0 |
| 2022-12-27 | CSC | Futures | 2.446 | 2.449 | 2.429 | 2.442 | 37.0 |
| 2022-12-27 | CT | Futures | 111.76 | 112.3 | 110.18 | 110.47 | 7355.0 |
| 2022-12-27 | DC | Futures | 23.07 | 23.55 | 23.07 | 23.19 | 172.0 |
| 2022-12-27 | DX | Futures | 100.951 | 101.218 | 100.708 | 101.007 | 13283.0 |
| 2022-12-27 | E1 | Futures | 1.17503 | 1.18242 | 1.17465 | 1.17948 | 11046.0 |
| 2022-12-27 | E6 | Futures | 1.10711 | 1.11078 | 1.10462 | 1.10778 | 132366.0 |
| 2022-12-27 | E7 | Futures | 1.1058 | 1.11 | 1.1039 | 1.1071 | 4909.0 |
| 2022-12-27 | EBM | Futures | 462.04 | 467.22 | 460.93 | 466.11 | 22522.0 |
| 2022-12-27 | ED | Futures | 94.462 | 94.462 | 94.3973 | 94.4072 | 98865.0 |
| 2022-12-27 | ER | Futures | 97.545 | 97.575 | 97.519 | 97.56 | 52759.0 |
| 2022-12-27 | ESG | Futures | 368.59 | 368.59 | 363.51 | 364.42 | 243.0 |
| 2022-12-27 | EW | Futures | 2643.7 | 2656.2 | 2618.7 | 2633.5 | 6146.0 |
| 2022-12-27 | FBON | Futures | 119.47 | 119.47 | 118.64 | 118.85 | 75.0 |
| 2022-12-27 | FBTP | Futures | 107.23 | 107.58 | 106.42 | 106.59 | 45736.0 |
| 2022-12-27 | FBTS | Futures | 105.75 | 105.831 | 105.499 | 105.59 | 30833.0 |
| 2022-12-27 | FCE | Futures | 7155.9 | 7186.5 | 7136.3 | 7153.7 | 24638.0 |
| 2022-12-27 | FDAX | Futures | 15212.2 | 15270.6 | 15160.4 | 15191.7 | 31610.0 |
| 2022-12-27 | FDIV | Futures | 162.72 | 162.72 | 162.42 | 162.52 | 4.0 |
| 2022-12-27 | FDXM | Futures | 15117.3 | 15177.5 | 15069.0 | 15100.1 | 20535.0 |
| 2022-12-27 | FDXS | Futures | 15018.0 | 15085.2 | 14978.5 | 15008.4 | 9578.0 |
| 2022-12-27 | FESX | Futures | 3820.6 | 3835.5 | 3802.7 | 3812.6 | 260457.0 |
| 2022-12-27 | FEU3 | Futures | 97.631 | 97.631 | 97.631 | 97.631 | 0.0 |
| 2022-12-27 | FGBL | Futures | 134.96 | 135.02 | 133.52 | 133.72 | 298332.0 |
| 2022-12-27 | FGBM | Futures | 118.96 | 118.97 | 118.46 | 118.58 | 170400.0 |
| 2022-12-27 | FGBS | Futures | 108.005 | 108.056 | 107.913 | 107.984 | 115111.0 |
| 2022-12-27 | FGBX | Futures | 145.73 | 146.16 | 140.73 | 141.33 | 34453.0 |
| 2022-12-27 | FMWO | Futures | 9295.0 | 9311.0 | 9187.4 | 9243.5 | 1606.0 |
| 2022-12-27 | FOAT | Futures | 125.84 | 125.89 | 124.5 | 124.73 | 55352.0 |
| 2022-12-27 | FSMX | Futures | 27096.8 | 27096.8 | 26856.0 | 26891.0 | 160.0 |
| 2022-12-27 | FTDX | Futures | 3109.8 | 3126.3 | 3104.4 | 3121.0 | 4.0 |
| 2022-12-27 | FTI | Futures | 728.5 | 728.7 | 719.61 | 721.33 | 9232.0 |
| 2022-12-27 | FTUK | Futures | 7538.1 | 7538.1 | 7538.1 | 7538.1 | 0.0 |
> showing 50 of 128 rows — these rows as CSV