PREVIEW / etf_1hour / 2024-08-27
file: by_date/etf_1hour/2024/2024-08-27.parquet size: 552 KB rows: 20,323
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 |
|---|---|---|---|---|---|---|---|
| 2024-08-27 04:00:00 | SPY | ETF | 561.03 | 561.62 | 561.0 | 561.3 | 13798.0 |
| 2024-08-27 05:00:00 | SPY | ETF | 561.28 | 561.65 | 561.28 | 561.32 | 5017.0 |
| 2024-08-27 06:00:00 | SPY | ETF | 561.31 | 561.31 | 559.88 | 560.1 | 17161.0 |
| 2024-08-27 07:00:00 | SPY | ETF | 560.11 | 561.11 | 559.84 | 560.7 | 24451.0 |
| 2024-08-27 08:00:00 | SPY | ETF | 560.11 | 561.05 | 558.88 | 559.26 | 133361.0 |
| 2024-08-27 09:00:00 | SPY | ETF | 559.27 | 560.22 | 558.32 | 559.825 | 3154543.0 |
| 2024-08-27 10:00:00 | SPY | ETF | 559.84 | 561.71 | 559.58 | 561.63 | 3638671.0 |
| 2024-08-27 11:00:00 | SPY | ETF | 561.63 | 562.05 | 559.811 | 560.68 | 2823734.0 |
| 2024-08-27 12:00:00 | SPY | ETF | 560.68 | 561.19 | 559.85 | 560.8 | 1743561.0 |
| 2024-08-27 13:00:00 | SPY | ETF | 560.8 | 562.03 | 560.755 | 561.94 | 1627859.0 |
| 2024-08-27 14:00:00 | SPY | ETF | 561.915 | 562.06 | 561.36 | 561.59 | 1665893.0 |
| 2024-08-27 15:00:00 | SPY | ETF | 561.61 | 561.85 | 561.13 | 561.5318 | 5718896.0 |
| 2024-08-27 16:00:00 | SPY | ETF | 561.53 | 561.82 | 561.33 | 561.39 | 1798849.0 |
| 2024-08-27 17:00:00 | SPY | ETF | 561.51 | 561.633 | 561.37 | 561.56 | 58216.0 |
| 2024-08-27 18:00:00 | SPY | ETF | 561.51 | 561.66 | 560.41 | 560.81 | 60624.0 |
| 2024-08-27 19:00:00 | SPY | ETF | 560.7886 | 561.0 | 560.36 | 560.76 | 22086.0 |
| 2024-08-27 04:00:00 | QQQ | ETF | 475.09 | 476.66 | 475.09 | 476.02 | 30450.0 |
| 2024-08-27 05:00:00 | QQQ | ETF | 476.07 | 476.69 | 476.07 | 476.39 | 19397.0 |
| 2024-08-27 06:00:00 | QQQ | ETF | 476.25 | 476.25 | 474.61 | 475.01 | 22429.0 |
| 2024-08-27 07:00:00 | QQQ | ETF | 475.05 | 475.88 | 474.44 | 475.47 | 94998.0 |
| 2024-08-27 08:00:00 | QQQ | ETF | 475.35 | 476.6296 | 473.24 | 473.51 | 241133.0 |
| 2024-08-27 09:00:00 | QQQ | ETF | 473.53 | 474.81 | 471.71 | 474.13 | 3458484.0 |
| 2024-08-27 10:00:00 | QQQ | ETF | 474.24 | 477.34 | 473.88 | 477.25 | 4419525.0 |
| 2024-08-27 11:00:00 | QQQ | ETF | 477.25 | 477.84 | 475.05 | 475.83 | 3329069.0 |
| 2024-08-27 12:00:00 | QQQ | ETF | 475.825 | 476.705 | 475.18 | 476.16 | 1941239.0 |
| 2024-08-27 13:00:00 | QQQ | ETF | 476.17 | 477.75 | 476.01 | 477.67 | 2628770.0 |
| 2024-08-27 14:00:00 | QQQ | ETF | 477.62 | 477.785 | 476.56 | 476.93 | 1630243.0 |
| 2024-08-27 15:00:00 | QQQ | ETF | 476.97 | 477.25 | 476.34 | 476.83 | 2725417.0 |
| 2024-08-27 16:00:00 | QQQ | ETF | 476.84 | 477.03 | 476.25 | 476.35 | 1133428.0 |
| 2024-08-27 17:00:00 | QQQ | ETF | 476.44 | 476.49 | 476.32 | 476.39 | 15585.0 |
| 2024-08-27 18:00:00 | QQQ | ETF | 476.49 | 476.64 | 475.05 | 475.4 | 93810.0 |
| 2024-08-27 19:00:00 | QQQ | ETF | 475.4 | 475.72 | 474.68 | 475.25 | 117149.0 |
| 2024-08-27 04:00:00 | IWM | ETF | 220.49 | 220.98 | 220.18 | 220.84 | 19185.0 |
| 2024-08-27 05:00:00 | IWM | ETF | 220.82 | 221.04 | 220.59 | 220.61 | 5247.0 |
| 2024-08-27 06:00:00 | IWM | ETF | 220.45 | 220.68 | 220.19 | 220.21 | 12110.0 |
| 2024-08-27 07:00:00 | IWM | ETF | 220.21 | 220.6 | 220.04 | 220.16 | 34108.0 |
| 2024-08-27 08:00:00 | IWM | ETF | 220.23 | 220.81 | 218.666 | 218.7 | 178025.0 |
| 2024-08-27 09:00:00 | IWM | ETF | 218.7 | 219.03 | 217.88 | 217.95 | 2325240.0 |
| 2024-08-27 10:00:00 | IWM | ETF | 217.97 | 219.37 | 217.87 | 219.1601 | 2779040.0 |
| 2024-08-27 11:00:00 | IWM | ETF | 219.2 | 219.26 | 218.03 | 218.385 | 1742499.0 |
| 2024-08-27 12:00:00 | IWM | ETF | 218.36 | 218.37 | 217.71 | 218.16 | 1188970.0 |
| 2024-08-27 13:00:00 | IWM | ETF | 218.16 | 219.02 | 218.1301 | 218.73 | 870192.0 |
| 2024-08-27 14:00:00 | IWM | ETF | 218.72 | 219.3 | 218.675 | 219.01 | 1014520.0 |
| 2024-08-27 15:00:00 | IWM | ETF | 219.02 | 219.25 | 218.61 | 218.76 | 2662752.0 |
| 2024-08-27 16:00:00 | IWM | ETF | 218.74 | 219.0 | 218.72 | 218.82 | 1632257.0 |
| 2024-08-27 17:00:00 | IWM | ETF | 218.85 | 218.86 | 218.57 | 218.77 | 36649.0 |
| 2024-08-27 18:00:00 | IWM | ETF | 218.71 | 218.9 | 218.26 | 218.57 | 47856.0 |
| 2024-08-27 19:00:00 | IWM | ETF | 218.58 | 218.69 | 218.4 | 218.62 | 21563.0 |
| 2024-08-27 05:00:00 | DIA | ETF | 413.04 | 413.04 | 412.76 | 412.76 | 497.0 |
| 2024-08-27 06:00:00 | DIA | ETF | 412.45 | 412.5 | 412.45 | 412.5 | 494.0 |
> showing 50 of 20,323 rows — these rows as CSV