PREVIEW / etf_1hour / 2025-09-11
file: by_date/etf_1hour/2025/2025-09-11.parquet size: 682 KB rows: 26,070
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-09-11 04:00:00 | SPY | ETF | 653.22 | 653.46 | 653.1 | 653.17 | 10567.0 |
| 2025-09-11 05:00:00 | SPY | ETF | 653.21 | 653.28 | 653.07 | 653.21 | 6440.0 |
| 2025-09-11 06:00:00 | SPY | ETF | 653.22 | 653.71 | 653.22 | 653.65 | 17092.0 |
| 2025-09-11 07:00:00 | SPY | ETF | 653.68 | 653.9 | 653.6 | 653.72 | 45901.0 |
| 2025-09-11 08:00:00 | SPY | ETF | 653.67 | 654.58 | 652.0 | 654.21 | 951869.0 |
| 2025-09-11 09:00:00 | SPY | ETF | 654.19 | 655.63 | 653.59 | 655.57 | 7290321.0 |
| 2025-09-11 10:00:00 | SPY | ETF | 655.57 | 657.0 | 655.38 | 656.65 | 7952223.0 |
| 2025-09-11 11:00:00 | SPY | ETF | 656.65 | 657.8 | 656.54 | 657.21 | 5822287.0 |
| 2025-09-11 12:00:00 | SPY | ETF | 657.21 | 657.72 | 656.855 | 657.16 | 3614088.0 |
| 2025-09-11 13:00:00 | SPY | ETF | 657.15 | 657.57 | 656.88 | 657.55 | 3422334.0 |
| 2025-09-11 14:00:00 | SPY | ETF | 657.555 | 657.735 | 657.16 | 657.535 | 5016428.0 |
| 2025-09-11 15:00:00 | SPY | ETF | 657.53 | 658.33 | 657.4 | 657.61 | 12531072.0 |
| 2025-09-11 16:00:00 | SPY | ETF | 657.6 | 657.79 | 657.42 | 657.55 | 2414197.0 |
| 2025-09-11 17:00:00 | SPY | ETF | 657.55 | 657.95 | 657.47 | 657.94 | 66049.0 |
| 2025-09-11 18:00:00 | SPY | ETF | 657.88 | 657.9394 | 657.4 | 657.58 | 80920.0 |
| 2025-09-11 19:00:00 | SPY | ETF | 657.53 | 657.8 | 657.42 | 657.67 | 22436.0 |
| 2025-09-11 04:00:00 | QQQ | ETF | 581.62 | 582.37 | 581.62 | 581.98 | 27104.0 |
| 2025-09-11 05:00:00 | QQQ | ETF | 581.96 | 582.12 | 581.6 | 581.89 | 30453.0 |
| 2025-09-11 06:00:00 | QQQ | ETF | 581.9 | 582.57 | 581.88 | 582.53 | 26649.0 |
| 2025-09-11 07:00:00 | QQQ | ETF | 582.46 | 582.7 | 582.33 | 582.5 | 64702.0 |
| 2025-09-11 08:00:00 | QQQ | ETF | 582.51 | 583.17 | 580.01 | 582.82 | 760386.0 |
| 2025-09-11 09:00:00 | QQQ | ETF | 582.8 | 583.73 | 581.62 | 583.28 | 5944850.0 |
| 2025-09-11 10:00:00 | QQQ | ETF | 583.26 | 584.24 | 582.5 | 583.8607 | 6385425.0 |
| 2025-09-11 11:00:00 | QQQ | ETF | 583.86 | 584.88 | 583.79 | 584.37 | 4184689.0 |
| 2025-09-11 12:00:00 | QQQ | ETF | 584.37 | 584.83 | 583.67 | 584.0 | 2775811.0 |
| 2025-09-11 13:00:00 | QQQ | ETF | 584.0 | 584.61 | 583.73 | 584.58 | 2633363.0 |
| 2025-09-11 14:00:00 | QQQ | ETF | 584.58 | 584.8 | 584.1407 | 584.61 | 2462190.0 |
| 2025-09-11 15:00:00 | QQQ | ETF | 584.6 | 584.87 | 584.005 | 584.09 | 5550873.0 |
| 2025-09-11 16:00:00 | QQQ | ETF | 584.09 | 584.38 | 583.9 | 583.95 | 3138268.0 |
| 2025-09-11 17:00:00 | QQQ | ETF | 584.04 | 584.74 | 583.85 | 584.67 | 100699.0 |
| 2025-09-11 18:00:00 | QQQ | ETF | 584.6 | 584.61 | 583.88 | 584.1401 | 125131.0 |
| 2025-09-11 19:00:00 | QQQ | ETF | 584.13 | 584.43 | 583.98 | 584.33 | 27954.0 |
| 2025-09-11 04:00:00 | IWM | ETF | 236.31 | 236.38 | 235.81 | 235.82 | 28020.0 |
| 2025-09-11 05:00:00 | IWM | ETF | 235.89 | 236.5 | 235.89 | 236.5 | 9460.0 |
| 2025-09-11 06:00:00 | IWM | ETF | 236.49 | 236.7 | 236.46 | 236.7 | 11967.0 |
| 2025-09-11 07:00:00 | IWM | ETF | 236.72 | 237.12 | 236.69 | 236.85 | 49237.0 |
| 2025-09-11 08:00:00 | IWM | ETF | 236.87 | 237.69 | 235.58 | 237.52 | 1370231.0 |
| 2025-09-11 09:00:00 | IWM | ETF | 237.51 | 238.795 | 236.24 | 238.775 | 5527957.0 |
| 2025-09-11 10:00:00 | IWM | ETF | 238.77 | 240.08 | 238.595 | 239.54 | 6233253.0 |
| 2025-09-11 11:00:00 | IWM | ETF | 239.53 | 240.11 | 239.29 | 239.78 | 4427382.0 |
| 2025-09-11 12:00:00 | IWM | ETF | 239.78 | 240.12 | 239.7535 | 240.11 | 2772275.0 |
| 2025-09-11 13:00:00 | IWM | ETF | 240.1 | 240.57 | 239.91 | 240.48 | 2487674.0 |
| 2025-09-11 14:00:00 | IWM | ETF | 240.49 | 240.67 | 239.7 | 239.85 | 2732986.0 |
| 2025-09-11 15:00:00 | IWM | ETF | 239.845 | 240.9295 | 239.83 | 240.76 | 6339986.0 |
| 2025-09-11 16:00:00 | IWM | ETF | 240.8 | 240.8 | 240.4 | 240.4 | 2112259.0 |
| 2025-09-11 17:00:00 | IWM | ETF | 240.38 | 240.7454 | 240.38 | 240.55 | 16321.0 |
| 2025-09-11 18:00:00 | IWM | ETF | 240.54 | 240.54 | 240.17 | 240.27 | 28093.0 |
| 2025-09-11 19:00:00 | IWM | ETF | 240.31 | 240.36 | 240.23 | 240.33 | 12531.0 |
| 2025-09-11 04:00:00 | DIA | ETF | 456.37 | 456.37 | 456.37 | 456.37 | 157.0 |
| 2025-09-11 05:00:00 | DIA | ETF | 456.58 | 456.58 | 456.58 | 456.58 | 100.0 |
> showing 50 of 26,070 rows — these rows as CSV