PREVIEW / etf_1hour / 2024-04-24
file: by_date/etf_1hour/2024/2024-04-24.parquet size: 530 KB rows: 19,632
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-04-24 04:00:00 | SPY | ETF | 506.74 | 506.97 | 506.3 | 506.31 | 35688.0 |
| 2024-04-24 05:00:00 | SPY | ETF | 506.31 | 506.4 | 505.6 | 505.86 | 37091.0 |
| 2024-04-24 06:00:00 | SPY | ETF | 505.89 | 506.34 | 505.83 | 505.96 | 31771.0 |
| 2024-04-24 07:00:00 | SPY | ETF | 505.99 | 506.89 | 505.9 | 506.83 | 259653.0 |
| 2024-04-24 08:00:00 | SPY | ETF | 506.02 | 507.6 | 505.8997 | 506.0301 | 428666.0 |
| 2024-04-24 09:00:00 | SPY | ETF | 506.03 | 507.37 | 505.77 | 506.2499 | 5800533.0 |
| 2024-04-24 10:00:00 | SPY | ETF | 506.24 | 507.1334 | 504.98 | 505.24 | 5718085.0 |
| 2024-04-24 11:00:00 | SPY | ETF | 505.22 | 505.39 | 503.6 | 503.75 | 6047566.0 |
| 2024-04-24 12:00:00 | SPY | ETF | 503.74 | 504.41 | 503.13 | 504.325 | 4892273.0 |
| 2024-04-24 13:00:00 | SPY | ETF | 504.32 | 506.545 | 504.06 | 506.43 | 4842192.0 |
| 2024-04-24 14:00:00 | SPY | ETF | 506.44 | 506.51 | 504.4 | 504.43 | 4002100.0 |
| 2024-04-24 15:00:00 | SPY | ETF | 504.44 | 506.19 | 504.23 | 505.47 | 7356354.0 |
| 2024-04-24 16:00:00 | SPY | ETF | 505.46 | 505.78 | 502.23 | 502.85 | 3477262.0 |
| 2024-04-24 17:00:00 | SPY | ETF | 502.83 | 502.9 | 501.63 | 501.9 | 209670.0 |
| 2024-04-24 18:00:00 | SPY | ETF | 501.9 | 502.67 | 501.9 | 502.34 | 187178.0 |
| 2024-04-24 19:00:00 | SPY | ETF | 502.41 | 502.69 | 502.12 | 502.45 | 80337.0 |
| 2024-04-24 04:00:00 | QQQ | ETF | 428.06 | 428.13 | 427.21 | 427.35 | 89052.0 |
| 2024-04-24 05:00:00 | QQQ | ETF | 427.39 | 427.64 | 426.71 | 427.02 | 64132.0 |
| 2024-04-24 06:00:00 | QQQ | ETF | 426.97 | 427.71 | 426.94 | 427.33 | 134362.0 |
| 2024-04-24 07:00:00 | QQQ | ETF | 427.35 | 428.14 | 427.27 | 428.12 | 351276.0 |
| 2024-04-24 08:00:00 | QQQ | ETF | 427.5 | 428.73 | 425.07 | 427.55 | 675818.0 |
| 2024-04-24 09:00:00 | QQQ | ETF | 427.54 | 429.73 | 427.16 | 428.31 | 5422774.0 |
| 2024-04-24 10:00:00 | QQQ | ETF | 428.32 | 429.25 | 426.8825 | 427.26 | 5012019.0 |
| 2024-04-24 11:00:00 | QQQ | ETF | 427.265 | 427.43 | 425.05 | 425.1599 | 4279169.0 |
| 2024-04-24 12:00:00 | QQQ | ETF | 425.14 | 425.76 | 424.2 | 425.55 | 3805689.0 |
| 2024-04-24 13:00:00 | QQQ | ETF | 425.55 | 427.56 | 425.21 | 427.4 | 4165439.0 |
| 2024-04-24 14:00:00 | QQQ | ETF | 427.4 | 427.5 | 425.26 | 425.31 | 3416016.0 |
| 2024-04-24 15:00:00 | QQQ | ETF | 425.31 | 427.11 | 425.17 | 426.43 | 5600984.0 |
| 2024-04-24 16:00:00 | QQQ | ETF | 426.43 | 426.9 | 421.96 | 422.72 | 3417116.0 |
| 2024-04-24 17:00:00 | QQQ | ETF | 422.71 | 422.73 | 420.48 | 420.9 | 589910.0 |
| 2024-04-24 18:00:00 | QQQ | ETF | 420.93 | 426.51 | 420.9 | 421.78 | 525674.0 |
| 2024-04-24 19:00:00 | QQQ | ETF | 421.86 | 422.12 | 421.32 | 421.69 | 184613.0 |
| 2024-04-24 04:00:00 | IWM | ETF | 198.25 | 198.39 | 197.92 | 197.92 | 27634.0 |
| 2024-04-24 05:00:00 | IWM | ETF | 197.99 | 198.23 | 197.78 | 197.89 | 14302.0 |
| 2024-04-24 06:00:00 | IWM | ETF | 197.85 | 198.0 | 197.66 | 197.73 | 7450.0 |
| 2024-04-24 07:00:00 | IWM | ETF | 197.73 | 198.11 | 197.65 | 198.07 | 105775.0 |
| 2024-04-24 08:00:00 | IWM | ETF | 197.74 | 198.9 | 197.58 | 197.74 | 171995.0 |
| 2024-04-24 09:00:00 | IWM | ETF | 197.75 | 198.91 | 197.14 | 198.44 | 3320408.0 |
| 2024-04-24 10:00:00 | IWM | ETF | 198.46 | 198.9103 | 197.4 | 197.58 | 3284909.0 |
| 2024-04-24 11:00:00 | IWM | ETF | 197.62 | 197.71 | 196.4601 | 196.74 | 3034848.0 |
| 2024-04-24 12:00:00 | IWM | ETF | 196.73 | 197.13 | 196.46 | 197.09 | 1778161.0 |
| 2024-04-24 13:00:00 | IWM | ETF | 197.09 | 197.97 | 196.95 | 197.92 | 1829987.0 |
| 2024-04-24 14:00:00 | IWM | ETF | 197.915 | 197.93 | 197.01 | 197.22 | 1860472.0 |
| 2024-04-24 15:00:00 | IWM | ETF | 197.22 | 198.05 | 196.99 | 197.68 | 3682602.0 |
| 2024-04-24 16:00:00 | IWM | ETF | 197.68 | 198.17 | 197.47 | 198.12 | 2659040.0 |
| 2024-04-24 17:00:00 | IWM | ETF | 198.1 | 198.1 | 197.25 | 197.68 | 121467.0 |
| 2024-04-24 18:00:00 | IWM | ETF | 197.56 | 198.13 | 197.55 | 197.69 | 200307.0 |
| 2024-04-24 19:00:00 | IWM | ETF | 197.7 | 197.89 | 197.51 | 197.58 | 48529.0 |
| 2024-04-24 04:00:00 | DIA | ETF | 385.01 | 385.3 | 384.92 | 385.13 | 2497.0 |
| 2024-04-24 05:00:00 | DIA | ETF | 385.12 | 385.12 | 385.04 | 385.04 | 336.0 |
> showing 50 of 19,632 rows — these rows as CSV