PREVIEW / futures_daily / 2024-05-01
file: by_date/futures_daily/2024/2024-05-01.parquet size: 9 KB rows: 101
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-05-01 | ES | Futures | 5275.86 | 5356.04 | 5263.06 | 5272.2 | 1955160.0 |
| 2024-05-01 | NQ | Futures | 18338.49 | 18685.83 | 18272.07 | 18313.02 | 791170.0 |
| 2024-05-01 | YM | Futures | 39032.7 | 39654.3 | 38974.0 | 39182.9 | 174074.0 |
| 2024-05-01 | CL | Futures | 73.59 | 73.67 | 71.2 | 71.35 | 441978.0 |
| 2024-05-01 | GC | Futures | 2402.8 | 2446.0 | 2396.0 | 2416.2 | 227384.0 |
| 2024-05-01 | ZN | Futures | 108.215774 | 108.971097 | 108.15283 | 108.876682 | 2218852.0 |
| 2024-05-01 | A6 | Futures | 0.65035 | 0.65692 | 0.6494 | 0.65617 | 145951.0 |
| 2024-05-01 | AD | Futures | 0.73042 | 0.73439 | 0.73012 | 0.73394 | 112481.0 |
| 2024-05-01 | ALI | Futures | 2742.37 | 2837.74 | 2706.87 | 2724.62 | 1861.0 |
| 2024-05-01 | B | Futures | 81.63 | 81.71 | 79.24 | 79.38 | 482834.0 |
| 2024-05-01 | B6 | Futures | 1.2492 | 1.255 | 1.2465 | 1.2545 | 116852.0 |
| 2024-05-01 | BR | Futures | 0.18556 | 0.18788 | 0.18551 | 0.1872 | 5252.0 |
| 2024-05-01 | BTC | Futures | 70219.5 | 71156.2 | 66222.4 | 66740.3 | 12640.0 |
| 2024-05-01 | BZ | Futures | 80.41 | 80.41 | 77.91 | 78.05 | 48165.0 |
| 2024-05-01 | C | Futures | 7279.0 | 7643.0 | 6826.0 | 6836.0 | 4381.0 |
| 2024-05-01 | CB | Futures | 301.327 | 305.04 | 301.327 | 302.947 | 27.0 |
| 2024-05-01 | CC | Futures | 5788.0 | 5915.0 | 4944.0 | 5165.0 | 19997.0 |
| 2024-05-01 | CNH | Futures | 7.0986 | 7.1005 | 7.0799 | 7.0839 | 265.0 |
| 2024-05-01 | CSC | Futures | 1.81 | 1.81 | 1.792 | 1.794 | 196.0 |
| 2024-05-01 | CT | Futures | 92.61 | 92.61 | 89.7 | 90.24 | 32655.0 |
| 2024-05-01 | DC | Futures | 17.25 | 17.29 | 17.03 | 17.14 | 963.0 |
| 2024-05-01 | DX | Futures | 105.439 | 105.608 | 104.551 | 104.862 | 30653.0 |
| 2024-05-01 | E1 | Futures | 1.1244 | 1.13042 | 1.12075 | 1.1281 | 32014.0 |
| 2024-05-01 | E6 | Futures | 1.07889 | 1.0856 | 1.07712 | 1.08505 | 201668.0 |
| 2024-05-01 | E7 | Futures | 1.0789 | 1.0853 | 1.077 | 1.0849 | 3509.0 |
| 2024-05-01 | ER | Futures | 97.503 | 97.503 | 97.503 | 97.503 | 0.0 |
| 2024-05-01 | ESG | Futures | 447.89 | 452.49 | 445.97 | 446.09 | 630.0 |
| 2024-05-01 | EW | Futures | 2944.5 | 2998.4 | 2931.2 | 2948.9 | 19237.0 |
| 2024-05-01 | FTUK | Futures | 8169.6 | 8208.1 | 8125.5 | 8149.0 | 59276.0 |
| 2024-05-01 | G | Futures | 96.03 | 96.38 | 95.83 | 96.07 | 156681.0 |
| 2024-05-01 | GF | Futures | 245.052 | 246.256 | 240.788 | 242.218 | 2670.0 |
| 2024-05-01 | GSCI | Futures | 605.86 | 605.86 | 597.52 | 598.09 | 14.0 |
| 2024-05-01 | HE | Futures | 82.844 | 83.571 | 80.988 | 81.069 | 31304.0 |
| 2024-05-01 | HG | Futures | 4.8126 | 4.8725 | 4.7824 | 4.8179 | 80008.0 |
| 2024-05-01 | HH | Futures | 2.503 | 2.514 | 2.448 | 2.474 | 3016.0 |
| 2024-05-01 | HO | Futures | 2.4518 | 2.4606 | 2.3777 | 2.3837 | 57890.0 |
| 2024-05-01 | HRC | Futures | 1023.3 | 1023.3 | 1009.4 | 1022.0 | 421.0 |
| 2024-05-01 | J1 | Futures | 0.006595 | 0.006797 | 0.0065821 | 0.0066188 | 276601.0 |
| 2024-05-01 | J7 | Futures | 0.00661 | 0.006813 | 0.006598 | 0.006635 | 3261.0 |
| 2024-05-01 | JB | Futures | 139.6 | 139.6 | 139.34 | 139.42 | 1207.0 |
| 2024-05-01 | KC | Futures | 194.38 | 197.41 | 192.66 | 195.6 | 24625.0 |
| 2024-05-01 | KE | Futures | 728.62 | 731.49 | 715.41 | 717.99 | 34482.0 |
| 2024-05-01 | KRW | Futures | 0.0007167 | 0.00072 | 0.0007161 | 0.000719 | 12.0 |
| 2024-05-01 | LBS | Futures | 663.6 | 669.6 | 649.7 | 650.4 | 607.0 |
| 2024-05-01 | LE | Futures | 179.346 | 180.623 | 176.384 | 177.559 | 38327.0 |
| 2024-05-01 | M2K | Futures | 2050.0 | 2100.1 | 2038.9 | 2057.1 | 90274.0 |
| 2024-05-01 | MBT | Futures | 63765.5 | 64971.3 | 60451.1 | 60929.2 | 62876.0 |
| 2024-05-01 | MCL | Futures | 82.89 | 82.96 | 80.15 | 80.33 | 79738.0 |
| 2024-05-01 | MES | Futures | 5216.77 | 5295.27 | 5203.86 | 5212.89 | 1167751.0 |
| 2024-05-01 | MET | Futures | 3315.0 | 3379.7 | 3151.1 | 3271.0 | 26081.0 |
> showing 50 of 101 rows — these rows as CSV