PREVIEW / futures_daily / 2023-01-04
file: by_date/futures_daily/2023/2023-01-04.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-04 | ES | Futures | 4248.98 | 4308.13 | 4242.06 | 4284.08 | 1912155.0 |
| 2023-01-04 | NQ | Futures | 12279.64 | 12422.45 | 12192.38 | 12344.73 | 758003.0 |
| 2023-01-04 | YM | Futures | 35920.3 | 36272.6 | 35847.9 | 36112.7 | 187173.0 |
| 2023-01-04 | CL | Futures | 67.45 | 67.6 | 63.5 | 63.6 | 352434.0 |
| 2023-01-04 | GC | Futures | 2088.2 | 2117.7 | 2084.6 | 2103.8 | 198354.0 |
| 2023-01-04 | ZN | Futures | 115.997334 | 116.607424 | 115.933114 | 116.302379 | 1520223.0 |
| 2023-01-04 | A6 | Futures | 0.68841 | 0.70447 | 0.68703 | 0.69963 | 128730.0 |
| 2023-01-04 | AD | Futures | 0.74261 | 0.75326 | 0.7419 | 0.75286 | 85962.0 |
| 2023-01-04 | ALI | Futures | 2607.62 | 2619.09 | 2555.01 | 2557.81 | 2582.0 |
| 2023-01-04 | B | Futures | 71.93 | 72.29 | 67.92 | 68.02 | 319305.0 |
| 2023-01-04 | B6 | Futures | 1.2085 | 1.2205 | 1.2073 | 1.2176 | 93980.0 |
| 2023-01-04 | BFX | Futures | 4096.9 | 4096.9 | 4096.9 | 4096.9 | 0.0 |
| 2023-01-04 | BR | Futures | 0.16158 | 0.16256 | 0.16131 | 0.16207 | 829.0 |
| 2023-01-04 | BTC | Futures | 22796.9 | 23331.7 | 22776.4 | 23009.5 | 7387.0 |
| 2023-01-04 | BZ | Futures | 71.1 | 71.48 | 67.2 | 67.31 | 24772.0 |
| 2023-01-04 | C | Futures | 1601.0 | 1610.0 | 1592.0 | 1601.0 | 5128.0 |
| 2023-01-04 | CB | Futures | 230.998 | 231.977 | 230.973 | 231.977 | 2.0 |
| 2023-01-04 | CC | Futures | 1502.0 | 1525.0 | 1497.0 | 1519.0 | 16842.0 |
| 2023-01-04 | CNH | Futures | 6.5269 | 6.5269 | 6.4984 | 6.5201 | 266.0 |
| 2023-01-04 | CSC | Futures | 2.375 | 2.38 | 2.371 | 2.38 | 61.0 |
| 2023-01-04 | CT | Futures | 109.06 | 110.48 | 105.39 | 105.48 | 18860.0 |
| 2023-01-04 | DC | Futures | 22.49 | 22.76 | 22.45 | 22.6 | 255.0 |
| 2023-01-04 | DX | Futures | 101.476 | 101.485 | 100.717 | 101.132 | 22696.0 |
| 2023-01-04 | E1 | Futures | 1.16938 | 1.18301 | 1.16867 | 1.17791 | 20580.0 |
| 2023-01-04 | E6 | Futures | 1.09717 | 1.10607 | 1.09619 | 1.10296 | 207581.0 |
| 2023-01-04 | E7 | Futures | 1.0965 | 1.1052 | 1.0957 | 1.1022 | 7369.0 |
| 2023-01-04 | EBM | Futures | 447.63 | 447.63 | 440.6 | 442.08 | 31803.0 |
| 2023-01-04 | ED | Futures | 94.4371 | 94.462 | 94.4222 | 94.4271 | 83308.0 |
| 2023-01-04 | ER | Futures | 97.66 | 97.691 | 97.645 | 97.67 | 141230.0 |
| 2023-01-04 | ESG | Futures | 364.65 | 367.35 | 361.95 | 365.24 | 700.0 |
| 2023-01-04 | EW | Futures | 2616.6 | 2667.5 | 2608.3 | 2652.2 | 18644.0 |
| 2023-01-04 | FBON | Futures | 120.71 | 122.04 | 120.62 | 121.84 | 205.0 |
| 2023-01-04 | FBTP | Futures | 107.98 | 109.95 | 107.93 | 109.6 | 160865.0 |
| 2023-01-04 | FBTS | Futures | 105.911 | 106.453 | 105.901 | 106.373 | 115495.0 |
| 2023-01-04 | FCE | Futures | 7265.7 | 7420.8 | 7253.7 | 7406.0 | 64331.0 |
| 2023-01-04 | FDAX | Futures | 15417.6 | 15747.2 | 15413.3 | 15725.6 | 71530.0 |
| 2023-01-04 | FDIV | Futures | 170.14 | 172.36 | 170.14 | 172.07 | 57.0 |
| 2023-01-04 | FDXM | Futures | 15324.7 | 15653.4 | 15321.4 | 15630.8 | 52082.0 |
| 2023-01-04 | FDXS | Futures | 15229.4 | 15557.2 | 15218.7 | 15535.8 | 25789.0 |
| 2023-01-04 | FESX | Futures | 3866.3 | 3965.7 | 3865.3 | 3955.7 | 1098483.0 |
| 2023-01-04 | FEU3 | Futures | 97.731 | 97.736 | 97.711 | 97.736 | 4.0 |
| 2023-01-04 | FGBL | Futures | 135.61 | 136.95 | 135.35 | 136.75 | 932356.0 |
| 2023-01-04 | FGBM | Futures | 119.4 | 120.07 | 119.27 | 120.0 | 735989.0 |
| 2023-01-04 | FGBS | Futures | 108.133 | 108.338 | 108.092 | 108.302 | 503661.0 |
| 2023-01-04 | FGBX | Futures | 145.28 | 148.45 | 144.5 | 147.94 | 71007.0 |
| 2023-01-04 | FMWO | Futures | 9259.5 | 9344.2 | 9224.0 | 9301.9 | 3225.0 |
| 2023-01-04 | FOAT | Futures | 126.59 | 128.05 | 126.38 | 127.81 | 181552.0 |
| 2023-01-04 | FSMX | Futures | 27685.5 | 28180.9 | 27685.5 | 28117.3 | 198.0 |
| 2023-01-04 | FTDX | Futures | 3176.4 | 3214.3 | 3173.2 | 3206.3 | 24.0 |
| 2023-01-04 | FTI | Futures | 731.38 | 740.93 | 729.42 | 738.04 | 20858.0 |
> showing 50 of 131 rows — these rows as CSV