PREVIEW / futures_daily / 2023-04-10
file: by_date/futures_daily/2023/2023-04-10.parquet size: 9 KB rows: 100
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-04-10 | ES | Futures | 4528.98 | 4533.36 | 4484.94 | 4525.97 | 1167715.0 |
| 2023-04-10 | NQ | Futures | 14610.43 | 14636.48 | 14375.14 | 14586.32 | 553003.0 |
| 2023-04-10 | YM | Futures | 36110.7 | 36201.8 | 35906.0 | 36166.4 | 109230.0 |
| 2023-04-10 | CL | Futures | 70.02 | 70.65 | 69.25 | 69.36 | 264906.0 |
| 2023-04-10 | GC | Futures | 2228.7 | 2243.0 | 2215.3 | 2223.4 | 136231.0 |
| 2023-04-10 | ZN | Futures | 118.449054 | 118.672874 | 118.049374 | 118.193259 | 795164.0 |
| 2023-04-10 | A6 | Futures | 0.6793 | 0.68077 | 0.67452 | 0.67671 | 39258.0 |
| 2023-04-10 | AD | Futures | 0.7503 | 0.75197 | 0.74817 | 0.75055 | 44384.0 |
| 2023-04-10 | ALI | Futures | 2558.93 | 2558.93 | 2558.93 | 2558.93 | 2215.0 |
| 2023-04-10 | B | Futures | 74.86 | 75.35 | 73.97 | 74.05 | 140529.0 |
| 2023-04-10 | B6 | Futures | 1.2488 | 1.2517 | 1.2417 | 1.2453 | 43685.0 |
| 2023-04-10 | BR | Futures | 0.17709 | 0.17749 | 0.17605 | 0.17636 | 118.0 |
| 2023-04-10 | BTC | Futures | 38818.1 | 40404.6 | 38491.3 | 40064.2 | 9746.0 |
| 2023-04-10 | BZ | Futures | 74.34 | 74.95 | 73.58 | 73.67 | 14242.0 |
| 2023-04-10 | CB | Futures | 231.022 | 231.977 | 231.022 | 231.977 | 59.0 |
| 2023-04-10 | CC | Futures | 1666.0 | 1671.0 | 1634.0 | 1661.0 | 32433.0 |
| 2023-04-10 | CNH | Futures | 6.5331 | 6.5505 | 6.5307 | 6.5505 | 1203.0 |
| 2023-04-10 | CSC | Futures | 2.255 | 2.255 | 2.235 | 2.238 | 117.0 |
| 2023-04-10 | CT | Futures | 107.8 | 108.62 | 106.93 | 107.09 | 19613.0 |
| 2023-04-10 | DC | Futures | 21.19 | 21.19 | 21.0 | 21.05 | 170.0 |
| 2023-04-10 | DX | Futures | 99.433 | 100.166 | 99.36 | 99.94 | 11163.0 |
| 2023-04-10 | E1 | Futures | 1.19286 | 1.1942 | 1.18338 | 1.18622 | 9870.0 |
| 2023-04-10 | E6 | Futures | 1.1261 | 1.12702 | 1.11818 | 1.12106 | 95955.0 |
| 2023-04-10 | E7 | Futures | 1.1255 | 1.1264 | 1.1176 | 1.1206 | 2447.0 |
| 2023-04-10 | ED | Futures | 94.73 | 94.76 | 94.68 | 94.69 | 5625.0 |
| 2023-04-10 | ER | Futures | 98.041 | 98.041 | 98.041 | 98.041 | 0.0 |
| 2023-04-10 | ESG | Futures | 390.19 | 390.62 | 387.61 | 390.62 | 262.0 |
| 2023-04-10 | EW | Futures | 2644.5 | 2665.6 | 2612.2 | 2661.2 | 9799.0 |
| 2023-04-10 | FTUK | Futures | 7888.8 | 7888.8 | 7888.8 | 7888.8 | 0.0 |
| 2023-04-10 | G | Futures | 104.03 | 104.03 | 104.03 | 104.03 | 0.0 |
| 2023-04-10 | GF | Futures | 236.04 | 236.585 | 234.058 | 236.212 | 6597.0 |
| 2023-04-10 | GSCI | Futures | 590.33 | 590.33 | 590.33 | 590.33 | 0.0 |
| 2023-04-10 | HE | Futures | 75.293 | 76.717 | 75.293 | 76.143 | 324.0 |
| 2023-04-10 | HG | Futures | 4.3767 | 4.4001 | 4.3168 | 4.3315 | 56662.0 |
| 2023-04-10 | HH | Futures | 4.851 | 5.317 | 4.844 | 5.219 | 6048.0 |
| 2023-04-10 | HO | Futures | 2.0749 | 2.1002 | 2.054 | 2.0834 | 32770.0 |
| 2023-04-10 | HRC | Futures | 1468.8 | 1468.8 | 1468.8 | 1468.8 | 0.0 |
| 2023-04-10 | J1 | Futures | 0.0084181 | 0.0084374 | 0.0083075 | 0.0083223 | 164858.0 |
| 2023-04-10 | J7 | Futures | 0.008439 | 0.008444 | 0.008322 | 0.008337 | 411.0 |
| 2023-04-10 | JB | Futures | 139.54 | 139.59 | 139.28 | 139.43 | 263.0 |
| 2023-04-10 | KC | Futures | 153.33 | 156.0 | 151.66 | 152.49 | 22686.0 |
| 2023-04-10 | KE | Futures | 1017.17 | 1023.85 | 1000.93 | 1016.3 | 22292.0 |
| 2023-04-10 | KRW | Futures | 0.0007729 | 0.0007729 | 0.0007729 | 0.0007729 | 0.0 |
| 2023-04-10 | LBS | Futures | 837.0 | 853.9 | 836.1 | 837.0 | 134.0 |
| 2023-04-10 | LE | Futures | 168.908 | 169.892 | 168.236 | 169.426 | 22000.0 |
| 2023-04-10 | M2K | Futures | 1926.8 | 1933.8 | 1896.1 | 1929.9 | 63726.0 |
| 2023-04-10 | MBT | Futures | 33926.4 | 35425.1 | 33759.2 | 35132.5 | 13957.0 |
| 2023-04-10 | MCL | Futures | 80.44 | 81.14 | 79.61 | 79.74 | 4851.0 |
| 2023-04-10 | MES | Futures | 4465.9 | 4470.22 | 4422.47 | 4462.93 | 727461.0 |
| 2023-04-10 | MET | Futures | 2483.9 | 2517.3 | 2428.1 | 2495.0 | 10888.0 |
> showing 50 of 100 rows — these rows as CSV