PREVIEW / futures_daily / 2023-12-27
file: by_date/futures_daily/2023/2023-12-27.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-12-27 | ES | Futures | 5110.52 | 5119.78 | 5098.61 | 5116.61 | 1042284.0 |
| 2023-12-27 | NQ | Futures | 18209.16 | 18254.71 | 18172.13 | 18233.66 | 424302.0 |
| 2023-12-27 | YM | Futures | 39500.7 | 39617.4 | 39400.7 | 39596.5 | 90396.0 |
| 2023-12-27 | CL | Futures | 66.83 | 67.13 | 65.45 | 65.75 | 253323.0 |
| 2023-12-27 | GC | Futures | 2216.6 | 2234.2 | 2209.7 | 2231.3 | 128179.0 |
| 2023-12-27 | ZN | Futures | 114.062425 | 114.80607 | 113.983314 | 114.758603 | 906098.0 |
| 2023-12-27 | A6 | Futures | 0.68807 | 0.69089 | 0.68747 | 0.68978 | 60739.0 |
| 2023-12-27 | AD | Futures | 0.76403 | 0.76508 | 0.76262 | 0.76302 | 89861.0 |
| 2023-12-27 | ALI | Futures | 2532.07 | 2636.02 | 2517.26 | 2600.91 | 4091.0 |
| 2023-12-27 | B | Futures | 73.94 | 74.36 | 72.71 | 73.0 | 282664.0 |
| 2023-12-27 | B6 | Futures | 1.2731 | 1.2809 | 1.2706 | 1.2801 | 60887.0 |
| 2023-12-27 | BFX | Futures | 3773.1 | 3773.1 | 3773.1 | 3773.1 | 0.0 |
| 2023-12-27 | BR | Futures | 0.1957 | 0.19584 | 0.19565 | 0.19565 | 1223.0 |
| 2023-12-27 | BTC | Futures | 55619.3 | 57206.7 | 55167.6 | 57058.3 | 7314.0 |
| 2023-12-27 | BZ | Futures | 73.19 | 73.55 | 71.96 | 72.23 | 23676.0 |
| 2023-12-27 | C | Futures | 2974.0 | 2977.0 | 2935.0 | 2937.0 | 4945.0 |
| 2023-12-27 | CB | Futures | 260.524 | 262.43 | 260.524 | 261.261 | 20.0 |
| 2023-12-27 | CC | Futures | 2486.0 | 2497.0 | 2475.0 | 2477.0 | 12495.0 |
| 2023-12-27 | CNH | Futures | 6.9207 | 6.9324 | 6.9173 | 6.9226 | 372.0 |
| 2023-12-27 | CSC | Futures | 1.727 | 1.729 | 1.72 | 1.729 | 52.0 |
| 2023-12-27 | CT | Futures | 96.19 | 97.1 | 95.6 | 96.82 | 13598.0 |
| 2023-12-27 | DC | Futures | 16.38 | 16.45 | 16.27 | 16.44 | 210.0 |
| 2023-12-27 | DX | Futures | 100.164 | 100.194 | 99.481 | 99.639 | 9394.0 |
| 2023-12-27 | E1 | Futures | 1.22713 | 1.2453 | 1.22515 | 1.24187 | 26825.0 |
| 2023-12-27 | E6 | Futures | 1.12275 | 1.1306 | 1.12123 | 1.12837 | 155137.0 |
| 2023-12-27 | E7 | Futures | 1.1225 | 1.1303 | 1.1211 | 1.1282 | 4179.0 |
| 2023-12-27 | EBM | Futures | 294.84 | 294.84 | 291.21 | 291.87 | 16064.0 |
| 2023-12-27 | ER | Futures | 97.858 | 97.899 | 97.858 | 97.893 | 113096.0 |
| 2023-12-27 | ESG | Futures | 432.37 | 433.22 | 431.72 | 432.89 | 226.0 |
| 2023-12-27 | EW | Futures | 2937.0 | 2944.2 | 2925.6 | 2935.8 | 10014.0 |
| 2023-12-27 | FBON | Futures | 127.37 | 128.35 | 127.27 | 127.94 | 169.0 |
| 2023-12-27 | FBTP | Futures | 119.81 | 120.39 | 119.66 | 120.09 | 99254.0 |
| 2023-12-27 | FBTS | Futures | 107.897 | 107.957 | 107.816 | 107.836 | 58092.0 |
| 2023-12-27 | FCE | Futures | 8054.6 | 8062.5 | 8002.8 | 8016.0 | 29369.0 |
| 2023-12-27 | FDAX | Futures | 17759.1 | 17780.1 | 17670.1 | 17717.2 | 35244.0 |
| 2023-12-27 | FDIV | Futures | 180.98 | 182.01 | 180.98 | 182.01 | 1.0 |
| 2023-12-27 | FDXM | Futures | 17619.2 | 17644.1 | 17538.1 | 17583.9 | 25017.0 |
| 2023-12-27 | FDXS | Futures | 17474.2 | 17528.9 | 17422.5 | 17468.0 | 10084.0 |
| 2023-12-27 | FESX | Futures | 4557.1 | 4568.0 | 4536.2 | 4546.1 | 314541.0 |
| 2023-12-27 | FEU3 | Futures | 97.863 | 97.893 | 97.863 | 97.893 | 1392.0 |
| 2023-12-27 | FGBL | Futures | 139.47 | 140.63 | 139.45 | 140.43 | 354366.0 |
| 2023-12-27 | FGBM | Futures | 121.22 | 121.67 | 121.22 | 121.58 | 262679.0 |
| 2023-12-27 | FGBS | Futures | 108.124 | 108.22 | 108.109 | 108.195 | 260049.0 |
| 2023-12-27 | FGBX | Futures | 146.28 | 149.14 | 146.2 | 148.73 | 48826.0 |
| 2023-12-27 | FMWO | Futures | 10899.4 | 10939.7 | 10895.1 | 10913.6 | 2131.0 |
| 2023-12-27 | FOAT | Futures | 131.2 | 132.17 | 131.19 | 132.0 | 75299.0 |
| 2023-12-27 | FSMX | Futures | 28055.4 | 28075.8 | 27857.1 | 27976.7 | 228.0 |
| 2023-12-27 | FTDX | Futures | 3468.1 | 3471.7 | 3463.9 | 3463.9 | 19.0 |
| 2023-12-27 | FTI | Futures | 813.97 | 814.79 | 808.84 | 810.45 | 8302.0 |
| 2023-12-27 | FTUK | Futures | 7780.9 | 7815.5 | 7762.4 | 7782.9 | 69608.0 |
> showing 50 of 130 rows — these rows as CSV