PREVIEW / etf_1hour / 2024-12-05
file: by_date/etf_1hour/2024/2024-12-05.parquet size: 610 KB rows: 22,646
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-12-05 04:00:00 | SPY | ETF | 607.27 | 607.33 | 607.11 | 607.25 | 12998.0 |
| 2024-12-05 05:00:00 | SPY | ETF | 607.28 | 607.53 | 607.07 | 607.26 | 2918.0 |
| 2024-12-05 06:00:00 | SPY | ETF | 607.2 | 607.43 | 607.2 | 607.3 | 18285.0 |
| 2024-12-05 07:00:00 | SPY | ETF | 607.26 | 607.57 | 607.25 | 607.57 | 29662.0 |
| 2024-12-05 08:00:00 | SPY | ETF | 607.42 | 607.6 | 607.03 | 607.38 | 73836.0 |
| 2024-12-05 09:00:00 | SPY | ETF | 607.43 | 607.85 | 607.34 | 607.79 | 1753545.0 |
| 2024-12-05 10:00:00 | SPY | ETF | 607.805 | 608.2 | 606.8 | 606.95 | 2428364.0 |
| 2024-12-05 11:00:00 | SPY | ETF | 606.95 | 607.7677 | 606.8301 | 607.74 | 1647607.0 |
| 2024-12-05 12:00:00 | SPY | ETF | 607.75 | 608.48 | 607.64 | 608.4099 | 1737042.0 |
| 2024-12-05 13:00:00 | SPY | ETF | 608.41 | 608.4152 | 606.86 | 607.36 | 2102622.0 |
| 2024-12-05 14:00:00 | SPY | ETF | 607.37 | 607.6599 | 606.91 | 607.185 | 2408597.0 |
| 2024-12-05 15:00:00 | SPY | ETF | 607.18 | 607.41 | 606.305 | 606.61 | 6279758.0 |
| 2024-12-05 16:00:00 | SPY | ETF | 606.6 | 606.66 | 605.91 | 606.35 | 1764108.0 |
| 2024-12-05 17:00:00 | SPY | ETF | 606.29 | 606.32 | 606.15 | 606.29 | 42660.0 |
| 2024-12-05 18:00:00 | SPY | ETF | 606.25 | 606.29 | 605.76 | 606.18 | 73161.0 |
| 2024-12-05 19:00:00 | SPY | ETF | 606.12 | 606.22 | 605.88 | 606.22 | 36061.0 |
| 2024-12-05 04:00:00 | QQQ | ETF | 522.42 | 522.61 | 522.2 | 522.6 | 41714.0 |
| 2024-12-05 05:00:00 | QQQ | ETF | 522.61 | 522.83 | 522.43 | 522.6 | 19681.0 |
| 2024-12-05 06:00:00 | QQQ | ETF | 522.6 | 522.94 | 522.6 | 522.81 | 19815.0 |
| 2024-12-05 07:00:00 | QQQ | ETF | 522.88 | 523.31 | 522.82 | 523.28 | 53149.0 |
| 2024-12-05 08:00:00 | QQQ | ETF | 523.02 | 523.28 | 522.25 | 523.0 | 113391.0 |
| 2024-12-05 09:00:00 | QQQ | ETF | 523.1 | 523.65 | 522.36 | 522.65 | 1806011.0 |
| 2024-12-05 10:00:00 | QQQ | ETF | 522.65 | 523.31 | 522.1338 | 522.5 | 1602263.0 |
| 2024-12-05 11:00:00 | QQQ | ETF | 522.47 | 523.37 | 522.37 | 523.16 | 986018.0 |
| 2024-12-05 12:00:00 | QQQ | ETF | 523.18 | 524.0399 | 523.025 | 523.8882 | 910585.0 |
| 2024-12-05 13:00:00 | QQQ | ETF | 523.89 | 523.89 | 521.99 | 522.25 | 1660482.0 |
| 2024-12-05 14:00:00 | QQQ | ETF | 522.25 | 522.82 | 521.77 | 522.29 | 1403434.0 |
| 2024-12-05 15:00:00 | QQQ | ETF | 522.27 | 522.698 | 521.42 | 521.8 | 2574558.0 |
| 2024-12-05 16:00:00 | QQQ | ETF | 521.84 | 522.778 | 520.96 | 521.33 | 693213.0 |
| 2024-12-05 17:00:00 | QQQ | ETF | 521.38 | 521.4 | 521.15 | 521.3 | 26652.0 |
| 2024-12-05 18:00:00 | QQQ | ETF | 521.23 | 521.38 | 520.64 | 521.33 | 39716.0 |
| 2024-12-05 19:00:00 | QQQ | ETF | 521.33 | 521.5 | 521.13 | 521.36 | 37710.0 |
| 2024-12-05 04:00:00 | IWM | ETF | 240.89 | 241.15 | 240.8 | 241.01 | 12445.0 |
| 2024-12-05 05:00:00 | IWM | ETF | 240.97 | 241.22 | 240.8 | 240.9 | 9451.0 |
| 2024-12-05 06:00:00 | IWM | ETF | 240.81 | 241.0 | 240.7 | 240.78 | 7419.0 |
| 2024-12-05 07:00:00 | IWM | ETF | 240.71 | 240.96 | 240.58 | 240.86 | 23644.0 |
| 2024-12-05 08:00:00 | IWM | ETF | 240.66 | 241.09 | 240.41 | 240.5 | 73219.0 |
| 2024-12-05 09:00:00 | IWM | ETF | 240.52 | 240.86 | 239.62 | 240.4689 | 1919414.0 |
| 2024-12-05 10:00:00 | IWM | ETF | 240.42 | 240.62 | 238.65 | 239.02 | 2482765.0 |
| 2024-12-05 11:00:00 | IWM | ETF | 239.01 | 239.95 | 238.99 | 239.9 | 1223374.0 |
| 2024-12-05 12:00:00 | IWM | ETF | 239.9 | 239.96 | 239.09 | 239.26 | 1016852.0 |
| 2024-12-05 13:00:00 | IWM | ETF | 239.26 | 239.3 | 238.33 | 238.41 | 1549048.0 |
| 2024-12-05 14:00:00 | IWM | ETF | 238.41 | 239.19 | 238.3 | 239.05 | 1302952.0 |
| 2024-12-05 15:00:00 | IWM | ETF | 239.02 | 239.055 | 237.735 | 238.05 | 3747303.0 |
| 2024-12-05 16:00:00 | IWM | ETF | 238.08 | 238.16 | 237.87 | 238.09 | 1671877.0 |
| 2024-12-05 17:00:00 | IWM | ETF | 238.08 | 238.18 | 238.01 | 238.1 | 32023.0 |
| 2024-12-05 18:00:00 | IWM | ETF | 238.05 | 238.08 | 237.61 | 237.78 | 38231.0 |
| 2024-12-05 19:00:00 | IWM | ETF | 237.7984 | 237.89 | 237.6 | 237.88 | 56608.0 |
| 2024-12-05 04:00:00 | DIA | ETF | 450.95 | 450.98 | 450.94 | 450.94 | 918.0 |
| 2024-12-05 05:00:00 | DIA | ETF | 451.02 | 451.02 | 450.63 | 450.63 | 704.0 |
> showing 50 of 22,646 rows — these rows as CSV