PREVIEW / etf_1hour / 2024-08-28
file: by_date/etf_1hour/2024/2024-08-28.parquet size: 545 KB rows: 20,412
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-28 04:00:00 | SPY | ETF | 561.19 | 562.23 | 561.19 | 562.23 | 16178.0 |
| 2024-08-28 05:00:00 | SPY | ETF | 562.23 | 562.25 | 561.93 | 562.05 | 3270.0 |
| 2024-08-28 06:00:00 | SPY | ETF | 562.08 | 562.08 | 561.8 | 561.85 | 4696.0 |
| 2024-08-28 07:00:00 | SPY | ETF | 561.89 | 561.89 | 561.0 | 561.16 | 33388.0 |
| 2024-08-28 08:00:00 | SPY | ETF | 561.63 | 562.1804 | 560.84 | 561.42 | 77513.0 |
| 2024-08-28 09:00:00 | SPY | ETF | 561.43 | 561.65 | 560.59 | 561.08 | 1755222.0 |
| 2024-08-28 10:00:00 | SPY | ETF | 561.06 | 561.31 | 559.45 | 559.64 | 2266982.0 |
| 2024-08-28 11:00:00 | SPY | ETF | 559.62 | 559.67 | 557.7 | 558.45 | 4128519.0 |
| 2024-08-28 12:00:00 | SPY | ETF | 558.445 | 558.67 | 556.8925 | 558.565 | 2157405.0 |
| 2024-08-28 13:00:00 | SPY | ETF | 558.555 | 558.87 | 555.21 | 555.335 | 2346732.0 |
| 2024-08-28 14:00:00 | SPY | ETF | 555.35 | 558.16 | 555.04 | 558.06 | 3331844.0 |
| 2024-08-28 15:00:00 | SPY | ETF | 558.04 | 559.36 | 557.15 | 558.33 | 8464007.0 |
| 2024-08-28 16:00:00 | SPY | ETF | 558.34 | 558.84 | 554.87 | 556.53 | 3203877.0 |
| 2024-08-28 17:00:00 | SPY | ETF | 557.0 | 558.0 | 554.91 | 555.13 | 281672.0 |
| 2024-08-28 18:00:00 | SPY | ETF | 555.0 | 555.97 | 553.38 | 554.25 | 202584.0 |
| 2024-08-28 19:00:00 | SPY | ETF | 554.2 | 554.58 | 554.09 | 554.46 | 55563.0 |
| 2024-08-28 04:00:00 | QQQ | ETF | 476.71 | 477.8 | 476.41 | 477.68 | 45755.0 |
| 2024-08-28 05:00:00 | QQQ | ETF | 477.66 | 477.82 | 477.18 | 477.35 | 22377.0 |
| 2024-08-28 06:00:00 | QQQ | ETF | 477.45 | 477.45 | 477.11 | 477.25 | 12260.0 |
| 2024-08-28 07:00:00 | QQQ | ETF | 477.27 | 477.28 | 475.95 | 476.15 | 93026.0 |
| 2024-08-28 08:00:00 | QQQ | ETF | 476.84 | 477.7096 | 475.85 | 476.73 | 131148.0 |
| 2024-08-28 09:00:00 | QQQ | ETF | 476.6 | 477.02 | 473.97 | 474.62 | 2277737.0 |
| 2024-08-28 10:00:00 | QQQ | ETF | 474.66 | 475.48 | 472.15 | 472.16 | 3863412.0 |
| 2024-08-28 11:00:00 | QQQ | ETF | 472.1499 | 472.1499 | 469.33 | 471.5199 | 4399824.0 |
| 2024-08-28 12:00:00 | QQQ | ETF | 471.45 | 472.33 | 469.91 | 472.102 | 1956886.0 |
| 2024-08-28 13:00:00 | QQQ | ETF | 472.08 | 472.46 | 468.18 | 468.31 | 3637580.0 |
| 2024-08-28 14:00:00 | QQQ | ETF | 468.335 | 471.66 | 467.89 | 471.56 | 4388271.0 |
| 2024-08-28 15:00:00 | QQQ | ETF | 471.53 | 472.77 | 470.99 | 471.28 | 5290100.0 |
| 2024-08-28 16:00:00 | QQQ | ETF | 471.31 | 472.1 | 466.43 | 468.51 | 2684476.0 |
| 2024-08-28 17:00:00 | QQQ | ETF | 468.53 | 471.35 | 466.2 | 466.38 | 462504.0 |
| 2024-08-28 18:00:00 | QQQ | ETF | 466.31 | 467.4 | 464.56 | 465.3 | 378573.0 |
| 2024-08-28 19:00:00 | QQQ | ETF | 465.43 | 466.0 | 465.31 | 465.81 | 162471.0 |
| 2024-08-28 04:00:00 | IWM | ETF | 218.74 | 218.96 | 218.42 | 218.88 | 24478.0 |
| 2024-08-28 05:00:00 | IWM | ETF | 218.92 | 218.92 | 218.58 | 218.68 | 5981.0 |
| 2024-08-28 06:00:00 | IWM | ETF | 218.91 | 218.93 | 218.54 | 218.57 | 2451.0 |
| 2024-08-28 07:00:00 | IWM | ETF | 218.58 | 219.02 | 218.13 | 218.13 | 33172.0 |
| 2024-08-28 08:00:00 | IWM | ETF | 218.7017 | 219.1 | 217.66 | 217.86 | 101942.0 |
| 2024-08-28 09:00:00 | IWM | ETF | 217.83 | 218.65 | 217.42 | 218.185 | 1592756.0 |
| 2024-08-28 10:00:00 | IWM | ETF | 218.19 | 219.115 | 217.94 | 218.65 | 2014806.0 |
| 2024-08-28 11:00:00 | IWM | ETF | 218.65 | 218.66 | 217.27 | 217.93 | 1307233.0 |
| 2024-08-28 12:00:00 | IWM | ETF | 217.87 | 217.87 | 216.81 | 217.56 | 1212387.0 |
| 2024-08-28 13:00:00 | IWM | ETF | 217.57 | 217.8 | 216.36 | 216.42 | 1364533.0 |
| 2024-08-28 14:00:00 | IWM | ETF | 216.425 | 217.53 | 216.27 | 217.47 | 1418214.0 |
| 2024-08-28 15:00:00 | IWM | ETF | 217.45 | 217.95 | 217.16 | 217.31 | 2816478.0 |
| 2024-08-28 16:00:00 | IWM | ETF | 217.33 | 217.52 | 216.77 | 217.29 | 1290186.0 |
| 2024-08-28 17:00:00 | IWM | ETF | 217.37 | 217.44 | 216.31 | 216.31 | 317549.0 |
| 2024-08-28 18:00:00 | IWM | ETF | 216.45 | 217.67 | 216.4 | 216.6 | 110041.0 |
| 2024-08-28 19:00:00 | IWM | ETF | 216.55 | 216.99 | 216.48 | 216.87 | 16318.0 |
| 2024-08-28 06:00:00 | DIA | ETF | 413.05 | 413.06 | 413.05 | 413.05 | 3404.0 |
| 2024-08-28 07:00:00 | DIA | ETF | 413.09 | 413.09 | 412.73 | 412.73 | 2750.0 |
> showing 50 of 20,412 rows — these rows as CSV