PREVIEW / etf_1hour / 2025-06-09
file: by_date/etf_1hour/2025/2025-06-09.parquet size: 629 KB rows: 25,065
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-06-09 04:00:00 | SPY | ETF | 599.45 | 600.0 | 599.1 | 599.88 | 83609.0 |
| 2025-06-09 05:00:00 | SPY | ETF | 599.94 | 599.95 | 599.5 | 599.55 | 14194.0 |
| 2025-06-09 06:00:00 | SPY | ETF | 599.48 | 599.63 | 599.12 | 599.33 | 14946.0 |
| 2025-06-09 07:00:00 | SPY | ETF | 599.35 | 600.37 | 599.32 | 600.15 | 175065.0 |
| 2025-06-09 08:00:00 | SPY | ETF | 599.58 | 600.37 | 598.1 | 599.76 | 252283.0 |
| 2025-06-09 09:00:00 | SPY | ETF | 599.79 | 600.1 | 598.49 | 598.895 | 4202256.0 |
| 2025-06-09 10:00:00 | SPY | ETF | 598.93 | 600.4 | 598.79 | 599.51 | 6819595.0 |
| 2025-06-09 11:00:00 | SPY | ETF | 599.52 | 600.01 | 599.05 | 599.85 | 3491709.0 |
| 2025-06-09 12:00:00 | SPY | ETF | 599.86 | 601.1 | 599.36 | 600.67 | 3869908.0 |
| 2025-06-09 13:00:00 | SPY | ETF | 600.69 | 601.215 | 600.105 | 600.94 | 3418773.0 |
| 2025-06-09 14:00:00 | SPY | ETF | 600.94 | 601.25 | 600.34 | 600.995 | 4176049.0 |
| 2025-06-09 15:00:00 | SPY | ETF | 601.0 | 601.14 | 599.42 | 599.56 | 10334975.0 |
| 2025-06-09 16:00:00 | SPY | ETF | 599.56 | 599.77 | 599.24 | 599.7 | 1818858.0 |
| 2025-06-09 17:00:00 | SPY | ETF | 599.72 | 599.8 | 599.64 | 599.74 | 91640.0 |
| 2025-06-09 18:00:00 | SPY | ETF | 599.78 | 600.2 | 599.68 | 599.79 | 85722.0 |
| 2025-06-09 19:00:00 | SPY | ETF | 599.909 | 599.9599 | 599.77 | 599.88 | 29693.0 |
| 2025-06-09 04:00:00 | QQQ | ETF | 530.01 | 530.18 | 529.21 | 529.99 | 53883.0 |
| 2025-06-09 05:00:00 | QQQ | ETF | 529.97 | 530.04 | 529.57 | 529.73 | 25191.0 |
| 2025-06-09 06:00:00 | QQQ | ETF | 529.69 | 529.94 | 529.32 | 529.6 | 48808.0 |
| 2025-06-09 07:00:00 | QQQ | ETF | 529.57 | 530.75 | 529.57 | 530.44 | 96606.0 |
| 2025-06-09 08:00:00 | QQQ | ETF | 529.5899 | 530.7286 | 528.59 | 530.13 | 153457.0 |
| 2025-06-09 09:00:00 | QQQ | ETF | 530.1 | 530.67 | 529.01 | 529.88 | 3431532.0 |
| 2025-06-09 10:00:00 | QQQ | ETF | 529.92 | 532.35 | 529.91 | 531.22 | 4148795.0 |
| 2025-06-09 11:00:00 | QQQ | ETF | 531.22 | 531.85 | 530.53 | 531.13 | 2759828.0 |
| 2025-06-09 12:00:00 | QQQ | ETF | 531.15 | 532.23 | 530.59 | 531.8864 | 2338109.0 |
| 2025-06-09 13:00:00 | QQQ | ETF | 531.88 | 532.17 | 531.03 | 531.815 | 2575215.0 |
| 2025-06-09 14:00:00 | QQQ | ETF | 531.82 | 532.0873 | 531.2 | 531.885 | 2377138.0 |
| 2025-06-09 15:00:00 | QQQ | ETF | 531.88 | 532.0 | 530.58 | 530.68 | 5254477.0 |
| 2025-06-09 16:00:00 | QQQ | ETF | 530.675 | 531.0 | 530.15 | 530.75 | 838721.0 |
| 2025-06-09 17:00:00 | QQQ | ETF | 530.74 | 530.86 | 530.49 | 530.75 | 93236.0 |
| 2025-06-09 18:00:00 | QQQ | ETF | 530.83 | 531.28 | 530.7641 | 530.85 | 133338.0 |
| 2025-06-09 19:00:00 | QQQ | ETF | 530.9 | 531.12 | 530.89 | 531.07 | 56097.0 |
| 2025-06-09 04:00:00 | IWM | ETF | 213.0 | 213.63 | 212.94 | 213.56 | 33690.0 |
| 2025-06-09 05:00:00 | IWM | ETF | 213.54 | 213.67 | 213.36 | 213.36 | 19975.0 |
| 2025-06-09 06:00:00 | IWM | ETF | 213.37 | 213.54 | 213.2 | 213.29 | 64454.0 |
| 2025-06-09 07:00:00 | IWM | ETF | 213.37 | 213.74 | 213.29 | 213.7 | 50332.0 |
| 2025-06-09 08:00:00 | IWM | ETF | 213.3502 | 213.88 | 212.05 | 213.71 | 110208.0 |
| 2025-06-09 09:00:00 | IWM | ETF | 213.73 | 213.99 | 212.58 | 212.84 | 6221414.0 |
| 2025-06-09 10:00:00 | IWM | ETF | 212.85 | 213.72 | 212.55 | 212.885 | 6015082.0 |
| 2025-06-09 11:00:00 | IWM | ETF | 212.89 | 213.2899 | 212.86 | 213.19 | 2474682.0 |
| 2025-06-09 12:00:00 | IWM | ETF | 213.19 | 213.725 | 213.095 | 213.495 | 1882823.0 |
| 2025-06-09 13:00:00 | IWM | ETF | 213.5 | 214.085 | 213.45 | 213.99 | 2020314.0 |
| 2025-06-09 14:00:00 | IWM | ETF | 213.99 | 214.28 | 213.84 | 214.11 | 1971106.0 |
| 2025-06-09 15:00:00 | IWM | ETF | 214.115 | 214.19 | 213.2201 | 213.31 | 4893244.0 |
| 2025-06-09 16:00:00 | IWM | ETF | 213.3 | 213.43 | 213.2898 | 213.37 | 965567.0 |
| 2025-06-09 17:00:00 | IWM | ETF | 213.48 | 213.6 | 213.36 | 213.49 | 518091.0 |
| 2025-06-09 18:00:00 | IWM | ETF | 213.4 | 213.61 | 213.4 | 213.46 | 12511.0 |
| 2025-06-09 19:00:00 | IWM | ETF | 213.45 | 213.599 | 213.44 | 213.56 | 8267.0 |
| 2025-06-09 04:00:00 | DIA | ETF | 428.73 | 428.99 | 428.73 | 428.99 | 300.0 |
| 2025-06-09 05:00:00 | DIA | ETF | 428.69 | 428.7 | 428.69 | 428.7 | 500.0 |
> showing 50 of 25,065 rows — these rows as CSV