PREVIEW / futures_1hour / 2025-04-01
file: by_date/futures_1hour/2025/2025-04-01.parquet size: 69 KB rows: 2,126
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-01 00:00:00 | ES | Futures | 5724.54 | 5725.55 | 5718.95 | 5725.05 | 5206.0 |
| 2025-04-01 01:00:00 | ES | Futures | 5725.05 | 5733.18 | 5723.52 | 5724.54 | 8025.0 |
| 2025-04-01 02:00:00 | ES | Futures | 5724.28 | 5742.07 | 5722.51 | 5741.05 | 11763.0 |
| 2025-04-01 03:00:00 | ES | Futures | 5741.31 | 5752.99 | 5729.37 | 5730.89 | 23266.0 |
| 2025-04-01 04:00:00 | ES | Futures | 5731.14 | 5745.88 | 5727.84 | 5745.12 | 19622.0 |
| 2025-04-01 05:00:00 | ES | Futures | 5745.12 | 5755.02 | 5743.34 | 5750.96 | 15641.0 |
| 2025-04-01 06:00:00 | ES | Futures | 5750.96 | 5751.97 | 5714.12 | 5729.37 | 39876.0 |
| 2025-04-01 07:00:00 | ES | Futures | 5729.62 | 5730.38 | 5708.79 | 5717.43 | 28583.0 |
| 2025-04-01 08:00:00 | ES | Futures | 5717.43 | 5728.35 | 5712.34 | 5725.81 | 39755.0 |
| 2025-04-01 09:00:00 | ES | Futures | 5726.06 | 5741.31 | 5713.87 | 5727.59 | 184859.0 |
| 2025-04-01 10:00:00 | ES | Futures | 5727.84 | 5754.26 | 5690.75 | 5752.99 | 311037.0 |
| 2025-04-01 11:00:00 | ES | Futures | 5752.99 | 5775.35 | 5749.43 | 5772.55 | 226426.0 |
| 2025-04-01 12:00:00 | ES | Futures | 5772.81 | 5786.78 | 5749.43 | 5763.41 | 192166.0 |
| 2025-04-01 13:00:00 | ES | Futures | 5763.41 | 5768.23 | 5744.86 | 5745.62 | 124199.0 |
| 2025-04-01 14:00:00 | ES | Futures | 5745.88 | 5747.66 | 5716.66 | 5732.16 | 163173.0 |
| 2025-04-01 15:00:00 | ES | Futures | 5731.91 | 5771.54 | 5729.62 | 5766.46 | 281764.0 |
| 2025-04-01 16:00:00 | ES | Futures | 5766.46 | 5771.28 | 5757.82 | 5763.91 | 66442.0 |
| 2025-04-01 18:00:00 | ES | Futures | 5763.66 | 5787.79 | 5763.15 | 5774.84 | 14911.0 |
| 2025-04-01 19:00:00 | ES | Futures | 5774.84 | 5779.67 | 5771.79 | 5774.58 | 5294.0 |
| 2025-04-01 20:00:00 | ES | Futures | 5774.58 | 5775.09 | 5754.01 | 5757.06 | 15708.0 |
| 2025-04-01 21:00:00 | ES | Futures | 5757.06 | 5763.91 | 5755.02 | 5761.63 | 5349.0 |
| 2025-04-01 22:00:00 | ES | Futures | 5761.88 | 5762.64 | 5757.56 | 5759.85 | 4423.0 |
| 2025-04-01 23:00:00 | ES | Futures | 5759.6 | 5761.12 | 5756.04 | 5757.31 | 4735.0 |
| 2025-04-01 00:00:00 | NQ | Futures | 19720.82 | 19727.95 | 19694.85 | 19726.42 | 2737.0 |
| 2025-04-01 01:00:00 | NQ | Futures | 19726.68 | 19761.06 | 19717.77 | 19720.82 | 4149.0 |
| 2025-04-01 02:00:00 | NQ | Futures | 19719.29 | 19798.24 | 19709.87 | 19791.36 | 6884.0 |
| 2025-04-01 03:00:00 | NQ | Futures | 19792.38 | 19841.78 | 19741.45 | 19754.69 | 12231.0 |
| 2025-04-01 04:00:00 | NQ | Futures | 19755.96 | 19835.41 | 19745.01 | 19831.34 | 10616.0 |
| 2025-04-01 05:00:00 | NQ | Futures | 19831.59 | 19874.12 | 19820.64 | 19850.44 | 10331.0 |
| 2025-04-01 06:00:00 | NQ | Futures | 19850.69 | 19854.0 | 19703.76 | 19766.15 | 19774.0 |
| 2025-04-01 07:00:00 | NQ | Futures | 19766.66 | 19768.95 | 19670.65 | 19714.45 | 14636.0 |
| 2025-04-01 08:00:00 | NQ | Futures | 19713.95 | 19755.2 | 19697.65 | 19742.72 | 15842.0 |
| 2025-04-01 09:00:00 | NQ | Futures | 19744.25 | 19824.72 | 19698.16 | 19759.78 | 94609.0 |
| 2025-04-01 10:00:00 | NQ | Futures | 19771.24 | 19882.78 | 19619.72 | 19879.21 | 134870.0 |
| 2025-04-01 11:00:00 | NQ | Futures | 19878.96 | 19970.89 | 19865.72 | 19956.63 | 93749.0 |
| 2025-04-01 12:00:00 | NQ | Futures | 19957.39 | 20009.6 | 19859.35 | 19928.36 | 86391.0 |
| 2025-04-01 13:00:00 | NQ | Futures | 19928.11 | 19947.21 | 19863.68 | 19868.52 | 56973.0 |
| 2025-04-01 14:00:00 | NQ | Futures | 19868.77 | 19877.43 | 19745.78 | 19809.95 | 74942.0 |
| 2025-04-01 15:00:00 | NQ | Futures | 19810.2 | 19991.52 | 19799.25 | 19968.34 | 88854.0 |
| 2025-04-01 16:00:00 | NQ | Futures | 19968.09 | 19994.32 | 19939.06 | 19962.74 | 19467.0 |
| 2025-04-01 18:00:00 | NQ | Futures | 19965.29 | 20063.58 | 19959.94 | 20008.58 | 8597.0 |
| 2025-04-01 19:00:00 | NQ | Futures | 20007.31 | 20032.77 | 19996.61 | 20010.36 | 4221.0 |
| 2025-04-01 20:00:00 | NQ | Futures | 20009.34 | 20012.4 | 19920.72 | 19936.26 | 8994.0 |
| 2025-04-01 21:00:00 | NQ | Futures | 19935.24 | 19967.83 | 19925.31 | 19957.65 | 4201.0 |
| 2025-04-01 22:00:00 | NQ | Futures | 19959.18 | 19963.25 | 19931.93 | 19944.66 | 2793.0 |
| 2025-04-01 23:00:00 | NQ | Futures | 19944.15 | 19953.32 | 19925.05 | 19932.69 | 2244.0 |
| 2025-04-01 00:00:00 | YM | Futures | 43383.5 | 43384.5 | 43350.6 | 43376.3 | 299.0 |
| 2025-04-01 01:00:00 | YM | Futures | 43376.3 | 43429.8 | 43365.0 | 43371.2 | 715.0 |
| 2025-04-01 02:00:00 | YM | Futures | 43366.0 | 43478.2 | 43357.8 | 43473.1 | 1486.0 |
| 2025-04-01 03:00:00 | YM | Futures | 43470.0 | 43541.0 | 43407.2 | 43414.4 | 3308.0 |
> showing 50 of 2,126 rows — these rows as CSV