PREVIEW / etf_1hour / 2026-05-12
file: by_date/etf_1hour/2026/2026-05-12.parquet size: 725 KB rows: 28,854
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-12 04:00:00 | SPY | ETF | 737.61 | 738.22 | 735.77 | 736.47 | 124505.0 |
| 2026-05-12 05:00:00 | SPY | ETF | 736.44 | 737.03 | 735.88 | 736.59 | 22123.0 |
| 2026-05-12 06:00:00 | SPY | ETF | 736.71 | 737.13 | 736.2 | 736.68 | 34371.0 |
| 2026-05-12 07:00:00 | SPY | ETF | 736.68 | 736.9 | 735.76 | 736.35 | 195418.0 |
| 2026-05-12 08:00:00 | SPY | ETF | 736.35 | 737.53 | 735.38 | 737.43 | 459936.0 |
| 2026-05-12 09:00:00 | SPY | ETF | 737.39 | 737.55 | 734.86 | 735.11 | 3998882.0 |
| 2026-05-12 10:00:00 | SPY | ETF | 735.14 | 736.38 | 733.54 | 733.79 | 5489117.0 |
| 2026-05-12 11:00:00 | SPY | ETF | 733.78 | 734.05 | 731.83 | 732.49 | 5879112.0 |
| 2026-05-12 12:00:00 | SPY | ETF | 732.49 | 733.48 | 731.83 | 732.12 | 4077408.0 |
| 2026-05-12 13:00:00 | SPY | ETF | 732.12 | 735.2 | 732.01 | 735.06 | 4669585.0 |
| 2026-05-12 14:00:00 | SPY | ETF | 735.06 | 736.57 | 734.66 | 736.0 | 4373577.0 |
| 2026-05-12 15:00:00 | SPY | ETF | 736.02 | 738.84 | 735.99 | 738.22 | 8613769.0 |
| 2026-05-12 16:00:00 | SPY | ETF | 738.2 | 738.23 | 737.02 | 737.47 | 2900001.0 |
| 2026-05-12 17:00:00 | SPY | ETF | 737.47 | 737.47 | 737.05 | 737.36 | 72035.0 |
| 2026-05-12 18:00:00 | SPY | ETF | 737.42 | 738.17 | 737.42 | 737.63 | 111714.0 |
| 2026-05-12 19:00:00 | SPY | ETF | 737.66 | 737.79 | 736.67 | 736.67 | 53128.0 |
| 2026-05-12 04:00:00 | QQQ | ETF | 709.44 | 711.09 | 707.0 | 708.2 | 209705.0 |
| 2026-05-12 05:00:00 | QQQ | ETF | 708.17 | 708.97 | 707.315 | 708.34 | 91149.0 |
| 2026-05-12 06:00:00 | QQQ | ETF | 708.41 | 709.02 | 707.55 | 708.05 | 103935.0 |
| 2026-05-12 07:00:00 | QQQ | ETF | 708.09 | 708.26 | 706.29 | 707.0891 | 302769.0 |
| 2026-05-12 08:00:00 | QQQ | ETF | 707.1047 | 712.756 | 705.0 | 708.44 | 712908.0 |
| 2026-05-12 09:00:00 | QQQ | ETF | 708.4 | 710.18 | 705.68 | 706.1 | 4599936.0 |
| 2026-05-12 10:00:00 | QQQ | ETF | 706.0675 | 708.48 | 702.95 | 703.3 | 5186561.0 |
| 2026-05-12 11:00:00 | QQQ | ETF | 703.28 | 703.69 | 698.8 | 699.03 | 5854256.0 |
| 2026-05-12 12:00:00 | QQQ | ETF | 699.035 | 700.92 | 696.64 | 696.8 | 3729483.0 |
| 2026-05-12 13:00:00 | QQQ | ETF | 696.82 | 701.29 | 696.82 | 701.04 | 3488737.0 |
| 2026-05-12 14:00:00 | QQQ | ETF | 701.01 | 703.155 | 700.85 | 701.87 | 3347553.0 |
| 2026-05-12 15:00:00 | QQQ | ETF | 701.89 | 707.56 | 701.89 | 707.21 | 6211765.0 |
| 2026-05-12 16:00:00 | QQQ | ETF | 707.17 | 707.25 | 705.45 | 706.23 | 1757652.0 |
| 2026-05-12 17:00:00 | QQQ | ETF | 706.23 | 706.6 | 705.89 | 706.55 | 132138.0 |
| 2026-05-12 18:00:00 | QQQ | ETF | 706.5 | 707.42 | 706.2116 | 706.44 | 85855.0 |
| 2026-05-12 19:00:00 | QQQ | ETF | 706.37 | 706.73 | 704.83 | 704.9 | 200972.0 |
| 2026-05-12 04:00:00 | IWM | ETF | 284.46 | 284.92 | 283.67 | 284.33 | 72543.0 |
| 2026-05-12 05:00:00 | IWM | ETF | 284.39 | 284.79 | 284.19 | 284.36 | 33050.0 |
| 2026-05-12 06:00:00 | IWM | ETF | 284.37 | 284.69 | 284.3 | 284.44 | 75215.0 |
| 2026-05-12 07:00:00 | IWM | ETF | 284.46 | 284.55 | 283.94 | 284.41 | 66599.0 |
| 2026-05-12 08:00:00 | IWM | ETF | 284.37 | 284.69 | 283.44 | 284.19 | 561106.0 |
| 2026-05-12 09:00:00 | IWM | ETF | 284.21 | 284.21 | 280.71 | 280.9 | 3667044.0 |
| 2026-05-12 10:00:00 | IWM | ETF | 280.9 | 282.22 | 279.56 | 279.94 | 4044643.0 |
| 2026-05-12 11:00:00 | IWM | ETF | 279.94 | 280.0393 | 278.32 | 278.48 | 3768419.0 |
| 2026-05-12 12:00:00 | IWM | ETF | 278.48 | 279.21 | 278.28 | 278.74 | 2365306.0 |
| 2026-05-12 13:00:00 | IWM | ETF | 278.735 | 281.0 | 278.59 | 280.94 | 2366059.0 |
| 2026-05-12 14:00:00 | IWM | ETF | 280.92 | 281.73 | 280.79 | 281.27 | 2252540.0 |
| 2026-05-12 15:00:00 | IWM | ETF | 281.29 | 282.77 | 281.2 | 282.57 | 2932750.0 |
| 2026-05-12 16:00:00 | IWM | ETF | 282.57 | 282.6 | 279.0 | 282.35 | 1068755.0 |
| 2026-05-12 17:00:00 | IWM | ETF | 282.04 | 282.39 | 282.0 | 282.18 | 33633.0 |
| 2026-05-12 18:00:00 | IWM | ETF | 282.19 | 282.7 | 282.15 | 282.4 | 22013.0 |
| 2026-05-12 19:00:00 | IWM | ETF | 282.42 | 282.42 | 281.92 | 281.96 | 27202.0 |
| 2026-05-12 04:00:00 | DIA | ETF | 496.87 | 497.01 | 495.88 | 496.84 | 998.0 |
| 2026-05-12 05:00:00 | DIA | ETF | 496.44 | 497.0 | 496.39 | 496.39 | 350.0 |
> showing 50 of 28,854 rows — these rows as CSV