PREVIEW / futures_1hour / 2025-05-06
file: by_date/futures_1hour/2025/2025-05-06.parquet size: 70 KB rows: 2,141
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-06 00:00:00 | ES | Futures | 5754.52 | 5755.02 | 5746.39 | 5750.45 | 2215.0 |
| 2025-05-06 01:00:00 | ES | Futures | 5750.7 | 5751.47 | 5737.24 | 5740.29 | 4007.0 |
| 2025-05-06 02:00:00 | ES | Futures | 5740.03 | 5750.96 | 5739.02 | 5750.96 | 6245.0 |
| 2025-05-06 03:00:00 | ES | Futures | 5750.96 | 5751.97 | 5731.91 | 5732.92 | 11958.0 |
| 2025-05-06 04:00:00 | ES | Futures | 5732.92 | 5733.94 | 5716.41 | 5725.55 | 19174.0 |
| 2025-05-06 05:00:00 | ES | Futures | 5725.55 | 5726.32 | 5714.88 | 5724.54 | 14274.0 |
| 2025-05-06 06:00:00 | ES | Futures | 5724.28 | 5731.4 | 5720.47 | 5730.89 | 12291.0 |
| 2025-05-06 07:00:00 | ES | Futures | 5730.89 | 5734.45 | 5707.26 | 5716.41 | 28923.0 |
| 2025-05-06 08:00:00 | ES | Futures | 5716.41 | 5720.98 | 5710.06 | 5717.93 | 22998.0 |
| 2025-05-06 09:00:00 | ES | Futures | 5717.93 | 5725.05 | 5697.61 | 5701.93 | 144070.0 |
| 2025-05-06 10:00:00 | ES | Futures | 5702.18 | 5744.1 | 5699.13 | 5736.48 | 178806.0 |
| 2025-05-06 11:00:00 | ES | Futures | 5736.73 | 5748.93 | 5730.64 | 5732.67 | 115425.0 |
| 2025-05-06 12:00:00 | ES | Futures | 5732.41 | 5763.41 | 5719.71 | 5720.73 | 164361.0 |
| 2025-05-06 13:00:00 | ES | Futures | 5720.98 | 5734.95 | 5711.07 | 5712.85 | 95768.0 |
| 2025-05-06 14:00:00 | ES | Futures | 5712.85 | 5739.78 | 5712.6 | 5739.78 | 118272.0 |
| 2025-05-06 15:00:00 | ES | Futures | 5739.53 | 5742.83 | 5714.88 | 5716.41 | 216603.0 |
| 2025-05-06 16:00:00 | ES | Futures | 5716.66 | 5718.7 | 5695.58 | 5705.74 | 64635.0 |
| 2025-05-06 18:00:00 | ES | Futures | 5699.13 | 5781.7 | 5699.13 | 5763.91 | 41464.0 |
| 2025-05-06 19:00:00 | ES | Futures | 5764.17 | 5766.46 | 5754.52 | 5763.41 | 8427.0 |
| 2025-05-06 20:00:00 | ES | Futures | 5763.15 | 5773.31 | 5750.2 | 5767.22 | 11872.0 |
| 2025-05-06 21:00:00 | ES | Futures | 5766.96 | 5772.3 | 5756.8 | 5760.87 | 8001.0 |
| 2025-05-06 22:00:00 | ES | Futures | 5760.87 | 5761.37 | 5743.59 | 5748.67 | 7019.0 |
| 2025-05-06 23:00:00 | ES | Futures | 5748.67 | 5755.28 | 5748.16 | 5749.94 | 3922.0 |
| 2025-05-06 00:00:00 | NQ | Futures | 20359.24 | 20364.58 | 20324.6 | 20344.97 | 2325.0 |
| 2025-05-06 01:00:00 | NQ | Futures | 20344.97 | 20348.03 | 20283.35 | 20293.79 | 3965.0 |
| 2025-05-06 02:00:00 | NQ | Futures | 20293.28 | 20336.83 | 20289.72 | 20332.75 | 4857.0 |
| 2025-05-06 03:00:00 | NQ | Futures | 20333.52 | 20346.5 | 20263.74 | 20272.91 | 10052.0 |
| 2025-05-06 04:00:00 | NQ | Futures | 20272.91 | 20280.55 | 20201.1 | 20243.62 | 13490.0 |
| 2025-05-06 05:00:00 | NQ | Futures | 20243.62 | 20245.91 | 20193.2 | 20236.24 | 9510.0 |
| 2025-05-06 06:00:00 | NQ | Futures | 20235.73 | 20263.49 | 20221.72 | 20261.96 | 6506.0 |
| 2025-05-06 07:00:00 | NQ | Futures | 20262.21 | 20278.77 | 20174.61 | 20209.24 | 13512.0 |
| 2025-05-06 08:00:00 | NQ | Futures | 20209.5 | 20224.27 | 20171.56 | 20209.75 | 12116.0 |
| 2025-05-06 09:00:00 | NQ | Futures | 20209.75 | 20233.69 | 20114.51 | 20124.95 | 66927.0 |
| 2025-05-06 10:00:00 | NQ | Futures | 20125.21 | 20308.81 | 20106.37 | 20275.45 | 73760.0 |
| 2025-05-06 11:00:00 | NQ | Futures | 20274.44 | 20323.84 | 20255.34 | 20267.31 | 46663.0 |
| 2025-05-06 12:00:00 | NQ | Futures | 20266.03 | 20398.96 | 20229.87 | 20233.95 | 67159.0 |
| 2025-05-06 13:00:00 | NQ | Futures | 20234.46 | 20290.73 | 20206.7 | 20216.12 | 40496.0 |
| 2025-05-06 14:00:00 | NQ | Futures | 20216.38 | 20326.39 | 20214.85 | 20325.62 | 38978.0 |
| 2025-05-06 15:00:00 | NQ | Futures | 20325.11 | 20344.21 | 20240.57 | 20245.66 | 52118.0 |
| 2025-05-06 16:00:00 | NQ | Futures | 20245.91 | 20275.96 | 20177.67 | 20216.12 | 20804.0 |
| 2025-05-06 18:00:00 | NQ | Futures | 20177.67 | 20508.46 | 20167.99 | 20451.93 | 20214.0 |
| 2025-05-06 19:00:00 | NQ | Futures | 20453.46 | 20460.08 | 20402.78 | 20441.49 | 7031.0 |
| 2025-05-06 20:00:00 | NQ | Futures | 20440.72 | 20479.69 | 20377.57 | 20456.51 | 9033.0 |
| 2025-05-06 21:00:00 | NQ | Futures | 20456.26 | 20482.23 | 20406.6 | 20425.19 | 6715.0 |
| 2025-05-06 22:00:00 | NQ | Futures | 20425.95 | 20429.26 | 20347.78 | 20368.15 | 6424.0 |
| 2025-05-06 23:00:00 | NQ | Futures | 20369.17 | 20394.38 | 20364.84 | 20374.26 | 4106.0 |
| 2025-05-06 00:00:00 | YM | Futures | 42506.7 | 42510.8 | 42467.6 | 42491.2 | 311.0 |
| 2025-05-06 01:00:00 | YM | Futures | 42492.3 | 42492.3 | 42406.8 | 42423.3 | 601.0 |
| 2025-05-06 02:00:00 | YM | Futures | 42421.2 | 42498.4 | 42416.1 | 42495.3 | 680.0 |
| 2025-05-06 03:00:00 | YM | Futures | 42495.3 | 42502.6 | 42363.6 | 42366.7 | 1311.0 |
> showing 50 of 2,141 rows — these rows as CSV