PREVIEW / futures_1hour / 2024-03-26
file: by_date/futures_1hour/2024/2024-03-26.parquet size: 64 KB rows: 2,067
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-26 00:00:00 | ES | Futures | 5605.96 | 5608.62 | 5605.96 | 5607.29 | 2201.0 |
| 2024-03-26 01:00:00 | ES | Futures | 5607.56 | 5610.21 | 5606.76 | 5609.68 | 3088.0 |
| 2024-03-26 02:00:00 | ES | Futures | 5609.68 | 5614.98 | 5608.09 | 5613.66 | 4411.0 |
| 2024-03-26 03:00:00 | ES | Futures | 5613.92 | 5618.17 | 5610.21 | 5611.53 | 9973.0 |
| 2024-03-26 04:00:00 | ES | Futures | 5611.53 | 5620.02 | 5610.74 | 5617.37 | 12397.0 |
| 2024-03-26 05:00:00 | ES | Futures | 5617.11 | 5623.21 | 5616.84 | 5621.35 | 11277.0 |
| 2024-03-26 06:00:00 | ES | Futures | 5621.62 | 5624.8 | 5621.62 | 5624.27 | 9366.0 |
| 2024-03-26 07:00:00 | ES | Futures | 5624.0 | 5624.8 | 5619.49 | 5623.21 | 12360.0 |
| 2024-03-26 08:00:00 | ES | Futures | 5623.21 | 5624.0 | 5611.8 | 5613.39 | 29664.0 |
| 2024-03-26 09:00:00 | ES | Futures | 5613.39 | 5616.31 | 5608.88 | 5613.92 | 118612.0 |
| 2024-03-26 10:00:00 | ES | Futures | 5613.92 | 5618.43 | 5607.82 | 5614.72 | 151468.0 |
| 2024-03-26 11:00:00 | ES | Futures | 5614.72 | 5616.58 | 5612.33 | 5616.04 | 74230.0 |
| 2024-03-26 12:00:00 | ES | Futures | 5616.04 | 5616.84 | 5608.88 | 5610.47 | 79439.0 |
| 2024-03-26 13:00:00 | ES | Futures | 5610.47 | 5612.07 | 5606.23 | 5608.35 | 67688.0 |
| 2024-03-26 14:00:00 | ES | Futures | 5608.09 | 5612.6 | 5607.82 | 5610.21 | 55670.0 |
| 2024-03-26 15:00:00 | ES | Futures | 5610.47 | 5611.27 | 5585.01 | 5588.19 | 282439.0 |
| 2024-03-26 16:00:00 | ES | Futures | 5588.19 | 5596.41 | 5586.86 | 5595.09 | 76357.0 |
| 2024-03-26 18:00:00 | ES | Futures | 5595.88 | 5596.94 | 5593.76 | 5595.88 | 4448.0 |
| 2024-03-26 19:00:00 | ES | Futures | 5595.62 | 5598.54 | 5594.56 | 5598.27 | 3995.0 |
| 2024-03-26 20:00:00 | ES | Futures | 5598.27 | 5599.86 | 5597.47 | 5598.54 | 6202.0 |
| 2024-03-26 21:00:00 | ES | Futures | 5598.8 | 5600.39 | 5597.47 | 5600.39 | 4701.0 |
| 2024-03-26 22:00:00 | ES | Futures | 5600.13 | 5600.66 | 5598.8 | 5599.86 | 2848.0 |
| 2024-03-26 23:00:00 | ES | Futures | 5599.86 | 5602.25 | 5599.6 | 5601.45 | 3521.0 |
| 2024-03-26 00:00:00 | NQ | Futures | 19820.71 | 19837.83 | 19819.91 | 19832.48 | 1939.0 |
| 2024-03-26 01:00:00 | NQ | Futures | 19832.48 | 19849.07 | 19830.07 | 19846.12 | 2319.0 |
| 2024-03-26 02:00:00 | NQ | Futures | 19846.12 | 19879.56 | 19837.83 | 19875.28 | 5096.0 |
| 2024-03-26 03:00:00 | NQ | Futures | 19876.08 | 19911.93 | 19864.05 | 19870.73 | 10016.0 |
| 2024-03-26 04:00:00 | NQ | Futures | 19870.47 | 19904.44 | 19865.12 | 19894.27 | 7369.0 |
| 2024-03-26 05:00:00 | NQ | Futures | 19894.54 | 19917.01 | 19889.19 | 19905.78 | 7513.0 |
| 2024-03-26 06:00:00 | NQ | Futures | 19906.04 | 19916.74 | 19898.82 | 19910.32 | 5416.0 |
| 2024-03-26 07:00:00 | NQ | Futures | 19910.32 | 19922.63 | 19894.81 | 19916.74 | 8362.0 |
| 2024-03-26 08:00:00 | NQ | Futures | 19917.01 | 19920.22 | 19856.29 | 19868.59 | 18976.0 |
| 2024-03-26 09:00:00 | NQ | Futures | 19868.86 | 19896.68 | 19848.8 | 19891.06 | 66445.0 |
| 2024-03-26 10:00:00 | NQ | Futures | 19891.06 | 19911.39 | 19831.68 | 19861.64 | 91360.0 |
| 2024-03-26 11:00:00 | NQ | Futures | 19861.1 | 19883.31 | 19848.53 | 19881.97 | 51613.0 |
| 2024-03-26 12:00:00 | NQ | Futures | 19881.17 | 19890.26 | 19833.02 | 19840.51 | 42012.0 |
| 2024-03-26 13:00:00 | NQ | Futures | 19840.77 | 19856.29 | 19826.86 | 19836.49 | 35440.0 |
| 2024-03-26 14:00:00 | NQ | Futures | 19836.23 | 19862.44 | 19833.82 | 19853.61 | 31665.0 |
| 2024-03-26 15:00:00 | NQ | Futures | 19853.61 | 19854.68 | 19730.29 | 19742.06 | 92809.0 |
| 2024-03-26 16:00:00 | NQ | Futures | 19742.06 | 19778.45 | 19738.85 | 19773.9 | 16769.0 |
| 2024-03-26 18:00:00 | NQ | Futures | 19771.22 | 19773.9 | 19761.06 | 19770.15 | 3430.0 |
| 2024-03-26 19:00:00 | NQ | Futures | 19769.35 | 19788.08 | 19766.14 | 19784.33 | 2707.0 |
| 2024-03-26 20:00:00 | NQ | Futures | 19784.06 | 19791.02 | 19777.64 | 19785.4 | 2918.0 |
| 2024-03-26 21:00:00 | NQ | Futures | 19784.87 | 19789.15 | 19775.77 | 19787.81 | 3500.0 |
| 2024-03-26 22:00:00 | NQ | Futures | 19788.08 | 19793.69 | 19782.19 | 19787.81 | 2288.0 |
| 2024-03-26 23:00:00 | NQ | Futures | 19787.81 | 19797.44 | 19787.81 | 19792.36 | 1875.0 |
| 2024-03-26 00:00:00 | YM | Futures | 42170.8 | 42186.7 | 42170.8 | 42179.3 | 404.0 |
| 2024-03-26 01:00:00 | YM | Futures | 42179.3 | 42187.8 | 42176.1 | 42184.6 | 596.0 |
| 2024-03-26 02:00:00 | YM | Futures | 42183.6 | 42204.8 | 42170.8 | 42198.4 | 870.0 |
| 2024-03-26 03:00:00 | YM | Futures | 42199.5 | 42214.3 | 42167.6 | 42168.7 | 2143.0 |
> showing 50 of 2,067 rows — these rows as CSV