PREVIEW / etf_1hour / 2024-01-02
file: by_date/etf_1hour/2024/2024-01-02.parquet size: 544 KB rows: 20,507
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-01-02 04:00:00 | SPY | ETF | 476.25 | 476.36 | 475.27 | 475.4 | 68497.0 |
| 2024-01-02 05:00:00 | SPY | ETF | 475.39 | 475.51 | 475.1 | 475.1 | 41835.0 |
| 2024-01-02 06:00:00 | SPY | ETF | 475.01 | 475.08 | 472.5 | 473.17 | 148955.0 |
| 2024-01-02 07:00:00 | SPY | ETF | 473.05 | 473.06 | 471.7 | 471.79 | 402556.0 |
| 2024-01-02 08:00:00 | SPY | ETF | 473.0699 | 476.35 | 471.64 | 472.03 | 529587.0 |
| 2024-01-02 09:00:00 | SPY | ETF | 472.09 | 472.8 | 471.36 | 472.27 | 10443096.0 |
| 2024-01-02 10:00:00 | SPY | ETF | 472.275 | 472.71 | 471.3 | 471.68 | 8909865.0 |
| 2024-01-02 11:00:00 | SPY | ETF | 471.67 | 473.29 | 471.63 | 473.185 | 6571904.0 |
| 2024-01-02 12:00:00 | SPY | ETF | 473.19 | 473.67 | 472.59 | 472.65 | 5633620.0 |
| 2024-01-02 13:00:00 | SPY | ETF | 472.65 | 472.97 | 472.0 | 472.1499 | 5552237.0 |
| 2024-01-02 14:00:00 | SPY | ETF | 472.13 | 472.25 | 470.92 | 470.925 | 7365522.0 |
| 2024-01-02 15:00:00 | SPY | ETF | 470.9275 | 472.67 | 470.49 | 472.6 | 25544294.0 |
| 2024-01-02 16:00:00 | SPY | ETF | 472.6 | 473.0 | 471.9163 | 472.69 | 7884611.0 |
| 2024-01-02 17:00:00 | SPY | ETF | 472.69 | 472.79 | 472.62 | 472.79 | 664508.0 |
| 2024-01-02 18:00:00 | SPY | ETF | 472.84 | 472.87 | 472.52 | 472.67 | 29897.0 |
| 2024-01-02 19:00:00 | SPY | ETF | 472.68 | 472.71 | 472.44 | 472.5 | 25114.0 |
| 2024-01-02 04:00:00 | QQQ | ETF | 409.84 | 409.84 | 408.94 | 409.03 | 28466.0 |
| 2024-01-02 05:00:00 | QQQ | ETF | 409.05 | 409.1 | 408.45 | 408.49 | 26685.0 |
| 2024-01-02 06:00:00 | QQQ | ETF | 408.42 | 408.59 | 405.5 | 406.17 | 267588.0 |
| 2024-01-02 07:00:00 | QQQ | ETF | 406.19 | 406.25 | 404.83 | 404.99 | 290001.0 |
| 2024-01-02 08:00:00 | QQQ | ETF | 408.41 | 410.0 | 404.81 | 405.61 | 424783.0 |
| 2024-01-02 09:00:00 | QQQ | ETF | 405.63 | 406.2 | 402.5 | 403.58 | 7851142.0 |
| 2024-01-02 10:00:00 | QQQ | ETF | 403.575 | 404.165 | 401.7408 | 402.355 | 6854909.0 |
| 2024-01-02 11:00:00 | QQQ | ETF | 402.355 | 404.15 | 402.32 | 403.97 | 4799153.0 |
| 2024-01-02 12:00:00 | QQQ | ETF | 403.97 | 404.18 | 402.5212 | 402.575 | 3358050.0 |
| 2024-01-02 13:00:00 | QQQ | ETF | 402.59 | 403.12 | 401.8299 | 402.03 | 3393812.0 |
| 2024-01-02 14:00:00 | QQQ | ETF | 402.03 | 402.27 | 400.96 | 401.02 | 4348074.0 |
| 2024-01-02 15:00:00 | QQQ | ETF | 401.03 | 402.69 | 400.24 | 402.57 | 10563106.0 |
| 2024-01-02 16:00:00 | QQQ | ETF | 402.57 | 402.94 | 402.42 | 402.76 | 1432061.0 |
| 2024-01-02 17:00:00 | QQQ | ETF | 402.77 | 402.9 | 402.6 | 402.9 | 38139.0 |
| 2024-01-02 18:00:00 | QQQ | ETF | 402.9 | 402.9 | 402.48 | 402.62 | 60929.0 |
| 2024-01-02 19:00:00 | QQQ | ETF | 402.64 | 402.71 | 402.4 | 402.43 | 69114.0 |
| 2024-01-02 04:00:00 | IWM | ETF | 201.78 | 202.26 | 201.72 | 201.8 | 55770.0 |
| 2024-01-02 05:00:00 | IWM | ETF | 201.8 | 202.07 | 201.63 | 201.75 | 49153.0 |
| 2024-01-02 06:00:00 | IWM | ETF | 201.56 | 201.58 | 199.83 | 200.24 | 91242.0 |
| 2024-01-02 07:00:00 | IWM | ETF | 200.3 | 200.3 | 199.0 | 199.25 | 252498.0 |
| 2024-01-02 08:00:00 | IWM | ETF | 200.2892 | 202.03 | 198.99 | 199.47 | 197269.0 |
| 2024-01-02 09:00:00 | IWM | ETF | 199.49 | 201.12 | 198.74 | 201.1 | 6470567.0 |
| 2024-01-02 10:00:00 | IWM | ETF | 201.08 | 201.62 | 199.55 | 199.67 | 6333508.0 |
| 2024-01-02 11:00:00 | IWM | ETF | 199.67 | 201.1 | 199.645 | 201.1 | 4256027.0 |
| 2024-01-02 12:00:00 | IWM | ETF | 201.105 | 201.575 | 200.63 | 200.71 | 3898253.0 |
| 2024-01-02 13:00:00 | IWM | ETF | 200.71 | 200.72 | 199.64 | 199.67 | 2502251.0 |
| 2024-01-02 14:00:00 | IWM | ETF | 199.68 | 199.84 | 198.86 | 198.86 | 3106214.0 |
| 2024-01-02 15:00:00 | IWM | ETF | 198.85 | 199.58 | 198.44 | 199.56 | 6365813.0 |
| 2024-01-02 16:00:00 | IWM | ETF | 199.52 | 199.79 | 199.42 | 199.68 | 1104067.0 |
| 2024-01-02 17:00:00 | IWM | ETF | 199.66 | 199.85 | 199.52 | 199.82 | 19812.0 |
| 2024-01-02 18:00:00 | IWM | ETF | 199.77 | 199.86 | 199.58 | 199.74 | 30329.0 |
| 2024-01-02 19:00:00 | IWM | ETF | 199.74 | 199.78 | 199.41 | 199.41 | 25721.0 |
| 2024-01-02 04:00:00 | DIA | ETF | 377.99 | 378.0 | 377.05 | 377.05 | 5686.0 |
| 2024-01-02 05:00:00 | DIA | ETF | 376.99 | 376.99 | 376.99 | 376.99 | 250.0 |
> showing 50 of 20,507 rows — these rows as CSV