PREVIEW / etf_1hour / 2025-08-29
file: by_date/etf_1hour/2025/2025-08-29.parquet size: 660 KB rows: 25,290
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-29 04:00:00 | SPY | ETF | 647.89 | 648.48 | 646.86 | 646.86 | 32130.0 |
| 2025-08-29 05:00:00 | SPY | ETF | 646.97 | 647.34 | 646.52 | 647.18 | 25668.0 |
| 2025-08-29 06:00:00 | SPY | ETF | 647.1 | 647.39 | 646.9 | 647.05 | 75767.0 |
| 2025-08-29 07:00:00 | SPY | ETF | 647.04 | 647.43 | 647.02 | 647.14 | 100814.0 |
| 2025-08-29 08:00:00 | SPY | ETF | 647.18 | 648.8 | 646.81 | 647.7 | 603063.0 |
| 2025-08-29 09:00:00 | SPY | ETF | 647.68 | 647.96 | 645.34 | 645.51 | 6954838.0 |
| 2025-08-29 10:00:00 | SPY | ETF | 645.5 | 646.063 | 643.14 | 643.82 | 10893889.0 |
| 2025-08-29 11:00:00 | SPY | ETF | 643.82 | 644.77 | 643.68 | 643.79 | 4323669.0 |
| 2025-08-29 12:00:00 | SPY | ETF | 643.78 | 645.0399 | 643.75 | 644.725 | 3474550.0 |
| 2025-08-29 13:00:00 | SPY | ETF | 644.7 | 645.0142 | 643.46 | 644.64 | 4293497.0 |
| 2025-08-29 14:00:00 | SPY | ETF | 644.65 | 644.74 | 644.17 | 644.49 | 3380129.0 |
| 2025-08-29 15:00:00 | SPY | ETF | 644.49 | 645.14 | 643.76 | 645.04 | 15118077.0 |
| 2025-08-29 16:00:00 | SPY | ETF | 645.03 | 645.4 | 644.5 | 644.94 | 4662096.0 |
| 2025-08-29 17:00:00 | SPY | ETF | 644.91 | 645.4999 | 644.91 | 645.23 | 254081.0 |
| 2025-08-29 18:00:00 | SPY | ETF | 645.25 | 645.28 | 644.84 | 645.02 | 34289.0 |
| 2025-08-29 19:00:00 | SPY | ETF | 645.01 | 645.07 | 644.91 | 644.95 | 26811.0 |
| 2025-08-29 04:00:00 | QQQ | ETF | 575.44 | 575.96 | 574.09 | 574.14 | 71165.0 |
| 2025-08-29 05:00:00 | QQQ | ETF | 574.18 | 574.82 | 573.74 | 574.58 | 74470.0 |
| 2025-08-29 06:00:00 | QQQ | ETF | 574.46 | 574.89 | 574.0 | 574.23 | 69124.0 |
| 2025-08-29 07:00:00 | QQQ | ETF | 574.27 | 574.75 | 574.18 | 574.34 | 44718.0 |
| 2025-08-29 08:00:00 | QQQ | ETF | 574.61 | 576.66 | 573.94 | 574.94 | 368106.0 |
| 2025-08-29 09:00:00 | QQQ | ETF | 574.93 | 575.07 | 571.15 | 571.44 | 6379574.0 |
| 2025-08-29 10:00:00 | QQQ | ETF | 571.46 | 572.23 | 568.96 | 569.42 | 8933629.0 |
| 2025-08-29 11:00:00 | QQQ | ETF | 569.41 | 570.93 | 569.17 | 569.32 | 3933181.0 |
| 2025-08-29 12:00:00 | QQQ | ETF | 569.33 | 570.74 | 569.26 | 570.43 | 2798916.0 |
| 2025-08-29 13:00:00 | QQQ | ETF | 570.4 | 570.4 | 568.54 | 569.97 | 3366922.0 |
| 2025-08-29 14:00:00 | QQQ | ETF | 569.97 | 570.16 | 569.44 | 569.985 | 2309762.0 |
| 2025-08-29 15:00:00 | QQQ | ETF | 569.98 | 570.845 | 569.18 | 570.31 | 7703190.0 |
| 2025-08-29 16:00:00 | QQQ | ETF | 570.32 | 570.64 | 569.81 | 569.95 | 1961993.0 |
| 2025-08-29 17:00:00 | QQQ | ETF | 569.91 | 570.27 | 569.4 | 569.7 | 72537.0 |
| 2025-08-29 18:00:00 | QQQ | ETF | 569.7 | 569.99 | 569.35 | 569.7 | 76650.0 |
| 2025-08-29 19:00:00 | QQQ | ETF | 569.81 | 569.81 | 569.54 | 569.68 | 31775.0 |
| 2025-08-29 04:00:00 | IWM | ETF | 236.08 | 236.08 | 235.49 | 235.49 | 19724.0 |
| 2025-08-29 05:00:00 | IWM | ETF | 235.5 | 235.74 | 235.48 | 235.67 | 27511.0 |
| 2025-08-29 06:00:00 | IWM | ETF | 235.63 | 235.8 | 235.57 | 235.74 | 21657.0 |
| 2025-08-29 07:00:00 | IWM | ETF | 235.75 | 235.89 | 235.66 | 235.74 | 16508.0 |
| 2025-08-29 08:00:00 | IWM | ETF | 235.77 | 236.59 | 235.56 | 236.17 | 382682.0 |
| 2025-08-29 09:00:00 | IWM | ETF | 236.17 | 237.18 | 235.73 | 236.0819 | 2764120.0 |
| 2025-08-29 10:00:00 | IWM | ETF | 236.11 | 236.43 | 234.37 | 234.81 | 4225803.0 |
| 2025-08-29 11:00:00 | IWM | ETF | 234.81 | 235.11 | 234.64 | 235.0 | 2825049.0 |
| 2025-08-29 12:00:00 | IWM | ETF | 234.99 | 235.38 | 234.975 | 235.21 | 1910018.0 |
| 2025-08-29 13:00:00 | IWM | ETF | 235.205 | 235.23 | 234.665 | 235.06 | 1595810.0 |
| 2025-08-29 14:00:00 | IWM | ETF | 235.07 | 235.075 | 234.45 | 234.59 | 1508406.0 |
| 2025-08-29 15:00:00 | IWM | ETF | 234.58 | 235.28 | 234.37 | 235.19 | 6649474.0 |
| 2025-08-29 16:00:00 | IWM | ETF | 235.17 | 235.32 | 235.06 | 235.26 | 1329913.0 |
| 2025-08-29 17:00:00 | IWM | ETF | 235.27 | 235.61 | 235.2 | 235.56 | 32525.0 |
| 2025-08-29 18:00:00 | IWM | ETF | 235.56 | 235.723 | 235.4 | 235.47 | 26567.0 |
| 2025-08-29 19:00:00 | IWM | ETF | 235.43 | 235.64 | 235.36 | 235.5001 | 14430.0 |
| 2025-08-29 04:00:00 | DIA | ETF | 455.89 | 455.89 | 455.39 | 455.43 | 11100.0 |
| 2025-08-29 05:00:00 | DIA | ETF | 455.47 | 455.64 | 455.22 | 455.55 | 3425.0 |
> showing 50 of 25,290 rows — these rows as CSV