PREVIEW / futures_1hour / 2025-06-04
file: by_date/futures_1hour/2025/2025-06-04.parquet size: 64 KB rows: 2,003
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-06-04 00:00:00 | ES | Futures | 6073.59 | 6076.64 | 6071.56 | 6072.57 | 2853.0 |
| 2025-06-04 01:00:00 | ES | Futures | 6072.57 | 6076.64 | 6071.81 | 6076.13 | 3573.0 |
| 2025-06-04 02:00:00 | ES | Futures | 6076.38 | 6081.21 | 6073.84 | 6077.15 | 7865.0 |
| 2025-06-04 03:00:00 | ES | Futures | 6077.4 | 6086.29 | 6074.1 | 6085.78 | 9929.0 |
| 2025-06-04 04:00:00 | ES | Futures | 6085.78 | 6092.9 | 6085.02 | 6085.28 | 13527.0 |
| 2025-06-04 05:00:00 | ES | Futures | 6085.53 | 6091.12 | 6084.26 | 6089.09 | 8611.0 |
| 2025-06-04 06:00:00 | ES | Futures | 6089.09 | 6093.66 | 6085.28 | 6091.12 | 9049.0 |
| 2025-06-04 07:00:00 | ES | Futures | 6090.86 | 6091.88 | 6085.53 | 6089.59 | 9339.0 |
| 2025-06-04 08:00:00 | ES | Futures | 6089.85 | 6093.4 | 6070.54 | 6078.92 | 42136.0 |
| 2025-06-04 09:00:00 | ES | Futures | 6078.92 | 6095.69 | 6077.15 | 6091.88 | 120141.0 |
| 2025-06-04 10:00:00 | ES | Futures | 6091.63 | 6094.17 | 6070.8 | 6091.63 | 212743.0 |
| 2025-06-04 11:00:00 | ES | Futures | 6091.37 | 6095.18 | 6079.94 | 6084.77 | 125084.0 |
| 2025-06-04 12:00:00 | ES | Futures | 6084.77 | 6085.78 | 6073.59 | 6083.5 | 101024.0 |
| 2025-06-04 13:00:00 | ES | Futures | 6083.5 | 6093.15 | 6083.5 | 6091.88 | 66228.0 |
| 2025-06-04 14:00:00 | ES | Futures | 6092.13 | 6095.95 | 6084.26 | 6086.29 | 75308.0 |
| 2025-06-04 15:00:00 | ES | Futures | 6086.29 | 6088.83 | 6074.61 | 6074.86 | 171012.0 |
| 2025-06-04 16:00:00 | ES | Futures | 6074.86 | 6077.15 | 6071.81 | 6073.34 | 40454.0 |
| 2025-06-04 18:00:00 | ES | Futures | 6070.8 | 6077.65 | 6068.76 | 6072.83 | 5213.0 |
| 2025-06-04 19:00:00 | ES | Futures | 6072.83 | 6074.61 | 6069.52 | 6070.54 | 3231.0 |
| 2025-06-04 20:00:00 | ES | Futures | 6070.8 | 6077.65 | 6070.29 | 6073.08 | 4688.0 |
| 2025-06-04 21:00:00 | ES | Futures | 6073.08 | 6075.62 | 6069.78 | 6075.11 | 4973.0 |
| 2025-06-04 22:00:00 | ES | Futures | 6075.11 | 6075.62 | 6069.52 | 6071.56 | 3706.0 |
| 2025-06-04 23:00:00 | ES | Futures | 6071.56 | 6074.1 | 6070.8 | 6073.08 | 3037.0 |
| 2025-06-04 00:00:00 | NQ | Futures | 22082.98 | 22100.04 | 22076.36 | 22081.71 | 2033.0 |
| 2025-06-04 01:00:00 | NQ | Futures | 22081.45 | 22099.28 | 22076.87 | 22098.77 | 1927.0 |
| 2025-06-04 02:00:00 | NQ | Futures | 22099.02 | 22119.4 | 22083.74 | 22094.69 | 4510.0 |
| 2025-06-04 03:00:00 | NQ | Futures | 22095.46 | 22126.53 | 22077.89 | 22124.74 | 5035.0 |
| 2025-06-04 04:00:00 | NQ | Futures | 22124.74 | 22153.52 | 22117.87 | 22121.43 | 7189.0 |
| 2025-06-04 05:00:00 | NQ | Futures | 22122.2 | 22150.46 | 22121.43 | 22140.79 | 4750.0 |
| 2025-06-04 06:00:00 | NQ | Futures | 22141.3 | 22168.03 | 22123.98 | 22155.05 | 6179.0 |
| 2025-06-04 07:00:00 | NQ | Futures | 22154.28 | 22160.9 | 22131.62 | 22151.74 | 5043.0 |
| 2025-06-04 08:00:00 | NQ | Futures | 22152.75 | 22172.11 | 22058.28 | 22112.52 | 21164.0 |
| 2025-06-04 09:00:00 | NQ | Futures | 22113.54 | 22198.85 | 22103.35 | 22158.87 | 51517.0 |
| 2025-06-04 10:00:00 | NQ | Futures | 22150.97 | 22169.31 | 22043.76 | 22166.0 | 73304.0 |
| 2025-06-04 11:00:00 | NQ | Futures | 22166.0 | 22189.93 | 22135.95 | 22159.12 | 43090.0 |
| 2025-06-04 12:00:00 | NQ | Futures | 22158.61 | 22162.94 | 22109.97 | 22159.12 | 35006.0 |
| 2025-06-04 13:00:00 | NQ | Futures | 22159.12 | 22196.3 | 22157.59 | 22191.46 | 26740.0 |
| 2025-06-04 14:00:00 | NQ | Futures | 22191.21 | 22208.78 | 22176.95 | 22188.15 | 30523.0 |
| 2025-06-04 15:00:00 | NQ | Futures | 22188.41 | 22203.94 | 22153.01 | 22162.69 | 43218.0 |
| 2025-06-04 16:00:00 | NQ | Futures | 22162.69 | 22169.82 | 22144.86 | 22152.75 | 14240.0 |
| 2025-06-04 18:00:00 | NQ | Futures | 22149.44 | 22177.71 | 22136.2 | 22155.56 | 3962.0 |
| 2025-06-04 19:00:00 | NQ | Futures | 22155.81 | 22163.96 | 22141.55 | 22145.62 | 2432.0 |
| 2025-06-04 20:00:00 | NQ | Futures | 22146.64 | 22171.85 | 22142.82 | 22148.94 | 3084.0 |
| 2025-06-04 21:00:00 | NQ | Futures | 22150.72 | 22162.18 | 22135.18 | 22161.16 | 3231.0 |
| 2025-06-04 22:00:00 | NQ | Futures | 22161.92 | 22163.71 | 22141.3 | 22149.95 | 3486.0 |
| 2025-06-04 23:00:00 | NQ | Futures | 22150.97 | 22160.14 | 22146.39 | 22155.05 | 2542.0 |
| 2025-06-04 00:00:00 | YM | Futures | 43806.5 | 43823.0 | 43796.2 | 43796.2 | 144.0 |
| 2025-06-04 01:00:00 | YM | Futures | 43795.2 | 43825.0 | 43793.1 | 43819.9 | 232.0 |
| 2025-06-04 02:00:00 | YM | Futures | 43819.9 | 43855.9 | 43802.4 | 43845.6 | 959.0 |
| 2025-06-04 03:00:00 | YM | Futures | 43843.6 | 43895.0 | 43815.8 | 43893.0 | 1070.0 |
> showing 50 of 2,003 rows — these rows as CSV