PREVIEW / futures_1hour / 2025-07-28
file: by_date/futures_1hour/2025/2025-07-28.parquet size: 65 KB rows: 2,064
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-07-28 00:00:00 | ES | Futures | 6499.88 | 6502.9 | 6499.37 | 6502.4 | 2319.0 |
| 2025-07-28 01:00:00 | ES | Futures | 6502.14 | 6504.66 | 6501.89 | 6503.66 | 4522.0 |
| 2025-07-28 02:00:00 | ES | Futures | 6503.91 | 6506.17 | 6499.37 | 6499.63 | 8078.0 |
| 2025-07-28 03:00:00 | ES | Futures | 6499.88 | 6500.89 | 6492.57 | 6495.34 | 13586.0 |
| 2025-07-28 04:00:00 | ES | Futures | 6495.09 | 6495.6 | 6492.07 | 6492.83 | 9608.0 |
| 2025-07-28 05:00:00 | ES | Futures | 6492.83 | 6493.83 | 6488.29 | 6489.3 | 7264.0 |
| 2025-07-28 06:00:00 | ES | Futures | 6489.3 | 6490.31 | 6481.74 | 6483.51 | 10089.0 |
| 2025-07-28 07:00:00 | ES | Futures | 6483.25 | 6485.77 | 6482.25 | 6484.01 | 9894.0 |
| 2025-07-28 08:00:00 | ES | Futures | 6484.01 | 6488.54 | 6481.49 | 6487.54 | 18964.0 |
| 2025-07-28 09:00:00 | ES | Futures | 6487.54 | 6487.79 | 6472.42 | 6476.2 | 132529.0 |
| 2025-07-28 10:00:00 | ES | Futures | 6475.95 | 6482.5 | 6473.93 | 6475.95 | 127993.0 |
| 2025-07-28 11:00:00 | ES | Futures | 6475.95 | 6477.46 | 6464.62 | 6475.45 | 102792.0 |
| 2025-07-28 12:00:00 | ES | Futures | 6475.7 | 6478.47 | 6469.15 | 6470.66 | 69748.0 |
| 2025-07-28 13:00:00 | ES | Futures | 6470.41 | 6473.43 | 6462.35 | 6462.85 | 76455.0 |
| 2025-07-28 14:00:00 | ES | Futures | 6462.6 | 6464.62 | 6456.81 | 6462.6 | 88240.0 |
| 2025-07-28 15:00:00 | ES | Futures | 6462.35 | 6472.42 | 6458.57 | 6471.16 | 151253.0 |
| 2025-07-28 16:00:00 | ES | Futures | 6471.16 | 6473.68 | 6469.9 | 6472.68 | 44389.0 |
| 2025-07-28 18:00:00 | ES | Futures | 6472.42 | 6477.21 | 6471.42 | 6476.45 | 4422.0 |
| 2025-07-28 19:00:00 | ES | Futures | 6476.45 | 6477.21 | 6474.19 | 6476.45 | 2233.0 |
| 2025-07-28 20:00:00 | ES | Futures | 6476.45 | 6476.71 | 6471.92 | 6475.45 | 4468.0 |
| 2025-07-28 21:00:00 | ES | Futures | 6475.45 | 6478.47 | 6474.94 | 6475.95 | 3682.0 |
| 2025-07-28 22:00:00 | ES | Futures | 6475.95 | 6478.22 | 6474.69 | 6478.22 | 3152.0 |
| 2025-07-28 23:00:00 | ES | Futures | 6478.22 | 6479.98 | 6476.96 | 6479.22 | 2485.0 |
| 2025-07-28 00:00:00 | NQ | Futures | 23754.36 | 23770.49 | 23750.07 | 23765.2 | 1896.0 |
| 2025-07-28 01:00:00 | NQ | Futures | 23764.69 | 23784.11 | 23763.94 | 23779.32 | 2931.0 |
| 2025-07-28 02:00:00 | NQ | Futures | 23779.07 | 23790.67 | 23765.2 | 23765.96 | 3784.0 |
| 2025-07-28 03:00:00 | NQ | Futures | 23765.7 | 23772.76 | 23738.47 | 23752.59 | 6555.0 |
| 2025-07-28 04:00:00 | NQ | Futures | 23752.84 | 23754.36 | 23738.47 | 23741.75 | 4452.0 |
| 2025-07-28 05:00:00 | NQ | Futures | 23742.0 | 23747.55 | 23727.12 | 23731.66 | 3127.0 |
| 2025-07-28 06:00:00 | NQ | Futures | 23730.9 | 23731.91 | 23689.29 | 23698.88 | 6536.0 |
| 2025-07-28 07:00:00 | NQ | Futures | 23698.12 | 23712.24 | 23694.59 | 23706.69 | 5622.0 |
| 2025-07-28 08:00:00 | NQ | Futures | 23706.19 | 23725.86 | 23690.81 | 23719.3 | 8858.0 |
| 2025-07-28 09:00:00 | NQ | Futures | 23719.05 | 23726.11 | 23669.12 | 23724.85 | 66200.0 |
| 2025-07-28 10:00:00 | NQ | Futures | 23725.1 | 23733.93 | 23677.95 | 23697.62 | 66816.0 |
| 2025-07-28 11:00:00 | NQ | Futures | 23698.12 | 23704.68 | 23640.88 | 23698.12 | 49947.0 |
| 2025-07-28 12:00:00 | NQ | Futures | 23698.62 | 23714.01 | 23678.45 | 23690.3 | 36659.0 |
| 2025-07-28 13:00:00 | NQ | Futures | 23690.55 | 23692.82 | 23659.28 | 23665.59 | 34076.0 |
| 2025-07-28 14:00:00 | NQ | Futures | 23665.34 | 23675.42 | 23644.15 | 23667.35 | 35960.0 |
| 2025-07-28 15:00:00 | NQ | Futures | 23666.85 | 23700.89 | 23654.24 | 23696.1 | 46173.0 |
| 2025-07-28 16:00:00 | NQ | Futures | 23696.35 | 23717.54 | 23693.58 | 23714.01 | 16809.0 |
| 2025-07-28 18:00:00 | NQ | Futures | 23708.96 | 23735.95 | 23707.7 | 23731.66 | 3501.0 |
| 2025-07-28 19:00:00 | NQ | Futures | 23730.9 | 23736.2 | 23722.33 | 23733.17 | 2166.0 |
| 2025-07-28 20:00:00 | NQ | Futures | 23733.68 | 23742.0 | 23721.32 | 23738.47 | 3375.0 |
| 2025-07-28 21:00:00 | NQ | Futures | 23738.47 | 23750.07 | 23730.9 | 23732.42 | 2858.0 |
| 2025-07-28 22:00:00 | NQ | Futures | 23732.67 | 23744.27 | 23726.11 | 23743.01 | 2266.0 |
| 2025-07-28 23:00:00 | NQ | Futures | 23742.76 | 23752.59 | 23740.74 | 23748.3 | 1962.0 |
| 2025-07-28 00:00:00 | YM | Futures | 46233.3 | 46249.6 | 46232.3 | 46246.6 | 142.0 |
| 2025-07-28 01:00:00 | YM | Futures | 46244.5 | 46259.8 | 46243.5 | 46252.7 | 273.0 |
| 2025-07-28 02:00:00 | YM | Futures | 46253.7 | 46289.5 | 46209.8 | 46211.8 | 1816.0 |
| 2025-07-28 03:00:00 | YM | Futures | 46213.9 | 46229.2 | 46159.7 | 46183.2 | 1453.0 |
> showing 50 of 2,064 rows — these rows as CSV