PREVIEW / futures_1hour / 2025-06-18
file: by_date/futures_1hour/2025/2025-06-18.parquet size: 65 KB rows: 1,986
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-18 00:00:00 | ES | Futures | 6086.05 | 6090.58 | 6081.77 | 6088.57 | 2959.0 |
| 2025-06-18 01:00:00 | ES | Futures | 6088.57 | 6093.1 | 6088.31 | 6091.09 | 2878.0 |
| 2025-06-18 02:00:00 | ES | Futures | 6091.09 | 6102.42 | 6089.57 | 6094.86 | 7533.0 |
| 2025-06-18 03:00:00 | ES | Futures | 6094.86 | 6102.42 | 6094.11 | 6097.38 | 8512.0 |
| 2025-06-18 04:00:00 | ES | Futures | 6097.38 | 6101.66 | 6093.35 | 6100.4 | 7871.0 |
| 2025-06-18 05:00:00 | ES | Futures | 6100.4 | 6108.21 | 6099.9 | 6100.4 | 8714.0 |
| 2025-06-18 06:00:00 | ES | Futures | 6100.15 | 6100.91 | 6079.75 | 6081.26 | 14948.0 |
| 2025-06-18 07:00:00 | ES | Futures | 6081.01 | 6099.15 | 6079.75 | 6093.35 | 18550.0 |
| 2025-06-18 08:00:00 | ES | Futures | 6093.35 | 6096.37 | 6086.3 | 6087.31 | 16305.0 |
| 2025-06-18 09:00:00 | ES | Futures | 6087.56 | 6102.42 | 6079.75 | 6097.89 | 112572.0 |
| 2025-06-18 10:00:00 | ES | Futures | 6097.63 | 6119.3 | 6093.6 | 6115.52 | 156613.0 |
| 2025-06-18 11:00:00 | ES | Futures | 6115.52 | 6116.02 | 6102.92 | 6104.18 | 94398.0 |
| 2025-06-18 12:00:00 | ES | Futures | 6104.43 | 6110.48 | 6100.4 | 6101.41 | 75679.0 |
| 2025-06-18 13:00:00 | ES | Futures | 6101.41 | 6107.21 | 6086.8 | 6103.68 | 93241.0 |
| 2025-06-18 14:00:00 | ES | Futures | 6103.68 | 6117.78 | 6073.45 | 6079.5 | 162274.0 |
| 2025-06-18 15:00:00 | ES | Futures | 6079.25 | 6096.63 | 6071.44 | 6080.76 | 246346.0 |
| 2025-06-18 16:00:00 | ES | Futures | 6080.76 | 6088.82 | 6080.0 | 6081.26 | 38564.0 |
| 2025-06-18 18:00:00 | ES | Futures | 6083.53 | 6083.53 | 6071.69 | 6076.48 | 6446.0 |
| 2025-06-18 19:00:00 | ES | Futures | 6076.22 | 6080.0 | 6073.71 | 6079.0 | 3750.0 |
| 2025-06-18 20:00:00 | ES | Futures | 6079.0 | 6080.0 | 6058.85 | 6068.67 | 8605.0 |
| 2025-06-18 21:00:00 | ES | Futures | 6068.67 | 6069.17 | 6044.74 | 6058.85 | 17662.0 |
| 2025-06-18 22:00:00 | ES | Futures | 6058.59 | 6066.15 | 6055.32 | 6061.11 | 4284.0 |
| 2025-06-18 23:00:00 | ES | Futures | 6061.36 | 6071.69 | 6061.36 | 6070.18 | 3365.0 |
| 2025-06-18 00:00:00 | NQ | Futures | 22161.1 | 22179.0 | 22135.88 | 22171.19 | 2447.0 |
| 2025-06-18 01:00:00 | NQ | Futures | 22171.44 | 22188.59 | 22169.92 | 22180.01 | 1817.0 |
| 2025-06-18 02:00:00 | NQ | Futures | 22179.51 | 22222.63 | 22172.95 | 22195.14 | 4912.0 |
| 2025-06-18 03:00:00 | NQ | Futures | 22195.39 | 22224.14 | 22189.85 | 22205.73 | 6062.0 |
| 2025-06-18 04:00:00 | NQ | Futures | 22206.49 | 22228.93 | 22197.41 | 22223.39 | 4596.0 |
| 2025-06-18 05:00:00 | NQ | Futures | 22224.65 | 22258.44 | 22221.87 | 22223.39 | 5593.0 |
| 2025-06-18 06:00:00 | NQ | Futures | 22222.88 | 22227.42 | 22143.45 | 22147.99 | 7900.0 |
| 2025-06-18 07:00:00 | NQ | Futures | 22148.99 | 22222.38 | 22143.19 | 22199.18 | 8548.0 |
| 2025-06-18 08:00:00 | NQ | Futures | 22199.68 | 22211.03 | 22171.44 | 22178.25 | 8089.0 |
| 2025-06-18 09:00:00 | NQ | Futures | 22178.5 | 22217.84 | 22117.22 | 22193.13 | 45374.0 |
| 2025-06-18 10:00:00 | NQ | Futures | 22193.38 | 22290.21 | 22171.94 | 22272.31 | 61106.0 |
| 2025-06-18 11:00:00 | NQ | Futures | 22272.06 | 22278.11 | 22225.66 | 22230.7 | 37176.0 |
| 2025-06-18 12:00:00 | NQ | Futures | 22230.45 | 22257.93 | 22213.55 | 22219.86 | 27736.0 |
| 2025-06-18 13:00:00 | NQ | Futures | 22220.11 | 22233.73 | 22130.59 | 22216.83 | 34229.0 |
| 2025-06-18 14:00:00 | NQ | Futures | 22220.86 | 22274.83 | 22081.66 | 22108.39 | 68747.0 |
| 2025-06-18 15:00:00 | NQ | Futures | 22109.4 | 22204.98 | 22072.84 | 22140.17 | 76567.0 |
| 2025-06-18 16:00:00 | NQ | Futures | 22139.66 | 22169.42 | 22138.15 | 22153.03 | 12668.0 |
| 2025-06-18 18:00:00 | NQ | Futures | 22147.99 | 22162.11 | 22101.33 | 22130.08 | 2592.0 |
| 2025-06-18 19:00:00 | NQ | Futures | 22127.31 | 22144.96 | 22112.93 | 22139.16 | 1448.0 |
| 2025-06-18 20:00:00 | NQ | Futures | 22140.42 | 22143.95 | 22038.29 | 22082.42 | 5720.0 |
| 2025-06-18 21:00:00 | NQ | Futures | 22082.42 | 22084.44 | 21979.78 | 22030.22 | 9037.0 |
| 2025-06-18 22:00:00 | NQ | Futures | 22029.21 | 22058.97 | 22012.31 | 22035.26 | 3472.0 |
| 2025-06-18 23:00:00 | NQ | Futures | 22036.27 | 22080.4 | 22035.01 | 22073.59 | 2954.0 |
| 2025-06-18 00:00:00 | YM | Futures | 43477.1 | 43494.4 | 43452.6 | 43480.1 | 441.0 |
| 2025-06-18 01:00:00 | YM | Futures | 43480.1 | 43508.7 | 43480.1 | 43495.5 | 291.0 |
| 2025-06-18 02:00:00 | YM | Futures | 43496.5 | 43582.3 | 43484.2 | 43517.9 | 1169.0 |
| 2025-06-18 03:00:00 | YM | Futures | 43521.0 | 43576.2 | 43516.9 | 43544.5 | 1146.0 |
> showing 50 of 1,986 rows — these rows as CSV