PREVIEW / futures_daily / 2024-08-19
file: by_date/futures_daily/2024/2024-08-19.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-08-19 | ES | Futures | 5767.72 | 5817.04 | 5748.36 | 5815.24 | 1010612.0 |
| 2024-08-19 | NQ | Futures | 20342.81 | 20594.39 | 20235.29 | 20579.88 | 429305.0 |
| 2024-08-19 | YM | Futures | 41624.2 | 41862.8 | 41545.7 | 41830.2 | 92057.0 |
| 2024-08-19 | CL | Futures | 71.14 | 71.39 | 69.24 | 69.43 | 422098.0 |
| 2024-08-19 | GC | Futures | 2603.3 | 2603.5 | 2576.8 | 2594.8 | 155994.0 |
| 2024-08-19 | ZN | Futures | 113.700376 | 113.951682 | 113.559016 | 113.810322 | 1352232.0 |
| 2024-08-19 | A6 | Futures | 0.66849 | 0.67485 | 0.66824 | 0.67455 | 92391.0 |
| 2024-08-19 | AD | Futures | 0.73519 | 0.73796 | 0.73499 | 0.73771 | 89622.0 |
| 2024-08-19 | ALI | Futures | 2378.74 | 2452.71 | 2376.68 | 2447.29 | 2634.0 |
| 2024-08-19 | B | Futures | 77.52 | 77.72 | 75.45 | 75.63 | 366537.0 |
| 2024-08-19 | B6 | Futures | 1.2944 | 1.2998 | 1.294 | 1.2992 | 100310.0 |
| 2024-08-19 | BFX | Futures | 4081.0 | 4081.0 | 4081.0 | 4081.0 | 0.0 |
| 2024-08-19 | BR | Futures | 0.17649 | 0.17919 | 0.176 | 0.17832 | 21105.0 |
| 2024-08-19 | BTC | Futures | 66953.6 | 67076.9 | 65047.0 | 66392.8 | 6577.0 |
| 2024-08-19 | BZ | Futures | 75.99 | 76.08 | 73.94 | 74.09 | 45853.0 |
| 2024-08-19 | C | Futures | 6283.0 | 6570.0 | 6184.0 | 6299.0 | 1633.0 |
| 2024-08-19 | CB | Futures | 313.041 | 313.866 | 310.71 | 313.235 | 61.0 |
| 2024-08-19 | CC | Futures | 5814.0 | 6224.0 | 5704.0 | 6009.0 | 12922.0 |
| 2024-08-19 | CNH | Futures | 7.0486 | 7.0505 | 7.0155 | 7.0199 | 2496.0 |
| 2024-08-19 | CSC | Futures | 2.092 | 2.117 | 2.085 | 2.117 | 130.0 |
| 2024-08-19 | CT | Futures | 75.02 | 76.95 | 75.02 | 76.36 | 23.0 |
| 2024-08-19 | DC | Futures | 20.29 | 20.64 | 20.24 | 20.62 | 990.0 |
| 2024-08-19 | DX | Futures | 101.687 | 101.806 | 101.179 | 101.21 | 12226.0 |
| 2024-08-19 | E1 | Futures | 1.17984 | 1.18625 | 1.1778 | 1.18488 | 26620.0 |
| 2024-08-19 | E6 | Futures | 1.11272 | 1.11851 | 1.11206 | 1.11806 | 179877.0 |
| 2024-08-19 | E7 | Futures | 1.1123 | 1.118 | 1.1118 | 1.1177 | 2913.0 |
| 2024-08-19 | EBM | Futures | 238.6 | 241.23 | 235.68 | 236.56 | 10130.0 |
| 2024-08-19 | ER | Futures | 97.634 | 97.644 | 97.624 | 97.629 | 81685.0 |
| 2024-08-19 | ESG | Futures | 495.84 | 501.03 | 495.54 | 500.87 | 478.0 |
| 2024-08-19 | EW | Futures | 3083.9 | 3103.9 | 3068.1 | 3102.9 | 5961.0 |
| 2024-08-19 | FBON | Futures | 124.89 | 125.01 | 124.77 | 124.84 | 7.0 |
| 2024-08-19 | FBTP | Futures | 118.89 | 119.19 | 118.67 | 118.8 | 149352.0 |
| 2024-08-19 | FBTS | Futures | 106.928 | 106.979 | 106.888 | 106.908 | 77657.0 |
| 2024-08-19 | FCE | Futures | 7601.2 | 7669.8 | 7585.5 | 7651.0 | 25187.0 |
| 2024-08-19 | FDAX | Futures | 18813.4 | 18942.2 | 18764.3 | 18914.6 | 28337.0 |
| 2024-08-19 | FDIV | Futures | 183.37 | 184.41 | 183.37 | 184.41 | 34.0 |
| 2024-08-19 | FDXM | Futures | 18733.9 | 18854.1 | 18675.9 | 18826.6 | 14620.0 |
| 2024-08-19 | FDXS | Futures | 18706.3 | 18805.8 | 18628.1 | 18777.4 | 12817.0 |
| 2024-08-19 | FESX | Futures | 4903.4 | 4938.7 | 4891.3 | 4930.6 | 433992.0 |
| 2024-08-19 | FEU3 | Futures | 97.654 | 97.654 | 97.634 | 97.639 | 1332.0 |
| 2024-08-19 | FGBL | Futures | 135.53 | 136.02 | 135.48 | 135.54 | 506476.0 |
| 2024-08-19 | FGBM | Futures | 118.49 | 118.69 | 118.43 | 118.46 | 368453.0 |
| 2024-08-19 | FGBS | Futures | 106.958 | 107.039 | 106.943 | 106.953 | 326908.0 |
| 2024-08-19 | FGBX | Futures | 136.85 | 138.04 | 136.57 | 136.77 | 53894.0 |
| 2024-08-19 | FMWO | Futures | 11911.7 | 12017.6 | 11886.6 | 11966.2 | 3842.0 |
| 2024-08-19 | FOAT | Futures | 125.74 | 126.26 | 125.74 | 125.84 | 93485.0 |
| 2024-08-19 | FSMX | Futures | 25159.0 | 25305.2 | 25107.6 | 25265.9 | 169.0 |
| 2024-08-19 | FTDX | Futures | 3418.3 | 3433.1 | 3418.3 | 3432.6 | 12.0 |
| 2024-08-19 | FTI | Futures | 915.69 | 920.43 | 912.52 | 919.36 | 5863.0 |
| 2024-08-19 | FTUK | Futures | 8350.0 | 8423.7 | 8322.9 | 8412.6 | 53262.0 |
> showing 50 of 130 rows — these rows as CSV