PREVIEW / futures_1hour / 2025-08-21
file: by_date/futures_1hour/2025/2025-08-21.parquet size: 64 KB rows: 2,044
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-08-21 00:00:00 | ES | Futures | 6461.84 | 6462.6 | 6459.33 | 6460.08 | 2594.0 |
| 2025-08-21 01:00:00 | ES | Futures | 6460.33 | 6462.1 | 6454.54 | 6461.34 | 4193.0 |
| 2025-08-21 02:00:00 | ES | Futures | 6461.59 | 6466.88 | 6460.33 | 6464.36 | 4607.0 |
| 2025-08-21 03:00:00 | ES | Futures | 6464.36 | 6465.37 | 6457.56 | 6461.09 | 8733.0 |
| 2025-08-21 04:00:00 | ES | Futures | 6461.34 | 6464.87 | 6451.01 | 6451.27 | 9133.0 |
| 2025-08-21 05:00:00 | ES | Futures | 6451.27 | 6456.3 | 6449.25 | 6451.77 | 7330.0 |
| 2025-08-21 06:00:00 | ES | Futures | 6451.77 | 6452.53 | 6442.95 | 6451.01 | 10622.0 |
| 2025-08-21 07:00:00 | ES | Futures | 6450.76 | 6456.3 | 6442.2 | 6445.72 | 15593.0 |
| 2025-08-21 08:00:00 | ES | Futures | 6445.72 | 6445.98 | 6432.63 | 6434.89 | 29092.0 |
| 2025-08-21 09:00:00 | ES | Futures | 6434.64 | 6445.72 | 6423.31 | 6431.87 | 179647.0 |
| 2025-08-21 10:00:00 | ES | Futures | 6431.62 | 6460.33 | 6426.33 | 6452.27 | 196209.0 |
| 2025-08-21 11:00:00 | ES | Futures | 6452.02 | 6456.56 | 6433.13 | 6436.15 | 159191.0 |
| 2025-08-21 12:00:00 | ES | Futures | 6435.9 | 6440.69 | 6426.58 | 6428.85 | 115332.0 |
| 2025-08-21 13:00:00 | ES | Futures | 6428.85 | 6442.45 | 6418.02 | 6439.43 | 112346.0 |
| 2025-08-21 14:00:00 | ES | Futures | 6439.43 | 6443.21 | 6430.86 | 6441.69 | 82094.0 |
| 2025-08-21 15:00:00 | ES | Futures | 6441.44 | 6445.47 | 6430.86 | 6436.15 | 155663.0 |
| 2025-08-21 16:00:00 | ES | Futures | 6436.41 | 6440.18 | 6433.89 | 6438.67 | 31762.0 |
| 2025-08-21 18:00:00 | ES | Futures | 6439.93 | 6445.47 | 6439.43 | 6444.72 | 5569.0 |
| 2025-08-21 19:00:00 | ES | Futures | 6444.47 | 6446.48 | 6442.2 | 6446.23 | 3293.0 |
| 2025-08-21 20:00:00 | ES | Futures | 6445.98 | 6447.24 | 6433.13 | 6439.43 | 9061.0 |
| 2025-08-21 21:00:00 | ES | Futures | 6439.43 | 6440.94 | 6435.65 | 6437.92 | 4726.0 |
| 2025-08-21 22:00:00 | ES | Futures | 6437.92 | 6442.7 | 6436.66 | 6436.91 | 4957.0 |
| 2025-08-21 23:00:00 | ES | Futures | 6436.91 | 6437.41 | 6433.38 | 6434.14 | 3151.0 |
| 2025-08-21 00:00:00 | NQ | Futures | 23544.8 | 23550.09 | 23533.2 | 23543.54 | 2319.0 |
| 2025-08-21 01:00:00 | NQ | Futures | 23543.28 | 23552.36 | 23514.28 | 23544.04 | 3221.0 |
| 2025-08-21 02:00:00 | NQ | Futures | 23543.79 | 23571.78 | 23534.96 | 23557.91 | 4237.0 |
| 2025-08-21 03:00:00 | NQ | Futures | 23557.4 | 23562.95 | 23524.87 | 23546.31 | 5200.0 |
| 2025-08-21 04:00:00 | NQ | Futures | 23546.81 | 23560.94 | 23498.14 | 23501.17 | 5903.0 |
| 2025-08-21 05:00:00 | NQ | Futures | 23500.92 | 23531.94 | 23492.85 | 23507.73 | 4702.0 |
| 2025-08-21 06:00:00 | NQ | Futures | 23507.47 | 23521.34 | 23475.7 | 23515.54 | 5890.0 |
| 2025-08-21 07:00:00 | NQ | Futures | 23515.04 | 23537.48 | 23467.13 | 23483.77 | 8816.0 |
| 2025-08-21 08:00:00 | NQ | Futures | 23484.27 | 23484.27 | 23417.45 | 23426.27 | 16699.0 |
| 2025-08-21 09:00:00 | NQ | Futures | 23425.77 | 23493.1 | 23377.6 | 23389.71 | 79977.0 |
| 2025-08-21 10:00:00 | NQ | Futures | 23386.43 | 23551.6 | 23357.68 | 23497.64 | 81944.0 |
| 2025-08-21 11:00:00 | NQ | Futures | 23497.89 | 23515.8 | 23393.24 | 23406.6 | 68007.0 |
| 2025-08-21 12:00:00 | NQ | Futures | 23406.35 | 23415.93 | 23352.13 | 23362.98 | 51890.0 |
| 2025-08-21 13:00:00 | NQ | Futures | 23363.23 | 23426.52 | 23320.36 | 23417.19 | 54897.0 |
| 2025-08-21 14:00:00 | NQ | Futures | 23416.69 | 23437.37 | 23381.39 | 23427.79 | 39512.0 |
| 2025-08-21 15:00:00 | NQ | Futures | 23427.28 | 23457.79 | 23405.59 | 23419.72 | 46936.0 |
| 2025-08-21 16:00:00 | NQ | Futures | 23419.72 | 23428.54 | 23402.06 | 23424.0 | 12543.0 |
| 2025-08-21 18:00:00 | NQ | Futures | 23427.53 | 23452.75 | 23425.52 | 23446.95 | 3387.0 |
| 2025-08-21 19:00:00 | NQ | Futures | 23446.45 | 23455.02 | 23433.33 | 23450.73 | 2113.0 |
| 2025-08-21 20:00:00 | NQ | Futures | 23451.99 | 23452.5 | 23382.9 | 23414.67 | 5926.0 |
| 2025-08-21 21:00:00 | NQ | Futures | 23416.19 | 23424.0 | 23394.25 | 23409.12 | 3233.0 |
| 2025-08-21 22:00:00 | NQ | Futures | 23409.12 | 23436.11 | 23405.09 | 23408.87 | 2533.0 |
| 2025-08-21 23:00:00 | NQ | Futures | 23409.12 | 23413.41 | 23393.74 | 23396.77 | 2328.0 |
| 2025-08-21 00:00:00 | YM | Futures | 45957.5 | 45961.5 | 45931.9 | 45931.9 | 204.0 |
| 2025-08-21 01:00:00 | YM | Futures | 45929.9 | 45944.2 | 45899.2 | 45936.0 | 489.0 |
| 2025-08-21 02:00:00 | YM | Futures | 45938.0 | 45973.8 | 45938.0 | 45952.3 | 812.0 |
| 2025-08-21 03:00:00 | YM | Futures | 45950.3 | 45956.4 | 45897.2 | 45911.5 | 1312.0 |
> showing 50 of 2,044 rows — these rows as CSV