PREVIEW / futures_1hour / 2025-04-30
file: by_date/futures_1hour/2025/2025-04-30.parquet size: 68 KB rows: 2,089
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-30 00:00:00 | ES | Futures | 5646.8 | 5651.37 | 5644.52 | 5648.58 | 3192.0 |
| 2025-04-30 01:00:00 | ES | Futures | 5649.09 | 5652.39 | 5644.77 | 5651.88 | 3968.0 |
| 2025-04-30 02:00:00 | ES | Futures | 5651.63 | 5662.55 | 5650.87 | 5660.77 | 7772.0 |
| 2025-04-30 03:00:00 | ES | Futures | 5660.77 | 5667.13 | 5660.01 | 5664.84 | 7903.0 |
| 2025-04-30 04:00:00 | ES | Futures | 5664.59 | 5672.46 | 5658.74 | 5661.03 | 12696.0 |
| 2025-04-30 05:00:00 | ES | Futures | 5661.28 | 5671.44 | 5660.52 | 5666.11 | 6462.0 |
| 2025-04-30 06:00:00 | ES | Futures | 5666.11 | 5667.13 | 5654.17 | 5663.31 | 8359.0 |
| 2025-04-30 07:00:00 | ES | Futures | 5663.06 | 5669.92 | 5652.65 | 5655.44 | 14557.0 |
| 2025-04-30 08:00:00 | ES | Futures | 5655.19 | 5657.22 | 5591.17 | 5601.07 | 69710.0 |
| 2025-04-30 09:00:00 | ES | Futures | 5601.07 | 5606.66 | 5543.66 | 5547.73 | 204951.0 |
| 2025-04-30 10:00:00 | ES | Futures | 5547.73 | 5604.89 | 5545.19 | 5599.55 | 248114.0 |
| 2025-04-30 11:00:00 | ES | Futures | 5599.55 | 5629.02 | 5598.28 | 5625.46 | 203511.0 |
| 2025-04-30 12:00:00 | ES | Futures | 5625.21 | 5633.85 | 5604.12 | 5626.22 | 120462.0 |
| 2025-04-30 13:00:00 | ES | Futures | 5626.48 | 5642.23 | 5601.33 | 5635.88 | 121863.0 |
| 2025-04-30 14:00:00 | ES | Futures | 5635.88 | 5662.55 | 5621.65 | 5626.73 | 178022.0 |
| 2025-04-30 15:00:00 | ES | Futures | 5626.73 | 5697.36 | 5624.19 | 5674.24 | 342575.0 |
| 2025-04-30 16:00:00 | ES | Futures | 5674.24 | 5717.17 | 5661.28 | 5710.06 | 127033.0 |
| 2025-04-30 18:00:00 | ES | Futures | 5708.28 | 5730.38 | 5705.74 | 5721.49 | 20402.0 |
| 2025-04-30 19:00:00 | ES | Futures | 5721.24 | 5727.33 | 5714.88 | 5725.3 | 7922.0 |
| 2025-04-30 20:00:00 | ES | Futures | 5725.55 | 5734.95 | 5724.54 | 5731.91 | 9501.0 |
| 2025-04-30 21:00:00 | ES | Futures | 5731.91 | 5734.19 | 5727.33 | 5732.41 | 6978.0 |
| 2025-04-30 22:00:00 | ES | Futures | 5732.41 | 5736.73 | 5726.06 | 5727.33 | 4200.0 |
| 2025-04-30 23:00:00 | ES | Futures | 5727.33 | 5739.27 | 5725.81 | 5738.76 | 7183.0 |
| 2025-04-30 00:00:00 | NQ | Futures | 19886.09 | 19903.92 | 19873.1 | 19883.03 | 3380.0 |
| 2025-04-30 01:00:00 | NQ | Futures | 19883.54 | 19902.13 | 19866.48 | 19901.12 | 3999.0 |
| 2025-04-30 02:00:00 | NQ | Futures | 19900.35 | 19937.02 | 19897.55 | 19928.36 | 5967.0 |
| 2025-04-30 03:00:00 | NQ | Futures | 19928.87 | 19959.69 | 19926.58 | 19950.52 | 5825.0 |
| 2025-04-30 04:00:00 | NQ | Futures | 19949.75 | 19987.95 | 19921.74 | 19939.57 | 7898.0 |
| 2025-04-30 05:00:00 | NQ | Futures | 19939.06 | 19980.06 | 19937.79 | 19953.32 | 4066.0 |
| 2025-04-30 06:00:00 | NQ | Futures | 19954.34 | 19957.9 | 19907.23 | 19934.98 | 6049.0 |
| 2025-04-30 07:00:00 | NQ | Futures | 19935.75 | 19965.8 | 19874.38 | 19890.67 | 9200.0 |
| 2025-04-30 08:00:00 | NQ | Futures | 19890.42 | 19899.08 | 19615.9 | 19645.19 | 40111.0 |
| 2025-04-30 09:00:00 | NQ | Futures | 19644.43 | 19666.83 | 19461.58 | 19477.12 | 97061.0 |
| 2025-04-30 10:00:00 | NQ | Futures | 19476.35 | 19717.0 | 19459.29 | 19692.81 | 103319.0 |
| 2025-04-30 11:00:00 | NQ | Futures | 19692.81 | 19817.08 | 19687.21 | 19804.86 | 74224.0 |
| 2025-04-30 12:00:00 | NQ | Futures | 19804.6 | 19835.92 | 19717.0 | 19800.27 | 58670.0 |
| 2025-04-30 13:00:00 | NQ | Futures | 19800.02 | 19872.08 | 19696.88 | 19840.76 | 54471.0 |
| 2025-04-30 14:00:00 | NQ | Futures | 19841.02 | 19946.44 | 19809.44 | 19836.69 | 68509.0 |
| 2025-04-30 15:00:00 | NQ | Futures | 19837.2 | 20082.68 | 19829.56 | 20008.07 | 89931.0 |
| 2025-04-30 16:00:00 | NQ | Futures | 20008.83 | 20249.99 | 19955.87 | 20217.9 | 43506.0 |
| 2025-04-30 18:00:00 | NQ | Futures | 20203.13 | 20307.03 | 20173.59 | 20273.67 | 12055.0 |
| 2025-04-30 19:00:00 | NQ | Futures | 20273.67 | 20304.99 | 20237.77 | 20287.93 | 9126.0 |
| 2025-04-30 20:00:00 | NQ | Futures | 20288.44 | 20327.15 | 20283.09 | 20317.98 | 9553.0 |
| 2025-04-30 21:00:00 | NQ | Futures | 20318.24 | 20323.07 | 20281.31 | 20299.9 | 7034.0 |
| 2025-04-30 22:00:00 | NQ | Futures | 20299.39 | 20322.57 | 20278.0 | 20284.37 | 4483.0 |
| 2025-04-30 23:00:00 | NQ | Futures | 20284.11 | 20334.79 | 20277.49 | 20328.68 | 4123.0 |
| 2025-04-30 00:00:00 | YM | Futures | 41742.0 | 41768.8 | 41732.7 | 41759.5 | 375.0 |
| 2025-04-30 01:00:00 | YM | Futures | 41757.4 | 41768.8 | 41730.7 | 41767.7 | 566.0 |
| 2025-04-30 02:00:00 | YM | Futures | 41769.8 | 41835.7 | 41761.6 | 41833.6 | 1149.0 |
| 2025-04-30 03:00:00 | YM | Futures | 41832.6 | 41868.6 | 41808.9 | 41852.1 | 1266.0 |
> showing 50 of 2,089 rows — these rows as CSV