PREVIEW / etf_1hour / 2024-08-23
file: by_date/etf_1hour/2024/2024-08-23.parquet size: 552 KB rows: 20,657
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-23 04:00:00 | SPY | ETF | 558.13 | 558.75 | 558.05 | 558.71 | 40058.0 |
| 2024-08-23 05:00:00 | SPY | ETF | 558.75 | 558.95 | 558.46 | 558.95 | 11297.0 |
| 2024-08-23 06:00:00 | SPY | ETF | 558.87 | 559.59 | 558.84 | 559.4 | 16551.0 |
| 2024-08-23 07:00:00 | SPY | ETF | 559.4 | 559.56 | 558.91 | 559.45 | 321507.0 |
| 2024-08-23 08:00:00 | SPY | ETF | 559.47 | 559.82 | 558.17 | 559.8 | 180255.0 |
| 2024-08-23 09:00:00 | SPY | ETF | 559.79 | 559.95 | 558.83 | 559.78 | 3377204.0 |
| 2024-08-23 10:00:00 | SPY | ETF | 559.77 | 563.09 | 558.35 | 560.53 | 10059596.0 |
| 2024-08-23 11:00:00 | SPY | ETF | 560.5 | 562.5 | 559.52 | 560.0 | 3789085.0 |
| 2024-08-23 12:00:00 | SPY | ETF | 560.01 | 560.16 | 557.29 | 559.2923 | 3765397.0 |
| 2024-08-23 13:00:00 | SPY | ETF | 559.25 | 561.0 | 558.96 | 560.39 | 2263791.0 |
| 2024-08-23 14:00:00 | SPY | ETF | 560.39 | 561.19 | 560.2 | 560.76 | 2693527.0 |
| 2024-08-23 15:00:00 | SPY | ETF | 560.76 | 562.68 | 560.1623 | 562.09 | 8141638.0 |
| 2024-08-23 16:00:00 | SPY | ETF | 562.09 | 562.45 | 561.78 | 562.06 | 2970934.0 |
| 2024-08-23 17:00:00 | SPY | ETF | 562.16 | 562.22 | 562.0 | 562.05 | 80020.0 |
| 2024-08-23 18:00:00 | SPY | ETF | 562.05 | 562.25 | 562.05 | 562.25 | 12922.0 |
| 2024-08-23 19:00:00 | SPY | ETF | 562.25 | 562.4 | 562.12 | 562.29 | 24287.0 |
| 2024-08-23 04:00:00 | QQQ | ETF | 477.4 | 478.15 | 477.26 | 478.11 | 43572.0 |
| 2024-08-23 05:00:00 | QQQ | ETF | 478.16 | 478.36 | 477.59 | 478.33 | 25203.0 |
| 2024-08-23 06:00:00 | QQQ | ETF | 478.31 | 479.2 | 478.31 | 478.84 | 141137.0 |
| 2024-08-23 07:00:00 | QQQ | ETF | 478.85 | 479.0 | 478.39 | 478.78 | 96592.0 |
| 2024-08-23 08:00:00 | QQQ | ETF | 478.93 | 479.31 | 475.206 | 479.26 | 224477.0 |
| 2024-08-23 09:00:00 | QQQ | ETF | 479.27 | 479.75 | 478.02 | 479.08 | 2945600.0 |
| 2024-08-23 10:00:00 | QQQ | ETF | 479.17 | 482.74 | 475.98 | 478.36 | 8811102.0 |
| 2024-08-23 11:00:00 | QQQ | ETF | 478.35 | 480.69 | 476.98 | 478.28 | 3716689.0 |
| 2024-08-23 12:00:00 | QQQ | ETF | 478.29 | 478.44 | 475.28 | 477.4 | 3082228.0 |
| 2024-08-23 13:00:00 | QQQ | ETF | 477.415 | 479.49 | 477.05 | 478.61 | 1815398.0 |
| 2024-08-23 14:00:00 | QQQ | ETF | 478.63 | 479.42 | 478.39 | 478.77 | 1649031.0 |
| 2024-08-23 15:00:00 | QQQ | ETF | 478.76 | 480.54 | 477.99 | 480.02 | 4678087.0 |
| 2024-08-23 16:00:00 | QQQ | ETF | 480.01 | 480.19 | 479.67 | 479.73 | 1019033.0 |
| 2024-08-23 17:00:00 | QQQ | ETF | 479.75 | 479.99 | 479.75 | 479.9792 | 37099.0 |
| 2024-08-23 18:00:00 | QQQ | ETF | 479.96 | 480.0299 | 479.9 | 479.9 | 12655.0 |
| 2024-08-23 19:00:00 | QQQ | ETF | 479.91 | 480.24 | 479.9 | 480.07 | 18392.0 |
| 2024-08-23 04:00:00 | IWM | ETF | 214.36 | 214.75 | 214.3 | 214.73 | 15241.0 |
| 2024-08-23 05:00:00 | IWM | ETF | 214.74 | 214.93 | 214.74 | 214.82 | 8216.0 |
| 2024-08-23 06:00:00 | IWM | ETF | 214.79 | 215.06 | 214.61 | 214.74 | 17372.0 |
| 2024-08-23 07:00:00 | IWM | ETF | 214.74 | 214.92 | 214.7 | 214.8 | 47627.0 |
| 2024-08-23 08:00:00 | IWM | ETF | 214.8487 | 214.96 | 214.5 | 214.83 | 88476.0 |
| 2024-08-23 09:00:00 | IWM | ETF | 214.82 | 216.2456 | 214.79 | 215.31 | 2764970.0 |
| 2024-08-23 10:00:00 | IWM | ETF | 215.32 | 219.995 | 215.32 | 219.33 | 10849484.0 |
| 2024-08-23 11:00:00 | IWM | ETF | 219.32 | 221.08 | 218.96 | 219.61 | 4716117.0 |
| 2024-08-23 12:00:00 | IWM | ETF | 219.61 | 220.43 | 219.1 | 219.87 | 3312331.0 |
| 2024-08-23 13:00:00 | IWM | ETF | 219.85 | 220.24 | 219.73 | 220.165 | 1558126.0 |
| 2024-08-23 14:00:00 | IWM | ETF | 220.17 | 220.24 | 219.52 | 219.72 | 1717188.0 |
| 2024-08-23 15:00:00 | IWM | ETF | 219.72 | 220.42 | 219.48 | 220.31 | 4630921.0 |
| 2024-08-23 16:00:00 | IWM | ETF | 220.33 | 220.55 | 220.15 | 220.41 | 2130185.0 |
| 2024-08-23 17:00:00 | IWM | ETF | 220.45 | 220.48 | 220.27 | 220.4 | 25023.0 |
| 2024-08-23 18:00:00 | IWM | ETF | 220.45 | 220.57 | 220.42 | 220.52 | 13379.0 |
| 2024-08-23 19:00:00 | IWM | ETF | 220.5778 | 220.97 | 220.5216 | 220.89 | 85007.0 |
| 2024-08-23 04:00:00 | DIA | ETF | 408.44 | 408.69 | 408.44 | 408.69 | 200.0 |
| 2024-08-23 05:00:00 | DIA | ETF | 408.78 | 408.95 | 408.78 | 408.95 | 500.0 |
> showing 50 of 20,657 rows — these rows as CSV