PREVIEW / etf_1hour / 2025-08-18
file: by_date/etf_1hour/2025/2025-08-18.parquet size: 654 KB rows: 25,683
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-08-18 04:00:00 | SPY | ETF | 642.97 | 644.26 | 642.14 | 642.84 | 99290.0 |
| 2025-08-18 05:00:00 | SPY | ETF | 642.86 | 642.86 | 642.08 | 642.53 | 20684.0 |
| 2025-08-18 06:00:00 | SPY | ETF | 642.59 | 643.06 | 642.53 | 642.95 | 24835.0 |
| 2025-08-18 07:00:00 | SPY | ETF | 642.98 | 643.04 | 642.61 | 642.91 | 40463.0 |
| 2025-08-18 08:00:00 | SPY | ETF | 642.86 | 644.55 | 642.19 | 643.05 | 273539.0 |
| 2025-08-18 09:00:00 | SPY | ETF | 643.05 | 643.8 | 642.53 | 642.73 | 4625335.0 |
| 2025-08-18 10:00:00 | SPY | ETF | 642.73 | 643.935 | 642.3 | 643.23 | 5050495.0 |
| 2025-08-18 11:00:00 | SPY | ETF | 643.22 | 643.44 | 642.5 | 642.7301 | 2894395.0 |
| 2025-08-18 12:00:00 | SPY | ETF | 642.73 | 643.36 | 642.18 | 642.51 | 2563589.0 |
| 2025-08-18 13:00:00 | SPY | ETF | 642.51 | 643.815 | 642.48 | 642.7894 | 3009585.0 |
| 2025-08-18 14:00:00 | SPY | ETF | 642.79 | 643.56 | 642.44 | 643.43 | 3477167.0 |
| 2025-08-18 15:00:00 | SPY | ETF | 643.43 | 644.0 | 643.0601 | 643.27 | 6855864.0 |
| 2025-08-18 16:00:00 | SPY | ETF | 643.28 | 643.47 | 643.01 | 643.13 | 1592546.0 |
| 2025-08-18 17:00:00 | SPY | ETF | 643.11 | 643.2797 | 643.11 | 643.22 | 35782.0 |
| 2025-08-18 18:00:00 | SPY | ETF | 643.28 | 644.16 | 643.28 | 643.78 | 111225.0 |
| 2025-08-18 19:00:00 | SPY | ETF | 643.85 | 643.85 | 643.38 | 643.55 | 16347.0 |
| 2025-08-18 04:00:00 | QQQ | ETF | 577.25 | 577.44 | 575.9 | 576.64 | 48076.0 |
| 2025-08-18 05:00:00 | QQQ | ETF | 576.72 | 576.72 | 575.82 | 576.3 | 15481.0 |
| 2025-08-18 06:00:00 | QQQ | ETF | 576.25 | 576.96 | 576.2 | 576.87 | 24077.0 |
| 2025-08-18 07:00:00 | QQQ | ETF | 576.91 | 576.99 | 575.94 | 576.53 | 41445.0 |
| 2025-08-18 08:00:00 | QQQ | ETF | 576.86 | 578.65 | 575.92 | 576.57 | 159898.0 |
| 2025-08-18 09:00:00 | QQQ | ETF | 576.55 | 577.6 | 575.645 | 575.95 | 3655871.0 |
| 2025-08-18 10:00:00 | QQQ | ETF | 575.96 | 577.765 | 575.2412 | 576.64 | 4403966.0 |
| 2025-08-18 11:00:00 | QQQ | ETF | 576.652 | 576.8 | 575.48 | 575.92 | 2593022.0 |
| 2025-08-18 12:00:00 | QQQ | ETF | 575.91 | 576.71 | 575.34 | 575.62 | 2112432.0 |
| 2025-08-18 13:00:00 | QQQ | ETF | 575.63 | 577.17 | 575.57 | 576.24 | 2455627.0 |
| 2025-08-18 14:00:00 | QQQ | ETF | 576.25 | 577.24 | 575.98 | 577.07 | 2174438.0 |
| 2025-08-18 15:00:00 | QQQ | ETF | 577.08 | 577.57 | 576.84 | 577.1 | 2878371.0 |
| 2025-08-18 16:00:00 | QQQ | ETF | 577.12 | 577.3 | 576.82 | 576.94 | 587976.0 |
| 2025-08-18 17:00:00 | QQQ | ETF | 576.95 | 577.09 | 576.94 | 577.0 | 20608.0 |
| 2025-08-18 18:00:00 | QQQ | ETF | 577.1 | 578.0389 | 577.07 | 577.6801 | 71880.0 |
| 2025-08-18 19:00:00 | QQQ | ETF | 577.73 | 577.75 | 577.26 | 577.31 | 19407.0 |
| 2025-08-18 04:00:00 | IWM | ETF | 227.16 | 227.44 | 227.0 | 227.35 | 25594.0 |
| 2025-08-18 05:00:00 | IWM | ETF | 227.37 | 227.41 | 227.06 | 227.14 | 13661.0 |
| 2025-08-18 06:00:00 | IWM | ETF | 227.09 | 227.2 | 227.06 | 227.06 | 35865.0 |
| 2025-08-18 07:00:00 | IWM | ETF | 227.03 | 227.23 | 226.94 | 227.23 | 52660.0 |
| 2025-08-18 08:00:00 | IWM | ETF | 227.0 | 227.8 | 226.99 | 227.28 | 65908.0 |
| 2025-08-18 09:00:00 | IWM | ETF | 227.31 | 227.94 | 226.94 | 227.4 | 2622286.0 |
| 2025-08-18 10:00:00 | IWM | ETF | 227.42 | 228.18 | 227.31 | 227.94 | 2410318.0 |
| 2025-08-18 11:00:00 | IWM | ETF | 227.93 | 228.025 | 227.49 | 227.895 | 1577658.0 |
| 2025-08-18 12:00:00 | IWM | ETF | 227.89 | 228.16 | 227.64 | 227.86 | 1467307.0 |
| 2025-08-18 13:00:00 | IWM | ETF | 227.86 | 228.46 | 227.855 | 228.03 | 1514516.0 |
| 2025-08-18 14:00:00 | IWM | ETF | 228.02 | 228.24 | 227.8724 | 228.185 | 1044329.0 |
| 2025-08-18 15:00:00 | IWM | ETF | 228.185 | 228.23 | 227.82 | 227.99 | 3348887.0 |
| 2025-08-18 16:00:00 | IWM | ETF | 227.99 | 228.08 | 227.91 | 227.96 | 1054218.0 |
| 2025-08-18 17:00:00 | IWM | ETF | 227.95 | 228.11 | 227.9 | 228.09 | 13126.0 |
| 2025-08-18 18:00:00 | IWM | ETF | 228.01 | 228.37 | 227.96 | 228.17 | 15000.0 |
| 2025-08-18 19:00:00 | IWM | ETF | 228.16 | 228.23 | 228.05 | 228.1 | 2811.0 |
| 2025-08-18 04:00:00 | DIA | ETF | 448.72 | 449.42 | 448.29 | 449.31 | 8250.0 |
| 2025-08-18 05:00:00 | DIA | ETF | 449.28 | 449.28 | 448.9 | 448.97 | 875.0 |
> showing 50 of 25,683 rows — these rows as CSV