PREVIEW / futures_daily / 2023-08-22
file: by_date/futures_daily/2023/2023-08-22.parquet size: 10 KB rows: 129
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-22 | ES | Futures | 4776.08 | 4808.3 | 4758.76 | 4764.17 | 1375651.0 |
| 2023-08-22 | NQ | Futures | 16384.68 | 16541.97 | 16338.18 | 16367.17 | 623728.0 |
| 2023-08-22 | YM | Futures | 36666.3 | 36826.7 | 36460.1 | 36499.4 | 139805.0 |
| 2023-08-22 | CL | Futures | 70.14 | 70.25 | 69.45 | 69.61 | 287489.0 |
| 2023-08-22 | GC | Futures | 2071.5 | 2081.4 | 2064.5 | 2073.7 | 131088.0 |
| 2023-08-22 | ZN | Futures | 111.020758 | 111.227501 | 110.814016 | 111.004855 | 1396508.0 |
| 2023-08-22 | A6 | Futures | 0.6504 | 0.65475 | 0.64923 | 0.65121 | 69484.0 |
| 2023-08-22 | AD | Futures | 0.74627 | 0.74804 | 0.74516 | 0.74562 | 53538.0 |
| 2023-08-22 | ALI | Futures | 2366.15 | 2400.89 | 2358.44 | 2394.0 | 2927.0 |
| 2023-08-22 | B | Futures | 74.75 | 74.92 | 74.21 | 74.36 | 287351.0 |
| 2023-08-22 | B6 | Futures | 1.2781 | 1.2827 | 1.2743 | 1.2763 | 74444.0 |
| 2023-08-22 | BFX | Futures | 3984.6 | 3984.6 | 3981.3 | 3981.3 | 12.0 |
| 2023-08-22 | BR | Futures | 0.18658 | 0.18891 | 0.18658 | 0.18858 | 12667.0 |
| 2023-08-22 | BTC | Futures | 34652.5 | 34659.1 | 34029.9 | 34082.9 | 7666.0 |
| 2023-08-22 | BZ | Futures | 74.45 | 74.68 | 73.97 | 74.14 | 27081.0 |
| 2023-08-22 | C | Futures | 2263.0 | 2271.0 | 2240.0 | 2259.0 | 1416.0 |
| 2023-08-22 | CB | Futures | 260.024 | 260.024 | 257.547 | 257.547 | 14.0 |
| 2023-08-22 | CC | Futures | 2016.0 | 2021.0 | 1988.0 | 1997.0 | 20446.0 |
| 2023-08-22 | CNH | Futures | 7.0187 | 7.0364 | 6.9997 | 7.0266 | 863.0 |
| 2023-08-22 | CSC | Futures | 2.133 | 2.158 | 2.081 | 2.088 | 221.0 |
| 2023-08-22 | CT | Futures | 105.82 | 105.93 | 105.46 | 105.93 | 3.0 |
| 2023-08-22 | DC | Futures | 19.65 | 19.98 | 19.17 | 19.26 | 940.0 |
| 2023-08-22 | DX | Futures | 101.264 | 101.661 | 100.974 | 101.512 | 16277.0 |
| 2023-08-22 | E1 | Futures | 1.211 | 1.21365 | 1.20755 | 1.20882 | 12779.0 |
| 2023-08-22 | E6 | Futures | 1.11659 | 1.12002 | 1.10999 | 1.11198 | 195338.0 |
| 2023-08-22 | E7 | Futures | 1.1166 | 1.12 | 1.1101 | 1.112 | 4305.0 |
| 2023-08-22 | EBM | Futures | 335.73 | 339.75 | 333.16 | 334.26 | 11549.0 |
| 2023-08-22 | ER | Futures | 97.802 | 97.817 | 97.802 | 97.817 | 47169.0 |
| 2023-08-22 | ESG | Futures | 415.08 | 417.48 | 413.2 | 413.77 | 3514.0 |
| 2023-08-22 | EW | Futures | 2731.5 | 2749.1 | 2716.5 | 2721.2 | 12663.0 |
| 2023-08-22 | FBON | Futures | 119.8 | 120.36 | 119.8 | 120.22 | 37.0 |
| 2023-08-22 | FBTP | Futures | 111.54 | 112.37 | 111.54 | 112.17 | 122899.0 |
| 2023-08-22 | FBTS | Futures | 105.977 | 106.068 | 105.946 | 106.027 | 72744.0 |
| 2023-08-22 | FCE | Futures | 7837.5 | 7911.1 | 7830.5 | 7853.2 | 46782.0 |
| 2023-08-22 | FDAX | Futures | 16605.3 | 16767.2 | 16589.4 | 16667.7 | 48891.0 |
| 2023-08-22 | FDIV | Futures | 182.7 | 182.7 | 182.7 | 182.7 | 0.0 |
| 2023-08-22 | FDXM | Futures | 16670.1 | 16835.9 | 16656.3 | 16736.0 | 35332.0 |
| 2023-08-22 | FDXS | Futures | 16550.6 | 16729.1 | 16546.4 | 16628.8 | 20879.0 |
| 2023-08-22 | FESX | Futures | 4303.3 | 4361.1 | 4302.3 | 4328.6 | 630282.0 |
| 2023-08-22 | FEU3 | Futures | 97.807 | 97.807 | 97.807 | 97.807 | 0.0 |
| 2023-08-22 | FGBL | Futures | 132.19 | 132.96 | 132.18 | 132.75 | 497712.0 |
| 2023-08-22 | FGBM | Futures | 117.68 | 117.95 | 117.65 | 117.86 | 620217.0 |
| 2023-08-22 | FGBS | Futures | 107.305 | 107.366 | 107.294 | 107.33 | 326000.0 |
| 2023-08-22 | FGBX | Futures | 131.15 | 133.5 | 131.15 | 132.95 | 59857.0 |
| 2023-08-22 | FMWO | Futures | 10173.2 | 10222.4 | 10122.9 | 10157.5 | 2898.0 |
| 2023-08-22 | FOAT | Futures | 123.34 | 124.21 | 123.34 | 124.01 | 114508.0 |
| 2023-08-22 | FSMX | Futures | 28357.5 | 28502.1 | 28357.5 | 28412.6 | 91.0 |
| 2023-08-22 | FTDX | Futures | 3257.6 | 3275.5 | 3257.6 | 3270.7 | 22.0 |
| 2023-08-22 | FTI | Futures | 769.67 | 777.28 | 768.78 | 771.37 | 10621.0 |
| 2023-08-22 | FTUK | Futures | 7387.2 | 7438.0 | 7381.1 | 7399.9 | 68813.0 |
> showing 50 of 129 rows — these rows as CSV