PREVIEW / futures_1hour / 2025-05-20
file: by_date/futures_1hour/2025/2025-05-20.parquet size: 67 KB rows: 2,088
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-05-20 00:00:00 | ES | Futures | 6061.4 | 6064.7 | 6059.36 | 6063.43 | 3519.0 |
| 2025-05-20 01:00:00 | ES | Futures | 6063.68 | 6070.8 | 6055.55 | 6056.06 | 6883.0 |
| 2025-05-20 02:00:00 | ES | Futures | 6055.81 | 6058.86 | 6051.49 | 6057.58 | 7906.0 |
| 2025-05-20 03:00:00 | ES | Futures | 6057.33 | 6068.51 | 6053.27 | 6060.89 | 11117.0 |
| 2025-05-20 04:00:00 | ES | Futures | 6061.14 | 6065.21 | 6055.3 | 6058.35 | 8321.0 |
| 2025-05-20 05:00:00 | ES | Futures | 6058.6 | 6063.43 | 6055.3 | 6056.82 | 6788.0 |
| 2025-05-20 06:00:00 | ES | Futures | 6057.08 | 6067.49 | 6054.79 | 6066.98 | 8607.0 |
| 2025-05-20 07:00:00 | ES | Futures | 6066.98 | 6071.05 | 6065.97 | 6066.73 | 12188.0 |
| 2025-05-20 08:00:00 | ES | Futures | 6066.48 | 6070.03 | 6058.86 | 6062.67 | 14999.0 |
| 2025-05-20 09:00:00 | ES | Futures | 6062.67 | 6067.75 | 6046.92 | 6055.04 | 127599.0 |
| 2025-05-20 10:00:00 | ES | Futures | 6055.3 | 6067.49 | 6049.96 | 6056.31 | 137121.0 |
| 2025-05-20 11:00:00 | ES | Futures | 6056.31 | 6063.17 | 6051.23 | 6059.11 | 102280.0 |
| 2025-05-20 12:00:00 | ES | Futures | 6058.86 | 6062.92 | 6048.95 | 6060.89 | 83760.0 |
| 2025-05-20 13:00:00 | ES | Futures | 6061.14 | 6065.46 | 6051.49 | 6057.33 | 84629.0 |
| 2025-05-20 14:00:00 | ES | Futures | 6057.08 | 6059.11 | 6032.18 | 6035.74 | 138543.0 |
| 2025-05-20 15:00:00 | ES | Futures | 6035.48 | 6057.33 | 6022.53 | 6055.55 | 216323.0 |
| 2025-05-20 16:00:00 | ES | Futures | 6055.81 | 6056.57 | 6047.68 | 6050.22 | 43981.0 |
| 2025-05-20 18:00:00 | ES | Futures | 6049.71 | 6049.96 | 6031.93 | 6044.12 | 12677.0 |
| 2025-05-20 19:00:00 | ES | Futures | 6044.12 | 6051.23 | 6043.36 | 6051.23 | 3957.0 |
| 2025-05-20 20:00:00 | ES | Futures | 6051.23 | 6054.54 | 6044.37 | 6049.2 | 6174.0 |
| 2025-05-20 21:00:00 | ES | Futures | 6049.2 | 6051.74 | 6040.31 | 6044.12 | 6048.0 |
| 2025-05-20 22:00:00 | ES | Futures | 6044.12 | 6044.88 | 6037.52 | 6038.79 | 4839.0 |
| 2025-05-20 23:00:00 | ES | Futures | 6038.53 | 6041.83 | 6035.48 | 6038.28 | 3876.0 |
| 2025-05-20 00:00:00 | NQ | Futures | 21833.68 | 21851.25 | 21818.65 | 21846.66 | 3054.0 |
| 2025-05-20 01:00:00 | NQ | Futures | 21845.39 | 21886.9 | 21814.32 | 21817.63 | 5953.0 |
| 2025-05-20 02:00:00 | NQ | Futures | 21817.63 | 21830.62 | 21791.91 | 21821.45 | 6461.0 |
| 2025-05-20 03:00:00 | NQ | Futures | 21820.94 | 21880.79 | 21806.43 | 21845.64 | 8581.0 |
| 2025-05-20 04:00:00 | NQ | Futures | 21843.86 | 21860.67 | 21808.46 | 21833.42 | 6787.0 |
| 2025-05-20 05:00:00 | NQ | Futures | 21833.17 | 21851.76 | 21813.81 | 21824.76 | 4695.0 |
| 2025-05-20 06:00:00 | NQ | Futures | 21826.54 | 21864.23 | 21818.4 | 21862.2 | 5567.0 |
| 2025-05-20 07:00:00 | NQ | Futures | 21862.45 | 21883.59 | 21855.83 | 21863.21 | 6937.0 |
| 2025-05-20 08:00:00 | NQ | Futures | 21862.45 | 21873.91 | 21817.12 | 21834.18 | 9143.0 |
| 2025-05-20 09:00:00 | NQ | Futures | 21834.44 | 21857.61 | 21752.19 | 21792.93 | 61293.0 |
| 2025-05-20 10:00:00 | NQ | Futures | 21793.19 | 21850.23 | 21760.59 | 21806.17 | 56510.0 |
| 2025-05-20 11:00:00 | NQ | Futures | 21805.66 | 21844.88 | 21785.55 | 21834.44 | 37541.0 |
| 2025-05-20 12:00:00 | NQ | Futures | 21834.44 | 21871.62 | 21801.08 | 21858.12 | 31464.0 |
| 2025-05-20 13:00:00 | NQ | Futures | 21858.63 | 21873.91 | 21806.43 | 21830.36 | 30633.0 |
| 2025-05-20 14:00:00 | NQ | Futures | 21829.35 | 21840.55 | 21737.93 | 21746.07 | 45928.0 |
| 2025-05-20 15:00:00 | NQ | Futures | 21746.07 | 21851.25 | 21694.38 | 21846.66 | 64712.0 |
| 2025-05-20 16:00:00 | NQ | Futures | 21846.66 | 21851.25 | 21796.75 | 21818.65 | 14314.0 |
| 2025-05-20 18:00:00 | NQ | Futures | 21813.3 | 21815.85 | 21739.2 | 21798.53 | 7594.0 |
| 2025-05-20 19:00:00 | NQ | Futures | 21798.53 | 21830.36 | 21795.48 | 21830.36 | 3355.0 |
| 2025-05-20 20:00:00 | NQ | Futures | 21830.62 | 21843.1 | 21801.33 | 21821.96 | 4670.0 |
| 2025-05-20 21:00:00 | NQ | Futures | 21821.96 | 21833.93 | 21786.82 | 21799.55 | 4870.0 |
| 2025-05-20 22:00:00 | NQ | Futures | 21800.32 | 21804.14 | 21771.03 | 21776.63 | 4393.0 |
| 2025-05-20 23:00:00 | NQ | Futures | 21776.38 | 21795.99 | 21766.96 | 21775.1 | 2954.0 |
| 2025-05-20 00:00:00 | YM | Futures | 44081.3 | 44097.8 | 44074.1 | 44090.6 | 394.0 |
| 2025-05-20 01:00:00 | YM | Futures | 44091.6 | 44123.5 | 44040.1 | 44042.2 | 755.0 |
| 2025-05-20 02:00:00 | YM | Futures | 44042.2 | 44057.6 | 44020.6 | 44055.6 | 1106.0 |
| 2025-05-20 03:00:00 | YM | Futures | 44056.6 | 44105.0 | 44022.6 | 44075.1 | 1375.0 |
> showing 50 of 2,088 rows — these rows as CSV