PREVIEW / futures_1hour / 2025-11-19
file: by_date/futures_1hour/2025/2025-11-19.parquet size: 68 KB rows: 2,123
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-19 00:00:00 | ES | Futures | 6676.95 | 6683.75 | 6662.84 | 6680.22 | 12301.0 |
| 2025-11-19 01:00:00 | ES | Futures | 6679.97 | 6686.27 | 6676.44 | 6684.0 | 7955.0 |
| 2025-11-19 02:00:00 | ES | Futures | 6683.75 | 6697.6 | 6679.97 | 6694.58 | 12540.0 |
| 2025-11-19 03:00:00 | ES | Futures | 6694.33 | 6702.39 | 6685.76 | 6689.04 | 19398.0 |
| 2025-11-19 04:00:00 | ES | Futures | 6688.78 | 6708.93 | 6684.5 | 6707.93 | 15769.0 |
| 2025-11-19 05:00:00 | ES | Futures | 6708.18 | 6714.73 | 6705.16 | 6713.47 | 12985.0 |
| 2025-11-19 06:00:00 | ES | Futures | 6713.47 | 6718.76 | 6710.19 | 6710.95 | 15080.0 |
| 2025-11-19 07:00:00 | ES | Futures | 6710.95 | 6717.25 | 6706.67 | 6711.7 | 17131.0 |
| 2025-11-19 08:00:00 | ES | Futures | 6711.96 | 6714.73 | 6700.12 | 6702.64 | 32974.0 |
| 2025-11-19 09:00:00 | ES | Futures | 6702.64 | 6743.94 | 6685.51 | 6741.93 | 232287.0 |
| 2025-11-19 10:00:00 | ES | Futures | 6742.18 | 6759.31 | 6710.95 | 6714.73 | 317602.0 |
| 2025-11-19 11:00:00 | ES | Futures | 6714.48 | 6720.27 | 6692.31 | 6709.94 | 263613.0 |
| 2025-11-19 12:00:00 | ES | Futures | 6709.94 | 6714.73 | 6671.66 | 6698.36 | 226034.0 |
| 2025-11-19 13:00:00 | ES | Futures | 6698.36 | 6718.25 | 6692.56 | 6710.7 | 183777.0 |
| 2025-11-19 14:00:00 | ES | Futures | 6710.95 | 6713.47 | 6677.95 | 6697.6 | 165519.0 |
| 2025-11-19 15:00:00 | ES | Futures | 6697.6 | 6733.62 | 6695.08 | 6711.7 | 266005.0 |
| 2025-11-19 16:00:00 | ES | Futures | 6711.45 | 6754.52 | 6702.13 | 6746.21 | 97610.0 |
| 2025-11-19 18:00:00 | ES | Futures | 6747.72 | 6783.24 | 6744.2 | 6782.48 | 25279.0 |
| 2025-11-19 19:00:00 | ES | Futures | 6782.23 | 6793.82 | 6778.45 | 6786.51 | 14747.0 |
| 2025-11-19 20:00:00 | ES | Futures | 6786.26 | 6793.56 | 6782.73 | 6792.56 | 10366.0 |
| 2025-11-19 21:00:00 | ES | Futures | 6792.3 | 6797.09 | 6788.02 | 6795.58 | 10254.0 |
| 2025-11-19 22:00:00 | ES | Futures | 6795.33 | 6800.36 | 6789.03 | 6795.08 | 10261.0 |
| 2025-11-19 23:00:00 | ES | Futures | 6794.82 | 6800.36 | 6792.81 | 6800.11 | 5787.0 |
| 2025-11-19 00:00:00 | NQ | Futures | 24737.61 | 24773.42 | 24658.67 | 24749.21 | 7501.0 |
| 2025-11-19 01:00:00 | NQ | Futures | 24749.21 | 24787.54 | 24735.34 | 24767.87 | 3996.0 |
| 2025-11-19 02:00:00 | NQ | Futures | 24765.6 | 24841.51 | 24746.18 | 24822.84 | 6627.0 |
| 2025-11-19 03:00:00 | NQ | Futures | 24822.34 | 24867.48 | 24785.77 | 24805.7 | 7956.0 |
| 2025-11-19 04:00:00 | NQ | Futures | 24805.19 | 24898.25 | 24784.76 | 24892.2 | 7669.0 |
| 2025-11-19 05:00:00 | NQ | Futures | 24892.2 | 24926.24 | 24878.58 | 24916.15 | 6437.0 |
| 2025-11-19 06:00:00 | NQ | Futures | 24915.4 | 24949.44 | 24903.8 | 24908.84 | 8093.0 |
| 2025-11-19 07:00:00 | NQ | Futures | 24907.58 | 24938.35 | 24888.66 | 24911.11 | 7563.0 |
| 2025-11-19 08:00:00 | NQ | Futures | 24911.36 | 24924.98 | 24856.13 | 24880.34 | 14608.0 |
| 2025-11-19 09:00:00 | NQ | Futures | 24880.34 | 25121.43 | 24787.29 | 25111.34 | 96624.0 |
| 2025-11-19 10:00:00 | NQ | Futures | 25111.6 | 25206.42 | 24964.32 | 24986.01 | 123062.0 |
| 2025-11-19 11:00:00 | NQ | Futures | 24985.25 | 25003.16 | 24864.2 | 24930.53 | 102627.0 |
| 2025-11-19 12:00:00 | NQ | Futures | 24930.53 | 24937.34 | 24721.21 | 24850.58 | 81424.0 |
| 2025-11-19 13:00:00 | NQ | Futures | 24848.82 | 24929.27 | 24802.17 | 24902.53 | 56309.0 |
| 2025-11-19 14:00:00 | NQ | Futures | 24904.05 | 24917.16 | 24785.77 | 24874.04 | 52717.0 |
| 2025-11-19 15:00:00 | NQ | Futures | 24872.27 | 25047.29 | 24859.92 | 24941.12 | 76968.0 |
| 2025-11-19 16:00:00 | NQ | Futures | 24940.87 | 25194.57 | 24891.44 | 25176.91 | 50788.0 |
| 2025-11-19 18:00:00 | NQ | Futures | 25184.98 | 25330.24 | 25173.38 | 25328.22 | 15213.0 |
| 2025-11-19 19:00:00 | NQ | Futures | 25327.21 | 25381.94 | 25306.54 | 25348.15 | 9798.0 |
| 2025-11-19 20:00:00 | NQ | Futures | 25346.13 | 25386.73 | 25322.17 | 25375.89 | 6669.0 |
| 2025-11-19 21:00:00 | NQ | Futures | 25376.39 | 25390.77 | 25348.65 | 25387.99 | 5625.0 |
| 2025-11-19 22:00:00 | NQ | Futures | 25387.74 | 25416.24 | 25358.74 | 25388.5 | 6635.0 |
| 2025-11-19 23:00:00 | NQ | Futures | 25388.5 | 25408.42 | 25371.09 | 25407.16 | 3479.0 |
| 2025-11-19 00:00:00 | YM | Futures | 46767.8 | 46805.3 | 46708.0 | 46782.0 | 904.0 |
| 2025-11-19 01:00:00 | YM | Futures | 46794.2 | 46819.5 | 46770.9 | 46811.4 | 539.0 |
| 2025-11-19 02:00:00 | YM | Futures | 46806.3 | 46871.2 | 46790.1 | 46848.9 | 1443.0 |
| 2025-11-19 03:00:00 | YM | Futures | 46847.9 | 46885.4 | 46792.1 | 46809.4 | 1856.0 |
> showing 50 of 2,123 rows — these rows as CSV