PREVIEW / futures_1hour / 2025-11-05
file: by_date/futures_1hour/2025/2025-11-05.parquet size: 67 KB rows: 2,130
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-05 00:00:00 | ES | Futures | 6837.89 | 6849.73 | 6835.38 | 6839.91 | 9990.0 |
| 2025-11-05 01:00:00 | ES | Futures | 6839.91 | 6852.25 | 6834.12 | 6848.72 | 10231.0 |
| 2025-11-05 02:00:00 | ES | Futures | 6848.72 | 6849.73 | 6837.14 | 6837.89 | 9350.0 |
| 2025-11-05 03:00:00 | ES | Futures | 6837.89 | 6851.5 | 6832.86 | 6845.95 | 16488.0 |
| 2025-11-05 04:00:00 | ES | Futures | 6845.95 | 6852.25 | 6838.65 | 6844.95 | 13540.0 |
| 2025-11-05 05:00:00 | ES | Futures | 6844.69 | 6849.73 | 6824.04 | 6824.29 | 16068.0 |
| 2025-11-05 06:00:00 | ES | Futures | 6824.29 | 6839.91 | 6822.53 | 6838.15 | 14558.0 |
| 2025-11-05 07:00:00 | ES | Futures | 6838.15 | 6847.47 | 6832.86 | 6846.21 | 18395.0 |
| 2025-11-05 08:00:00 | ES | Futures | 6846.46 | 6858.8 | 6841.42 | 6856.53 | 36560.0 |
| 2025-11-05 09:00:00 | ES | Futures | 6856.53 | 6875.68 | 6840.66 | 6873.16 | 173556.0 |
| 2025-11-05 10:00:00 | ES | Futures | 6872.9 | 6882.48 | 6860.56 | 6878.19 | 233822.0 |
| 2025-11-05 11:00:00 | ES | Futures | 6878.45 | 6897.84 | 6867.11 | 6893.81 | 160791.0 |
| 2025-11-05 12:00:00 | ES | Futures | 6893.81 | 6909.17 | 6890.28 | 6902.37 | 116303.0 |
| 2025-11-05 13:00:00 | ES | Futures | 6902.37 | 6908.92 | 6900.36 | 6906.91 | 75662.0 |
| 2025-11-05 14:00:00 | ES | Futures | 6906.66 | 6906.66 | 6897.59 | 6902.63 | 78526.0 |
| 2025-11-05 15:00:00 | ES | Futures | 6902.63 | 6905.9 | 6874.16 | 6875.42 | 220690.0 |
| 2025-11-05 16:00:00 | ES | Futures | 6875.42 | 6881.97 | 6871.14 | 6878.7 | 74009.0 |
| 2025-11-05 18:00:00 | ES | Futures | 6879.71 | 6886.25 | 6871.9 | 6886.0 | 9532.0 |
| 2025-11-05 19:00:00 | ES | Futures | 6886.0 | 6886.25 | 6861.57 | 6872.15 | 12850.0 |
| 2025-11-05 20:00:00 | ES | Futures | 6871.9 | 6871.9 | 6856.53 | 6866.1 | 13934.0 |
| 2025-11-05 21:00:00 | ES | Futures | 6866.36 | 6874.16 | 6859.05 | 6873.41 | 8997.0 |
| 2025-11-05 22:00:00 | ES | Futures | 6873.16 | 6877.19 | 6870.39 | 6874.42 | 6663.0 |
| 2025-11-05 23:00:00 | ES | Futures | 6874.16 | 6878.7 | 6871.14 | 6877.69 | 4244.0 |
| 2025-11-05 00:00:00 | NQ | Futures | 25688.34 | 25758.7 | 25685.07 | 25704.48 | 8254.0 |
| 2025-11-05 01:00:00 | NQ | Futures | 25703.73 | 25777.37 | 25678.51 | 25752.15 | 8457.0 |
| 2025-11-05 02:00:00 | NQ | Futures | 25752.65 | 25758.96 | 25692.88 | 25696.41 | 7047.0 |
| 2025-11-05 03:00:00 | NQ | Futures | 25697.93 | 25761.23 | 25675.99 | 25735.75 | 9663.0 |
| 2025-11-05 04:00:00 | NQ | Futures | 25736.76 | 25775.6 | 25703.48 | 25742.31 | 7399.0 |
| 2025-11-05 05:00:00 | NQ | Futures | 25740.8 | 25759.96 | 25634.12 | 25636.14 | 6611.0 |
| 2025-11-05 06:00:00 | NQ | Futures | 25635.13 | 25707.26 | 25626.05 | 25704.48 | 8323.0 |
| 2025-11-05 07:00:00 | NQ | Futures | 25702.72 | 25759.21 | 25680.78 | 25752.15 | 8733.0 |
| 2025-11-05 08:00:00 | NQ | Futures | 25751.14 | 25819.73 | 25731.22 | 25810.65 | 19386.0 |
| 2025-11-05 09:00:00 | NQ | Futures | 25810.4 | 25920.61 | 25710.79 | 25920.61 | 85007.0 |
| 2025-11-05 10:00:00 | NQ | Futures | 25904.97 | 25960.96 | 25838.9 | 25944.56 | 91983.0 |
| 2025-11-05 11:00:00 | NQ | Futures | 25944.82 | 26013.92 | 25882.53 | 25999.54 | 66224.0 |
| 2025-11-05 12:00:00 | NQ | Futures | 25999.29 | 26054.01 | 25965.24 | 26037.87 | 43604.0 |
| 2025-11-05 13:00:00 | NQ | Futures | 26037.37 | 26098.9 | 26030.05 | 26090.58 | 32042.0 |
| 2025-11-05 14:00:00 | NQ | Futures | 26090.33 | 26106.21 | 26048.97 | 26089.32 | 35542.0 |
| 2025-11-05 15:00:00 | NQ | Futures | 26089.32 | 26103.95 | 25954.4 | 25966.0 | 63052.0 |
| 2025-11-05 16:00:00 | NQ | Futures | 25966.5 | 25989.2 | 25919.09 | 25953.89 | 24377.0 |
| 2025-11-05 18:00:00 | NQ | Futures | 25963.48 | 25999.29 | 25926.91 | 25998.03 | 6581.0 |
| 2025-11-05 19:00:00 | NQ | Futures | 25998.28 | 26000.3 | 25877.23 | 25923.88 | 9917.0 |
| 2025-11-05 20:00:00 | NQ | Futures | 25921.36 | 25922.37 | 25841.17 | 25897.91 | 9368.0 |
| 2025-11-05 21:00:00 | NQ | Futures | 25897.41 | 25943.3 | 25863.36 | 25940.28 | 5977.0 |
| 2025-11-05 22:00:00 | NQ | Futures | 25939.27 | 25960.7 | 25924.89 | 25945.83 | 5084.0 |
| 2025-11-05 23:00:00 | NQ | Futures | 25944.31 | 25967.01 | 25929.18 | 25964.49 | 2811.0 |
| 2025-11-05 00:00:00 | YM | Futures | 47908.7 | 47953.3 | 47884.3 | 47916.8 | 959.0 |
| 2025-11-05 01:00:00 | YM | Futures | 47916.8 | 47962.4 | 47888.4 | 47953.3 | 989.0 |
| 2025-11-05 02:00:00 | YM | Futures | 47952.3 | 47955.3 | 47901.6 | 47904.6 | 1135.0 |
| 2025-11-05 03:00:00 | YM | Futures | 47903.6 | 47977.6 | 47877.2 | 47950.3 | 1837.0 |
> showing 50 of 2,130 rows — these rows as CSV