PREVIEW / futures_daily / 2024-11-06
file: by_date/futures_daily/2024/2024-11-06.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-11-06 | ES | Futures | 5954.37 | 6104.5 | 5948.74 | 6095.55 | 2023257.0 |
| 2024-11-06 | NQ | Futures | 20884.11 | 21473.64 | 20846.16 | 21431.33 | 632408.0 |
| 2024-11-06 | YM | Futures | 42886.0 | 44427.1 | 42861.8 | 44362.4 | 184773.0 |
| 2024-11-06 | CL | Futures | 69.7 | 70.29 | 67.5 | 69.38 | 388265.0 |
| 2024-11-06 | GC | Futures | 2810.5 | 2816.8 | 2716.7 | 2732.6 | 361313.0 |
| 2024-11-06 | ZN | Futures | 110.623934 | 110.811671 | 109.356711 | 109.68525 | 4168617.0 |
| 2024-11-06 | A6 | Futures | 0.66339 | 0.66439 | 0.6511 | 0.65809 | 175986.0 |
| 2024-11-06 | AD | Futures | 0.72579 | 0.72589 | 0.71847 | 0.72018 | 141967.0 |
| 2024-11-06 | ALI | Futures | 2702.83 | 2708.2 | 2619.17 | 2656.01 | 3287.0 |
| 2024-11-06 | B | Futures | 74.72 | 75.39 | 72.77 | 74.34 | 467562.0 |
| 2024-11-06 | B6 | Futures | 1.3035 | 1.3043 | 1.2828 | 1.2883 | 169123.0 |
| 2024-11-06 | BFX | Futures | 4250.5 | 4250.5 | 4250.5 | 4250.5 | 0.0 |
| 2024-11-06 | BR | Futures | 0.16908 | 0.17171 | 0.16577 | 0.17113 | 36472.0 |
| 2024-11-06 | BTC | Futures | 75679.2 | 83398.5 | 75295.4 | 83112.0 | 29081.0 |
| 2024-11-06 | BZ | Futures | 73.41 | 73.92 | 71.33 | 72.86 | 57996.0 |
| 2024-11-06 | C | Futures | 5554.0 | 5601.0 | 5377.0 | 5390.0 | 2504.0 |
| 2024-11-06 | CB | Futures | 284.529 | 284.944 | 282.973 | 282.973 | 5.0 |
| 2024-11-06 | CC | Futures | 6008.0 | 6027.0 | 5737.0 | 5793.0 | 11791.0 |
| 2024-11-06 | CNH | Futures | 7.0552 | 7.1618 | 7.0413 | 7.1508 | 3274.0 |
| 2024-11-06 | CSC | Futures | 1.956 | 1.958 | 1.94 | 1.951 | 217.0 |
| 2024-11-06 | CT | Futures | 76.68 | 76.74 | 75.59 | 76.4 | 32812.0 |
| 2024-11-06 | DC | Futures | 19.07 | 19.11 | 18.97 | 18.99 | 864.0 |
| 2024-11-06 | DX | Futures | 103.826 | 105.057 | 103.676 | 104.698 | 52557.0 |
| 2024-11-06 | E1 | Futures | 1.17433 | 1.17615 | 1.15556 | 1.15717 | 55625.0 |
| 2024-11-06 | E6 | Futures | 1.09921 | 1.10007 | 1.07441 | 1.07973 | 388385.0 |
| 2024-11-06 | E7 | Futures | 1.0988 | 1.0997 | 1.0742 | 1.0794 | 19094.0 |
| 2024-11-06 | EBM | Futures | 232.78 | 237.15 | 232.78 | 236.6 | 47422.0 |
| 2024-11-06 | ER | Futures | 97.765 | 97.835 | 97.765 | 97.8 | 366873.0 |
| 2024-11-06 | ESG | Futures | 521.52 | 524.69 | 519.52 | 523.87 | 821.0 |
| 2024-11-06 | EW | Futures | 3215.9 | 3373.5 | 3205.0 | 3337.0 | 15041.0 |
| 2024-11-06 | FBON | Futures | 124.09 | 124.5 | 123.65 | 123.89 | 446.0 |
| 2024-11-06 | FBTP | Futures | 118.87 | 119.47 | 118.14 | 118.42 | 409707.0 |
| 2024-11-06 | FBTS | Futures | 107.01 | 107.19 | 106.86 | 107.0 | 180325.0 |
| 2024-11-06 | FCE | Futures | 7434.8 | 7578.2 | 7338.8 | 7373.8 | 84482.0 |
| 2024-11-06 | FDAX | Futures | 19575.8 | 19841.4 | 19271.9 | 19307.2 | 63712.0 |
| 2024-11-06 | FDIV | Futures | 187.16 | 187.16 | 183.63 | 183.98 | 38.0 |
| 2024-11-06 | FDXM | Futures | 19534.5 | 19798.4 | 19230.2 | 19265.5 | 47795.0 |
| 2024-11-06 | FDXS | Futures | 19484.7 | 19752.1 | 19188.1 | 19222.3 | 66072.0 |
| 2024-11-06 | FESX | Futures | 4894.8 | 4968.9 | 4804.7 | 4814.7 | 1265190.0 |
| 2024-11-06 | FEU3 | Futures | 97.805 | 97.82 | 97.785 | 97.805 | 2567.0 |
| 2024-11-06 | FGBL | Futures | 133.57 | 133.94 | 132.28 | 133.45 | 1620587.0 |
| 2024-11-06 | FGBM | Futures | 117.52 | 117.95 | 117.13 | 117.78 | 869575.0 |
| 2024-11-06 | FGBS | Futures | 106.848 | 107.074 | 106.813 | 107.019 | 1035387.0 |
| 2024-11-06 | FGBX | Futures | 133.74 | 133.96 | 130.01 | 131.44 | 188118.0 |
| 2024-11-06 | FMWO | Futures | 12287.8 | 12424.6 | 12257.7 | 12313.7 | 8641.0 |
| 2024-11-06 | FOAT | Futures | 124.19 | 124.41 | 122.86 | 123.71 | 226447.0 |
| 2024-11-06 | FSMX | Futures | 26809.9 | 27058.0 | 26419.7 | 26487.7 | 674.0 |
| 2024-11-06 | FTDX | Futures | 3461.8 | 3465.3 | 3371.6 | 3372.1 | 66.0 |
| 2024-11-06 | FTI | Futures | 891.09 | 903.5 | 879.08 | 881.43 | 14728.0 |
| 2024-11-06 | FTUK | Futures | 8215.7 | 8334.9 | 8173.6 | 8189.6 | 117316.0 |
> showing 50 of 130 rows — these rows as CSV