PREVIEW / futures_1hour / 2025-04-24
file: by_date/futures_1hour/2025/2025-04-24.parquet size: 69 KB rows: 2,096
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-04-24 00:00:00 | ES | Futures | 5480.15 | 5483.71 | 5470.24 | 5481.68 | 4467.0 |
| 2025-04-24 01:00:00 | ES | Futures | 5481.68 | 5486.76 | 5459.07 | 5468.21 | 8325.0 |
| 2025-04-24 02:00:00 | ES | Futures | 5468.21 | 5485.49 | 5465.67 | 5477.1 | 11013.0 |
| 2025-04-24 03:00:00 | ES | Futures | 5477.1 | 5480.15 | 5455.26 | 5460.84 | 24398.0 |
| 2025-04-24 04:00:00 | ES | Futures | 5460.84 | 5467.2 | 5441.79 | 5451.7 | 18376.0 |
| 2025-04-24 05:00:00 | ES | Futures | 5451.19 | 5466.18 | 5451.19 | 5463.64 | 13893.0 |
| 2025-04-24 06:00:00 | ES | Futures | 5463.64 | 5497.17 | 5462.12 | 5492.09 | 28787.0 |
| 2025-04-24 07:00:00 | ES | Futures | 5491.84 | 5492.6 | 5466.94 | 5474.56 | 34302.0 |
| 2025-04-24 08:00:00 | ES | Futures | 5474.31 | 5495.65 | 5473.55 | 5492.09 | 33680.0 |
| 2025-04-24 09:00:00 | ES | Futures | 5492.09 | 5529.44 | 5485.74 | 5527.4 | 124465.0 |
| 2025-04-24 10:00:00 | ES | Futures | 5527.66 | 5567.29 | 5522.58 | 5558.65 | 220465.0 |
| 2025-04-24 11:00:00 | ES | Futures | 5558.65 | 5573.38 | 5552.05 | 5561.7 | 157260.0 |
| 2025-04-24 12:00:00 | ES | Futures | 5561.7 | 5593.45 | 5556.36 | 5588.88 | 142569.0 |
| 2025-04-24 13:00:00 | ES | Futures | 5589.14 | 5590.91 | 5574.4 | 5587.61 | 95192.0 |
| 2025-04-24 14:00:00 | ES | Futures | 5587.86 | 5603.87 | 5585.07 | 5595.74 | 101008.0 |
| 2025-04-24 15:00:00 | ES | Futures | 5595.49 | 5609.2 | 5577.45 | 5599.55 | 227384.0 |
| 2025-04-24 16:00:00 | ES | Futures | 5599.55 | 5631.05 | 5599.04 | 5608.95 | 60655.0 |
| 2025-04-24 18:00:00 | ES | Futures | 5618.35 | 5624.45 | 5606.92 | 5619.62 | 9697.0 |
| 2025-04-24 19:00:00 | ES | Futures | 5619.37 | 5623.94 | 5615.81 | 5617.59 | 6585.0 |
| 2025-04-24 20:00:00 | ES | Futures | 5617.59 | 5632.58 | 5613.27 | 5630.04 | 8972.0 |
| 2025-04-24 21:00:00 | ES | Futures | 5629.78 | 5631.81 | 5616.83 | 5619.37 | 8156.0 |
| 2025-04-24 22:00:00 | ES | Futures | 5619.11 | 5621.4 | 5609.46 | 5613.27 | 6051.0 |
| 2025-04-24 23:00:00 | ES | Futures | 5613.27 | 5631.56 | 5609.97 | 5630.04 | 10360.0 |
| 2025-04-24 00:00:00 | NQ | Futures | 19105.83 | 19118.57 | 19058.98 | 19112.96 | 5040.0 |
| 2025-04-24 01:00:00 | NQ | Futures | 19113.47 | 19131.3 | 19026.13 | 19058.72 | 6096.0 |
| 2025-04-24 02:00:00 | NQ | Futures | 19059.74 | 19128.5 | 19054.14 | 19092.59 | 7125.0 |
| 2025-04-24 03:00:00 | NQ | Futures | 19093.1 | 19104.05 | 18997.86 | 19023.58 | 14046.0 |
| 2025-04-24 04:00:00 | NQ | Futures | 19022.82 | 19052.61 | 18940.82 | 18976.47 | 13298.0 |
| 2025-04-24 05:00:00 | NQ | Futures | 18976.73 | 19043.95 | 18976.73 | 19041.66 | 7721.0 |
| 2025-04-24 06:00:00 | NQ | Futures | 19043.19 | 19190.12 | 19041.41 | 19167.21 | 15185.0 |
| 2025-04-24 07:00:00 | NQ | Futures | 19166.44 | 19173.32 | 19078.08 | 19118.57 | 15950.0 |
| 2025-04-24 08:00:00 | NQ | Futures | 19118.82 | 19216.86 | 19118.31 | 19201.84 | 16831.0 |
| 2025-04-24 09:00:00 | NQ | Futures | 19203.88 | 19415.24 | 19174.34 | 19406.32 | 63845.0 |
| 2025-04-24 10:00:00 | NQ | Futures | 19407.09 | 19536.96 | 19399.19 | 19497.49 | 86770.0 |
| 2025-04-24 11:00:00 | NQ | Futures | 19497.24 | 19572.61 | 19476.35 | 19519.39 | 64017.0 |
| 2025-04-24 12:00:00 | NQ | Futures | 19519.65 | 19636.79 | 19496.47 | 19621.0 | 59695.0 |
| 2025-04-24 13:00:00 | NQ | Futures | 19620.49 | 19632.2 | 19560.9 | 19623.54 | 44978.0 |
| 2025-04-24 14:00:00 | NQ | Futures | 19624.31 | 19684.66 | 19616.92 | 19652.32 | 42725.0 |
| 2025-04-24 15:00:00 | NQ | Futures | 19651.3 | 19698.16 | 19578.72 | 19679.31 | 69366.0 |
| 2025-04-24 16:00:00 | NQ | Futures | 19678.55 | 19779.39 | 19672.18 | 19707.58 | 25274.0 |
| 2025-04-24 18:00:00 | NQ | Futures | 19766.15 | 19788.56 | 19712.42 | 19766.4 | 6506.0 |
| 2025-04-24 19:00:00 | NQ | Futures | 19767.93 | 19797.22 | 19757.49 | 19773.79 | 5343.0 |
| 2025-04-24 20:00:00 | NQ | Futures | 19774.04 | 19825.23 | 19750.87 | 19818.61 | 6782.0 |
| 2025-04-24 21:00:00 | NQ | Futures | 19818.1 | 19832.1 | 19762.33 | 19772.26 | 7351.0 |
| 2025-04-24 22:00:00 | NQ | Futures | 19772.01 | 19784.23 | 19723.37 | 19745.27 | 6412.0 |
| 2025-04-24 23:00:00 | NQ | Futures | 19743.23 | 19816.06 | 19727.44 | 19809.69 | 6095.0 |
| 2025-04-24 00:00:00 | YM | Futures | 40813.7 | 40843.5 | 40765.3 | 40820.9 | 868.0 |
| 2025-04-24 01:00:00 | YM | Futures | 40821.9 | 40848.7 | 40659.3 | 40724.2 | 1407.0 |
| 2025-04-24 02:00:00 | YM | Futures | 40724.2 | 40825.0 | 40699.5 | 40788.0 | 1612.0 |
| 2025-04-24 03:00:00 | YM | Futures | 40789.0 | 40805.5 | 40666.5 | 40690.2 | 3106.0 |
> showing 50 of 2,096 rows — these rows as CSV