PREVIEW / futures_1hour / 2025-01-31
file: by_date/futures_1hour/2025/2025-01-31.parquet size: 58 KB rows: 1,706
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 | 6269.71 | 2480.0 |
| 2025-01-31 01:00:00 | ES | Futures | 6269.97 | 6275.87 | 6268.43 | 6274.07 | 4143.0 |
| 2025-01-31 02:00:00 | ES | Futures | 6273.82 | 6280.99 | 6273.82 | 6278.17 | 7351.0 |
| 2025-01-31 03:00:00 | ES | Futures | 6278.43 | 6280.23 | 6272.28 | 6274.59 | 10682.0 |
| 2025-01-31 04:00:00 | ES | Futures | 6274.59 | 6284.84 | 6274.59 | 6280.74 | 9863.0 |
| 2025-01-31 05:00:00 | ES | Futures | 6280.74 | 6283.05 | 6278.94 | 6280.48 | 6549.0 |
| 2025-01-31 06:00:00 | ES | Futures | 6280.23 | 6285.35 | 6280.23 | 6285.35 | 6934.0 |
| 2025-01-31 07:00:00 | ES | Futures | 6285.35 | 6286.38 | 6281.25 | 6281.76 | 13602.0 |
| 2025-01-31 08:00:00 | ES | Futures | 6281.76 | 6286.12 | 6277.15 | 6283.56 | 25233.0 |
| 2025-01-31 09:00:00 | ES | Futures | 6283.3 | 6285.61 | 6273.05 | 6285.35 | 137042.0 |
| 2025-01-31 10:00:00 | ES | Futures | 6285.1 | 6300.99 | 6284.07 | 6299.2 | 185405.0 |
| 2025-01-31 11:00:00 | ES | Futures | 6299.2 | 6304.58 | 6289.71 | 6293.56 | 138087.0 |
| 2025-01-31 12:00:00 | ES | Futures | 6293.56 | 6302.27 | 6284.07 | 6295.61 | 144069.0 |
| 2025-01-31 13:00:00 | ES | Futures | 6295.61 | 6298.17 | 6251.25 | 6257.41 | 299790.0 |
| 2025-01-31 14:00:00 | ES | Futures | 6257.15 | 6262.54 | 6221.52 | 6238.69 | 281073.0 |
| 2025-01-31 15:00:00 | ES | Futures | 6238.69 | 6238.69 | 6212.29 | 6219.46 | 369438.0 |
| 2025-01-31 16:00:00 | ES | Futures | 6219.46 | 6223.82 | 6212.29 | 6220.23 | 81378.0 |
| 2025-01-31 00:00:00 | NQ | Futures | 22369.35 | 22383.76 | 22366.0 | 22376.04 | 2033.0 |
| 2025-01-31 01:00:00 | NQ | Futures | 22375.52 | 22413.35 | 22370.37 | 22400.23 | 3309.0 |
| 2025-01-31 02:00:00 | NQ | Futures | 22401.26 | 22448.09 | 22396.37 | 22429.82 | 6246.0 |
| 2025-01-31 03:00:00 | NQ | Futures | 22429.31 | 22434.97 | 22381.7 | 22391.99 | 6069.0 |
| 2025-01-31 04:00:00 | NQ | Futures | 22393.02 | 22441.4 | 22392.51 | 22422.62 | 5761.0 |
| 2025-01-31 05:00:00 | NQ | Futures | 22422.62 | 22433.68 | 22411.81 | 22421.59 | 6023.0 |
| 2025-01-31 06:00:00 | NQ | Futures | 22421.07 | 22451.18 | 22420.3 | 22445.52 | 5624.0 |
| 2025-01-31 07:00:00 | NQ | Futures | 22445.26 | 22454.01 | 22421.07 | 22422.87 | 7259.0 |
| 2025-01-31 08:00:00 | NQ | Futures | 22422.87 | 22449.64 | 22395.08 | 22431.88 | 16156.0 |
| 2025-01-31 09:00:00 | NQ | Futures | 22431.62 | 22515.0 | 22389.16 | 22510.89 | 71282.0 |
| 2025-01-31 10:00:00 | NQ | Futures | 22509.86 | 22602.24 | 22508.31 | 22581.91 | 82959.0 |
| 2025-01-31 11:00:00 | NQ | Futures | 22581.4 | 22611.51 | 22519.89 | 22546.66 | 53080.0 |
| 2025-01-31 12:00:00 | NQ | Futures | 22547.43 | 22583.72 | 22507.54 | 22559.01 | 45972.0 |
| 2025-01-31 13:00:00 | NQ | Futures | 22559.52 | 22570.85 | 22359.31 | 22390.96 | 97116.0 |
| 2025-01-31 14:00:00 | NQ | Futures | 22391.22 | 22421.84 | 22219.05 | 22297.55 | 87824.0 |
| 2025-01-31 15:00:00 | NQ | Futures | 22297.03 | 22297.03 | 22168.61 | 22214.94 | 95626.0 |
| 2025-01-31 16:00:00 | NQ | Futures | 22215.19 | 22226.52 | 22166.56 | 22204.9 | 23133.0 |
| 2025-01-31 00:00:00 | YM | Futures | 46414.8 | 46450.8 | 46412.7 | 46445.6 | 583.0 |
| 2025-01-31 01:00:00 | YM | Futures | 46443.6 | 46468.3 | 46439.5 | 46454.9 | 463.0 |
| 2025-01-31 02:00:00 | YM | Futures | 46452.8 | 46491.9 | 46447.7 | 46471.4 | 1126.0 |
| 2025-01-31 03:00:00 | YM | Futures | 46473.4 | 46502.2 | 46453.9 | 46486.8 | 1177.0 |
| 2025-01-31 04:00:00 | YM | Futures | 46489.9 | 46550.6 | 46485.8 | 46502.2 | 2198.0 |
| 2025-01-31 05:00:00 | YM | Futures | 46502.2 | 46541.4 | 46500.2 | 46513.6 | 1245.0 |
| 2025-01-31 06:00:00 | YM | Futures | 46511.5 | 46545.5 | 46511.5 | 46545.5 | 889.0 |
| 2025-01-31 07:00:00 | YM | Futures | 46544.4 | 46547.5 | 46508.4 | 46511.5 | 1704.0 |
| 2025-01-31 08:00:00 | YM | Futures | 46512.5 | 46522.8 | 46461.1 | 46491.9 | 3262.0 |
| 2025-01-31 09:00:00 | YM | Futures | 46490.9 | 46517.7 | 46353.0 | 46369.5 | 14146.0 |
| 2025-01-31 10:00:00 | YM | Futures | 46369.5 | 46438.4 | 46340.6 | 46352.0 | 12402.0 |
| 2025-01-31 11:00:00 | YM | Futures | 46352.0 | 46400.3 | 46310.8 | 46343.7 | 7613.0 |
| 2025-01-31 12:00:00 | YM | Futures | 46343.7 | 46435.3 | 46294.3 | 46360.2 | 8662.0 |
| 2025-01-31 13:00:00 | YM | Futures | 46362.3 | 46394.2 | 46061.7 | 46130.7 | 17927.0 |
| 2025-01-31 14:00:00 | YM | Futures | 46131.7 | 46163.6 | 45980.4 | 46101.9 | 21528.0 |
| 2025-01-31 15:00:00 | YM | Futures | 46097.7 | 46098.8 | 45962.9 | 45998.9 | 24025.0 |
> showing 50 of 1,706 rows — these rows as CSV