PREVIEW / etf_1hour / 2024-04-30
file: by_date/etf_1hour/2024/2024-04-30.parquet size: 540 KB rows: 19,883
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-30 04:00:00 | SPY | ETF | 509.71 | 509.71 | 509.1 | 509.15 | 6668.0 |
| 2024-04-30 05:00:00 | SPY | ETF | 509.0 | 509.58 | 509.0 | 509.37 | 8039.0 |
| 2024-04-30 06:00:00 | SPY | ETF | 509.36 | 509.9 | 509.32 | 509.9 | 17838.0 |
| 2024-04-30 07:00:00 | SPY | ETF | 509.9 | 510.0 | 509.5 | 509.58 | 74706.0 |
| 2024-04-30 08:00:00 | SPY | ETF | 509.9002 | 509.93 | 507.54 | 508.14 | 725027.0 |
| 2024-04-30 09:00:00 | SPY | ETF | 508.19 | 509.54 | 507.89 | 509.1308 | 3768957.0 |
| 2024-04-30 10:00:00 | SPY | ETF | 509.16 | 509.56 | 508.11 | 508.64 | 5109277.0 |
| 2024-04-30 11:00:00 | SPY | ETF | 508.65 | 508.66 | 506.03 | 506.61 | 7034904.0 |
| 2024-04-30 12:00:00 | SPY | ETF | 506.61 | 507.03 | 504.8 | 505.29 | 6027991.0 |
| 2024-04-30 13:00:00 | SPY | ETF | 505.3 | 506.265 | 504.71 | 506.11 | 4988382.0 |
| 2024-04-30 14:00:00 | SPY | ETF | 506.105 | 506.54 | 504.4 | 504.795 | 5845083.0 |
| 2024-04-30 15:00:00 | SPY | ETF | 504.795 | 505.29 | 502.03 | 502.04 | 15828026.0 |
| 2024-04-30 16:00:00 | SPY | ETF | 502.04 | 503.95 | 500.66 | 501.0 | 6696143.0 |
| 2024-04-30 17:00:00 | SPY | ETF | 501.0 | 501.98 | 500.15 | 500.35 | 288278.0 |
| 2024-04-30 18:00:00 | SPY | ETF | 500.4 | 501.2 | 500.4 | 501.12 | 160218.0 |
| 2024-04-30 19:00:00 | SPY | ETF | 501.06 | 501.43 | 500.85 | 501.28 | 51246.0 |
| 2024-04-30 20:00:00 | SPY | ETF | 501.3 | 501.3 | 501.3 | 501.3 | 326.0 |
| 2024-04-30 04:00:00 | QQQ | ETF | 432.75 | 432.79 | 432.0 | 432.0 | 40696.0 |
| 2024-04-30 05:00:00 | QQQ | ETF | 431.9 | 432.32 | 431.79 | 431.93 | 15093.0 |
| 2024-04-30 06:00:00 | QQQ | ETF | 432.06 | 432.55 | 431.96 | 432.51 | 29075.0 |
| 2024-04-30 07:00:00 | QQQ | ETF | 432.46 | 432.56 | 432.0 | 432.08 | 117058.0 |
| 2024-04-30 08:00:00 | QQQ | ETF | 432.53 | 433.074 | 430.07 | 430.9 | 469596.0 |
| 2024-04-30 09:00:00 | QQQ | ETF | 430.94 | 432.36 | 430.59 | 431.97 | 2632352.0 |
| 2024-04-30 10:00:00 | QQQ | ETF | 431.9631 | 432.56 | 430.7 | 431.2 | 3242169.0 |
| 2024-04-30 11:00:00 | QQQ | ETF | 431.19 | 431.23 | 428.65 | 429.43 | 3742754.0 |
| 2024-04-30 12:00:00 | QQQ | ETF | 429.43 | 429.6995 | 427.46 | 427.98 | 3135728.0 |
| 2024-04-30 13:00:00 | QQQ | ETF | 427.99 | 428.7701 | 427.3 | 428.56 | 2327457.0 |
| 2024-04-30 14:00:00 | QQQ | ETF | 428.57 | 428.97 | 427.12 | 427.4205 | 2699562.0 |
| 2024-04-30 15:00:00 | QQQ | ETF | 427.43 | 428.05 | 424.51 | 424.53 | 9714867.0 |
| 2024-04-30 16:00:00 | QQQ | ETF | 424.53 | 426.16 | 422.48 | 423.22 | 3036742.0 |
| 2024-04-30 17:00:00 | QQQ | ETF | 423.24 | 423.3 | 422.12 | 422.24 | 259931.0 |
| 2024-04-30 18:00:00 | QQQ | ETF | 422.13 | 424.59 | 421.99 | 422.92 | 225987.0 |
| 2024-04-30 19:00:00 | QQQ | ETF | 422.92 | 423.27 | 422.6 | 423.17 | 76434.0 |
| 2024-04-30 04:00:00 | IWM | ETF | 199.53 | 199.59 | 199.15 | 199.15 | 10071.0 |
| 2024-04-30 05:00:00 | IWM | ETF | 199.15 | 199.28 | 198.96 | 199.07 | 8354.0 |
| 2024-04-30 06:00:00 | IWM | ETF | 199.1 | 199.12 | 199.02 | 199.11 | 19361.0 |
| 2024-04-30 07:00:00 | IWM | ETF | 199.08 | 199.26 | 198.84 | 198.95 | 131428.0 |
| 2024-04-30 08:00:00 | IWM | ETF | 199.1 | 199.52 | 197.13 | 197.99 | 407092.0 |
| 2024-04-30 09:00:00 | IWM | ETF | 197.88 | 198.65 | 197.16 | 198.2525 | 2698352.0 |
| 2024-04-30 10:00:00 | IWM | ETF | 198.21 | 198.61 | 197.58 | 197.98 | 2430184.0 |
| 2024-04-30 11:00:00 | IWM | ETF | 197.975 | 198.13 | 197.04 | 197.35 | 2276270.0 |
| 2024-04-30 12:00:00 | IWM | ETF | 197.345 | 197.5 | 196.49 | 196.74 | 1696269.0 |
| 2024-04-30 13:00:00 | IWM | ETF | 196.74 | 197.255 | 196.631 | 197.2 | 2461211.0 |
| 2024-04-30 14:00:00 | IWM | ETF | 197.2 | 197.33 | 196.495 | 196.63 | 1450994.0 |
| 2024-04-30 15:00:00 | IWM | ETF | 196.62 | 196.88 | 195.75 | 195.85 | 5506332.0 |
| 2024-04-30 16:00:00 | IWM | ETF | 195.9 | 196.5304 | 195.04 | 195.51 | 3968357.0 |
| 2024-04-30 17:00:00 | IWM | ETF | 195.42 | 195.5 | 195.21 | 195.28 | 18915.0 |
| 2024-04-30 18:00:00 | IWM | ETF | 195.33 | 195.9 | 195.19 | 195.41 | 57230.0 |
| 2024-04-30 19:00:00 | IWM | ETF | 195.42 | 195.55 | 195.28 | 195.44 | 32038.0 |
| 2024-04-30 04:00:00 | DIA | ETF | 383.46 | 383.46 | 383.46 | 383.46 | 200.0 |
> showing 50 of 19,883 rows — these rows as CSV