PREVIEW / futures_1hour / 2025-05-05
file: by_date/futures_1hour/2025/2025-05-05.parquet size: 67 KB rows: 2,052
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-05-05 00:00:00 | ES | Futures | 5761.37 | 5761.88 | 5754.01 | 5755.79 | 3813.0 |
| 2025-05-05 01:00:00 | ES | Futures | 5755.79 | 5764.93 | 5755.79 | 5761.88 | 3973.0 |
| 2025-05-05 02:00:00 | ES | Futures | 5761.88 | 5772.3 | 5761.88 | 5764.42 | 8067.0 |
| 2025-05-05 03:00:00 | ES | Futures | 5764.17 | 5764.93 | 5757.56 | 5762.39 | 8892.0 |
| 2025-05-05 04:00:00 | ES | Futures | 5762.64 | 5767.22 | 5746.64 | 5750.96 | 10952.0 |
| 2025-05-05 05:00:00 | ES | Futures | 5750.7 | 5760.1 | 5746.64 | 5755.79 | 9660.0 |
| 2025-05-05 06:00:00 | ES | Futures | 5755.79 | 5758.83 | 5751.47 | 5757.31 | 8629.0 |
| 2025-05-05 07:00:00 | ES | Futures | 5757.56 | 5759.09 | 5747.66 | 5751.97 | 11707.0 |
| 2025-05-05 08:00:00 | ES | Futures | 5751.97 | 5759.09 | 5748.67 | 5756.29 | 15738.0 |
| 2025-05-05 09:00:00 | ES | Futures | 5756.29 | 5764.17 | 5746.64 | 5760.87 | 100907.0 |
| 2025-05-05 10:00:00 | ES | Futures | 5760.87 | 5782.97 | 5754.26 | 5780.94 | 170279.0 |
| 2025-05-05 11:00:00 | ES | Futures | 5780.68 | 5784.24 | 5769.0 | 5780.94 | 106102.0 |
| 2025-05-05 12:00:00 | ES | Futures | 5780.94 | 5790.84 | 5778.9 | 5787.54 | 72345.0 |
| 2025-05-05 13:00:00 | ES | Futures | 5787.29 | 5792.11 | 5779.16 | 5787.79 | 67526.0 |
| 2025-05-05 14:00:00 | ES | Futures | 5787.79 | 5798.46 | 5786.52 | 5789.06 | 69459.0 |
| 2025-05-05 15:00:00 | ES | Futures | 5789.32 | 5790.08 | 5760.87 | 5766.2 | 192733.0 |
| 2025-05-05 16:00:00 | ES | Futures | 5765.95 | 5766.96 | 5756.8 | 5762.9 | 44361.0 |
| 2025-05-05 18:00:00 | ES | Futures | 5757.82 | 5764.93 | 5755.53 | 5759.34 | 3847.0 |
| 2025-05-05 19:00:00 | ES | Futures | 5759.09 | 5762.64 | 5757.06 | 5758.07 | 3572.0 |
| 2025-05-05 20:00:00 | ES | Futures | 5758.07 | 5763.15 | 5752.74 | 5756.8 | 4417.0 |
| 2025-05-05 21:00:00 | ES | Futures | 5756.8 | 5759.34 | 5747.91 | 5750.2 | 6269.0 |
| 2025-05-05 22:00:00 | ES | Futures | 5750.45 | 5751.72 | 5745.88 | 5748.93 | 4393.0 |
| 2025-05-05 23:00:00 | ES | Futures | 5748.93 | 5754.52 | 5743.34 | 5754.26 | 4446.0 |
| 2025-05-05 00:00:00 | NQ | Futures | 20429.77 | 20432.83 | 20389.54 | 20409.4 | 4474.0 |
| 2025-05-05 01:00:00 | NQ | Futures | 20410.68 | 20446.33 | 20410.68 | 20436.14 | 3534.0 |
| 2025-05-05 02:00:00 | NQ | Futures | 20435.38 | 20472.81 | 20433.34 | 20435.12 | 5137.0 |
| 2025-05-05 03:00:00 | NQ | Futures | 20435.38 | 20443.78 | 20409.91 | 20430.54 | 6280.0 |
| 2025-05-05 04:00:00 | NQ | Futures | 20431.3 | 20451.42 | 20349.05 | 20372.99 | 8690.0 |
| 2025-05-05 05:00:00 | NQ | Futures | 20372.73 | 20401.0 | 20354.65 | 20383.94 | 6597.0 |
| 2025-05-05 06:00:00 | NQ | Futures | 20384.45 | 20393.36 | 20353.38 | 20382.41 | 5961.0 |
| 2025-05-05 07:00:00 | NQ | Futures | 20383.43 | 20392.34 | 20337.59 | 20352.36 | 8535.0 |
| 2025-05-05 08:00:00 | NQ | Futures | 20352.61 | 20384.7 | 20342.17 | 20377.06 | 9622.0 |
| 2025-05-05 09:00:00 | NQ | Futures | 20376.55 | 20444.54 | 20357.2 | 20424.17 | 48922.0 |
| 2025-05-05 10:00:00 | NQ | Futures | 20432.58 | 20489.62 | 20381.39 | 20479.18 | 67137.0 |
| 2025-05-05 11:00:00 | NQ | Futures | 20477.9 | 20498.53 | 20438.94 | 20476.12 | 40801.0 |
| 2025-05-05 12:00:00 | NQ | Futures | 20476.38 | 20521.7 | 20468.48 | 20508.97 | 27857.0 |
| 2025-05-05 13:00:00 | NQ | Futures | 20508.72 | 20531.38 | 20480.45 | 20518.65 | 26091.0 |
| 2025-05-05 14:00:00 | NQ | Futures | 20518.9 | 20567.29 | 20513.05 | 20526.54 | 29921.0 |
| 2025-05-05 15:00:00 | NQ | Futures | 20527.05 | 20530.11 | 20417.81 | 20440.22 | 51040.0 |
| 2025-05-05 16:00:00 | NQ | Futures | 20438.94 | 20444.03 | 20374.51 | 20415.26 | 18423.0 |
| 2025-05-05 18:00:00 | NQ | Futures | 20386.74 | 20409.66 | 20379.35 | 20390.3 | 2707.0 |
| 2025-05-05 19:00:00 | NQ | Futures | 20389.03 | 20408.13 | 20377.32 | 20380.63 | 3213.0 |
| 2025-05-05 20:00:00 | NQ | Futures | 20381.14 | 20403.29 | 20347.01 | 20364.84 | 5181.0 |
| 2025-05-05 21:00:00 | NQ | Futures | 20365.86 | 20376.55 | 20323.84 | 20329.7 | 6060.0 |
| 2025-05-05 22:00:00 | NQ | Futures | 20330.46 | 20342.94 | 20308.05 | 20326.39 | 5295.0 |
| 2025-05-05 23:00:00 | NQ | Futures | 20326.64 | 20360.51 | 20303.21 | 20360.0 | 3755.0 |
| 2025-05-05 00:00:00 | YM | Futures | 42363.6 | 42365.7 | 42309.1 | 42315.2 | 622.0 |
| 2025-05-05 01:00:00 | YM | Futures | 42313.2 | 42370.8 | 42313.2 | 42351.3 | 868.0 |
| 2025-05-05 02:00:00 | YM | Futures | 42351.3 | 42430.5 | 42351.3 | 42391.4 | 1418.0 |
| 2025-05-05 03:00:00 | YM | Futures | 42392.4 | 42395.5 | 42344.1 | 42388.3 | 1366.0 |
> showing 50 of 2,052 rows — these rows as CSV