PREVIEW / futures_1hour / 2025-06-09
file: by_date/futures_1hour/2025/2025-06-09.parquet size: 58 KB rows: 1,806
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-09 00:00:00 | ES | Futures | 6093.4 | 6096.2 | 6091.37 | 6095.44 | 3833.0 |
| 2025-06-09 01:00:00 | ES | Futures | 6095.18 | 6095.69 | 6091.37 | 6095.44 | 3782.0 |
| 2025-06-09 02:00:00 | ES | Futures | 6095.44 | 6102.3 | 6092.13 | 6102.3 | 6318.0 |
| 2025-06-09 03:00:00 | ES | Futures | 6102.04 | 6107.88 | 6097.22 | 6107.88 | 8816.0 |
| 2025-06-09 04:00:00 | ES | Futures | 6107.63 | 6112.97 | 6102.8 | 6111.44 | 9060.0 |
| 2025-06-09 05:00:00 | ES | Futures | 6111.7 | 6111.95 | 6107.12 | 6107.88 | 4459.0 |
| 2025-06-09 06:00:00 | ES | Futures | 6107.38 | 6109.16 | 6103.57 | 6106.11 | 4627.0 |
| 2025-06-09 07:00:00 | ES | Futures | 6105.85 | 6117.03 | 6105.6 | 6113.22 | 12984.0 |
| 2025-06-09 08:00:00 | ES | Futures | 6113.22 | 6115.0 | 6108.65 | 6110.43 | 13965.0 |
| 2025-06-09 09:00:00 | ES | Futures | 6110.68 | 6113.73 | 6096.96 | 6101.53 | 101157.0 |
| 2025-06-09 10:00:00 | ES | Futures | 6101.53 | 6116.78 | 6100.01 | 6107.38 | 120815.0 |
| 2025-06-09 11:00:00 | ES | Futures | 6107.63 | 6112.71 | 6102.8 | 6111.19 | 70272.0 |
| 2025-06-09 12:00:00 | ES | Futures | 6111.19 | 6123.89 | 6106.11 | 6119.32 | 77443.0 |
| 2025-06-09 13:00:00 | ES | Futures | 6119.57 | 6124.91 | 6113.47 | 6122.11 | 76726.0 |
| 2025-06-09 14:00:00 | ES | Futures | 6122.11 | 6125.16 | 6116.01 | 6122.62 | 61030.0 |
| 2025-06-09 15:00:00 | ES | Futures | 6122.37 | 6124.14 | 6105.6 | 6107.38 | 185303.0 |
| 2025-06-09 16:00:00 | ES | Futures | 6107.38 | 6109.41 | 6104.07 | 6109.16 | 38804.0 |
| 2025-06-09 18:00:00 | ES | Futures | 6109.41 | 6114.24 | 6109.16 | 6109.41 | 3443.0 |
| 2025-06-09 19:00:00 | ES | Futures | 6109.66 | 6111.95 | 6109.41 | 6110.68 | 1895.0 |
| 2025-06-09 20:00:00 | ES | Futures | 6110.68 | 6118.3 | 6106.11 | 6116.78 | 5862.0 |
| 2025-06-09 21:00:00 | ES | Futures | 6116.52 | 6138.37 | 6116.52 | 6136.34 | 17991.0 |
| 2025-06-09 22:00:00 | ES | Futures | 6136.59 | 6138.37 | 6132.78 | 6135.32 | 6610.0 |
| 2025-06-09 23:00:00 | ES | Futures | 6135.07 | 6136.59 | 6132.02 | 6133.03 | 3269.0 |
| 2025-06-09 00:00:00 | NQ | Futures | 22148.68 | 22157.34 | 22135.69 | 22151.74 | 2426.0 |
| 2025-06-09 01:00:00 | NQ | Futures | 22150.97 | 22153.52 | 22133.4 | 22150.97 | 2536.0 |
| 2025-06-09 02:00:00 | NQ | Futures | 22151.48 | 22173.13 | 22136.46 | 22171.34 | 3424.0 |
| 2025-06-09 03:00:00 | NQ | Futures | 22171.6 | 22203.18 | 22154.79 | 22200.12 | 5729.0 |
| 2025-06-09 04:00:00 | NQ | Futures | 22199.61 | 22205.72 | 22162.43 | 22197.83 | 6705.0 |
| 2025-06-09 05:00:00 | NQ | Futures | 22197.83 | 22199.61 | 22178.47 | 22185.1 | 2917.0 |
| 2025-06-09 06:00:00 | NQ | Futures | 22184.84 | 22196.56 | 22168.29 | 22180.51 | 3248.0 |
| 2025-06-09 07:00:00 | NQ | Futures | 22179.75 | 22230.42 | 22179.24 | 22216.67 | 8160.0 |
| 2025-06-09 08:00:00 | NQ | Futures | 22217.95 | 22224.06 | 22196.56 | 22202.67 | 7216.0 |
| 2025-06-09 09:00:00 | NQ | Futures | 22203.18 | 22225.84 | 22155.56 | 22192.99 | 49423.0 |
| 2025-06-09 10:00:00 | NQ | Futures | 22192.99 | 22298.16 | 22192.99 | 22249.01 | 55129.0 |
| 2025-06-09 11:00:00 | NQ | Futures | 22249.01 | 22276.52 | 22218.96 | 22244.68 | 34117.0 |
| 2025-06-09 12:00:00 | NQ | Futures | 22245.7 | 22292.3 | 22221.51 | 22277.28 | 28646.0 |
| 2025-06-09 13:00:00 | NQ | Futures | 22277.28 | 22288.99 | 22240.61 | 22274.22 | 30091.0 |
| 2025-06-09 14:00:00 | NQ | Futures | 22274.48 | 22286.45 | 22248.0 | 22276.26 | 23581.0 |
| 2025-06-09 15:00:00 | NQ | Futures | 22276.77 | 22282.37 | 22219.98 | 22224.57 | 49273.0 |
| 2025-06-09 16:00:00 | NQ | Futures | 22224.57 | 22231.19 | 22202.41 | 22228.39 | 13644.0 |
| 2025-06-09 18:00:00 | NQ | Futures | 22230.17 | 22254.36 | 22229.41 | 22231.44 | 2618.0 |
| 2025-06-09 19:00:00 | NQ | Futures | 22232.72 | 22244.68 | 22231.44 | 22238.83 | 1634.0 |
| 2025-06-09 20:00:00 | NQ | Futures | 22239.34 | 22280.08 | 22221.26 | 22270.91 | 4530.0 |
| 2025-06-09 21:00:00 | NQ | Futures | 22270.66 | 22382.2 | 22269.64 | 22375.07 | 10191.0 |
| 2025-06-09 22:00:00 | NQ | Futures | 22374.81 | 22376.85 | 22352.66 | 22356.99 | 4227.0 |
| 2025-06-09 23:00:00 | NQ | Futures | 22356.22 | 22361.06 | 22340.94 | 22347.56 | 2527.0 |
| 2025-06-09 00:00:00 | YM | Futures | 43986.6 | 44004.1 | 43975.3 | 43997.9 | 375.0 |
| 2025-06-09 01:00:00 | YM | Futures | 44000.0 | 44000.0 | 43974.3 | 43996.9 | 534.0 |
| 2025-06-09 02:00:00 | YM | Futures | 43999.0 | 44049.4 | 43979.4 | 44048.4 | 988.0 |
| 2025-06-09 03:00:00 | YM | Futures | 44048.4 | 44088.5 | 44008.2 | 44088.5 | 1126.0 |
> showing 50 of 1,806 rows — these rows as CSV