PREVIEW / futures_1hour / 2025-09-19
file: by_date/futures_1hour/2025/2025-09-19.parquet size: 53 KB rows: 1,639
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-09-19 00:00:00 | ES | Futures | 6747.97 | 6749.49 | 6740.67 | 6748.98 | 5367.0 |
| 2025-09-19 01:00:00 | ES | Futures | 6748.98 | 6749.74 | 6740.92 | 6742.94 | 5573.0 |
| 2025-09-19 02:00:00 | ES | Futures | 6743.19 | 6744.95 | 6734.12 | 6734.12 | 11412.0 |
| 2025-09-19 03:00:00 | ES | Futures | 6734.12 | 6739.66 | 6729.59 | 6738.15 | 12003.0 |
| 2025-09-19 04:00:00 | ES | Futures | 6738.15 | 6745.71 | 6737.4 | 6743.19 | 7599.0 |
| 2025-09-19 05:00:00 | ES | Futures | 6742.94 | 6747.97 | 6742.43 | 6743.19 | 7462.0 |
| 2025-09-19 06:00:00 | ES | Futures | 6743.44 | 6747.72 | 6741.43 | 6746.46 | 7418.0 |
| 2025-09-19 07:00:00 | ES | Futures | 6746.21 | 6750.24 | 6743.69 | 6749.99 | 10185.0 |
| 2025-09-19 08:00:00 | ES | Futures | 6749.99 | 6756.54 | 6748.98 | 6752.76 | 21310.0 |
| 2025-09-19 09:00:00 | ES | Futures | 6753.01 | 6762.84 | 6746.97 | 6756.03 | 188923.0 |
| 2025-09-19 10:00:00 | ES | Futures | 6755.78 | 6758.55 | 6743.44 | 6749.74 | 153837.0 |
| 2025-09-19 11:00:00 | ES | Futures | 6749.74 | 6753.52 | 6737.4 | 6750.24 | 138608.0 |
| 2025-09-19 12:00:00 | ES | Futures | 6749.99 | 6762.58 | 6749.74 | 6760.32 | 107758.0 |
| 2025-09-19 13:00:00 | ES | Futures | 6760.32 | 6764.35 | 6757.04 | 6762.33 | 70808.0 |
| 2025-09-19 14:00:00 | ES | Futures | 6762.08 | 6767.37 | 6758.81 | 6767.37 | 73449.0 |
| 2025-09-19 15:00:00 | ES | Futures | 6767.12 | 6781.98 | 6766.61 | 6772.15 | 293557.0 |
| 2025-09-19 16:00:00 | ES | Futures | 6772.15 | 6775.18 | 6768.38 | 6770.14 | 70248.0 |
| 2025-09-19 00:00:00 | NQ | Futures | 24929.01 | 24938.85 | 24897.74 | 24936.33 | 4656.0 |
| 2025-09-19 01:00:00 | NQ | Futures | 24936.58 | 24939.61 | 24912.87 | 24922.46 | 3030.0 |
| 2025-09-19 02:00:00 | NQ | Futures | 24922.21 | 24932.8 | 24887.66 | 24888.66 | 5437.0 |
| 2025-09-19 03:00:00 | NQ | Futures | 24887.66 | 24907.83 | 24870.51 | 24900.77 | 5738.0 |
| 2025-09-19 04:00:00 | NQ | Futures | 24901.02 | 24930.78 | 24896.23 | 24920.94 | 4569.0 |
| 2025-09-19 05:00:00 | NQ | Futures | 24922.21 | 24945.91 | 24919.18 | 24922.71 | 3887.0 |
| 2025-09-19 06:00:00 | NQ | Futures | 24923.72 | 24948.43 | 24916.15 | 24940.61 | 4085.0 |
| 2025-09-19 07:00:00 | NQ | Futures | 24940.61 | 24952.47 | 24929.01 | 24952.47 | 3839.0 |
| 2025-09-19 08:00:00 | NQ | Futures | 24951.96 | 24971.13 | 24947.68 | 24954.48 | 8882.0 |
| 2025-09-19 09:00:00 | NQ | Futures | 24954.48 | 25034.43 | 24950.95 | 25007.7 | 85250.0 |
| 2025-09-19 10:00:00 | NQ | Futures | 25007.19 | 25024.34 | 24950.2 | 24979.96 | 69720.0 |
| 2025-09-19 11:00:00 | NQ | Futures | 24979.96 | 24995.09 | 24923.97 | 24987.77 | 57689.0 |
| 2025-09-19 12:00:00 | NQ | Futures | 24987.52 | 25052.58 | 24986.76 | 25038.46 | 54861.0 |
| 2025-09-19 13:00:00 | NQ | Futures | 25038.46 | 25046.28 | 25012.24 | 25032.66 | 31117.0 |
| 2025-09-19 14:00:00 | NQ | Futures | 25033.42 | 25050.06 | 25020.81 | 25042.25 | 26714.0 |
| 2025-09-19 15:00:00 | NQ | Futures | 25041.99 | 25105.54 | 25038.46 | 25077.3 | 67956.0 |
| 2025-09-19 16:00:00 | NQ | Futures | 25077.55 | 25097.73 | 25069.99 | 25078.31 | 20578.0 |
| 2025-09-19 00:00:00 | YM | Futures | 47218.1 | 47219.1 | 47163.3 | 47212.0 | 695.0 |
| 2025-09-19 01:00:00 | YM | Futures | 47213.0 | 47215.0 | 47143.0 | 47161.3 | 671.0 |
| 2025-09-19 02:00:00 | YM | Futures | 47159.3 | 47171.4 | 47085.2 | 47097.4 | 1480.0 |
| 2025-09-19 03:00:00 | YM | Futures | 47096.4 | 47146.1 | 47052.8 | 47136.9 | 1621.0 |
| 2025-09-19 04:00:00 | YM | Futures | 47136.9 | 47189.7 | 47113.6 | 47170.4 | 1357.0 |
| 2025-09-19 05:00:00 | YM | Futures | 47171.4 | 47186.6 | 47147.1 | 47155.2 | 1012.0 |
| 2025-09-19 06:00:00 | YM | Futures | 47153.2 | 47168.4 | 47132.9 | 47153.2 | 1177.0 |
| 2025-09-19 07:00:00 | YM | Futures | 47157.2 | 47193.7 | 47144.0 | 47190.7 | 1041.0 |
| 2025-09-19 08:00:00 | YM | Futures | 47189.7 | 47244.4 | 47184.6 | 47224.2 | 1584.0 |
| 2025-09-19 09:00:00 | YM | Futures | 47222.1 | 47345.9 | 47107.5 | 47194.7 | 18622.0 |
| 2025-09-19 10:00:00 | YM | Futures | 47191.7 | 47253.6 | 47130.9 | 47169.4 | 9552.0 |
| 2025-09-19 11:00:00 | YM | Futures | 47168.4 | 47207.9 | 47092.3 | 47169.4 | 7207.0 |
| 2025-09-19 12:00:00 | YM | Futures | 47167.4 | 47287.0 | 47161.3 | 47262.7 | 5710.0 |
| 2025-09-19 13:00:00 | YM | Futures | 47263.7 | 47318.5 | 47229.2 | 47310.4 | 3695.0 |
| 2025-09-19 14:00:00 | YM | Futures | 47309.3 | 47314.4 | 47260.7 | 47310.4 | 3427.0 |
| 2025-09-19 15:00:00 | YM | Futures | 47310.4 | 47397.6 | 47299.2 | 47309.3 | 11865.0 |
> showing 50 of 1,639 rows — these rows as CSV