PREVIEW / etf_1hour / 2025-04-02
file: by_date/etf_1hour/2025/2025-04-02.parquet size: 650 KB rows: 25,269
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-04-02 04:00:00 | SPY | ETF | 559.66 | 560.16 | 558.97 | 559.36 | 21626.0 |
| 2025-04-02 05:00:00 | SPY | ETF | 559.34 | 559.8 | 559.0 | 559.04 | 9873.0 |
| 2025-04-02 06:00:00 | SPY | ETF | 559.1 | 559.19 | 557.6 | 557.95 | 323218.0 |
| 2025-04-02 07:00:00 | SPY | ETF | 557.99 | 558.25 | 557.11 | 557.16 | 176560.0 |
| 2025-04-02 08:00:00 | SPY | ETF | 557.53 | 560.83 | 555.0 | 556.16 | 593060.0 |
| 2025-04-02 09:00:00 | SPY | ETF | 556.18 | 559.78 | 554.81 | 558.73 | 4434779.0 |
| 2025-04-02 10:00:00 | SPY | ETF | 558.71 | 562.2696 | 558.29 | 562.09 | 4079581.0 |
| 2025-04-02 11:00:00 | SPY | ETF | 562.07 | 563.75 | 560.86 | 562.2836 | 4326152.0 |
| 2025-04-02 12:00:00 | SPY | ETF | 562.31 | 566.06 | 562.08 | 565.68 | 4113939.0 |
| 2025-04-02 13:00:00 | SPY | ETF | 565.69 | 567.42 | 563.21 | 564.1 | 5235188.0 |
| 2025-04-02 14:00:00 | SPY | ETF | 564.08 | 564.45 | 560.96 | 561.11 | 4586639.0 |
| 2025-04-02 15:00:00 | SPY | ETF | 561.15 | 565.655 | 561.135 | 564.65 | 8843823.0 |
| 2025-04-02 16:00:00 | SPY | ETF | 564.64 | 570.74 | 550.5 | 552.29 | 14706238.0 |
| 2025-04-02 17:00:00 | SPY | ETF | 552.3 | 552.42 | 546.36 | 547.3 | 3102874.0 |
| 2025-04-02 18:00:00 | SPY | ETF | 547.25 | 548.77 | 542.2 | 546.58 | 1688268.0 |
| 2025-04-02 19:00:00 | SPY | ETF | 546.48 | 546.48 | 544.0 | 544.83 | 579371.0 |
| 2025-04-02 04:00:00 | QQQ | ETF | 471.0 | 471.76 | 470.2 | 470.91 | 47790.0 |
| 2025-04-02 05:00:00 | QQQ | ETF | 470.83 | 471.31 | 470.58 | 470.58 | 28029.0 |
| 2025-04-02 06:00:00 | QQQ | ETF | 470.56 | 470.7 | 469.14 | 469.59 | 86678.0 |
| 2025-04-02 07:00:00 | QQQ | ETF | 469.54 | 469.75 | 468.43 | 468.56 | 171272.0 |
| 2025-04-02 08:00:00 | QQQ | ETF | 469.37 | 472.23 | 466.48 | 467.52 | 670902.0 |
| 2025-04-02 09:00:00 | QQQ | ETF | 467.45 | 472.15 | 465.86 | 470.97 | 3478499.0 |
| 2025-04-02 10:00:00 | QQQ | ETF | 470.95 | 473.54 | 469.99 | 473.4085 | 4034809.0 |
| 2025-04-02 11:00:00 | QQQ | ETF | 473.34 | 475.33 | 472.085 | 474.26 | 3768248.0 |
| 2025-04-02 12:00:00 | QQQ | ETF | 474.195 | 478.11 | 474.03 | 477.73 | 3331221.0 |
| 2025-04-02 13:00:00 | QQQ | ETF | 477.74 | 479.56 | 475.31 | 476.085 | 3517747.0 |
| 2025-04-02 14:00:00 | QQQ | ETF | 476.04 | 476.45 | 472.68 | 472.79 | 3537724.0 |
| 2025-04-02 15:00:00 | QQQ | ETF | 472.79 | 477.25 | 472.79 | 476.15 | 4936663.0 |
| 2025-04-02 16:00:00 | QQQ | ETF | 476.14 | 483.21 | 460.0 | 461.52 | 7009553.0 |
| 2025-04-02 17:00:00 | QQQ | ETF | 461.67 | 462.96 | 458.0 | 458.23 | 1838495.0 |
| 2025-04-02 18:00:00 | QQQ | ETF | 458.49 | 459.0 | 453.86 | 456.76 | 1592258.0 |
| 2025-04-02 19:00:00 | QQQ | ETF | 456.6299 | 456.6299 | 454.54 | 455.2 | 537755.0 |
| 2025-04-02 04:00:00 | IWM | ETF | 198.88 | 198.99 | 198.7 | 198.72 | 13111.0 |
| 2025-04-02 05:00:00 | IWM | ETF | 198.74 | 198.96 | 198.65 | 198.65 | 2934.0 |
| 2025-04-02 06:00:00 | IWM | ETF | 198.69 | 198.69 | 198.16 | 198.4 | 39556.0 |
| 2025-04-02 07:00:00 | IWM | ETF | 198.48 | 198.48 | 197.81 | 197.91 | 50357.0 |
| 2025-04-02 08:00:00 | IWM | ETF | 198.33 | 199.24 | 196.96 | 197.28 | 140995.0 |
| 2025-04-02 09:00:00 | IWM | ETF | 197.19 | 199.59 | 196.54 | 198.55 | 2953304.0 |
| 2025-04-02 10:00:00 | IWM | ETF | 198.54 | 200.86 | 198.42 | 200.67 | 2523854.0 |
| 2025-04-02 11:00:00 | IWM | ETF | 200.67 | 201.67 | 200.25 | 201.25 | 2611051.0 |
| 2025-04-02 12:00:00 | IWM | ETF | 201.27 | 202.73 | 201.19 | 202.55 | 1796087.0 |
| 2025-04-02 13:00:00 | IWM | ETF | 202.56 | 203.33 | 201.26 | 201.78 | 3892637.0 |
| 2025-04-02 14:00:00 | IWM | ETF | 201.77 | 202.1598 | 200.71 | 201.13 | 2318099.0 |
| 2025-04-02 15:00:00 | IWM | ETF | 201.14 | 202.99 | 201.14 | 202.7 | 4030572.0 |
| 2025-04-02 16:00:00 | IWM | ETF | 202.7 | 206.01 | 194.5 | 194.5 | 6969036.0 |
| 2025-04-02 17:00:00 | IWM | ETF | 194.76 | 195.0 | 192.84 | 192.95 | 773409.0 |
| 2025-04-02 18:00:00 | IWM | ETF | 192.86 | 194.0 | 191.43 | 193.02 | 642415.0 |
| 2025-04-02 19:00:00 | IWM | ETF | 192.8 | 193.0 | 192.0 | 192.44 | 128589.0 |
| 2025-04-02 04:00:00 | DIA | ETF | 418.8 | 418.89 | 418.63 | 418.89 | 4108.0 |
| 2025-04-02 05:00:00 | DIA | ETF | 418.62 | 418.78 | 418.6 | 418.78 | 500.0 |
> showing 50 of 25,269 rows — these rows as CSV