PREVIEW / etf_1hour / 2026-05-21
file: by_date/etf_1hour/2026/2026-05-21.parquet size: 714 KB rows: 28,535
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 |
|---|---|---|---|---|---|---|---|
| 2026-05-21 04:00:00 | SPY | ETF | 739.2293 | 743.21 | 739.0 | 741.6 | 121180.0 |
| 2026-05-21 05:00:00 | SPY | ETF | 741.56 | 742.62 | 741.45 | 741.91 | 29624.0 |
| 2026-05-21 06:00:00 | SPY | ETF | 741.79 | 742.1 | 737.87 | 738.65 | 195364.0 |
| 2026-05-21 07:00:00 | SPY | ETF | 738.68 | 740.05 | 738.2 | 739.3387 | 211585.0 |
| 2026-05-21 08:00:00 | SPY | ETF | 739.34 | 740.63 | 738.1 | 738.11 | 273376.0 |
| 2026-05-21 09:00:00 | SPY | ETF | 738.22 | 740.18 | 737.4146 | 739.79 | 4243792.0 |
| 2026-05-21 10:00:00 | SPY | ETF | 739.78 | 740.615 | 737.44 | 738.91 | 4129143.0 |
| 2026-05-21 11:00:00 | SPY | ETF | 738.96 | 739.81 | 737.03 | 739.3 | 3845429.0 |
| 2026-05-21 12:00:00 | SPY | ETF | 739.3 | 739.96 | 738.09 | 738.9 | 2779433.0 |
| 2026-05-21 13:00:00 | SPY | ETF | 738.93 | 744.87 | 738.93 | 743.68 | 6557663.0 |
| 2026-05-21 14:00:00 | SPY | ETF | 743.68 | 744.11 | 740.08 | 741.0268 | 5500109.0 |
| 2026-05-21 15:00:00 | SPY | ETF | 741.04 | 743.16 | 740.98 | 742.75 | 6856688.0 |
| 2026-05-21 16:00:00 | SPY | ETF | 742.72 | 743.22 | 742.56 | 742.93 | 1800813.0 |
| 2026-05-21 17:00:00 | SPY | ETF | 742.99 | 743.15 | 742.9 | 742.97 | 22909.0 |
| 2026-05-21 18:00:00 | SPY | ETF | 743.0293 | 744.12 | 743.0293 | 744.0058 | 69299.0 |
| 2026-05-21 19:00:00 | SPY | ETF | 744.0 | 744.56 | 743.9 | 744.1311 | 36867.0 |
| 2026-05-21 04:00:00 | QQQ | ETF | 711.03 | 714.92 | 708.76 | 712.89 | 278673.0 |
| 2026-05-21 05:00:00 | QQQ | ETF | 712.83 | 714.05 | 712.66 | 712.92 | 66900.0 |
| 2026-05-21 06:00:00 | QQQ | ETF | 712.92 | 713.2 | 708.48 | 709.57 | 251147.0 |
| 2026-05-21 07:00:00 | QQQ | ETF | 709.7 | 710.82 | 708.7 | 709.8046 | 254505.0 |
| 2026-05-21 08:00:00 | QQQ | ETF | 709.8608 | 710.76 | 708.26 | 708.47 | 365241.0 |
| 2026-05-21 09:00:00 | QQQ | ETF | 708.38 | 711.35 | 707.94 | 710.65 | 4316902.0 |
| 2026-05-21 10:00:00 | QQQ | ETF | 710.63 | 711.89 | 706.77 | 709.409 | 4669999.0 |
| 2026-05-21 11:00:00 | QQQ | ETF | 709.44 | 711.04 | 706.85 | 710.17 | 3454005.0 |
| 2026-05-21 12:00:00 | QQQ | ETF | 710.19 | 711.24 | 708.77 | 709.99 | 2021991.0 |
| 2026-05-21 13:00:00 | QQQ | ETF | 710.0 | 717.12 | 710.0 | 715.695 | 5044323.0 |
| 2026-05-21 14:00:00 | QQQ | ETF | 715.72 | 716.31 | 710.91 | 711.88 | 3285524.0 |
| 2026-05-21 15:00:00 | QQQ | ETF | 711.92 | 714.9 | 711.84 | 714.45 | 4007716.0 |
| 2026-05-21 16:00:00 | QQQ | ETF | 714.52 | 715.08 | 714.0095 | 714.6 | 983195.0 |
| 2026-05-21 17:00:00 | QQQ | ETF | 714.6566 | 715.0 | 714.5 | 714.6 | 50102.0 |
| 2026-05-21 18:00:00 | QQQ | ETF | 714.52 | 716.77 | 714.5 | 716.66 | 136342.0 |
| 2026-05-21 19:00:00 | QQQ | ETF | 716.76 | 717.55 | 716.6 | 716.9839 | 101056.0 |
| 2026-05-21 04:00:00 | IWM | ETF | 279.16 | 280.68 | 278.61 | 279.83 | 66829.0 |
| 2026-05-21 05:00:00 | IWM | ETF | 279.85 | 280.09 | 279.63 | 279.77 | 15370.0 |
| 2026-05-21 06:00:00 | IWM | ETF | 279.82 | 280.05 | 277.3 | 277.85 | 187714.0 |
| 2026-05-21 07:00:00 | IWM | ETF | 277.7593 | 278.79 | 277.57 | 278.47 | 107413.0 |
| 2026-05-21 08:00:00 | IWM | ETF | 278.51 | 278.69 | 277.67 | 278.17 | 234851.0 |
| 2026-05-21 09:00:00 | IWM | ETF | 278.08 | 280.59 | 277.15 | 280.45 | 4435972.0 |
| 2026-05-21 10:00:00 | IWM | ETF | 280.47 | 281.25 | 279.33 | 280.25 | 4509468.0 |
| 2026-05-21 11:00:00 | IWM | ETF | 280.245 | 280.82 | 279.5 | 279.91 | 2192546.0 |
| 2026-05-21 12:00:00 | IWM | ETF | 279.94 | 280.785 | 279.62 | 280.02 | 1684614.0 |
| 2026-05-21 13:00:00 | IWM | ETF | 280.03 | 283.68 | 279.91 | 282.84 | 4524185.0 |
| 2026-05-21 14:00:00 | IWM | ETF | 282.82 | 283.55 | 281.45 | 281.95 | 3350111.0 |
| 2026-05-21 15:00:00 | IWM | ETF | 281.94 | 282.805 | 281.88 | 282.505 | 3957276.0 |
| 2026-05-21 16:00:00 | IWM | ETF | 282.53 | 282.71 | 282.4 | 282.5 | 780759.0 |
| 2026-05-21 17:00:00 | IWM | ETF | 282.59 | 282.65 | 282.4 | 282.49 | 21726.0 |
| 2026-05-21 18:00:00 | IWM | ETF | 282.58 | 283.13 | 282.55 | 283.03 | 35508.0 |
| 2026-05-21 19:00:00 | IWM | ETF | 283.02 | 283.28 | 282.84 | 283.1496 | 27573.0 |
| 2026-05-21 04:00:00 | DIA | ETF | 500.0 | 501.32 | 499.77 | 500.61 | 1133.0 |
| 2026-05-21 05:00:00 | DIA | ETF | 501.39 | 501.39 | 501.39 | 501.39 | 40.0 |
> showing 50 of 28,535 rows — these rows as CSV