PREVIEW / futures_1hour / 2025-04-29
file: by_date/futures_1hour/2025/2025-04-29.parquet size: 67 KB rows: 2,107
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-29 00:00:00 | ES | Futures | 5652.65 | 5657.47 | 5645.02 | 5647.06 | 4164.0 |
| 2025-04-29 01:00:00 | ES | Futures | 5647.06 | 5651.63 | 5642.74 | 5643.5 | 4841.0 |
| 2025-04-29 02:00:00 | ES | Futures | 5643.75 | 5651.37 | 5641.98 | 5645.53 | 4330.0 |
| 2025-04-29 03:00:00 | ES | Futures | 5645.53 | 5663.82 | 5642.99 | 5660.52 | 10428.0 |
| 2025-04-29 04:00:00 | ES | Futures | 5660.52 | 5661.28 | 5645.79 | 5656.2 | 9895.0 |
| 2025-04-29 05:00:00 | ES | Futures | 5656.46 | 5657.73 | 5648.58 | 5653.66 | 8194.0 |
| 2025-04-29 06:00:00 | ES | Futures | 5653.41 | 5656.96 | 5622.67 | 5637.66 | 21252.0 |
| 2025-04-29 07:00:00 | ES | Futures | 5637.15 | 5646.55 | 5636.64 | 5640.96 | 13568.0 |
| 2025-04-29 08:00:00 | ES | Futures | 5640.96 | 5648.07 | 5624.45 | 5625.97 | 38152.0 |
| 2025-04-29 09:00:00 | ES | Futures | 5626.22 | 5649.09 | 5610.73 | 5638.67 | 145853.0 |
| 2025-04-29 10:00:00 | ES | Futures | 5638.93 | 5663.06 | 5625.72 | 5662.55 | 186900.0 |
| 2025-04-29 11:00:00 | ES | Futures | 5662.55 | 5665.6 | 5640.71 | 5649.85 | 125416.0 |
| 2025-04-29 12:00:00 | ES | Futures | 5649.85 | 5667.38 | 5636.89 | 5642.74 | 106116.0 |
| 2025-04-29 13:00:00 | ES | Futures | 5642.74 | 5684.65 | 5639.44 | 5680.59 | 121068.0 |
| 2025-04-29 14:00:00 | ES | Futures | 5680.84 | 5687.7 | 5673.73 | 5676.52 | 113396.0 |
| 2025-04-29 15:00:00 | ES | Futures | 5676.52 | 5686.94 | 5670.68 | 5673.73 | 181041.0 |
| 2025-04-29 16:00:00 | ES | Futures | 5673.73 | 5680.84 | 5666.62 | 5672.97 | 41329.0 |
| 2025-04-29 18:00:00 | ES | Futures | 5669.67 | 5673.22 | 5661.28 | 5662.3 | 5386.0 |
| 2025-04-29 19:00:00 | ES | Futures | 5662.3 | 5664.08 | 5657.98 | 5661.54 | 3031.0 |
| 2025-04-29 20:00:00 | ES | Futures | 5661.54 | 5666.11 | 5649.85 | 5652.39 | 7694.0 |
| 2025-04-29 21:00:00 | ES | Futures | 5652.14 | 5655.44 | 5646.04 | 5648.33 | 5298.0 |
| 2025-04-29 22:00:00 | ES | Futures | 5648.07 | 5650.61 | 5644.52 | 5645.02 | 4269.0 |
| 2025-04-29 23:00:00 | ES | Futures | 5645.02 | 5647.82 | 5638.42 | 5646.8 | 5523.0 |
| 2025-04-29 00:00:00 | NQ | Futures | 19938.29 | 19962.23 | 19905.19 | 19916.65 | 4616.0 |
| 2025-04-29 01:00:00 | NQ | Futures | 19916.39 | 19934.73 | 19893.48 | 19896.02 | 3878.0 |
| 2025-04-29 02:00:00 | NQ | Futures | 19895.0 | 19929.64 | 19888.89 | 19906.46 | 3881.0 |
| 2025-04-29 03:00:00 | NQ | Futures | 19907.23 | 19987.19 | 19896.28 | 19974.46 | 7367.0 |
| 2025-04-29 04:00:00 | NQ | Futures | 19975.22 | 19975.73 | 19904.93 | 19945.93 | 6991.0 |
| 2025-04-29 05:00:00 | NQ | Futures | 19946.44 | 19954.34 | 19909.52 | 19931.16 | 5641.0 |
| 2025-04-29 06:00:00 | NQ | Futures | 19930.4 | 19945.17 | 19809.19 | 19859.1 | 11521.0 |
| 2025-04-29 07:00:00 | NQ | Futures | 19858.84 | 19895.0 | 19850.95 | 19867.25 | 9872.0 |
| 2025-04-29 08:00:00 | NQ | Futures | 19866.23 | 19901.62 | 19807.4 | 19811.99 | 20526.0 |
| 2025-04-29 09:00:00 | NQ | Futures | 19812.75 | 19909.77 | 19738.65 | 19869.28 | 74109.0 |
| 2025-04-29 10:00:00 | NQ | Futures | 19869.03 | 19973.95 | 19828.54 | 19961.47 | 87076.0 |
| 2025-04-29 11:00:00 | NQ | Futures | 19962.74 | 19980.31 | 19862.92 | 19902.64 | 58546.0 |
| 2025-04-29 12:00:00 | NQ | Futures | 19902.13 | 19970.89 | 19833.38 | 19857.06 | 57291.0 |
| 2025-04-29 13:00:00 | NQ | Futures | 19856.81 | 20033.53 | 19845.6 | 20021.82 | 55544.0 |
| 2025-04-29 14:00:00 | NQ | Futures | 20022.33 | 20054.93 | 20004.25 | 20011.89 | 47387.0 |
| 2025-04-29 15:00:00 | NQ | Futures | 20012.14 | 20049.58 | 19980.06 | 20011.13 | 61172.0 |
| 2025-04-29 16:00:00 | NQ | Futures | 20010.62 | 20034.55 | 19931.42 | 19979.29 | 16745.0 |
| 2025-04-29 18:00:00 | NQ | Futures | 19964.52 | 19976.75 | 19927.34 | 19928.62 | 4648.0 |
| 2025-04-29 19:00:00 | NQ | Futures | 19928.62 | 19938.8 | 19908.5 | 19927.09 | 3806.0 |
| 2025-04-29 20:00:00 | NQ | Futures | 19926.58 | 19948.99 | 19882.02 | 19894.75 | 6970.0 |
| 2025-04-29 21:00:00 | NQ | Futures | 19893.73 | 19908.5 | 19869.03 | 19876.41 | 4754.0 |
| 2025-04-29 22:00:00 | NQ | Futures | 19876.41 | 19891.95 | 19862.92 | 19872.34 | 4160.0 |
| 2025-04-29 23:00:00 | NQ | Futures | 19872.59 | 19891.18 | 19847.89 | 19886.6 | 4908.0 |
| 2025-04-29 00:00:00 | YM | Futures | 41598.9 | 41642.2 | 41553.7 | 41576.3 | 1113.0 |
| 2025-04-29 01:00:00 | YM | Futures | 41573.2 | 41600.0 | 41542.3 | 41565.0 | 865.0 |
| 2025-04-29 02:00:00 | YM | Futures | 41565.0 | 41604.1 | 41546.5 | 41560.9 | 612.0 |
| 2025-04-29 03:00:00 | YM | Futures | 41559.8 | 41668.9 | 41545.4 | 41645.3 | 1391.0 |
> showing 50 of 2,107 rows — these rows as CSV