PREVIEW / futures_1hour / 2025-05-01
file: by_date/futures_1hour/2025/2025-05-01.parquet size: 61 KB rows: 1,815
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-05-01 00:00:00 | ES | Futures | 5738.51 | 5740.29 | 5733.18 | 5735.21 | 4747.0 |
| 2025-05-01 01:00:00 | ES | Futures | 5735.46 | 5744.61 | 5731.65 | 5732.41 | 8152.0 |
| 2025-05-01 02:00:00 | ES | Futures | 5732.67 | 5739.27 | 5730.13 | 5730.89 | 7573.0 |
| 2025-05-01 03:00:00 | ES | Futures | 5730.89 | 5741.31 | 5726.06 | 5735.97 | 11253.0 |
| 2025-05-01 04:00:00 | ES | Futures | 5735.97 | 5743.85 | 5728.6 | 5742.83 | 12367.0 |
| 2025-05-01 05:00:00 | ES | Futures | 5743.08 | 5753.5 | 5741.56 | 5751.72 | 10067.0 |
| 2025-05-01 06:00:00 | ES | Futures | 5751.97 | 5753.75 | 5739.27 | 5743.59 | 13379.0 |
| 2025-05-01 07:00:00 | ES | Futures | 5743.59 | 5750.2 | 5736.73 | 5746.13 | 19052.0 |
| 2025-05-01 08:00:00 | ES | Futures | 5745.88 | 5751.21 | 5727.59 | 5730.64 | 32422.0 |
| 2025-05-01 09:00:00 | ES | Futures | 5730.64 | 5746.13 | 5718.19 | 5719.71 | 147136.0 |
| 2025-05-01 10:00:00 | ES | Futures | 5721.74 | 5767.22 | 5719.97 | 5766.71 | 195921.0 |
| 2025-05-01 11:00:00 | ES | Futures | 5766.71 | 5774.33 | 5728.86 | 5736.22 | 165599.0 |
| 2025-05-01 12:00:00 | ES | Futures | 5735.97 | 5745.12 | 5722.51 | 5728.6 | 132992.0 |
| 2025-05-01 13:00:00 | ES | Futures | 5728.6 | 5752.23 | 5728.1 | 5738.0 | 91834.0 |
| 2025-05-01 14:00:00 | ES | Futures | 5738.0 | 5759.85 | 5736.73 | 5749.94 | 98311.0 |
| 2025-05-01 15:00:00 | ES | Futures | 5749.94 | 5757.31 | 5709.55 | 5715.9 | 213004.0 |
| 2025-05-01 16:00:00 | ES | Futures | 5715.9 | 5730.38 | 5692.28 | 5702.44 | 87010.0 |
| 2025-05-01 18:00:00 | ES | Futures | 5699.13 | 5703.71 | 5691.51 | 5700.66 | 7628.0 |
| 2025-05-01 19:00:00 | ES | Futures | 5700.4 | 5709.55 | 5698.88 | 5702.44 | 4049.0 |
| 2025-05-01 20:00:00 | ES | Futures | 5702.44 | 5754.77 | 5696.09 | 5749.94 | 23341.0 |
| 2025-05-01 21:00:00 | ES | Futures | 5749.69 | 5764.17 | 5745.62 | 5753.5 | 16369.0 |
| 2025-05-01 22:00:00 | ES | Futures | 5753.5 | 5761.12 | 5746.39 | 5758.33 | 8317.0 |
| 2025-05-01 23:00:00 | ES | Futures | 5758.58 | 5762.39 | 5757.56 | 5759.09 | 6340.0 |
| 2025-05-01 00:00:00 | NQ | Futures | 20329.7 | 20338.86 | 20305.25 | 20312.63 | 2429.0 |
| 2025-05-01 01:00:00 | NQ | Futures | 20312.89 | 20345.74 | 20288.95 | 20292.26 | 4303.0 |
| 2025-05-01 02:00:00 | NQ | Futures | 20293.03 | 20319.76 | 20285.9 | 20292.77 | 4461.0 |
| 2025-05-01 03:00:00 | NQ | Futures | 20293.28 | 20348.29 | 20271.63 | 20327.66 | 6625.0 |
| 2025-05-01 04:00:00 | NQ | Futures | 20327.15 | 20359.74 | 20302.45 | 20355.92 | 7441.0 |
| 2025-05-01 05:00:00 | NQ | Futures | 20356.43 | 20396.16 | 20344.72 | 20390.3 | 7492.0 |
| 2025-05-01 06:00:00 | NQ | Futures | 20389.54 | 20400.23 | 20354.91 | 20373.75 | 7999.0 |
| 2025-05-01 07:00:00 | NQ | Futures | 20374.01 | 20399.73 | 20352.36 | 20382.41 | 9404.0 |
| 2025-05-01 08:00:00 | NQ | Futures | 20381.14 | 20408.64 | 20320.78 | 20324.86 | 16746.0 |
| 2025-05-01 09:00:00 | NQ | Futures | 20325.37 | 20368.4 | 20229.62 | 20246.93 | 76406.0 |
| 2025-05-01 10:00:00 | NQ | Futures | 20246.93 | 20447.09 | 20235.22 | 20446.33 | 81414.0 |
| 2025-05-01 11:00:00 | NQ | Futures | 20446.58 | 20500.31 | 20303.98 | 20333.52 | 72494.0 |
| 2025-05-01 12:00:00 | NQ | Futures | 20334.53 | 20371.71 | 20280.55 | 20313.91 | 57529.0 |
| 2025-05-01 13:00:00 | NQ | Futures | 20313.65 | 20401.76 | 20310.09 | 20353.89 | 43246.0 |
| 2025-05-01 14:00:00 | NQ | Futures | 20353.89 | 20422.39 | 20348.29 | 20381.39 | 38414.0 |
| 2025-05-01 15:00:00 | NQ | Futures | 20381.39 | 20395.14 | 20227.33 | 20247.7 | 67988.0 |
| 2025-05-01 16:00:00 | NQ | Futures | 20247.7 | 20293.79 | 20124.95 | 20167.48 | 30726.0 |
| 2025-05-01 18:00:00 | NQ | Futures | 20150.67 | 20165.7 | 20117.06 | 20156.79 | 5953.0 |
| 2025-05-01 19:00:00 | NQ | Futures | 20156.28 | 20194.98 | 20146.09 | 20157.81 | 4243.0 |
| 2025-05-01 20:00:00 | NQ | Futures | 20158.31 | 20340.39 | 20122.66 | 20314.42 | 15406.0 |
| 2025-05-01 21:00:00 | NQ | Futures | 20313.14 | 20353.12 | 20285.9 | 20299.39 | 9409.0 |
| 2025-05-01 22:00:00 | NQ | Futures | 20299.39 | 20344.47 | 20277.24 | 20330.46 | 5055.0 |
| 2025-05-01 23:00:00 | NQ | Futures | 20330.46 | 20358.98 | 20323.84 | 20349.81 | 3100.0 |
| 2025-05-01 00:00:00 | YM | Futures | 42210.3 | 42219.5 | 42182.5 | 42207.2 | 371.0 |
| 2025-05-01 01:00:00 | YM | Futures | 42207.2 | 42255.6 | 42178.4 | 42184.5 | 1226.0 |
| 2025-05-01 02:00:00 | YM | Futures | 42186.6 | 42213.4 | 42154.7 | 42154.7 | 869.0 |
| 2025-05-01 03:00:00 | YM | Futures | 42154.7 | 42195.9 | 42125.9 | 42164.0 | 1199.0 |
> showing 50 of 1,815 rows — these rows as CSV