PREVIEW / futures_1hour / 2025-01-28
file: by_date/futures_1hour/2025/2025-01-28.parquet size: 66 KB rows: 2,119
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-01-28 00:00:00 | ES | Futures | 6201.52 | 6203.83 | 6190.24 | 6197.67 | 5099.0 |
| 2025-01-28 01:00:00 | ES | Futures | 6197.93 | 6200.24 | 6191.52 | 6195.11 | 4711.0 |
| 2025-01-28 02:00:00 | ES | Futures | 6194.85 | 6206.9 | 6191.01 | 6204.59 | 10230.0 |
| 2025-01-28 03:00:00 | ES | Futures | 6204.59 | 6220.75 | 6197.67 | 6219.46 | 22198.0 |
| 2025-01-28 04:00:00 | ES | Futures | 6219.21 | 6224.08 | 6213.31 | 6222.54 | 19979.0 |
| 2025-01-28 05:00:00 | ES | Futures | 6222.54 | 6227.92 | 6221.52 | 6223.05 | 13958.0 |
| 2025-01-28 06:00:00 | ES | Futures | 6223.05 | 6226.9 | 6212.03 | 6214.59 | 12440.0 |
| 2025-01-28 07:00:00 | ES | Futures | 6214.85 | 6216.13 | 6200.24 | 6212.54 | 30872.0 |
| 2025-01-28 08:00:00 | ES | Futures | 6212.54 | 6221.0 | 6205.88 | 6209.47 | 35142.0 |
| 2025-01-28 09:00:00 | ES | Futures | 6209.21 | 6214.08 | 6177.16 | 6193.83 | 198575.0 |
| 2025-01-28 10:00:00 | ES | Futures | 6193.83 | 6237.41 | 6192.8 | 6236.9 | 251965.0 |
| 2025-01-28 11:00:00 | ES | Futures | 6237.15 | 6242.54 | 6214.85 | 6232.03 | 214761.0 |
| 2025-01-28 12:00:00 | ES | Futures | 6231.77 | 6247.92 | 6229.98 | 6245.36 | 143023.0 |
| 2025-01-28 13:00:00 | ES | Futures | 6245.36 | 6254.84 | 6241.77 | 6244.59 | 119986.0 |
| 2025-01-28 14:00:00 | ES | Futures | 6244.85 | 6259.97 | 6238.95 | 6258.69 | 110319.0 |
| 2025-01-28 15:00:00 | ES | Futures | 6258.43 | 6261.25 | 6250.74 | 6251.51 | 208579.0 |
| 2025-01-28 16:00:00 | ES | Futures | 6251.51 | 6251.77 | 6245.1 | 6246.64 | 52594.0 |
| 2025-01-28 18:00:00 | ES | Futures | 6246.13 | 6250.23 | 6241.77 | 6243.05 | 6628.0 |
| 2025-01-28 19:00:00 | ES | Futures | 6243.05 | 6248.95 | 6241.77 | 6247.67 | 4533.0 |
| 2025-01-28 20:00:00 | ES | Futures | 6247.41 | 6249.46 | 6245.36 | 6247.15 | 2951.0 |
| 2025-01-28 21:00:00 | ES | Futures | 6247.41 | 6251.25 | 6245.61 | 6249.97 | 2753.0 |
| 2025-01-28 22:00:00 | ES | Futures | 6249.97 | 6250.23 | 6244.08 | 6249.72 | 3710.0 |
| 2025-01-28 23:00:00 | ES | Futures | 6249.72 | 6255.36 | 6249.72 | 6252.54 | 4070.0 |
| 2025-01-28 00:00:00 | NQ | Futures | 21926.71 | 21941.38 | 21870.61 | 21917.96 | 3477.0 |
| 2025-01-28 01:00:00 | NQ | Futures | 21918.22 | 21939.32 | 21889.14 | 21916.67 | 4145.0 |
| 2025-01-28 02:00:00 | NQ | Futures | 21915.13 | 21978.69 | 21898.92 | 21967.37 | 6710.0 |
| 2025-01-28 03:00:00 | NQ | Futures | 21968.4 | 22027.59 | 21914.87 | 22023.21 | 12369.0 |
| 2025-01-28 04:00:00 | NQ | Futures | 22023.99 | 22034.02 | 21972.52 | 22023.99 | 11634.0 |
| 2025-01-28 05:00:00 | NQ | Futures | 22025.02 | 22053.07 | 22017.55 | 22020.64 | 9597.0 |
| 2025-01-28 06:00:00 | NQ | Futures | 22020.64 | 22039.43 | 21952.7 | 21968.66 | 9386.0 |
| 2025-01-28 07:00:00 | NQ | Futures | 21968.91 | 21975.35 | 21882.45 | 21932.37 | 16342.0 |
| 2025-01-28 08:00:00 | NQ | Futures | 21932.11 | 21985.64 | 21907.41 | 21926.71 | 22140.0 |
| 2025-01-28 09:00:00 | NQ | Futures | 21926.97 | 21946.01 | 21781.31 | 21908.44 | 96844.0 |
| 2025-01-28 10:00:00 | NQ | Futures | 21910.24 | 22113.03 | 21906.38 | 22086.01 | 112347.0 |
| 2025-01-28 11:00:00 | NQ | Futures | 22086.52 | 22110.2 | 22016.01 | 22103.51 | 74689.0 |
| 2025-01-28 12:00:00 | NQ | Futures | 22103.76 | 22197.18 | 22101.45 | 22177.88 | 60735.0 |
| 2025-01-28 13:00:00 | NQ | Futures | 22177.88 | 22218.28 | 22153.95 | 22173.25 | 44611.0 |
| 2025-01-28 14:00:00 | NQ | Futures | 22173.5 | 22261.52 | 22145.71 | 22250.71 | 45664.0 |
| 2025-01-28 15:00:00 | NQ | Futures | 22250.45 | 22257.91 | 22191.52 | 22209.53 | 65738.0 |
| 2025-01-28 16:00:00 | NQ | Futures | 22209.53 | 22210.05 | 22183.8 | 22192.03 | 14875.0 |
| 2025-01-28 18:00:00 | NQ | Futures | 22192.55 | 22213.14 | 22163.21 | 22178.65 | 4200.0 |
| 2025-01-28 19:00:00 | NQ | Futures | 22179.17 | 22205.67 | 22167.84 | 22200.01 | 3618.0 |
| 2025-01-28 20:00:00 | NQ | Futures | 22199.24 | 22210.56 | 22187.66 | 22200.53 | 2604.0 |
| 2025-01-28 21:00:00 | NQ | Futures | 22200.27 | 22220.6 | 22193.83 | 22213.14 | 2201.0 |
| 2025-01-28 22:00:00 | NQ | Futures | 22213.14 | 22218.28 | 22191.78 | 22217.25 | 2488.0 |
| 2025-01-28 23:00:00 | NQ | Futures | 22217.77 | 22243.76 | 22217.51 | 22230.64 | 3253.0 |
| 2025-01-28 00:00:00 | YM | Futures | 46137.9 | 46160.5 | 46080.2 | 46121.4 | 885.0 |
| 2025-01-28 01:00:00 | YM | Futures | 46124.5 | 46131.7 | 46065.8 | 46075.1 | 827.0 |
| 2025-01-28 02:00:00 | YM | Futures | 46074.1 | 46129.6 | 46052.5 | 46115.2 | 1492.0 |
| 2025-01-28 03:00:00 | YM | Futures | 46114.2 | 46229.5 | 46090.5 | 46222.3 | 2824.0 |
> showing 50 of 2,119 rows — these rows as CSV