PREVIEW / futures_1hour / 2025-11-17
file: by_date/futures_1hour/2025/2025-11-17.parquet size: 66 KB rows: 2,109
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-11-17 00:00:00 | ES | Futures | 6836.89 | 6839.15 | 6830.84 | 6831.6 | 6181.0 |
| 2025-11-17 01:00:00 | ES | Futures | 6831.6 | 6836.38 | 6829.08 | 6830.34 | 6975.0 |
| 2025-11-17 02:00:00 | ES | Futures | 6830.34 | 6846.21 | 6829.33 | 6843.44 | 9453.0 |
| 2025-11-17 03:00:00 | ES | Futures | 6843.18 | 6852.5 | 6841.17 | 6850.24 | 13138.0 |
| 2025-11-17 04:00:00 | ES | Futures | 6849.98 | 6851.5 | 6834.12 | 6838.4 | 13469.0 |
| 2025-11-17 05:00:00 | ES | Futures | 6838.15 | 6838.65 | 6814.97 | 6819.76 | 14718.0 |
| 2025-11-17 06:00:00 | ES | Futures | 6819.76 | 6830.09 | 6814.97 | 6822.53 | 12584.0 |
| 2025-11-17 07:00:00 | ES | Futures | 6822.53 | 6822.53 | 6806.41 | 6809.68 | 18045.0 |
| 2025-11-17 08:00:00 | ES | Futures | 6809.68 | 6810.94 | 6785.0 | 6798.1 | 32910.0 |
| 2025-11-17 09:00:00 | ES | Futures | 6798.1 | 6825.55 | 6776.94 | 6815.73 | 187768.0 |
| 2025-11-17 10:00:00 | ES | Futures | 6815.98 | 6820.26 | 6788.78 | 6795.08 | 239402.0 |
| 2025-11-17 11:00:00 | ES | Futures | 6795.08 | 6818.0 | 6765.1 | 6817.74 | 230524.0 |
| 2025-11-17 12:00:00 | ES | Futures | 6817.74 | 6818.25 | 6779.21 | 6779.96 | 148755.0 |
| 2025-11-17 13:00:00 | ES | Futures | 6779.96 | 6786.76 | 6752.26 | 6753.01 | 198518.0 |
| 2025-11-17 14:00:00 | ES | Futures | 6753.01 | 6756.54 | 6713.72 | 6714.48 | 235471.0 |
| 2025-11-17 15:00:00 | ES | Futures | 6714.22 | 6744.95 | 6708.43 | 6743.94 | 332018.0 |
| 2025-11-17 16:00:00 | ES | Futures | 6743.94 | 6751.25 | 6742.18 | 6747.47 | 60052.0 |
| 2025-11-17 18:00:00 | ES | Futures | 6746.72 | 6756.54 | 6743.44 | 6751.75 | 9922.0 |
| 2025-11-17 19:00:00 | ES | Futures | 6751.75 | 6754.78 | 6735.13 | 6739.91 | 14798.0 |
| 2025-11-17 20:00:00 | ES | Futures | 6739.91 | 6759.06 | 6738.91 | 6754.27 | 14346.0 |
| 2025-11-17 21:00:00 | ES | Futures | 6754.27 | 6758.05 | 6736.64 | 6736.89 | 12858.0 |
| 2025-11-17 22:00:00 | ES | Futures | 6736.64 | 6737.4 | 6722.54 | 6725.31 | 21066.0 |
| 2025-11-17 23:00:00 | ES | Futures | 6725.31 | 6725.31 | 6688.53 | 6711.7 | 36687.0 |
| 2025-11-17 00:00:00 | NQ | Futures | 25496.18 | 25507.27 | 25461.38 | 25466.93 | 4506.0 |
| 2025-11-17 01:00:00 | NQ | Futures | 25467.43 | 25492.14 | 25449.52 | 25458.6 | 4398.0 |
| 2025-11-17 02:00:00 | NQ | Futures | 25456.84 | 25549.14 | 25451.54 | 25533.5 | 7609.0 |
| 2025-11-17 03:00:00 | NQ | Futures | 25535.77 | 25582.93 | 25523.41 | 25576.88 | 8662.0 |
| 2025-11-17 04:00:00 | NQ | Futures | 25576.88 | 25582.17 | 25485.33 | 25505.26 | 8400.0 |
| 2025-11-17 05:00:00 | NQ | Futures | 25505.01 | 25511.81 | 25388.75 | 25419.26 | 8911.0 |
| 2025-11-17 06:00:00 | NQ | Futures | 25419.51 | 25465.16 | 25390.51 | 25423.05 | 7577.0 |
| 2025-11-17 07:00:00 | NQ | Futures | 25423.55 | 25423.8 | 25331.5 | 25350.67 | 11179.0 |
| 2025-11-17 08:00:00 | NQ | Futures | 25350.67 | 25359.24 | 25228.61 | 25297.46 | 20212.0 |
| 2025-11-17 09:00:00 | NQ | Futures | 25297.71 | 25474.74 | 25173.13 | 25418.76 | 95696.0 |
| 2025-11-17 10:00:00 | NQ | Futures | 25419.51 | 25436.41 | 25272.74 | 25299.73 | 104873.0 |
| 2025-11-17 11:00:00 | NQ | Futures | 25299.73 | 25421.28 | 25163.04 | 25416.99 | 88169.0 |
| 2025-11-17 12:00:00 | NQ | Futures | 25416.49 | 25420.02 | 25215.5 | 25219.53 | 62973.0 |
| 2025-11-17 13:00:00 | NQ | Futures | 25219.53 | 25269.72 | 25104.28 | 25112.86 | 68477.0 |
| 2025-11-17 14:00:00 | NQ | Futures | 25113.11 | 25129.25 | 24970.62 | 24972.64 | 74711.0 |
| 2025-11-17 15:00:00 | NQ | Futures | 24972.64 | 25108.32 | 24947.93 | 25105.8 | 89400.0 |
| 2025-11-17 16:00:00 | NQ | Futures | 25105.54 | 25144.13 | 25094.7 | 25123.2 | 20509.0 |
| 2025-11-17 18:00:00 | NQ | Futures | 25123.2 | 25172.63 | 25099.49 | 25138.33 | 6940.0 |
| 2025-11-17 19:00:00 | NQ | Futures | 25138.58 | 25155.98 | 25047.29 | 25068.72 | 9562.0 |
| 2025-11-17 20:00:00 | NQ | Futures | 25069.73 | 25177.67 | 25069.73 | 25152.7 | 9247.0 |
| 2025-11-17 21:00:00 | NQ | Futures | 25152.45 | 25171.87 | 25055.11 | 25057.38 | 7257.0 |
| 2025-11-17 22:00:00 | NQ | Futures | 25056.87 | 25058.13 | 24978.44 | 25002.15 | 11198.0 |
| 2025-11-17 23:00:00 | NQ | Futures | 25001.39 | 25001.39 | 24822.09 | 24946.41 | 17219.0 |
| 2025-11-17 00:00:00 | YM | Futures | 47943.2 | 47958.4 | 47915.8 | 47916.8 | 364.0 |
| 2025-11-17 01:00:00 | YM | Futures | 47917.8 | 47946.2 | 47912.7 | 47934.0 | 482.0 |
| 2025-11-17 02:00:00 | YM | Futures | 47933.0 | 47994.9 | 47925.9 | 47978.7 | 1098.0 |
| 2025-11-17 03:00:00 | YM | Futures | 47977.6 | 48036.5 | 47971.6 | 48004.0 | 1351.0 |
> showing 50 of 2,109 rows — these rows as CSV