PREVIEW / futures_daily / 2023-09-12
file: by_date/futures_daily/2023/2023-09-12.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-12 | ES | Futures | 4860.01 | 4863.53 | 4828.61 | 4835.37 | 1153961.0 |
| 2023-09-12 | NQ | Futures | 16923.01 | 16938.6 | 16728.52 | 16746.03 | 253049.0 |
| 2023-09-12 | YM | Futures | 36832.6 | 37049.4 | 36707.4 | 36828.4 | 155936.0 |
| 2023-09-12 | CL | Futures | 76.28 | 78.11 | 76.23 | 77.65 | 341137.0 |
| 2023-09-12 | GC | Futures | 2094.8 | 2096.8 | 2077.9 | 2083.5 | 161993.0 |
| 2023-09-12 | ZN | Futures | 111.29215 | 111.418889 | 111.212939 | 111.403047 | 1010007.0 |
| 2023-09-12 | A6 | Futures | 0.65078 | 0.65143 | 0.64826 | 0.64982 | 59673.0 |
| 2023-09-12 | AD | Futures | 0.74389 | 0.74535 | 0.74263 | 0.7447 | 56247.0 |
| 2023-09-12 | ALI | Futures | 2423.22 | 2433.7 | 2401.44 | 2421.01 | 1349.0 |
| 2023-09-12 | B | Futures | 80.77 | 82.35 | 80.68 | 82.05 | 336574.0 |
| 2023-09-12 | B6 | Futures | 1.2519 | 1.2536 | 1.2467 | 1.2492 | 57080.0 |
| 2023-09-12 | BFX | Futures | 3982.7 | 3982.7 | 3982.7 | 3982.7 | 0.0 |
| 2023-09-12 | BR | Futures | 0.18921 | 0.18964 | 0.18832 | 0.18832 | 9.0 |
| 2023-09-12 | BTC | Futures | 33515.2 | 35574.9 | 33461.9 | 34828.3 | 11268.0 |
| 2023-09-12 | BZ | Futures | 80.52 | 82.18 | 80.51 | 81.86 | 31070.0 |
| 2023-09-12 | C | Futures | 2525.0 | 2537.0 | 2509.0 | 2524.0 | 8902.0 |
| 2023-09-12 | CB | Futures | 260.519 | 264.481 | 260.519 | 264.481 | 28.0 |
| 2023-09-12 | CC | Futures | 2135.0 | 2139.0 | 2122.0 | 2129.0 | 15528.0 |
| 2023-09-12 | CNH | Futures | 7.0479 | 7.0595 | 7.0401 | 7.0498 | 451.0 |
| 2023-09-12 | CSC | Futures | 2.105 | 2.128 | 2.086 | 2.096 | 89.0 |
| 2023-09-12 | CT | Futures | 108.95 | 109.24 | 107.45 | 109.04 | 16.0 |
| 2023-09-12 | DC | Futures | 19.78 | 19.86 | 19.43 | 19.64 | 105.0 |
| 2023-09-12 | DX | Futures | 102.804 | 103.124 | 102.636 | 102.927 | 6170.0 |
| 2023-09-12 | E1 | Futures | 1.19019 | 1.19081 | 1.18651 | 1.18929 | 13324.0 |
| 2023-09-12 | E6 | Futures | 1.09896 | 1.10074 | 1.09418 | 1.09683 | 194119.0 |
| 2023-09-12 | E7 | Futures | 1.0992 | 1.1021 | 1.0944 | 1.0971 | 1405.0 |
| 2023-09-12 | EBM | Futures | 320.08 | 320.42 | 315.62 | 318.36 | 46199.0 |
| 2023-09-12 | ER | Futures | 97.858 | 97.868 | 97.802 | 97.843 | 221598.0 |
| 2023-09-12 | ESG | Futures | 420.0 | 420.64 | 418.22 | 418.5 | 15583.0 |
| 2023-09-12 | EW | Futures | 2728.3 | 2740.1 | 2718.6 | 2726.0 | 13610.0 |
| 2023-09-12 | FBON | Futures | 120.26 | 120.59 | 120.26 | 120.27 | 19.0 |
| 2023-09-12 | FBTP | Futures | 111.71 | 112.07 | 111.57 | 111.66 | 119635.0 |
| 2023-09-12 | FBTS | Futures | 105.825 | 105.886 | 105.734 | 105.774 | 87726.0 |
| 2023-09-12 | FCE | Futures | 7878.1 | 7884.8 | 7820.9 | 7834.2 | 39531.0 |
| 2023-09-12 | FDAX | Futures | 16756.7 | 16775.7 | 16611.6 | 16648.7 | 80635.0 |
| 2023-09-12 | FDIV | Futures | 181.18 | 181.18 | 181.18 | 181.18 | 0.0 |
| 2023-09-12 | FDXM | Futures | 16838.2 | 16846.6 | 16687.6 | 16725.5 | 5508.0 |
| 2023-09-12 | FDXS | Futures | 16719.9 | 16743.9 | 16585.9 | 16616.3 | 1007.0 |
| 2023-09-12 | FESX | Futures | 4324.4 | 4327.5 | 4290.2 | 4302.3 | 1490228.0 |
| 2023-09-12 | FEU3 | Futures | 97.838 | 97.838 | 97.838 | 97.838 | 0.0 |
| 2023-09-12 | FGBL | Futures | 132.8 | 133.17 | 132.62 | 132.8 | 524767.0 |
| 2023-09-12 | FGBM | Futures | 117.86 | 117.98 | 117.64 | 117.76 | 490192.0 |
| 2023-09-12 | FGBS | Futures | 107.259 | 107.29 | 107.157 | 107.203 | 502938.0 |
| 2023-09-12 | FGBX | Futures | 131.98 | 133.11 | 131.82 | 132.21 | 64587.0 |
| 2023-09-12 | FMWO | Futures | 10316.3 | 10328.6 | 10276.1 | 10291.7 | 42831.0 |
| 2023-09-12 | FOAT | Futures | 123.98 | 124.36 | 123.83 | 123.97 | 133633.0 |
| 2023-09-12 | FSMX | Futures | 28142.5 | 28142.5 | 28038.7 | 28094.2 | 753.0 |
| 2023-09-12 | FTDX | Futures | 3220.2 | 3229.0 | 3220.2 | 3229.0 | 2.0 |
| 2023-09-12 | FTI | Futures | 771.55 | 773.16 | 765.43 | 767.69 | 13434.0 |
| 2023-09-12 | FTUK | Futures | 7630.4 | 7673.2 | 7619.3 | 7651.6 | 256246.0 |
> showing 50 of 130 rows — these rows as CSV