PREVIEW / futures_1hour / 2025-08-08
file: by_date/futures_1hour/2025/2025-08-08.parquet size: 54 KB rows: 1,643
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-08 00:00:00 | ES | Futures | 6429.61 | 6430.36 | 6425.07 | 6426.33 | 3828.0 |
| 2025-08-08 01:00:00 | ES | Futures | 6426.58 | 6429.35 | 6417.01 | 6418.27 | 5967.0 |
| 2025-08-08 02:00:00 | ES | Futures | 6418.27 | 6428.09 | 6418.02 | 6424.32 | 5403.0 |
| 2025-08-08 03:00:00 | ES | Futures | 6424.57 | 6429.86 | 6423.56 | 6424.57 | 7151.0 |
| 2025-08-08 04:00:00 | ES | Futures | 6424.57 | 6430.61 | 6424.57 | 6428.09 | 6667.0 |
| 2025-08-08 05:00:00 | ES | Futures | 6428.09 | 6433.38 | 6427.59 | 6431.12 | 6629.0 |
| 2025-08-08 06:00:00 | ES | Futures | 6431.12 | 6434.39 | 6431.12 | 6433.38 | 5010.0 |
| 2025-08-08 07:00:00 | ES | Futures | 6433.64 | 6437.67 | 6431.87 | 6436.41 | 12547.0 |
| 2025-08-08 08:00:00 | ES | Futures | 6436.66 | 6436.91 | 6424.06 | 6426.83 | 21811.0 |
| 2025-08-08 09:00:00 | ES | Futures | 6427.09 | 6449.5 | 6424.82 | 6449.0 | 145031.0 |
| 2025-08-08 10:00:00 | ES | Futures | 6449.0 | 6461.09 | 6447.24 | 6448.5 | 194613.0 |
| 2025-08-08 11:00:00 | ES | Futures | 6448.24 | 6455.3 | 6438.42 | 6453.78 | 151110.0 |
| 2025-08-08 12:00:00 | ES | Futures | 6454.04 | 6464.11 | 6453.03 | 6456.05 | 124215.0 |
| 2025-08-08 13:00:00 | ES | Futures | 6456.05 | 6463.86 | 6451.52 | 6462.35 | 96464.0 |
| 2025-08-08 14:00:00 | ES | Futures | 6462.6 | 6467.13 | 6459.58 | 6463.36 | 72936.0 |
| 2025-08-08 15:00:00 | ES | Futures | 6463.1 | 6467.13 | 6450.76 | 6462.1 | 195022.0 |
| 2025-08-08 16:00:00 | ES | Futures | 6461.84 | 6473.93 | 6461.34 | 6473.43 | 48652.0 |
| 2025-08-08 00:00:00 | NQ | Futures | 23758.14 | 23761.67 | 23741.49 | 23747.8 | 2329.0 |
| 2025-08-08 01:00:00 | NQ | Futures | 23748.56 | 23759.15 | 23707.7 | 23713.75 | 4046.0 |
| 2025-08-08 02:00:00 | NQ | Futures | 23715.02 | 23759.65 | 23713.5 | 23742.25 | 3979.0 |
| 2025-08-08 03:00:00 | NQ | Futures | 23740.99 | 23756.63 | 23729.89 | 23733.17 | 2959.0 |
| 2025-08-08 04:00:00 | NQ | Futures | 23733.93 | 23764.95 | 23732.67 | 23758.89 | 3910.0 |
| 2025-08-08 05:00:00 | NQ | Futures | 23759.4 | 23783.36 | 23756.37 | 23767.47 | 3998.0 |
| 2025-08-08 06:00:00 | NQ | Futures | 23767.72 | 23781.09 | 23765.7 | 23772.01 | 3326.0 |
| 2025-08-08 07:00:00 | NQ | Futures | 23772.51 | 23787.39 | 23766.46 | 23779.57 | 5747.0 |
| 2025-08-08 08:00:00 | NQ | Futures | 23780.08 | 23781.59 | 23723.09 | 23738.22 | 13751.0 |
| 2025-08-08 09:00:00 | NQ | Futures | 23738.47 | 23855.23 | 23726.11 | 23849.43 | 61686.0 |
| 2025-08-08 10:00:00 | NQ | Futures | 23849.68 | 23909.44 | 23832.03 | 23858.25 | 78139.0 |
| 2025-08-08 11:00:00 | NQ | Futures | 23858.25 | 23888.01 | 23817.65 | 23886.75 | 58940.0 |
| 2025-08-08 12:00:00 | NQ | Futures | 23886.24 | 23913.98 | 23880.7 | 23883.22 | 40706.0 |
| 2025-08-08 13:00:00 | NQ | Futures | 23883.22 | 23909.95 | 23861.28 | 23906.17 | 36810.0 |
| 2025-08-08 14:00:00 | NQ | Futures | 23906.92 | 23930.63 | 23896.08 | 23917.51 | 32490.0 |
| 2025-08-08 15:00:00 | NQ | Futures | 23918.02 | 23927.6 | 23883.97 | 23921.04 | 54316.0 |
| 2025-08-08 16:00:00 | NQ | Futures | 23921.04 | 23974.76 | 23919.53 | 23972.49 | 19380.0 |
| 2025-08-08 00:00:00 | YM | Futures | 45127.9 | 45129.0 | 45098.3 | 45104.4 | 368.0 |
| 2025-08-08 01:00:00 | YM | Futures | 45103.4 | 45120.8 | 45034.0 | 45042.1 | 574.0 |
| 2025-08-08 02:00:00 | YM | Futures | 45044.2 | 45109.6 | 45042.1 | 45079.9 | 785.0 |
| 2025-08-08 03:00:00 | YM | Futures | 45082.0 | 45131.0 | 45080.9 | 45102.4 | 722.0 |
| 2025-08-08 04:00:00 | YM | Futures | 45103.4 | 45107.5 | 45070.7 | 45077.9 | 1603.0 |
| 2025-08-08 05:00:00 | YM | Futures | 45078.9 | 45116.7 | 45075.8 | 45114.7 | 591.0 |
| 2025-08-08 06:00:00 | YM | Futures | 45113.6 | 45146.3 | 45109.6 | 45146.3 | 562.0 |
| 2025-08-08 07:00:00 | YM | Futures | 45146.3 | 45173.9 | 45129.0 | 45162.7 | 1001.0 |
| 2025-08-08 08:00:00 | YM | Futures | 45162.7 | 45163.7 | 45072.8 | 45095.2 | 1676.0 |
| 2025-08-08 09:00:00 | YM | Futures | 45095.2 | 45224.0 | 45088.1 | 45204.6 | 9605.0 |
| 2025-08-08 10:00:00 | YM | Futures | 45206.6 | 45342.5 | 45156.5 | 45166.8 | 11937.0 |
| 2025-08-08 11:00:00 | YM | Futures | 45167.8 | 45196.4 | 45073.8 | 45184.1 | 7757.0 |
| 2025-08-08 12:00:00 | YM | Futures | 45181.1 | 45289.3 | 45174.9 | 45227.0 | 5823.0 |
| 2025-08-08 13:00:00 | YM | Futures | 45225.0 | 45285.3 | 45187.2 | 45262.8 | 4268.0 |
| 2025-08-08 14:00:00 | YM | Futures | 45264.8 | 45301.6 | 45252.6 | 45261.8 | 3613.0 |
| 2025-08-08 15:00:00 | YM | Futures | 45258.7 | 45296.5 | 45163.7 | 45238.3 | 7374.0 |
> showing 50 of 1,643 rows — these rows as CSV