PREVIEW / futures_daily / 2023-01-03
file: by_date/futures_daily/2023/2023-01-03.parquet size: 10 KB rows: 131
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 |
|---|---|---|---|---|---|---|---|
| 2023-01-03 | ES | Futures | 4306.75 | 4319.74 | 4217.74 | 4252.57 | 1782473.0 |
| 2023-01-03 | NQ | Futures | 12483.06 | 12549.84 | 12171.33 | 12284.41 | 657681.0 |
| 2023-01-03 | YM | Futures | 36187.3 | 36358.0 | 35644.8 | 35963.6 | 196899.0 |
| 2023-01-03 | CL | Futures | 70.35 | 71.16 | 66.88 | 67.17 | 338520.0 |
| 2023-01-03 | GC | Futures | 2073.0 | 2101.1 | 2072.5 | 2089.2 | 212272.0 |
| 2023-01-03 | ZN | Futures | 115.660179 | 116.222104 | 115.483574 | 115.740454 | 1471344.0 |
| 2023-01-03 | A6 | Futures | 0.69539 | 0.69917 | 0.68407 | 0.68897 | 110981.0 |
| 2023-01-03 | AD | Futures | 0.74895 | 0.75073 | 0.74165 | 0.74281 | 86979.0 |
| 2023-01-03 | ALI | Futures | 2702.76 | 2702.76 | 2597.55 | 2608.74 | 3510.0 |
| 2023-01-03 | B | Futures | 75.12 | 76.03 | 71.46 | 71.74 | 302855.0 |
| 2023-01-03 | B6 | Futures | 1.2173 | 1.2202 | 1.2015 | 1.21 | 118341.0 |
| 2023-01-03 | BFX | Futures | 4063.7 | 4063.7 | 4063.7 | 4063.7 | 0.0 |
| 2023-01-03 | BR | Futures | 0.16462 | 0.16542 | 0.16118 | 0.16212 | 429.0 |
| 2023-01-03 | BTC | Futures | 22865.5 | 22988.9 | 22659.8 | 22783.2 | 4086.0 |
| 2023-01-03 | BZ | Futures | 74.4 | 75.24 | 70.7 | 70.99 | 27559.0 |
| 2023-01-03 | C | Futures | 1615.0 | 1619.0 | 1580.0 | 1602.0 | 8723.0 |
| 2023-01-03 | CB | Futures | 232.221 | 232.221 | 231.487 | 231.977 | 23.0 |
| 2023-01-03 | CC | Futures | 1510.0 | 1514.0 | 1479.0 | 1501.0 | 24327.0 |
| 2023-01-03 | CNH | Futures | 6.5076 | 6.5525 | 6.4079 | 6.5368 | 881.0 |
| 2023-01-03 | CSC | Futures | 2.394 | 2.395 | 2.371 | 2.395 | 123.0 |
| 2023-01-03 | CT | Futures | 109.32 | 112.58 | 108.58 | 109.02 | 13015.0 |
| 2023-01-03 | DC | Futures | 22.92 | 22.92 | 22.51 | 22.72 | 285.0 |
| 2023-01-03 | DX | Futures | 100.572 | 101.743 | 100.367 | 101.414 | 32361.0 |
| 2023-01-03 | E1 | Futures | 1.18236 | 1.18693 | 1.1647 | 1.17079 | 26710.0 |
| 2023-01-03 | E6 | Futures | 1.1099 | 1.11125 | 1.09406 | 1.09893 | 262819.0 |
| 2023-01-03 | E7 | Futures | 1.11 | 1.1104 | 1.0932 | 1.0982 | 9274.0 |
| 2023-01-03 | EBM | Futures | 456.5 | 460.56 | 446.89 | 448.0 | 20684.0 |
| 2023-01-03 | ED | Futures | 94.4421 | 94.4669 | 94.4222 | 94.4321 | 61191.0 |
| 2023-01-03 | ER | Futures | 97.66 | 97.701 | 97.645 | 97.66 | 111580.0 |
| 2023-01-03 | ESG | Futures | 366.45 | 368.61 | 360.66 | 363.46 | 688.0 |
| 2023-01-03 | EW | Futures | 2647.8 | 2661.8 | 2594.2 | 2613.2 | 15735.0 |
| 2023-01-03 | FBON | Futures | 119.29 | 120.6 | 119.02 | 120.48 | 369.0 |
| 2023-01-03 | FBTP | Futures | 107.07 | 108.3 | 106.48 | 107.79 | 136316.0 |
| 2023-01-03 | FBTS | Futures | 105.73 | 105.951 | 105.64 | 105.891 | 91177.0 |
| 2023-01-03 | FCE | Futures | 7171.2 | 7319.2 | 7151.5 | 7238.9 | 69363.0 |
| 2023-01-03 | FDAX | Futures | 15170.1 | 15518.1 | 15090.1 | 15410.0 | 79220.0 |
| 2023-01-03 | FDIV | Futures | 168.26 | 168.26 | 167.37 | 167.72 | 11.0 |
| 2023-01-03 | FDXM | Futures | 15084.0 | 15422.4 | 15001.3 | 15317.1 | 54901.0 |
| 2023-01-03 | FDXS | Futures | 15003.0 | 15328.7 | 14917.6 | 15224.0 | 24096.0 |
| 2023-01-03 | FESX | Futures | 3806.7 | 3903.1 | 3787.8 | 3867.3 | 972883.0 |
| 2023-01-03 | FEU3 | Futures | 97.726 | 97.726 | 97.726 | 97.726 | 0.0 |
| 2023-01-03 | FGBL | Futures | 134.46 | 135.82 | 134.06 | 135.35 | 778978.0 |
| 2023-01-03 | FGBM | Futures | 118.99 | 119.48 | 118.75 | 119.3 | 595193.0 |
| 2023-01-03 | FGBS | Futures | 108.082 | 108.189 | 108.0 | 108.123 | 456158.0 |
| 2023-01-03 | FGBX | Futures | 141.55 | 146.56 | 140.81 | 144.97 | 69525.0 |
| 2023-01-03 | FMWO | Futures | 9249.2 | 9336.2 | 9165.6 | 9200.0 | 5155.0 |
| 2023-01-03 | FOAT | Futures | 125.55 | 126.87 | 125.03 | 126.39 | 155403.0 |
| 2023-01-03 | FSMX | Futures | 27235.8 | 27734.3 | 27235.8 | 27595.4 | 400.0 |
| 2023-01-03 | FTDX | Futures | 3114.6 | 3180.7 | 3114.6 | 3171.6 | 285.0 |
| 2023-01-03 | FTI | Futures | 717.35 | 735.69 | 716.11 | 727.9 | 26979.0 |
> showing 50 of 131 rows — these rows as CSV