PREVIEW / futures_daily / 2023-08-18
file: by_date/futures_daily/2023/2023-08-18.parquet size: 10 KB rows: 130
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-08-18 | ES | Futures | 4742.51 | 4760.65 | 4710.84 | 4746.3 | 1746289.0 |
| 2023-08-18 | NQ | Futures | 16136.85 | 16196.75 | 15985.03 | 16132.47 | 731241.0 |
| 2023-08-18 | YM | Futures | 36692.8 | 36835.2 | 36482.4 | 36734.3 | 157850.0 |
| 2023-08-18 | CL | Futures | 69.56 | 70.77 | 69.07 | 70.5 | 377453.0 |
| 2023-08-18 | GC | Futures | 2066.4 | 2073.7 | 2062.8 | 2063.5 | 114737.0 |
| 2023-08-18 | ZN | Futures | 111.434243 | 111.847728 | 111.386534 | 111.593276 | 1251625.0 |
| 2023-08-18 | A6 | Futures | 0.64923 | 0.65187 | 0.6468 | 0.64949 | 70185.0 |
| 2023-08-18 | AD | Futures | 0.74622 | 0.74739 | 0.74456 | 0.74622 | 59535.0 |
| 2023-08-18 | ALI | Futures | 2375.25 | 2384.62 | 2357.61 | 2364.5 | 1303.0 |
| 2023-08-18 | B | Futures | 74.23 | 75.29 | 73.75 | 75.05 | 287965.0 |
| 2023-08-18 | B6 | Futures | 1.2771 | 1.279 | 1.2714 | 1.2767 | 83537.0 |
| 2023-08-18 | BFX | Futures | 3932.6 | 3932.6 | 3932.6 | 3932.6 | 0.0 |
| 2023-08-18 | BR | Futures | 0.18634 | 0.18756 | 0.18588 | 0.18714 | 8846.0 |
| 2023-08-18 | BTC | Futures | 35069.7 | 35771.8 | 33910.7 | 34467.0 | 11658.0 |
| 2023-08-18 | BZ | Futures | 73.96 | 75.05 | 73.51 | 74.81 | 26072.0 |
| 2023-08-18 | C | Futures | 2282.0 | 2285.0 | 2250.0 | 2259.0 | 1002.0 |
| 2023-08-18 | CB | Futures | 264.81 | 264.81 | 259.023 | 259.309 | 105.0 |
| 2023-08-18 | CC | Futures | 2031.0 | 2033.0 | 2004.0 | 2012.0 | 28039.0 |
| 2023-08-18 | CNH | Futures | 7.017 | 7.0322 | 7.0014 | 7.0215 | 667.0 |
| 2023-08-18 | CSC | Futures | 2.027 | 2.088 | 2.023 | 2.086 | 291.0 |
| 2023-08-18 | CT | Futures | 106.13 | 106.14 | 105.09 | 105.09 | 6.0 |
| 2023-08-18 | DC | Futures | 18.61 | 19.32 | 18.6 | 19.25 | 823.0 |
| 2023-08-18 | DX | Futures | 101.352 | 101.612 | 101.176 | 101.319 | 12519.0 |
| 2023-08-18 | E1 | Futures | 1.21163 | 1.21264 | 1.20532 | 1.20638 | 17295.0 |
| 2023-08-18 | E6 | Futures | 1.11423 | 1.11638 | 1.11132 | 1.11475 | 144221.0 |
| 2023-08-18 | E7 | Futures | 1.1141 | 1.1163 | 1.1114 | 1.1148 | 3846.0 |
| 2023-08-18 | EBM | Futures | 336.09 | 341.58 | 335.73 | 341.22 | 10553.0 |
| 2023-08-18 | ER | Futures | 97.812 | 97.843 | 97.812 | 97.822 | 98389.0 |
| 2023-08-18 | ESG | Futures | 410.99 | 412.16 | 409.04 | 411.42 | 378.0 |
| 2023-08-18 | EW | Futures | 2725.7 | 2739.3 | 2704.1 | 2731.9 | 13624.0 |
| 2023-08-18 | FBON | Futures | 120.0 | 120.48 | 119.99 | 120.28 | 78.0 |
| 2023-08-18 | FBTP | Futures | 112.06 | 112.4 | 111.91 | 112.1 | 116860.0 |
| 2023-08-18 | FBTS | Futures | 105.886 | 106.068 | 105.866 | 106.027 | 109022.0 |
| 2023-08-18 | FCE | Futures | 7779.1 | 7792.1 | 7694.8 | 7772.1 | 61901.0 |
| 2023-08-18 | FDAX | Futures | 16579.9 | 16627.5 | 16419.0 | 16540.7 | 64931.0 |
| 2023-08-18 | FDIV | Futures | 181.17 | 182.7 | 181.17 | 182.24 | 96.0 |
| 2023-08-18 | FDXM | Futures | 16654.1 | 16696.7 | 16486.2 | 16608.4 | 51047.0 |
| 2023-08-18 | FDXS | Futures | 16532.7 | 16588.6 | 16380.6 | 16502.0 | 29552.0 |
| 2023-08-18 | FESX | Futures | 4281.0 | 4296.2 | 4241.5 | 4282.0 | 949000.0 |
| 2023-08-18 | FEU3 | Futures | 97.817 | 97.817 | 97.817 | 97.817 | 0.0 |
| 2023-08-18 | FGBL | Futures | 132.44 | 133.38 | 132.4 | 133.06 | 585909.0 |
| 2023-08-18 | FGBM | Futures | 117.8 | 118.21 | 117.78 | 118.02 | 465250.0 |
| 2023-08-18 | FGBS | Futures | 107.366 | 107.473 | 107.356 | 107.417 | 431809.0 |
| 2023-08-18 | FGBX | Futures | 132.15 | 134.36 | 132.05 | 133.17 | 61713.0 |
| 2023-08-18 | FMWO | Futures | 10113.9 | 10120.6 | 10020.0 | 10077.0 | 4975.0 |
| 2023-08-18 | FOAT | Futures | 123.61 | 124.52 | 123.61 | 124.2 | 123570.0 |
| 2023-08-18 | FSMX | Futures | 28416.8 | 28502.1 | 28306.5 | 28345.0 | 112.0 |
| 2023-08-18 | FTDX | Futures | 3237.0 | 3237.0 | 3209.6 | 3230.7 | 57.0 |
| 2023-08-18 | FTI | Futures | 769.77 | 770.66 | 762.62 | 768.24 | 24617.0 |
| 2023-08-18 | FTUK | Futures | 7405.0 | 7427.4 | 7341.5 | 7390.8 | 113850.0 |
> showing 50 of 130 rows — these rows as CSV