PREVIEW / futures_1hour / 2025-08-28
file: by_date/futures_1hour/2025/2025-08-28.parquet size: 62 KB rows: 2,045
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-28 00:00:00 | ES | Futures | 6541.19 | 6541.19 | 6536.15 | 6536.9 | 2548.0 |
| 2025-08-28 01:00:00 | ES | Futures | 6536.65 | 6538.67 | 6533.63 | 6534.13 | 2607.0 |
| 2025-08-28 02:00:00 | ES | Futures | 6534.13 | 6548.49 | 6533.63 | 6545.72 | 8451.0 |
| 2025-08-28 03:00:00 | ES | Futures | 6545.72 | 6553.02 | 6545.47 | 6553.02 | 10852.0 |
| 2025-08-28 04:00:00 | ES | Futures | 6553.02 | 6555.54 | 6547.48 | 6547.73 | 11310.0 |
| 2025-08-28 05:00:00 | ES | Futures | 6547.73 | 6550.5 | 6544.96 | 6546.47 | 5806.0 |
| 2025-08-28 06:00:00 | ES | Futures | 6546.73 | 6548.24 | 6540.68 | 6544.46 | 7165.0 |
| 2025-08-28 07:00:00 | ES | Futures | 6544.21 | 6546.47 | 6539.17 | 6545.97 | 10564.0 |
| 2025-08-28 08:00:00 | ES | Futures | 6545.97 | 6552.02 | 6540.68 | 6547.48 | 29561.0 |
| 2025-08-28 09:00:00 | ES | Futures | 6547.48 | 6557.31 | 6529.35 | 6535.64 | 187417.0 |
| 2025-08-28 10:00:00 | ES | Futures | 6535.39 | 6548.24 | 6531.87 | 6545.22 | 166792.0 |
| 2025-08-28 11:00:00 | ES | Futures | 6545.47 | 6553.02 | 6537.16 | 6546.73 | 130089.0 |
| 2025-08-28 12:00:00 | ES | Futures | 6546.73 | 6561.84 | 6545.72 | 6553.02 | 105662.0 |
| 2025-08-28 13:00:00 | ES | Futures | 6553.28 | 6561.84 | 6551.01 | 6560.58 | 65064.0 |
| 2025-08-28 14:00:00 | ES | Futures | 6560.33 | 6567.38 | 6559.82 | 6566.62 | 71767.0 |
| 2025-08-28 15:00:00 | ES | Futures | 6566.37 | 6571.91 | 6564.11 | 6565.87 | 192882.0 |
| 2025-08-28 16:00:00 | ES | Futures | 6565.87 | 6568.14 | 6562.85 | 6565.11 | 53600.0 |
| 2025-08-28 18:00:00 | ES | Futures | 6564.86 | 6566.88 | 6560.33 | 6561.84 | 5400.0 |
| 2025-08-28 19:00:00 | ES | Futures | 6561.59 | 6564.11 | 6560.58 | 6563.1 | 2647.0 |
| 2025-08-28 20:00:00 | ES | Futures | 6562.85 | 6565.62 | 6561.34 | 6563.1 | 4260.0 |
| 2025-08-28 21:00:00 | ES | Futures | 6563.1 | 6564.36 | 6560.33 | 6561.08 | 3701.0 |
| 2025-08-28 22:00:00 | ES | Futures | 6561.08 | 6561.08 | 6558.56 | 6559.82 | 3081.0 |
| 2025-08-28 23:00:00 | ES | Futures | 6559.82 | 6563.35 | 6559.82 | 6560.58 | 2815.0 |
| 2025-08-28 00:00:00 | NQ | Futures | 23780.33 | 23780.83 | 23762.93 | 23766.96 | 2579.0 |
| 2025-08-28 01:00:00 | NQ | Futures | 23766.46 | 23772.51 | 23745.78 | 23747.55 | 2720.0 |
| 2025-08-28 02:00:00 | NQ | Futures | 23748.05 | 23817.9 | 23744.52 | 23812.36 | 5565.0 |
| 2025-08-28 03:00:00 | NQ | Futures | 23812.36 | 23841.36 | 23808.32 | 23838.08 | 6416.0 |
| 2025-08-28 04:00:00 | NQ | Futures | 23837.07 | 23868.09 | 23820.68 | 23822.7 | 8611.0 |
| 2025-08-28 05:00:00 | NQ | Futures | 23821.94 | 23834.04 | 23814.37 | 23820.93 | 4225.0 |
| 2025-08-28 06:00:00 | NQ | Futures | 23819.92 | 23832.03 | 23803.28 | 23817.9 | 3745.0 |
| 2025-08-28 07:00:00 | NQ | Futures | 23816.64 | 23824.46 | 23788.15 | 23823.45 | 6567.0 |
| 2025-08-28 08:00:00 | NQ | Futures | 23823.45 | 23859.77 | 23798.99 | 23839.09 | 20482.0 |
| 2025-08-28 09:00:00 | NQ | Futures | 23839.59 | 23949.04 | 23777.81 | 23814.88 | 96284.0 |
| 2025-08-28 10:00:00 | NQ | Futures | 23814.63 | 23936.68 | 23798.74 | 23920.79 | 84133.0 |
| 2025-08-28 11:00:00 | NQ | Futures | 23920.79 | 23959.63 | 23871.11 | 23893.81 | 58320.0 |
| 2025-08-28 12:00:00 | NQ | Futures | 23894.31 | 23972.99 | 23888.77 | 23938.7 | 39757.0 |
| 2025-08-28 13:00:00 | NQ | Futures | 23938.95 | 23980.31 | 23928.86 | 23973.5 | 28353.0 |
| 2025-08-28 14:00:00 | NQ | Futures | 23973.25 | 23999.72 | 23968.45 | 23996.19 | 24932.0 |
| 2025-08-28 15:00:00 | NQ | Futures | 23995.69 | 24011.07 | 23971.98 | 23973.75 | 47102.0 |
| 2025-08-28 16:00:00 | NQ | Futures | 23973.75 | 23981.06 | 23951.31 | 23968.96 | 14895.0 |
| 2025-08-28 18:00:00 | NQ | Futures | 23967.45 | 23968.96 | 23941.72 | 23948.28 | 3075.0 |
| 2025-08-28 19:00:00 | NQ | Futures | 23947.52 | 23959.63 | 23943.74 | 23954.08 | 2066.0 |
| 2025-08-28 20:00:00 | NQ | Futures | 23954.33 | 23962.65 | 23945.0 | 23953.32 | 2613.0 |
| 2025-08-28 21:00:00 | NQ | Futures | 23953.07 | 23958.62 | 23936.43 | 23939.71 | 3092.0 |
| 2025-08-28 22:00:00 | NQ | Futures | 23939.45 | 23940.46 | 23924.32 | 23932.9 | 2513.0 |
| 2025-08-28 23:00:00 | NQ | Futures | 23933.15 | 23947.78 | 23930.63 | 23935.17 | 2141.0 |
| 2025-08-28 00:00:00 | YM | Futures | 46711.4 | 46713.4 | 46683.8 | 46687.9 | 237.0 |
| 2025-08-28 01:00:00 | YM | Futures | 46689.9 | 46708.3 | 46672.6 | 46678.7 | 376.0 |
| 2025-08-28 02:00:00 | YM | Futures | 46678.7 | 46761.4 | 46675.6 | 46727.7 | 1204.0 |
| 2025-08-28 03:00:00 | YM | Futures | 46727.7 | 46789.0 | 46722.6 | 46788.0 | 1611.0 |
> showing 50 of 2,045 rows — these rows as CSV