PREVIEW / futures_30min / 2025-01-31
file: by_date/futures_30min/2025/2025-01-31.parquet size: 95 KB rows: 3,247
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2025-01-31 00:00:00 | ES | Futures | 6267.92 | 6271.25 | 6267.66 | 6270.23 | 1180.0 |
| 2025-01-31 00:30:00 | ES | Futures | 6269.97 | 6270.74 | 6268.69 | 6269.71 | 1300.0 |
| 2025-01-31 01:00:00 | ES | Futures | 6269.97 | 6274.07 | 6268.43 | 6274.07 | 2517.0 |
| 2025-01-31 01:30:00 | ES | Futures | 6273.82 | 6275.87 | 6273.05 | 6274.07 | 1626.0 |
| 2025-01-31 02:00:00 | ES | Futures | 6273.82 | 6280.74 | 6273.82 | 6279.71 | 4060.0 |
| 2025-01-31 02:30:00 | ES | Futures | 6279.46 | 6280.99 | 6278.17 | 6278.17 | 3291.0 |
| 2025-01-31 03:00:00 | ES | Futures | 6278.43 | 6279.71 | 6275.35 | 6277.15 | 5963.0 |
| 2025-01-31 03:30:00 | ES | Futures | 6276.89 | 6280.23 | 6272.28 | 6274.59 | 4719.0 |
| 2025-01-31 04:00:00 | ES | Futures | 6274.59 | 6283.81 | 6274.59 | 6283.81 | 5934.0 |
| 2025-01-31 04:30:00 | ES | Futures | 6284.07 | 6284.84 | 6279.71 | 6280.74 | 3929.0 |
| 2025-01-31 05:00:00 | ES | Futures | 6280.74 | 6282.79 | 6278.94 | 6282.02 | 2983.0 |
| 2025-01-31 05:30:00 | ES | Futures | 6282.02 | 6283.05 | 6279.2 | 6280.48 | 3566.0 |
| 2025-01-31 06:00:00 | ES | Futures | 6280.23 | 6284.84 | 6280.23 | 6283.3 | 3649.0 |
| 2025-01-31 06:30:00 | ES | Futures | 6283.3 | 6285.35 | 6281.76 | 6285.35 | 3285.0 |
| 2025-01-31 07:00:00 | ES | Futures | 6285.35 | 6286.38 | 6282.53 | 6283.56 | 7985.0 |
| 2025-01-31 07:30:00 | ES | Futures | 6283.81 | 6285.35 | 6281.25 | 6281.76 | 5617.0 |
| 2025-01-31 08:00:00 | ES | Futures | 6281.76 | 6283.81 | 6279.97 | 6283.81 | 7486.0 |
| 2025-01-31 08:30:00 | ES | Futures | 6283.56 | 6286.12 | 6277.15 | 6283.56 | 17747.0 |
| 2025-01-31 09:00:00 | ES | Futures | 6283.3 | 6283.3 | 6273.05 | 6278.69 | 26705.0 |
| 2025-01-31 09:30:00 | ES | Futures | 6278.69 | 6285.61 | 6274.33 | 6285.35 | 110337.0 |
| 2025-01-31 10:00:00 | ES | Futures | 6285.1 | 6294.84 | 6284.07 | 6294.07 | 99558.0 |
| 2025-01-31 10:30:00 | ES | Futures | 6294.07 | 6300.99 | 6293.04 | 6299.2 | 85847.0 |
| 2025-01-31 11:00:00 | ES | Futures | 6299.2 | 6304.58 | 6295.35 | 6295.86 | 70447.0 |
| 2025-01-31 11:30:00 | ES | Futures | 6295.61 | 6298.94 | 6289.71 | 6293.56 | 67640.0 |
| 2025-01-31 12:00:00 | ES | Futures | 6293.56 | 6300.22 | 6284.07 | 6299.97 | 95619.0 |
| 2025-01-31 12:30:00 | ES | Futures | 6300.22 | 6302.27 | 6293.56 | 6295.61 | 48450.0 |
| 2025-01-31 13:00:00 | ES | Futures | 6295.61 | 6298.17 | 6270.74 | 6272.28 | 129858.0 |
| 2025-01-31 13:30:00 | ES | Futures | 6272.02 | 6274.07 | 6251.25 | 6257.41 | 169932.0 |
| 2025-01-31 14:00:00 | ES | Futures | 6257.15 | 6262.54 | 6235.87 | 6247.92 | 141247.0 |
| 2025-01-31 14:30:00 | ES | Futures | 6247.92 | 6254.59 | 6221.52 | 6238.69 | 139826.0 |
| 2025-01-31 15:00:00 | ES | Futures | 6238.69 | 6238.69 | 6215.62 | 6218.7 | 133185.0 |
| 2025-01-31 15:30:00 | ES | Futures | 6218.95 | 6235.36 | 6212.29 | 6219.46 | 236253.0 |
| 2025-01-31 16:00:00 | ES | Futures | 6219.46 | 6223.82 | 6212.29 | 6219.72 | 69072.0 |
| 2025-01-31 16:30:00 | ES | Futures | 6219.98 | 6222.03 | 6215.62 | 6220.23 | 12306.0 |
| 2025-01-31 00:00:00 | NQ | Futures | 22369.35 | 22383.76 | 22366.0 | 22375.78 | 1181.0 |
| 2025-01-31 00:30:00 | NQ | Futures | 22375.26 | 22378.35 | 22367.8 | 22376.04 | 852.0 |
| 2025-01-31 01:00:00 | NQ | Futures | 22375.52 | 22401.26 | 22370.37 | 22401.26 | 1535.0 |
| 2025-01-31 01:30:00 | NQ | Futures | 22399.97 | 22413.35 | 22394.82 | 22400.23 | 1774.0 |
| 2025-01-31 02:00:00 | NQ | Futures | 22401.26 | 22448.09 | 22396.37 | 22430.85 | 4005.0 |
| 2025-01-31 02:30:00 | NQ | Futures | 22430.34 | 22435.23 | 22419.01 | 22429.82 | 2241.0 |
| 2025-01-31 03:00:00 | NQ | Futures | 22429.31 | 22434.97 | 22405.89 | 22414.9 | 3351.0 |
| 2025-01-31 03:30:00 | NQ | Futures | 22414.9 | 22430.34 | 22381.7 | 22391.99 | 2718.0 |
| 2025-01-31 04:00:00 | NQ | Futures | 22393.02 | 22434.97 | 22392.51 | 22434.97 | 3448.0 |
| 2025-01-31 04:30:00 | NQ | Futures | 22435.23 | 22441.4 | 22415.67 | 22422.62 | 2313.0 |
| 2025-01-31 05:00:00 | NQ | Futures | 22422.62 | 22432.65 | 22412.84 | 22427.76 | 2000.0 |
| 2025-01-31 05:30:00 | NQ | Futures | 22429.31 | 22433.68 | 22411.81 | 22421.59 | 4023.0 |
| 2025-01-31 06:00:00 | NQ | Futures | 22421.07 | 22446.03 | 22420.3 | 22436.26 | 2612.0 |
| 2025-01-31 06:30:00 | NQ | Futures | 22436.51 | 22451.18 | 22431.11 | 22445.52 | 3012.0 |
| 2025-01-31 07:00:00 | NQ | Futures | 22445.26 | 22454.01 | 22429.05 | 22434.97 | 4268.0 |
| 2025-01-31 07:30:00 | NQ | Futures | 22434.71 | 22440.63 | 22421.07 | 22422.87 | 2991.0 |
> showing 50 of 3,247 rows — these rows as CSV