PREVIEW / futures_daily / 2023-01-09
file: by_date/futures_daily/2023/2023-01-09.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-09 | ES | Futures | 4332.73 | 4393.27 | 4323.06 | 4327.48 | 1697887.0 |
| 2023-01-09 | NQ | Futures | 12487.55 | 12778.23 | 12480.53 | 12553.77 | 646318.0 |
| 2023-01-09 | YM | Futures | 36516.9 | 36830.3 | 36344.0 | 36387.2 | 153569.0 |
| 2023-01-09 | CL | Futures | 64.15 | 67.0 | 64.15 | 65.16 | 329290.0 |
| 2023-01-09 | GC | Futures | 2119.4 | 2134.8 | 2115.5 | 2125.1 | 204550.0 |
| 2023-01-09 | ZN | Futures | 117.378064 | 117.891823 | 117.137239 | 117.779438 | 1491031.0 |
| 2023-01-09 | A6 | Futures | 0.7032 | 0.71075 | 0.70304 | 0.70917 | 85592.0 |
| 2023-01-09 | AD | Futures | 0.75524 | 0.75996 | 0.75499 | 0.75935 | 64224.0 |
| 2023-01-09 | ALI | Futures | 2647.07 | 2768.79 | 2630.56 | 2758.72 | 1950.0 |
| 2023-01-09 | B | Futures | 68.53 | 71.11 | 68.53 | 69.6 | 245120.0 |
| 2023-01-09 | B6 | Futures | 1.2206 | 1.2327 | 1.2206 | 1.232 | 87458.0 |
| 2023-01-09 | BFX | Futures | 4135.0 | 4135.0 | 4135.0 | 4135.0 | 0.0 |
| 2023-01-09 | BR | Futures | 0.16685 | 0.16899 | 0.16667 | 0.16828 | 4632.0 |
| 2023-01-09 | BTC | Futures | 23283.7 | 23914.5 | 23249.4 | 23619.7 | 7471.0 |
| 2023-01-09 | BZ | Futures | 67.86 | 70.36 | 67.74 | 68.87 | 29985.0 |
| 2023-01-09 | C | Futures | 1602.0 | 1623.0 | 1598.0 | 1617.0 | 6427.0 |
| 2023-01-09 | CB | Futures | 230.068 | 232.466 | 230.043 | 232.466 | 9.0 |
| 2023-01-09 | CC | Futures | 1531.0 | 1575.0 | 1530.0 | 1570.0 | 30613.0 |
| 2023-01-09 | CNH | Futures | 6.4447 | 6.4496 | 6.3965 | 6.4053 | 614.0 |
| 2023-01-09 | CSC | Futures | 2.428 | 2.447 | 2.428 | 2.447 | 59.0 |
| 2023-01-09 | CT | Futures | 112.34 | 115.36 | 110.91 | 113.06 | 21882.0 |
| 2023-01-09 | DC | Futures | 22.91 | 23.45 | 22.72 | 23.2 | 722.0 |
| 2023-01-09 | DX | Futures | 100.81 | 100.81 | 99.828 | 99.889 | 35675.0 |
| 2023-01-09 | E1 | Futures | 1.17954 | 1.19372 | 1.17883 | 1.18964 | 24839.0 |
| 2023-01-09 | E6 | Futures | 1.10648 | 1.11911 | 1.10638 | 1.11782 | 199693.0 |
| 2023-01-09 | E7 | Futures | 1.106 | 1.1182 | 1.1059 | 1.1171 | 7122.0 |
| 2023-01-09 | EBM | Futures | 442.45 | 444.3 | 437.28 | 438.39 | 19278.0 |
| 2023-01-09 | ED | Futures | 94.4222 | 94.457 | 94.4172 | 94.447 | 71020.0 |
| 2023-01-09 | ER | Futures | 97.645 | 97.645 | 97.625 | 97.64 | 152174.0 |
| 2023-01-09 | ESG | Futures | 370.73 | 374.94 | 369.13 | 369.62 | 1394.0 |
| 2023-01-09 | EW | Futures | 2696.6 | 2721.7 | 2688.3 | 2691.0 | 9417.0 |
| 2023-01-09 | FBON | Futures | 122.88 | 122.88 | 121.98 | 122.71 | 204.0 |
| 2023-01-09 | FBTP | Futures | 110.24 | 110.83 | 109.45 | 110.57 | 159672.0 |
| 2023-01-09 | FBTS | Futures | 106.272 | 106.433 | 106.102 | 106.373 | 98136.0 |
| 2023-01-09 | FCE | Futures | 7528.3 | 7570.4 | 7485.2 | 7546.9 | 53091.0 |
| 2023-01-09 | FDAX | Futures | 15924.5 | 16097.4 | 15871.5 | 16088.8 | 54315.0 |
| 2023-01-09 | FDIV | Futures | 175.08 | 176.37 | 174.94 | 176.37 | 40.0 |
| 2023-01-09 | FDXM | Futures | 15821.0 | 15999.3 | 15775.9 | 15991.8 | 45770.0 |
| 2023-01-09 | FDXS | Futures | 15717.3 | 15902.1 | 15680.0 | 15894.6 | 17839.0 |
| 2023-01-09 | FESX | Futures | 4017.3 | 4062.1 | 4004.4 | 4058.1 | 933895.0 |
| 2023-01-09 | FEU3 | Futures | 97.691 | 97.706 | 97.676 | 97.706 | 22.0 |
| 2023-01-09 | FGBL | Futures | 137.41 | 137.66 | 136.67 | 137.31 | 723062.0 |
| 2023-01-09 | FGBM | Futures | 120.26 | 120.36 | 119.85 | 120.21 | 508144.0 |
| 2023-01-09 | FGBS | Futures | 108.332 | 108.343 | 108.158 | 108.281 | 354534.0 |
| 2023-01-09 | FGBX | Futures | 149.37 | 149.7 | 147.24 | 148.88 | 48788.0 |
| 2023-01-09 | FMWO | Futures | 9407.2 | 9548.0 | 9407.2 | 9544.6 | 6026.0 |
| 2023-01-09 | FOAT | Futures | 128.49 | 128.66 | 127.75 | 128.48 | 150235.0 |
| 2023-01-09 | FSMX | Futures | 28842.8 | 29397.6 | 28840.7 | 29341.4 | 1486.0 |
| 2023-01-09 | FTDX | Futures | 3256.9 | 3328.3 | 3244.1 | 3287.3 | 67.0 |
| 2023-01-09 | FTI | Futures | 751.62 | 758.71 | 748.59 | 757.02 | 19863.0 |
> showing 50 of 131 rows — these rows as CSV