PREVIEW / etf_1hour / 2024-01-30
file: by_date/etf_1hour/2024/2024-01-30.parquet size: 537 KB rows: 19,675
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-30 04:00:00 | SPY | ETF | 491.15 | 491.29 | 490.71 | 490.88 | 35157.0 |
| 2024-01-30 05:00:00 | SPY | ETF | 490.87 | 491.16 | 490.84 | 490.93 | 13227.0 |
| 2024-01-30 06:00:00 | SPY | ETF | 490.9 | 490.9 | 490.6 | 490.83 | 16409.0 |
| 2024-01-30 07:00:00 | SPY | ETF | 490.86 | 490.95 | 490.47 | 490.6 | 77833.0 |
| 2024-01-30 08:00:00 | SPY | ETF | 490.8896 | 491.34 | 490.03 | 490.23 | 302615.0 |
| 2024-01-30 09:00:00 | SPY | ETF | 490.26 | 491.32 | 490.12 | 491.2601 | 4842662.0 |
| 2024-01-30 10:00:00 | SPY | ETF | 491.3 | 491.3596 | 490.34 | 490.64 | 7081788.0 |
| 2024-01-30 11:00:00 | SPY | ETF | 490.64 | 491.48 | 490.46 | 491.32 | 4828690.0 |
| 2024-01-30 12:00:00 | SPY | ETF | 491.33 | 491.47 | 490.11 | 490.4 | 5058196.0 |
| 2024-01-30 13:00:00 | SPY | ETF | 490.39 | 491.04 | 490.13 | 490.74 | 3584794.0 |
| 2024-01-30 14:00:00 | SPY | ETF | 490.75 | 491.49 | 490.46 | 491.37 | 4543774.0 |
| 2024-01-30 15:00:00 | SPY | ETF | 491.38 | 491.62 | 490.72 | 490.86 | 10548392.0 |
| 2024-01-30 16:00:00 | SPY | ETF | 490.85 | 491.1233 | 489.28 | 489.31 | 4726361.0 |
| 2024-01-30 17:00:00 | SPY | ETF | 489.38 | 490.89 | 488.15 | 488.4015 | 513903.0 |
| 2024-01-30 18:00:00 | SPY | ETF | 488.74 | 489.3 | 488.64 | 488.89 | 188472.0 |
| 2024-01-30 19:00:00 | SPY | ETF | 489.06 | 489.32 | 489.04 | 489.21 | 26957.0 |
| 2024-01-30 04:00:00 | QQQ | ETF | 428.41 | 428.62 | 427.7 | 427.87 | 69508.0 |
| 2024-01-30 05:00:00 | QQQ | ETF | 427.85 | 428.34 | 427.83 | 427.98 | 51943.0 |
| 2024-01-30 06:00:00 | QQQ | ETF | 427.87 | 428.13 | 427.67 | 428.03 | 47912.0 |
| 2024-01-30 07:00:00 | QQQ | ETF | 428.05 | 428.12 | 427.51 | 427.6 | 102123.0 |
| 2024-01-30 08:00:00 | QQQ | ETF | 427.84 | 428.67 | 426.93 | 427.1 | 294869.0 |
| 2024-01-30 09:00:00 | QQQ | ETF | 427.1 | 427.68 | 426.75 | 427.3 | 2740727.0 |
| 2024-01-30 10:00:00 | QQQ | ETF | 427.3 | 427.35 | 426.05 | 426.59 | 4861616.0 |
| 2024-01-30 11:00:00 | QQQ | ETF | 426.6 | 426.96 | 426.25 | 426.5899 | 2406232.0 |
| 2024-01-30 12:00:00 | QQQ | ETF | 426.6 | 426.79 | 424.76 | 425.0 | 3565933.0 |
| 2024-01-30 13:00:00 | QQQ | ETF | 424.97 | 425.68 | 424.55 | 424.9137 | 2896688.0 |
| 2024-01-30 14:00:00 | QQQ | ETF | 424.93 | 425.66 | 424.38 | 425.4 | 2578449.0 |
| 2024-01-30 15:00:00 | QQQ | ETF | 425.37 | 425.83 | 425.05 | 425.21 | 4928182.0 |
| 2024-01-30 16:00:00 | QQQ | ETF | 425.21 | 425.77 | 422.42 | 422.5 | 2912319.0 |
| 2024-01-30 17:00:00 | QQQ | ETF | 422.56 | 425.3 | 420.25 | 421.17 | 871926.0 |
| 2024-01-30 18:00:00 | QQQ | ETF | 420.91 | 422.25 | 420.85 | 421.93 | 601921.0 |
| 2024-01-30 19:00:00 | QQQ | ETF | 421.97 | 422.2 | 421.79 | 421.89 | 139994.0 |
| 2024-01-30 04:00:00 | IWM | ETF | 199.39 | 199.39 | 199.11 | 199.21 | 27801.0 |
| 2024-01-30 05:00:00 | IWM | ETF | 199.23 | 199.46 | 199.15 | 199.15 | 18080.0 |
| 2024-01-30 06:00:00 | IWM | ETF | 199.14 | 199.24 | 198.99 | 199.24 | 32594.0 |
| 2024-01-30 07:00:00 | IWM | ETF | 199.25 | 199.26 | 198.99 | 199.15 | 63966.0 |
| 2024-01-30 08:00:00 | IWM | ETF | 199.2499 | 199.48 | 198.18 | 198.43 | 218928.0 |
| 2024-01-30 09:00:00 | IWM | ETF | 198.46 | 198.93 | 197.83 | 198.6975 | 3651598.0 |
| 2024-01-30 10:00:00 | IWM | ETF | 198.68 | 198.86 | 197.27 | 197.685 | 5564642.0 |
| 2024-01-30 11:00:00 | IWM | ETF | 197.67 | 198.29 | 197.37 | 198.165 | 3050592.0 |
| 2024-01-30 12:00:00 | IWM | ETF | 198.17 | 198.175 | 197.101 | 197.295 | 2792153.0 |
| 2024-01-30 13:00:00 | IWM | ETF | 197.29 | 197.79 | 197.1 | 197.7 | 1770209.0 |
| 2024-01-30 14:00:00 | IWM | ETF | 197.71 | 198.085 | 197.52 | 198.02 | 2026099.0 |
| 2024-01-30 15:00:00 | IWM | ETF | 198.025 | 198.08 | 197.641 | 197.68 | 4825925.0 |
| 2024-01-30 16:00:00 | IWM | ETF | 197.67 | 198.35 | 197.51 | 198.15 | 939940.0 |
| 2024-01-30 17:00:00 | IWM | ETF | 198.13 | 198.24 | 197.2 | 197.32 | 317873.0 |
| 2024-01-30 18:00:00 | IWM | ETF | 197.49 | 198.41 | 197.49 | 198.12 | 240983.0 |
| 2024-01-30 19:00:00 | IWM | ETF | 198.12 | 198.43 | 198.12 | 198.17 | 89317.0 |
| 2024-01-30 04:00:00 | DIA | ETF | 382.87 | 382.91 | 382.79 | 382.87 | 1483.0 |
| 2024-01-30 06:00:00 | DIA | ETF | 382.81 | 382.83 | 382.81 | 382.83 | 200.0 |
> showing 50 of 19,675 rows — these rows as CSV