PREVIEW / etf_1hour / 2025-03-31
file: by_date/etf_1hour/2025/2025-03-31.parquet size: 650 KB rows: 25,634
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-03-31 04:00:00 | SPY | ETF | 552.6 | 552.6 | 550.76 | 550.81 | 97571.0 |
| 2025-03-31 05:00:00 | SPY | ETF | 550.73 | 551.08 | 549.81 | 550.42 | 78796.0 |
| 2025-03-31 06:00:00 | SPY | ETF | 550.47 | 551.06 | 550.13 | 550.69 | 203198.0 |
| 2025-03-31 07:00:00 | SPY | ETF | 550.75 | 551.0 | 548.701 | 549.79 | 373054.0 |
| 2025-03-31 08:00:00 | SPY | ETF | 550.81 | 552.45 | 548.7204 | 550.81 | 443526.0 |
| 2025-03-31 09:00:00 | SPY | ETF | 550.9 | 551.2 | 546.87 | 549.74 | 7047886.0 |
| 2025-03-31 10:00:00 | SPY | ETF | 549.75 | 551.98 | 549.43 | 551.6 | 5654298.0 |
| 2025-03-31 11:00:00 | SPY | ETF | 551.61 | 554.12 | 551.236 | 553.32 | 4220574.0 |
| 2025-03-31 12:00:00 | SPY | ETF | 553.32 | 554.59 | 551.915 | 553.33 | 2730230.0 |
| 2025-03-31 13:00:00 | SPY | ETF | 553.26 | 555.16 | 552.71 | 553.16 | 3199013.0 |
| 2025-03-31 14:00:00 | SPY | ETF | 553.15 | 557.95 | 553.02 | 556.39 | 8628355.0 |
| 2025-03-31 15:00:00 | SPY | ETF | 556.39 | 560.7112 | 556.365 | 559.15 | 19665108.0 |
| 2025-03-31 16:00:00 | SPY | ETF | 559.14 | 559.39 | 557.56 | 557.97 | 9209871.0 |
| 2025-03-31 17:00:00 | SPY | ETF | 557.96 | 558.2 | 557.96 | 558.09 | 66339.0 |
| 2025-03-31 18:00:00 | SPY | ETF | 558.01 | 558.06 | 556.2 | 557.41 | 298192.0 |
| 2025-03-31 19:00:00 | SPY | ETF | 557.3717 | 558.04 | 556.75 | 557.001 | 74453.0 |
| 2025-03-31 04:00:00 | QQQ | ETF | 464.66 | 464.66 | 462.82 | 462.84 | 159328.0 |
| 2025-03-31 05:00:00 | QQQ | ETF | 462.73 | 463.58 | 461.9 | 462.64 | 90954.0 |
| 2025-03-31 06:00:00 | QQQ | ETF | 462.65 | 463.48 | 462.33 | 463.06 | 173647.0 |
| 2025-03-31 07:00:00 | QQQ | ETF | 463.13 | 463.31 | 460.71 | 462.09 | 383779.0 |
| 2025-03-31 08:00:00 | QQQ | ETF | 462.77 | 469.291 | 460.88 | 463.21 | 505391.0 |
| 2025-03-31 09:00:00 | QQQ | ETF | 463.25 | 463.57 | 457.33 | 460.02 | 7613287.0 |
| 2025-03-31 10:00:00 | QQQ | ETF | 460.03 | 461.9568 | 459.26 | 461.29 | 4928014.0 |
| 2025-03-31 11:00:00 | QQQ | ETF | 461.3 | 464.27 | 460.71 | 463.28 | 4304954.0 |
| 2025-03-31 12:00:00 | QQQ | ETF | 463.3 | 464.83 | 462.15 | 463.16 | 2594867.0 |
| 2025-03-31 13:00:00 | QQQ | ETF | 463.18 | 465.34 | 462.9513 | 463.32 | 1877627.0 |
| 2025-03-31 14:00:00 | QQQ | ETF | 463.32 | 468.0 | 463.21 | 466.3855 | 4268613.0 |
| 2025-03-31 15:00:00 | QQQ | ETF | 466.36 | 469.86 | 466.34 | 468.93 | 7701356.0 |
| 2025-03-31 16:00:00 | QQQ | ETF | 468.92 | 468.97 | 467.54 | 467.99 | 2196776.0 |
| 2025-03-31 17:00:00 | QQQ | ETF | 468.0 | 468.1 | 467.8106 | 468.07 | 28203.0 |
| 2025-03-31 18:00:00 | QQQ | ETF | 468.07 | 468.07 | 465.931 | 467.1 | 204491.0 |
| 2025-03-31 19:00:00 | QQQ | ETF | 466.98 | 467.849 | 466.251 | 466.65 | 81965.0 |
| 2025-03-31 04:00:00 | IWM | ETF | 198.7 | 198.88 | 198.14 | 198.15 | 31324.0 |
| 2025-03-31 05:00:00 | IWM | ETF | 198.09 | 198.38 | 197.86 | 198.06 | 23999.0 |
| 2025-03-31 06:00:00 | IWM | ETF | 198.14 | 198.22 | 197.9 | 198.05 | 25037.0 |
| 2025-03-31 07:00:00 | IWM | ETF | 198.13 | 198.22 | 197.58 | 197.77 | 92464.0 |
| 2025-03-31 08:00:00 | IWM | ETF | 197.9 | 198.83 | 197.61 | 197.94 | 205340.0 |
| 2025-03-31 09:00:00 | IWM | ETF | 198.0 | 198.06 | 195.49 | 197.22 | 4232518.0 |
| 2025-03-31 10:00:00 | IWM | ETF | 197.235 | 198.37 | 197.16 | 198.1191 | 2974520.0 |
| 2025-03-31 11:00:00 | IWM | ETF | 198.12 | 198.87 | 198.11 | 198.38 | 1675673.0 |
| 2025-03-31 12:00:00 | IWM | ETF | 198.41 | 198.9 | 197.75 | 198.28 | 1302360.0 |
| 2025-03-31 13:00:00 | IWM | ETF | 198.275 | 198.96 | 198.05 | 198.26 | 2104752.0 |
| 2025-03-31 14:00:00 | IWM | ETF | 198.26 | 199.96 | 198.225 | 199.42 | 2815453.0 |
| 2025-03-31 15:00:00 | IWM | ETF | 199.42 | 200.64 | 199.4 | 199.54 | 4480112.0 |
| 2025-03-31 16:00:00 | IWM | ETF | 199.49 | 199.5447 | 199.1 | 199.36 | 3769633.0 |
| 2025-03-31 17:00:00 | IWM | ETF | 199.31 | 199.56 | 199.3 | 199.48 | 28302.0 |
| 2025-03-31 18:00:00 | IWM | ETF | 199.37 | 199.48 | 198.6 | 199.08 | 57173.0 |
| 2025-03-31 19:00:00 | IWM | ETF | 199.06 | 199.35 | 198.82 | 199.13 | 8961.0 |
| 2025-03-31 04:00:00 | DIA | ETF | 413.98 | 414.2 | 413.61 | 413.83 | 3600.0 |
| 2025-03-31 05:00:00 | DIA | ETF | 412.91 | 413.28 | 412.91 | 413.19 | 4336.0 |
> showing 50 of 25,634 rows — these rows as CSV