PREVIEW / futures_daily / 2024-06-27
file: by_date/futures_daily/2024/2024-06-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 |
|---|---|---|---|---|---|---|---|
| 2024-06-27 | ES | Futures | 5715.04 | 5737.77 | 5697.23 | 5728.47 | 1257121.0 |
| 2024-06-27 | NQ | Futures | 20671.34 | 20848.3 | 20596.98 | 20768.24 | 589649.0 |
| 2024-06-27 | YM | Futures | 40280.2 | 40434.2 | 40167.0 | 40331.2 | 111391.0 |
| 2024-06-27 | CL | Futures | 73.86 | 74.94 | 73.54 | 74.67 | 306342.0 |
| 2024-06-27 | GC | Futures | 2414.5 | 2448.6 | 2411.8 | 2442.9 | 140228.0 |
| 2024-06-27 | ZN | Futures | 110.574754 | 110.936007 | 110.433395 | 110.826061 | 1948452.0 |
| 2024-06-27 | A6 | Futures | 0.66709 | 0.66964 | 0.66624 | 0.66714 | 92405.0 |
| 2024-06-27 | AD | Futures | 0.73479 | 0.73625 | 0.73424 | 0.73529 | 86745.0 |
| 2024-06-27 | ALI | Futures | 2576.86 | 2587.53 | 2554.49 | 2558.39 | 384.0 |
| 2024-06-27 | B | Futures | 81.13 | 82.39 | 80.97 | 82.08 | 494694.0 |
| 2024-06-27 | B6 | Futures | 1.2625 | 1.2674 | 1.2616 | 1.2648 | 84177.0 |
| 2024-06-27 | BFX | Futures | 3957.3 | 3957.3 | 3957.3 | 3957.3 | 0.0 |
| 2024-06-27 | BR | Futures | 0.17432 | 0.17432 | 0.17432 | 0.17432 | 0.0 |
| 2024-06-27 | BTC | Futures | 70024.2 | 71728.1 | 69596.8 | 70485.8 | 6817.0 |
| 2024-06-27 | BZ | Futures | 79.67 | 80.72 | 79.35 | 80.43 | 49291.0 |
| 2024-06-27 | C | Futures | 6982.0 | 6982.0 | 6240.0 | 6409.0 | 5246.0 |
| 2024-06-27 | CB | Futures | 304.204 | 304.932 | 304.204 | 304.446 | 44.0 |
| 2024-06-27 | CC | Futures | 5452.0 | 5497.0 | 4996.0 | 5095.0 | 8175.0 |
| 2024-06-27 | CNH | Futures | 7.1666 | 7.1715 | 7.1631 | 7.1695 | 576.0 |
| 2024-06-27 | CSC | Futures | 1.983 | 1.988 | 1.961 | 1.961 | 56.0 |
| 2024-06-27 | CT | Futures | 83.38 | 84.44 | 82.19 | 83.02 | 37.0 |
| 2024-06-27 | DC | Futures | 19.12 | 19.15 | 18.79 | 18.81 | 229.0 |
| 2024-06-27 | DX | Futures | 105.199 | 105.219 | 104.836 | 105.031 | 9853.0 |
| 2024-06-27 | E1 | Futures | 1.14642 | 1.14795 | 1.14393 | 1.14439 | 20934.0 |
| 2024-06-27 | E6 | Futures | 1.08033 | 1.08486 | 1.07982 | 1.08269 | 179261.0 |
| 2024-06-27 | E7 | Futures | 1.08 | 1.0844 | 1.0795 | 1.0824 | 2389.0 |
| 2024-06-27 | EBM | Futures | 259.92 | 266.05 | 259.63 | 265.47 | 35556.0 |
| 2024-06-27 | ER | Futures | 97.533 | 97.548 | 97.528 | 97.538 | 133095.0 |
| 2024-06-27 | ESG | Futures | 493.02 | 494.12 | 491.76 | 492.64 | 439.0 |
| 2024-06-27 | EW | Futures | 2993.9 | 3009.2 | 2985.0 | 3006.1 | 9389.0 |
| 2024-06-27 | FBON | Futures | 121.82 | 122.09 | 121.74 | 121.91 | 83.0 |
| 2024-06-27 | FBTP | Futures | 115.4 | 115.55 | 115.09 | 115.24 | 317661.0 |
| 2024-06-27 | FBTS | Futures | 105.88 | 105.95 | 105.85 | 105.87 | 150797.0 |
| 2024-06-27 | FCE | Futures | 7865.1 | 7880.6 | 7759.0 | 7769.3 | 50736.0 |
| 2024-06-27 | FDAX | Futures | 18716.2 | 18855.3 | 18674.3 | 18786.8 | 31754.0 |
| 2024-06-27 | FDIV | Futures | 184.96 | 185.26 | 184.96 | 185.26 | 4.0 |
| 2024-06-27 | FDXM | Futures | 18629.1 | 18769.6 | 18587.3 | 18699.3 | 23375.0 |
| 2024-06-27 | FDXS | Futures | 18607.8 | 18718.5 | 18540.8 | 18650.4 | 22508.0 |
| 2024-06-27 | FESX | Futures | 4986.1 | 5015.3 | 4974.0 | 4979.0 | 602365.0 |
| 2024-06-27 | FEU3 | Futures | 97.543 | 97.553 | 97.538 | 97.548 | 2680.0 |
| 2024-06-27 | FGBL | Futures | 133.28 | 133.56 | 133.05 | 133.41 | 905485.0 |
| 2024-06-27 | FGBM | Futures | 117.25 | 117.43 | 117.15 | 117.36 | 537674.0 |
| 2024-06-27 | FGBS | Futures | 106.485 | 106.54 | 106.449 | 106.515 | 431144.0 |
| 2024-06-27 | FGBX | Futures | 131.88 | 132.79 | 131.48 | 132.36 | 97727.0 |
| 2024-06-27 | FMWO | Futures | 11742.0 | 11789.1 | 11735.7 | 11750.4 | 4022.0 |
| 2024-06-27 | FOAT | Futures | 123.23 | 123.33 | 122.85 | 122.99 | 237385.0 |
| 2024-06-27 | FSMX | Futures | 25805.4 | 26242.0 | 25794.3 | 25794.3 | 67.0 |
| 2024-06-27 | FTDX | Futures | 3426.4 | 3436.6 | 3418.3 | 3424.4 | 35.0 |
| 2024-06-27 | FTI | Futures | 939.93 | 944.24 | 939.22 | 940.42 | 7943.0 |
| 2024-06-27 | FTUK | Futures | 8270.8 | 8303.3 | 8226.6 | 8242.2 | 85980.0 |
> showing 50 of 130 rows — these rows as CSV