PREVIEW / futures_daily / 2023-09-28
file: by_date/futures_daily/2023/2023-09-28.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-09-28 | ES | Futures | 4627.5 | 4662.29 | 4603.69 | 4642.75 | 2012088.0 |
| 2023-09-28 | NQ | Futures | 15942.78 | 16131.64 | 15819.21 | 16036.94 | 734472.0 |
| 2023-09-28 | YM | Futures | 35637.1 | 35790.7 | 35457.2 | 35666.6 | 217709.0 |
| 2023-09-28 | CL | Futures | 82.68 | 83.79 | 80.58 | 80.86 | 406709.0 |
| 2023-09-28 | GC | Futures | 2038.5 | 2042.3 | 2018.2 | 2022.7 | 231419.0 |
| 2023-09-28 | ZN | Futures | 109.232652 | 109.517813 | 108.709856 | 109.35939 | 2422053.0 |
| 2023-09-28 | A6 | Futures | 0.64211 | 0.65012 | 0.6413 | 0.64917 | 150012.0 |
| 2023-09-28 | AD | Futures | 0.74777 | 0.74923 | 0.74666 | 0.74747 | 81188.0 |
| 2023-09-28 | ALI | Futures | 2474.73 | 2528.95 | 2467.3 | 2514.36 | 5089.0 |
| 2023-09-28 | B | Futures | 84.92 | 85.79 | 83.45 | 83.77 | 571845.0 |
| 2023-09-28 | B6 | Futures | 1.2148 | 1.2234 | 1.2129 | 1.2204 | 130430.0 |
| 2023-09-28 | BFX | Futures | 3819.7 | 3819.7 | 3819.7 | 3819.7 | 0.0 |
| 2023-09-28 | BR | Futures | 0.1846 | 0.18535 | 0.1846 | 0.18502 | 2314.0 |
| 2023-09-28 | BTC | Futures | 35254.7 | 36843.9 | 35254.7 | 36530.0 | 13005.0 |
| 2023-09-28 | BZ | Futures | 84.77 | 85.6 | 83.28 | 83.59 | 55188.0 |
| 2023-09-28 | C | Futures | 2467.0 | 2484.0 | 2451.0 | 2473.0 | 5039.0 |
| 2023-09-28 | CB | Futures | 269.434 | 269.483 | 269.434 | 269.434 | 6.0 |
| 2023-09-28 | CC | Futures | 2002.0 | 2025.0 | 1998.0 | 2018.0 | 23340.0 |
| 2023-09-28 | CNH | Futures | 7.0804 | 7.084 | 7.0488 | 7.0519 | 355.0 |
| 2023-09-28 | CSC | Futures | 2.0 | 2.0 | 1.989 | 1.989 | 115.0 |
| 2023-09-28 | CT | Futures | 108.07 | 109.6 | 107.85 | 108.16 | 21192.0 |
| 2023-09-28 | DC | Futures | 18.76 | 18.82 | 18.62 | 18.64 | 218.0 |
| 2023-09-28 | DX | Futures | 104.944 | 105.033 | 104.303 | 104.498 | 19728.0 |
| 2023-09-28 | E1 | Futures | 1.14921 | 1.15677 | 1.14806 | 1.15488 | 20621.0 |
| 2023-09-28 | E6 | Futures | 1.07266 | 1.07994 | 1.07098 | 1.07744 | 273944.0 |
| 2023-09-28 | E7 | Futures | 1.0728 | 1.0802 | 1.0712 | 1.0776 | 6044.0 |
| 2023-09-28 | EBM | Futures | 329.68 | 331.74 | 327.28 | 328.65 | 29034.0 |
| 2023-09-28 | ER | Futures | 97.756 | 97.766 | 97.746 | 97.756 | 150949.0 |
| 2023-09-28 | ESG | Futures | 397.8 | 401.87 | 397.09 | 400.45 | 1028.0 |
| 2023-09-28 | EW | Futures | 2626.9 | 2661.0 | 2614.7 | 2649.7 | 12206.0 |
| 2023-09-28 | FBON | Futures | 117.85 | 117.85 | 116.61 | 116.68 | 50.0 |
| 2023-09-28 | FBTP | Futures | 108.21 | 108.33 | 106.89 | 107.09 | 338053.0 |
| 2023-09-28 | FBTS | Futures | 105.218 | 105.258 | 104.955 | 105.046 | 223779.0 |
| 2023-09-28 | FCE | Futures | 7648.5 | 7704.4 | 7599.5 | 7680.2 | 65143.0 |
| 2023-09-28 | FDAX | Futures | 16213.8 | 16327.5 | 16081.0 | 16267.5 | 74720.0 |
| 2023-09-28 | FDIV | Futures | 174.86 | 176.3 | 174.86 | 176.3 | 5.0 |
| 2023-09-28 | FDXM | Futures | 16208.4 | 16321.1 | 16075.8 | 16261.1 | 52043.0 |
| 2023-09-28 | FDXS | Futures | 16111.0 | 16214.5 | 15971.8 | 16154.9 | 26533.0 |
| 2023-09-28 | FESX | Futures | 4194.5 | 4229.8 | 4159.3 | 4213.7 | 802652.0 |
| 2023-09-28 | FEU3 | Futures | 97.751 | 97.751 | 97.751 | 97.751 | 0.0 |
| 2023-09-28 | FGBL | Futures | 130.45 | 130.73 | 129.12 | 129.2 | 1495647.0 |
| 2023-09-28 | FGBM | Futures | 116.74 | 116.89 | 116.2 | 116.22 | 919474.0 |
| 2023-09-28 | FGBS | Futures | 106.918 | 106.984 | 106.821 | 106.826 | 777461.0 |
| 2023-09-28 | FGBX | Futures | 124.91 | 125.54 | 122.12 | 122.61 | 162845.0 |
| 2023-09-28 | FMWO | Futures | 9858.2 | 9949.8 | 9820.7 | 9914.5 | 4164.0 |
| 2023-09-28 | FOAT | Futures | 121.52 | 121.77 | 120.24 | 120.34 | 255256.0 |
| 2023-09-28 | FSMX | Futures | 26588.4 | 26715.8 | 26337.8 | 26591.5 | 264.0 |
| 2023-09-28 | FTDX | Futures | 3138.6 | 3138.6 | 3105.9 | 3131.9 | 13.0 |
| 2023-09-28 | FTI | Futures | 752.56 | 757.86 | 744.16 | 755.09 | 15779.0 |
| 2023-09-28 | FTUK | Futures | 7701.9 | 7727.1 | 7625.9 | 7709.0 | 101137.0 |
> showing 50 of 130 rows — these rows as CSV