PREVIEW / etf_1hour / 2024-03-21
file: by_date/etf_1hour/2024/2024-03-21.parquet size: 544 KB rows: 20,188
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-03-21 04:00:00 | SPY | ETF | 523.48 | 523.8 | 522.75 | 522.79 | 66765.0 |
| 2024-03-21 05:00:00 | SPY | ETF | 522.77 | 522.77 | 522.21 | 522.59 | 23612.0 |
| 2024-03-21 06:00:00 | SPY | ETF | 522.44 | 522.46 | 522.14 | 522.27 | 24178.0 |
| 2024-03-21 07:00:00 | SPY | ETF | 522.31 | 522.95 | 522.27 | 522.76 | 177149.0 |
| 2024-03-21 08:00:00 | SPY | ETF | 522.78 | 523.34 | 522.1204 | 523.17 | 421229.0 |
| 2024-03-21 09:00:00 | SPY | ETF | 523.16 | 524.01 | 522.765 | 523.43 | 6028478.0 |
| 2024-03-21 10:00:00 | SPY | ETF | 523.43 | 523.98 | 523.1551 | 523.6 | 6679222.0 |
| 2024-03-21 11:00:00 | SPY | ETF | 523.59 | 523.93 | 523.03 | 523.75 | 4575624.0 |
| 2024-03-21 12:00:00 | SPY | ETF | 523.74 | 524.11 | 523.43 | 523.76 | 4163761.0 |
| 2024-03-21 13:00:00 | SPY | ETF | 523.745 | 523.76 | 522.73 | 522.81 | 3926249.0 |
| 2024-03-21 14:00:00 | SPY | ETF | 522.8 | 523.12 | 522.03 | 522.32 | 5193440.0 |
| 2024-03-21 15:00:00 | SPY | ETF | 522.33 | 523.17 | 521.91 | 522.11 | 10313177.0 |
| 2024-03-21 16:00:00 | SPY | ETF | 522.11 | 522.77 | 522.04 | 522.6 | 2378195.0 |
| 2024-03-21 17:00:00 | SPY | ETF | 522.6 | 522.75 | 522.2 | 522.49 | 101904.0 |
| 2024-03-21 18:00:00 | SPY | ETF | 522.56 | 522.81 | 522.34 | 522.77 | 36596.0 |
| 2024-03-21 19:00:00 | SPY | ETF | 522.7401 | 522.91 | 522.6502 | 522.85 | 27796.0 |
| 2024-03-21 04:00:00 | QQQ | ETF | 448.17 | 448.17 | 447.01 | 447.23 | 110860.0 |
| 2024-03-21 05:00:00 | QQQ | ETF | 447.24 | 447.38 | 446.55 | 446.96 | 45799.0 |
| 2024-03-21 06:00:00 | QQQ | ETF | 447.0 | 447.05 | 446.7 | 446.92 | 96365.0 |
| 2024-03-21 07:00:00 | QQQ | ETF | 446.95 | 447.93 | 446.91 | 447.72 | 242977.0 |
| 2024-03-21 08:00:00 | QQQ | ETF | 446.58 | 448.54 | 443.438 | 448.2 | 451768.0 |
| 2024-03-21 09:00:00 | QQQ | ETF | 448.2 | 449.32 | 447.38 | 447.9176 | 5080565.0 |
| 2024-03-21 10:00:00 | QQQ | ETF | 447.9 | 448.865 | 447.29 | 447.85 | 4524652.0 |
| 2024-03-21 11:00:00 | QQQ | ETF | 447.84 | 449.21 | 447.22 | 448.75 | 3277649.0 |
| 2024-03-21 12:00:00 | QQQ | ETF | 448.75 | 449.34 | 448.5812 | 448.92 | 2446628.0 |
| 2024-03-21 13:00:00 | QQQ | ETF | 448.91 | 448.93 | 447.07 | 447.245 | 2568341.0 |
| 2024-03-21 14:00:00 | QQQ | ETF | 447.2 | 447.33 | 445.67 | 446.1481 | 3542524.0 |
| 2024-03-21 15:00:00 | QQQ | ETF | 446.15 | 446.83 | 445.67 | 445.8 | 6026665.0 |
| 2024-03-21 16:00:00 | QQQ | ETF | 445.79 | 446.44 | 445.77 | 446.29 | 1069251.0 |
| 2024-03-21 17:00:00 | QQQ | ETF | 446.27 | 446.4 | 446.17 | 446.27 | 28760.0 |
| 2024-03-21 18:00:00 | QQQ | ETF | 446.27 | 446.55 | 446.12 | 446.49 | 46137.0 |
| 2024-03-21 19:00:00 | QQQ | ETF | 446.53 | 446.6 | 446.34 | 446.56 | 45424.0 |
| 2024-03-21 04:00:00 | IWM | ETF | 207.62 | 207.97 | 207.0 | 207.11 | 65976.0 |
| 2024-03-21 05:00:00 | IWM | ETF | 206.99 | 207.05 | 206.54 | 206.75 | 35251.0 |
| 2024-03-21 06:00:00 | IWM | ETF | 206.77 | 206.87 | 206.47 | 206.74 | 31361.0 |
| 2024-03-21 07:00:00 | IWM | ETF | 206.76 | 207.17 | 206.73 | 207.17 | 197743.0 |
| 2024-03-21 08:00:00 | IWM | ETF | 206.75 | 207.74 | 206.57 | 206.69 | 180383.0 |
| 2024-03-21 09:00:00 | IWM | ETF | 206.68 | 208.28 | 206.39 | 207.68 | 5639237.0 |
| 2024-03-21 10:00:00 | IWM | ETF | 207.67 | 208.95 | 207.36 | 208.87 | 5618059.0 |
| 2024-03-21 11:00:00 | IWM | ETF | 208.87 | 208.88 | 207.89 | 208.17 | 3502964.0 |
| 2024-03-21 12:00:00 | IWM | ETF | 208.16 | 208.39 | 207.67 | 208.36 | 1838993.0 |
| 2024-03-21 13:00:00 | IWM | ETF | 208.355 | 208.47 | 207.96 | 208.02 | 2074408.0 |
| 2024-03-21 14:00:00 | IWM | ETF | 208.02 | 208.47 | 207.84 | 208.16 | 2441114.0 |
| 2024-03-21 15:00:00 | IWM | ETF | 208.17 | 208.73 | 207.86 | 207.92 | 5726111.0 |
| 2024-03-21 16:00:00 | IWM | ETF | 207.94 | 208.39 | 207.86 | 208.25 | 1982021.0 |
| 2024-03-21 17:00:00 | IWM | ETF | 208.27 | 208.29 | 208.11 | 208.12 | 12452.0 |
| 2024-03-21 18:00:00 | IWM | ETF | 208.18 | 208.48 | 208.16 | 208.44 | 18365.0 |
| 2024-03-21 19:00:00 | IWM | ETF | 208.44 | 208.57 | 208.41 | 208.45 | 72468.0 |
| 2024-03-21 04:00:00 | DIA | ETF | 396.0 | 396.77 | 396.0 | 396.43 | 700.0 |
| 2024-03-21 05:00:00 | DIA | ETF | 396.1 | 396.25 | 396.1 | 396.13 | 2200.0 |
> showing 50 of 20,188 rows — these rows as CSV