PREVIEW / futures_1hour / 2025-07-18
file: by_date/futures_1hour/2025/2025-07-18.parquet size: 54 KB rows: 1,632
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-07-18 00:00:00 | ES | Futures | 6397.62 | 6399.13 | 6396.61 | 6398.37 | 2509.0 |
| 2025-07-18 01:00:00 | ES | Futures | 6398.62 | 6403.91 | 6398.62 | 6403.41 | 5041.0 |
| 2025-07-18 02:00:00 | ES | Futures | 6403.41 | 6404.67 | 6400.64 | 6401.9 | 5865.0 |
| 2025-07-18 03:00:00 | ES | Futures | 6401.9 | 6402.65 | 6392.58 | 6393.84 | 11667.0 |
| 2025-07-18 04:00:00 | ES | Futures | 6393.59 | 6398.12 | 6393.59 | 6396.36 | 7116.0 |
| 2025-07-18 05:00:00 | ES | Futures | 6396.11 | 6397.87 | 6395.1 | 6395.85 | 4931.0 |
| 2025-07-18 06:00:00 | ES | Futures | 6395.85 | 6396.36 | 6388.3 | 6390.31 | 8202.0 |
| 2025-07-18 07:00:00 | ES | Futures | 6390.56 | 6392.58 | 6387.04 | 6390.82 | 10754.0 |
| 2025-07-18 08:00:00 | ES | Futures | 6390.82 | 6396.36 | 6390.31 | 6395.6 | 20255.0 |
| 2025-07-18 09:00:00 | ES | Futures | 6395.35 | 6401.14 | 6390.06 | 6392.58 | 136490.0 |
| 2025-07-18 10:00:00 | ES | Futures | 6392.33 | 6401.14 | 6376.96 | 6377.22 | 168508.0 |
| 2025-07-18 11:00:00 | ES | Futures | 6377.22 | 6387.79 | 6374.7 | 6387.54 | 101503.0 |
| 2025-07-18 12:00:00 | ES | Futures | 6387.54 | 6388.05 | 6370.92 | 6372.68 | 132616.0 |
| 2025-07-18 13:00:00 | ES | Futures | 6372.68 | 6381.75 | 6370.67 | 6377.22 | 89462.0 |
| 2025-07-18 14:00:00 | ES | Futures | 6377.22 | 6380.49 | 6371.93 | 6378.73 | 65123.0 |
| 2025-07-18 15:00:00 | ES | Futures | 6378.47 | 6384.52 | 6376.46 | 6382.25 | 144280.0 |
| 2025-07-18 16:00:00 | ES | Futures | 6382.25 | 6383.51 | 6380.74 | 6382.76 | 38181.0 |
| 2025-07-18 00:00:00 | NQ | Futures | 23478.47 | 23484.78 | 23474.19 | 23481.5 | 1301.0 |
| 2025-07-18 01:00:00 | NQ | Futures | 23481.75 | 23512.27 | 23480.49 | 23506.97 | 3412.0 |
| 2025-07-18 02:00:00 | NQ | Futures | 23505.96 | 23512.52 | 23485.53 | 23486.8 | 3297.0 |
| 2025-07-18 03:00:00 | NQ | Futures | 23486.29 | 23495.62 | 23463.34 | 23472.42 | 5215.0 |
| 2025-07-18 04:00:00 | NQ | Futures | 23471.92 | 23489.57 | 23468.64 | 23484.27 | 3214.0 |
| 2025-07-18 05:00:00 | NQ | Futures | 23484.02 | 23493.35 | 23477.72 | 23481.5 | 2430.0 |
| 2025-07-18 06:00:00 | NQ | Futures | 23480.49 | 23484.27 | 23454.77 | 23468.89 | 4614.0 |
| 2025-07-18 07:00:00 | NQ | Futures | 23469.65 | 23475.45 | 23453.76 | 23466.87 | 4698.0 |
| 2025-07-18 08:00:00 | NQ | Futures | 23467.13 | 23474.94 | 23456.53 | 23471.16 | 7203.0 |
| 2025-07-18 09:00:00 | NQ | Futures | 23471.66 | 23523.87 | 23455.02 | 23460.06 | 74134.0 |
| 2025-07-18 10:00:00 | NQ | Futures | 23460.06 | 23497.89 | 23388.7 | 23407.11 | 78808.0 |
| 2025-07-18 11:00:00 | NQ | Futures | 23407.11 | 23456.79 | 23388.7 | 23449.98 | 48087.0 |
| 2025-07-18 12:00:00 | NQ | Futures | 23450.23 | 23451.74 | 23371.3 | 23389.45 | 58674.0 |
| 2025-07-18 13:00:00 | NQ | Futures | 23389.2 | 23425.01 | 23373.82 | 23400.55 | 41200.0 |
| 2025-07-18 14:00:00 | NQ | Futures | 23401.31 | 23429.3 | 23395.51 | 23406.1 | 28794.0 |
| 2025-07-18 15:00:00 | NQ | Futures | 23405.59 | 23434.85 | 23400.55 | 23428.79 | 44500.0 |
| 2025-07-18 16:00:00 | NQ | Futures | 23428.54 | 23432.07 | 23419.21 | 23430.81 | 11284.0 |
| 2025-07-18 00:00:00 | YM | Futures | 45763.4 | 45776.6 | 45758.2 | 45772.6 | 198.0 |
| 2025-07-18 01:00:00 | YM | Futures | 45771.5 | 45807.3 | 45771.5 | 45800.1 | 401.0 |
| 2025-07-18 02:00:00 | YM | Futures | 45797.1 | 45819.5 | 45778.7 | 45819.5 | 946.0 |
| 2025-07-18 03:00:00 | YM | Futures | 45819.5 | 45825.7 | 45733.7 | 45737.8 | 1070.0 |
| 2025-07-18 04:00:00 | YM | Futures | 45736.8 | 45764.4 | 45731.7 | 45742.9 | 755.0 |
| 2025-07-18 05:00:00 | YM | Futures | 45743.9 | 45762.3 | 45737.8 | 45745.0 | 842.0 |
| 2025-07-18 06:00:00 | YM | Futures | 45740.9 | 45762.3 | 45679.6 | 45698.0 | 2041.0 |
| 2025-07-18 07:00:00 | YM | Futures | 45699.0 | 45732.7 | 45671.4 | 45713.3 | 3076.0 |
| 2025-07-18 08:00:00 | YM | Futures | 45713.3 | 45770.5 | 45710.2 | 45761.3 | 1446.0 |
| 2025-07-18 09:00:00 | YM | Futures | 45758.2 | 45786.9 | 45533.5 | 45572.3 | 14886.0 |
| 2025-07-18 10:00:00 | YM | Futures | 45572.3 | 45638.7 | 45434.4 | 45441.6 | 14415.0 |
| 2025-07-18 11:00:00 | YM | Futures | 45439.5 | 45525.3 | 45439.5 | 45506.9 | 8814.0 |
| 2025-07-18 12:00:00 | YM | Futures | 45508.0 | 45515.1 | 45381.3 | 45395.6 | 8010.0 |
| 2025-07-18 13:00:00 | YM | Futures | 45393.5 | 45466.1 | 45391.5 | 45438.5 | 4820.0 |
| 2025-07-18 14:00:00 | YM | Futures | 45439.5 | 45466.1 | 45395.6 | 45463.0 | 3345.0 |
| 2025-07-18 15:00:00 | YM | Futures | 45464.0 | 45521.2 | 45435.4 | 45498.8 | 8248.0 |
> showing 50 of 1,632 rows — these rows as CSV