PREVIEW / etf_1hour / 2024-10-23
file: by_date/etf_1hour/2024/2024-10-23.parquet size: 577 KB rows: 21,472
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-10-23 04:00:00 | SPY | ETF | 582.9 | 583.23 | 582.43 | 582.46 | 30484.0 |
| 2024-10-23 05:00:00 | SPY | ETF | 582.59 | 582.78 | 582.37 | 582.59 | 10479.0 |
| 2024-10-23 06:00:00 | SPY | ETF | 582.3 | 582.43 | 581.8 | 581.93 | 36918.0 |
| 2024-10-23 07:00:00 | SPY | ETF | 581.93 | 582.34 | 581.87 | 582.1 | 56594.0 |
| 2024-10-23 08:00:00 | SPY | ETF | 581.99 | 583.43 | 581.3163 | 581.44 | 299518.0 |
| 2024-10-23 09:00:00 | SPY | ETF | 581.38 | 581.7086 | 580.96 | 581.31 | 2170395.0 |
| 2024-10-23 10:00:00 | SPY | ETF | 581.29 | 581.64 | 580.1 | 580.49 | 3279074.0 |
| 2024-10-23 11:00:00 | SPY | ETF | 580.51 | 580.76 | 578.78 | 579.835 | 4179442.0 |
| 2024-10-23 12:00:00 | SPY | ETF | 579.83 | 579.83 | 577.6302 | 578.15 | 3339801.0 |
| 2024-10-23 13:00:00 | SPY | ETF | 578.15 | 578.15 | 575.86 | 575.95 | 4014766.0 |
| 2024-10-23 14:00:00 | SPY | ETF | 575.96 | 577.23 | 574.415 | 577.17 | 5882326.0 |
| 2024-10-23 15:00:00 | SPY | ETF | 577.15 | 578.13 | 576.66 | 577.93 | 8220560.0 |
| 2024-10-23 16:00:00 | SPY | ETF | 577.93 | 578.9 | 577.68 | 578.41 | 3829138.0 |
| 2024-10-23 17:00:00 | SPY | ETF | 578.47 | 578.87 | 577.99 | 578.87 | 434945.0 |
| 2024-10-23 18:00:00 | SPY | ETF | 578.78 | 578.78 | 578.33 | 578.54 | 51616.0 |
| 2024-10-23 19:00:00 | SPY | ETF | 578.5 | 578.6 | 578.2 | 578.56 | 53212.0 |
| 2024-10-23 04:00:00 | QQQ | ETF | 495.24 | 495.61 | 494.76 | 494.88 | 36108.0 |
| 2024-10-23 05:00:00 | QQQ | ETF | 494.87 | 495.22 | 494.5 | 494.77 | 25295.0 |
| 2024-10-23 06:00:00 | QQQ | ETF | 494.78 | 494.78 | 493.91 | 494.13 | 55463.0 |
| 2024-10-23 07:00:00 | QQQ | ETF | 494.13 | 494.75 | 494.02 | 494.46 | 89184.0 |
| 2024-10-23 08:00:00 | QQQ | ETF | 494.27 | 496.05 | 493.8 | 494.07 | 239233.0 |
| 2024-10-23 09:00:00 | QQQ | ETF | 493.99 | 494.25 | 492.95 | 493.56 | 2443027.0 |
| 2024-10-23 10:00:00 | QQQ | ETF | 493.53 | 494.1169 | 491.45 | 492.57 | 3911525.0 |
| 2024-10-23 11:00:00 | QQQ | ETF | 492.59 | 493.18 | 490.44 | 491.73 | 3652164.0 |
| 2024-10-23 12:00:00 | QQQ | ETF | 491.72 | 491.72 | 488.735 | 489.13 | 2918573.0 |
| 2024-10-23 13:00:00 | QQQ | ETF | 489.12 | 489.12 | 486.09 | 486.2 | 3819692.0 |
| 2024-10-23 14:00:00 | QQQ | ETF | 486.17 | 487.69 | 485.05 | 487.41 | 3875391.0 |
| 2024-10-23 15:00:00 | QQQ | ETF | 487.4 | 488.62 | 486.605 | 488.37 | 4715390.0 |
| 2024-10-23 16:00:00 | QQQ | ETF | 488.36 | 490.25 | 488.08 | 489.77 | 2660486.0 |
| 2024-10-23 17:00:00 | QQQ | ETF | 489.79 | 490.39 | 489.65 | 490.38 | 86788.0 |
| 2024-10-23 18:00:00 | QQQ | ETF | 490.3 | 490.3 | 489.76 | 490.04 | 123718.0 |
| 2024-10-23 19:00:00 | QQQ | ETF | 490.03 | 490.19 | 489.62 | 490.1 | 67401.0 |
| 2024-10-23 04:00:00 | IWM | ETF | 220.94 | 221.07 | 220.35 | 220.47 | 14130.0 |
| 2024-10-23 05:00:00 | IWM | ETF | 220.36 | 220.8 | 220.31 | 220.8 | 10247.0 |
| 2024-10-23 06:00:00 | IWM | ETF | 220.67 | 220.67 | 220.21 | 220.46 | 57111.0 |
| 2024-10-23 07:00:00 | IWM | ETF | 220.45 | 220.93 | 220.18 | 220.18 | 46797.0 |
| 2024-10-23 08:00:00 | IWM | ETF | 220.8119 | 221.11 | 219.87 | 219.92 | 160280.0 |
| 2024-10-23 09:00:00 | IWM | ETF | 219.97 | 220.8 | 219.73 | 220.41 | 2101294.0 |
| 2024-10-23 10:00:00 | IWM | ETF | 220.41 | 220.69 | 219.52 | 219.8 | 2700934.0 |
| 2024-10-23 11:00:00 | IWM | ETF | 219.82 | 219.82 | 219.0 | 219.7 | 1759137.0 |
| 2024-10-23 12:00:00 | IWM | ETF | 219.7 | 219.89 | 218.96 | 218.98 | 1342609.0 |
| 2024-10-23 13:00:00 | IWM | ETF | 218.98 | 219.049 | 218.18 | 218.245 | 1405842.0 |
| 2024-10-23 14:00:00 | IWM | ETF | 218.24 | 218.78 | 217.37 | 218.64 | 2676163.0 |
| 2024-10-23 15:00:00 | IWM | ETF | 218.63 | 219.58 | 218.525 | 219.28 | 3496017.0 |
| 2024-10-23 16:00:00 | IWM | ETF | 219.24 | 219.48 | 219.07 | 219.12 | 1368570.0 |
| 2024-10-23 17:00:00 | IWM | ETF | 219.08 | 219.29 | 219.08 | 219.11 | 7837.0 |
| 2024-10-23 18:00:00 | IWM | ETF | 219.21 | 219.22 | 219.04 | 219.19 | 17516.0 |
| 2024-10-23 19:00:00 | IWM | ETF | 219.16 | 219.19 | 218.98 | 219.12 | 8069.0 |
| 2024-10-23 04:00:00 | DIA | ETF | 428.03 | 428.21 | 427.8 | 427.8 | 1589.0 |
| 2024-10-23 05:00:00 | DIA | ETF | 427.71 | 427.9 | 427.71 | 427.9 | 500.0 |
> showing 50 of 21,472 rows — these rows as CSV