PREVIEW / futures_1hour / 2025-04-28
file: by_date/futures_1hour/2025/2025-04-28.parquet size: 69 KB rows: 2,119
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-28 00:00:00 | ES | Futures | 5607.68 | 5612.51 | 5607.43 | 5610.22 | 3326.0 |
| 2025-04-28 01:00:00 | ES | Futures | 5610.22 | 5612.25 | 5605.65 | 5608.7 | 4120.0 |
| 2025-04-28 02:00:00 | ES | Futures | 5608.7 | 5628.26 | 5608.7 | 5627.75 | 9172.0 |
| 2025-04-28 03:00:00 | ES | Futures | 5628.0 | 5633.59 | 5619.87 | 5620.64 | 11166.0 |
| 2025-04-28 04:00:00 | ES | Futures | 5620.89 | 5630.8 | 5616.83 | 5629.78 | 9929.0 |
| 2025-04-28 05:00:00 | ES | Futures | 5630.04 | 5638.93 | 5625.97 | 5633.08 | 10063.0 |
| 2025-04-28 06:00:00 | ES | Futures | 5633.34 | 5633.85 | 5619.87 | 5622.41 | 11452.0 |
| 2025-04-28 07:00:00 | ES | Futures | 5621.91 | 5637.15 | 5619.37 | 5633.08 | 14897.0 |
| 2025-04-28 08:00:00 | ES | Futures | 5633.08 | 5644.26 | 5622.67 | 5641.72 | 24498.0 |
| 2025-04-28 09:00:00 | ES | Futures | 5641.98 | 5668.9 | 5633.85 | 5635.12 | 152494.0 |
| 2025-04-28 10:00:00 | ES | Futures | 5635.12 | 5654.17 | 5628.77 | 5637.66 | 164872.0 |
| 2025-04-28 11:00:00 | ES | Futures | 5637.91 | 5644.77 | 5602.09 | 5606.92 | 142926.0 |
| 2025-04-28 12:00:00 | ES | Futures | 5606.92 | 5608.7 | 5588.63 | 5596.5 | 122963.0 |
| 2025-04-28 13:00:00 | ES | Futures | 5596.5 | 5610.73 | 5580.75 | 5608.95 | 98770.0 |
| 2025-04-28 14:00:00 | ES | Futures | 5609.2 | 5622.67 | 5605.65 | 5619.37 | 87581.0 |
| 2025-04-28 15:00:00 | ES | Futures | 5619.62 | 5655.69 | 5618.35 | 5641.21 | 188136.0 |
| 2025-04-28 16:00:00 | ES | Futures | 5641.47 | 5642.99 | 5632.32 | 5635.12 | 39858.0 |
| 2025-04-28 18:00:00 | ES | Futures | 5632.58 | 5636.13 | 5626.99 | 5633.34 | 4215.0 |
| 2025-04-28 19:00:00 | ES | Futures | 5633.34 | 5645.53 | 5631.31 | 5645.02 | 5945.0 |
| 2025-04-28 20:00:00 | ES | Futures | 5644.77 | 5649.85 | 5636.13 | 5648.33 | 5369.0 |
| 2025-04-28 21:00:00 | ES | Futures | 5648.07 | 5658.23 | 5646.04 | 5657.22 | 5233.0 |
| 2025-04-28 22:00:00 | ES | Futures | 5657.47 | 5663.82 | 5648.33 | 5650.87 | 6264.0 |
| 2025-04-28 23:00:00 | ES | Futures | 5650.36 | 5654.93 | 5649.09 | 5652.14 | 3374.0 |
| 2025-04-28 00:00:00 | NQ | Futures | 19764.37 | 19789.32 | 19764.37 | 19772.52 | 2202.0 |
| 2025-04-28 01:00:00 | NQ | Futures | 19773.02 | 19791.36 | 19765.13 | 19777.61 | 2729.0 |
| 2025-04-28 02:00:00 | NQ | Futures | 19778.12 | 19868.77 | 19778.12 | 19865.72 | 5676.0 |
| 2025-04-28 03:00:00 | NQ | Futures | 19866.23 | 19881.25 | 19829.81 | 19831.34 | 6783.0 |
| 2025-04-28 04:00:00 | NQ | Futures | 19830.58 | 19865.72 | 19802.56 | 19862.92 | 6189.0 |
| 2025-04-28 05:00:00 | NQ | Futures | 19863.17 | 19903.66 | 19845.35 | 19878.2 | 5972.0 |
| 2025-04-28 06:00:00 | NQ | Futures | 19879.47 | 19886.35 | 19828.54 | 19839.49 | 7481.0 |
| 2025-04-28 07:00:00 | NQ | Futures | 19837.96 | 19897.3 | 19828.54 | 19877.69 | 9116.0 |
| 2025-04-28 08:00:00 | NQ | Futures | 19877.94 | 19913.85 | 19832.61 | 19903.66 | 12409.0 |
| 2025-04-28 09:00:00 | NQ | Futures | 19903.66 | 19988.21 | 19815.81 | 19827.52 | 69849.0 |
| 2025-04-28 10:00:00 | NQ | Futures | 19826.76 | 19902.9 | 19794.92 | 19833.12 | 72592.0 |
| 2025-04-28 11:00:00 | NQ | Futures | 19831.09 | 19858.84 | 19671.16 | 19707.83 | 70582.0 |
| 2025-04-28 12:00:00 | NQ | Futures | 19707.07 | 19716.49 | 19626.09 | 19677.53 | 52631.0 |
| 2025-04-28 13:00:00 | NQ | Futures | 19676.51 | 19739.41 | 19615.65 | 19731.77 | 45112.0 |
| 2025-04-28 14:00:00 | NQ | Futures | 19732.53 | 19800.53 | 19717.0 | 19790.09 | 38530.0 |
| 2025-04-28 15:00:00 | NQ | Futures | 19790.34 | 19943.13 | 19784.99 | 19887.87 | 59901.0 |
| 2025-04-28 16:00:00 | NQ | Futures | 19887.62 | 19890.16 | 19837.71 | 19846.36 | 13408.0 |
| 2025-04-28 18:00:00 | NQ | Futures | 19840.76 | 19852.99 | 19817.59 | 19848.66 | 4267.0 |
| 2025-04-28 19:00:00 | NQ | Futures | 19848.4 | 19895.77 | 19840.76 | 19891.95 | 4575.0 |
| 2025-04-28 20:00:00 | NQ | Futures | 19891.69 | 19925.05 | 19859.1 | 19918.94 | 4315.0 |
| 2025-04-28 21:00:00 | NQ | Futures | 19917.92 | 19964.78 | 19908.25 | 19958.92 | 4700.0 |
| 2025-04-28 22:00:00 | NQ | Futures | 19958.41 | 19996.36 | 19923.02 | 19934.73 | 7744.0 |
| 2025-04-28 23:00:00 | NQ | Futures | 19934.73 | 19955.61 | 19925.05 | 19937.53 | 3394.0 |
| 2025-04-28 00:00:00 | YM | Futures | 41249.0 | 41271.7 | 41247.0 | 41266.5 | 348.0 |
| 2025-04-28 01:00:00 | YM | Futures | 41266.5 | 41266.5 | 41221.2 | 41230.5 | 508.0 |
| 2025-04-28 02:00:00 | YM | Futures | 41234.6 | 41343.7 | 41234.6 | 41335.5 | 1065.0 |
| 2025-04-28 03:00:00 | YM | Futures | 41336.5 | 41399.3 | 41304.6 | 41310.8 | 1597.0 |
> showing 50 of 2,119 rows — these rows as CSV