PREVIEW / etf_1hour / 2024-09-26
file: by_date/etf_1hour/2024/2024-09-26.parquet size: 583 KB rows: 21,850
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-09-26 04:00:00 | SPY | ETF | 573.72 | 574.82 | 573.72 | 574.57 | 40947.0 |
| 2024-09-26 05:00:00 | SPY | ETF | 574.52 | 574.6 | 574.22 | 574.43 | 18136.0 |
| 2024-09-26 06:00:00 | SPY | ETF | 574.43 | 574.85 | 574.31 | 574.78 | 33724.0 |
| 2024-09-26 07:00:00 | SPY | ETF | 574.89 | 574.9 | 574.27 | 574.37 | 289189.0 |
| 2024-09-26 08:00:00 | SPY | ETF | 574.76 | 574.97 | 572.6 | 574.65 | 307814.0 |
| 2024-09-26 09:00:00 | SPY | ETF | 574.7 | 575.0 | 573.165 | 573.545 | 4347327.0 |
| 2024-09-26 10:00:00 | SPY | ETF | 573.56 | 574.15 | 571.03 | 571.235 | 4967258.0 |
| 2024-09-26 11:00:00 | SPY | ETF | 571.24 | 572.5702 | 570.9 | 572.4201 | 2985629.0 |
| 2024-09-26 12:00:00 | SPY | ETF | 572.41 | 572.42 | 570.8398 | 571.08 | 2415284.0 |
| 2024-09-26 13:00:00 | SPY | ETF | 571.07 | 571.76 | 569.9 | 571.53 | 2982565.0 |
| 2024-09-26 14:00:00 | SPY | ETF | 571.55 | 572.73 | 571.54 | 572.26 | 2758840.0 |
| 2024-09-26 15:00:00 | SPY | ETF | 572.24 | 572.75 | 571.82 | 572.29 | 6495905.0 |
| 2024-09-26 16:00:00 | SPY | ETF | 572.28 | 572.57 | 572.15 | 572.36 | 1740232.0 |
| 2024-09-26 17:00:00 | SPY | ETF | 572.3426 | 572.44 | 572.3 | 572.38 | 55381.0 |
| 2024-09-26 18:00:00 | SPY | ETF | 572.36 | 573.07 | 572.36 | 572.8 | 49935.0 |
| 2024-09-26 19:00:00 | SPY | ETF | 572.8 | 572.877 | 572.29 | 572.4 | 86138.0 |
| 2024-09-26 04:00:00 | QQQ | ETF | 491.72 | 493.07 | 491.3 | 492.45 | 99774.0 |
| 2024-09-26 05:00:00 | QQQ | ETF | 492.51 | 492.79 | 492.21 | 492.57 | 34244.0 |
| 2024-09-26 06:00:00 | QQQ | ETF | 492.59 | 493.23 | 492.41 | 493.23 | 65569.0 |
| 2024-09-26 07:00:00 | QQQ | ETF | 493.22 | 493.39 | 492.76 | 493.02 | 148889.0 |
| 2024-09-26 08:00:00 | QQQ | ETF | 492.85 | 493.81 | 490.0 | 493.73 | 484488.0 |
| 2024-09-26 09:00:00 | QQQ | ETF | 493.76 | 494.21 | 491.0 | 491.55 | 4384725.0 |
| 2024-09-26 10:00:00 | QQQ | ETF | 491.55 | 491.74 | 486.25 | 486.4427 | 4396891.0 |
| 2024-09-26 11:00:00 | QQQ | ETF | 486.42 | 489.0405 | 485.8 | 489.0 | 3413667.0 |
| 2024-09-26 12:00:00 | QQQ | ETF | 489.0 | 489.0 | 486.78 | 487.33 | 1720474.0 |
| 2024-09-26 13:00:00 | QQQ | ETF | 487.31 | 488.26 | 485.84 | 487.86 | 2035281.0 |
| 2024-09-26 14:00:00 | QQQ | ETF | 487.87 | 489.66 | 487.87 | 489.3925 | 2094167.0 |
| 2024-09-26 15:00:00 | QQQ | ETF | 489.39 | 489.97 | 488.99 | 489.44 | 3356718.0 |
| 2024-09-26 16:00:00 | QQQ | ETF | 489.43 | 489.879 | 489.1667 | 489.51 | 1160763.0 |
| 2024-09-26 17:00:00 | QQQ | ETF | 489.53 | 489.6 | 489.3 | 489.3 | 139772.0 |
| 2024-09-26 18:00:00 | QQQ | ETF | 489.29 | 490.36 | 489.29 | 489.98 | 109656.0 |
| 2024-09-26 19:00:00 | QQQ | ETF | 489.95 | 489.98 | 489.15 | 489.44 | 51320.0 |
| 2024-09-26 04:00:00 | IWM | ETF | 219.32 | 219.65 | 219.23 | 219.62 | 44533.0 |
| 2024-09-26 05:00:00 | IWM | ETF | 219.56 | 219.75 | 219.32 | 219.6 | 12917.0 |
| 2024-09-26 06:00:00 | IWM | ETF | 219.67 | 220.12 | 219.53 | 219.99 | 62167.0 |
| 2024-09-26 07:00:00 | IWM | ETF | 220.03 | 220.06 | 219.4 | 219.65 | 131783.0 |
| 2024-09-26 08:00:00 | IWM | ETF | 220.0009 | 220.49 | 218.84 | 220.4 | 432421.0 |
| 2024-09-26 09:00:00 | IWM | ETF | 220.4 | 220.77 | 219.6301 | 219.96 | 3141175.0 |
| 2024-09-26 10:00:00 | IWM | ETF | 219.98 | 221.13 | 218.54 | 218.63 | 3085904.0 |
| 2024-09-26 11:00:00 | IWM | ETF | 218.62 | 220.14 | 218.38 | 220.03 | 1816979.0 |
| 2024-09-26 12:00:00 | IWM | ETF | 220.05 | 220.08 | 219.21 | 219.25 | 884060.0 |
| 2024-09-26 13:00:00 | IWM | ETF | 219.24 | 219.58 | 218.67 | 219.43 | 1183839.0 |
| 2024-09-26 14:00:00 | IWM | ETF | 219.44 | 219.58 | 219.1401 | 219.41 | 1005991.0 |
| 2024-09-26 15:00:00 | IWM | ETF | 219.43 | 219.75 | 218.78 | 218.82 | 3520147.0 |
| 2024-09-26 16:00:00 | IWM | ETF | 218.85 | 219.12 | 218.83 | 218.94 | 835880.0 |
| 2024-09-26 17:00:00 | IWM | ETF | 219.0 | 219.03 | 218.7 | 218.85 | 38679.0 |
| 2024-09-26 18:00:00 | IWM | ETF | 218.89 | 219.28 | 218.88 | 219.045 | 27724.0 |
| 2024-09-26 19:00:00 | IWM | ETF | 219.0 | 219.14 | 218.73 | 218.84 | 22643.0 |
| 2024-09-26 04:00:00 | DIA | ETF | 420.74 | 421.2 | 420.73 | 421.2 | 1101.0 |
| 2024-09-26 05:00:00 | DIA | ETF | 421.06 | 421.13 | 421.05 | 421.13 | 1194.0 |
> showing 50 of 21,850 rows — these rows as CSV