PREVIEW / etf_1hour / 2025-05-23
file: by_date/etf_1hour/2025/2025-05-23.parquet size: 620 KB rows: 24,243
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 |
|---|---|---|---|---|---|---|---|
| 2025-05-23 04:00:00 | SPY | ETF | 584.22 | 584.66 | 583.57 | 583.64 | 20972.0 |
| 2025-05-23 05:00:00 | SPY | ETF | 583.5 | 583.5 | 581.9 | 583.5 | 18405.0 |
| 2025-05-23 06:00:00 | SPY | ETF | 583.29 | 583.49 | 582.48 | 583.14 | 19492.0 |
| 2025-05-23 07:00:00 | SPY | ETF | 583.16 | 583.4 | 574.33 | 575.09 | 1789266.0 |
| 2025-05-23 08:00:00 | SPY | ETF | 575.13 | 584.4 | 573.26 | 575.04 | 2113050.0 |
| 2025-05-23 09:00:00 | SPY | ETF | 575.05 | 578.16 | 573.94 | 576.77 | 9494874.0 |
| 2025-05-23 10:00:00 | SPY | ETF | 576.84 | 578.9499 | 576.69 | 577.12 | 7497777.0 |
| 2025-05-23 11:00:00 | SPY | ETF | 577.13 | 579.73 | 576.8094 | 578.03 | 4989127.0 |
| 2025-05-23 12:00:00 | SPY | ETF | 578.04 | 579.62 | 577.52 | 579.0 | 4107036.0 |
| 2025-05-23 13:00:00 | SPY | ETF | 579.0 | 581.46 | 578.73 | 580.82 | 4431906.0 |
| 2025-05-23 14:00:00 | SPY | ETF | 580.82 | 581.8101 | 579.99 | 580.73 | 4975111.0 |
| 2025-05-23 15:00:00 | SPY | ETF | 580.73 | 581.45 | 578.49 | 579.16 | 10862326.0 |
| 2025-05-23 16:00:00 | SPY | ETF | 579.17 | 579.18 | 578.22 | 579.0 | 2451089.0 |
| 2025-05-23 17:00:00 | SPY | ETF | 578.81 | 579.08 | 578.8 | 578.8 | 49613.0 |
| 2025-05-23 18:00:00 | SPY | ETF | 578.8 | 578.95 | 578.7 | 578.8882 | 15310.0 |
| 2025-05-23 19:00:00 | SPY | ETF | 578.78 | 579.1 | 578.75 | 579.0 | 20036.0 |
| 2025-05-23 04:00:00 | QQQ | ETF | 514.84 | 515.4 | 514.26 | 514.4 | 56590.0 |
| 2025-05-23 05:00:00 | QQQ | ETF | 514.27 | 514.49 | 512.78 | 514.23 | 80937.0 |
| 2025-05-23 06:00:00 | QQQ | ETF | 514.26 | 514.45 | 513.36 | 514.09 | 29638.0 |
| 2025-05-23 07:00:00 | QQQ | ETF | 514.1 | 514.26 | 505.18 | 505.67 | 1081881.0 |
| 2025-05-23 08:00:00 | QQQ | ETF | 514.23 | 515.327 | 503.28 | 505.09 | 1657619.0 |
| 2025-05-23 09:00:00 | QQQ | ETF | 504.87 | 508.715 | 504.0 | 507.14 | 7513527.0 |
| 2025-05-23 10:00:00 | QQQ | ETF | 507.15 | 509.68 | 506.98 | 507.67 | 5795436.0 |
| 2025-05-23 11:00:00 | QQQ | ETF | 507.67 | 510.03 | 507.06 | 508.27 | 4356031.0 |
| 2025-05-23 12:00:00 | QQQ | ETF | 508.265 | 509.96 | 507.88 | 509.43 | 4189874.0 |
| 2025-05-23 13:00:00 | QQQ | ETF | 509.43 | 511.59 | 509.16 | 511.1401 | 3925761.0 |
| 2025-05-23 14:00:00 | QQQ | ETF | 511.12 | 511.84 | 509.98 | 510.75 | 3658734.0 |
| 2025-05-23 15:00:00 | QQQ | ETF | 510.76 | 511.5 | 508.82 | 509.2865 | 6803584.0 |
| 2025-05-23 16:00:00 | QQQ | ETF | 509.3 | 509.32 | 508.2 | 508.69 | 1834860.0 |
| 2025-05-23 17:00:00 | QQQ | ETF | 508.67 | 508.75 | 508.4 | 508.44 | 22643.0 |
| 2025-05-23 18:00:00 | QQQ | ETF | 508.5801 | 508.5801 | 508.19 | 508.2 | 8059.0 |
| 2025-05-23 19:00:00 | QQQ | ETF | 508.31 | 508.4865 | 508.28 | 508.34 | 17015.0 |
| 2025-05-23 04:00:00 | IWM | ETF | 204.2 | 204.2 | 203.8 | 203.94 | 23753.0 |
| 2025-05-23 05:00:00 | IWM | ETF | 203.71 | 203.72 | 203.04 | 203.72 | 10342.0 |
| 2025-05-23 06:00:00 | IWM | ETF | 203.5 | 203.64 | 203.26 | 203.64 | 8644.0 |
| 2025-05-23 07:00:00 | IWM | ETF | 203.64 | 203.64 | 198.82 | 199.12 | 757421.0 |
| 2025-05-23 08:00:00 | IWM | ETF | 203.36 | 204.21 | 196.58 | 199.2 | 1130755.0 |
| 2025-05-23 09:00:00 | IWM | ETF | 199.15 | 201.89 | 198.5 | 201.55 | 4151627.0 |
| 2025-05-23 10:00:00 | IWM | ETF | 201.55 | 202.215 | 201.12 | 201.36 | 3206750.0 |
| 2025-05-23 11:00:00 | IWM | ETF | 201.39 | 202.5 | 201.31 | 201.83 | 1912382.0 |
| 2025-05-23 12:00:00 | IWM | ETF | 201.84 | 202.59 | 201.76 | 202.33 | 1819408.0 |
| 2025-05-23 13:00:00 | IWM | ETF | 202.33 | 203.12 | 202.28 | 202.92 | 1620937.0 |
| 2025-05-23 14:00:00 | IWM | ETF | 202.92 | 203.22 | 202.49 | 202.845 | 1858109.0 |
| 2025-05-23 15:00:00 | IWM | ETF | 202.84 | 203.255 | 202.27 | 202.55 | 4494464.0 |
| 2025-05-23 16:00:00 | IWM | ETF | 202.56 | 202.57 | 202.22 | 202.36 | 662306.0 |
| 2025-05-23 17:00:00 | IWM | ETF | 202.28 | 202.48 | 202.22 | 202.32 | 4143.0 |
| 2025-05-23 18:00:00 | IWM | ETF | 202.37 | 202.47 | 202.3 | 202.3 | 4076.0 |
| 2025-05-23 19:00:00 | IWM | ETF | 202.3 | 202.65 | 202.3 | 202.3 | 10264.0 |
| 2025-05-23 04:00:00 | DIA | ETF | 418.9 | 419.65 | 418.9 | 419.14 | 2184.0 |
| 2025-05-23 05:00:00 | DIA | ETF | 418.81 | 418.86 | 417.91 | 418.26 | 2950.0 |
> showing 50 of 24,243 rows — these rows as CSV