PREVIEW / etf_1hour / 2025-06-24
file: by_date/etf_1hour/2025/2025-06-24.parquet size: 667 KB rows: 25,524
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-24 04:00:00 | SPY | ETF | 605.07 | 605.54 | 588.79 | 604.98 | 139121.0 |
| 2025-06-24 05:00:00 | SPY | ETF | 605.02 | 605.96 | 604.96 | 605.13 | 28548.0 |
| 2025-06-24 06:00:00 | SPY | ETF | 605.11 | 605.33 | 604.53 | 604.72 | 209644.0 |
| 2025-06-24 07:00:00 | SPY | ETF | 604.72 | 605.21 | 604.03 | 604.83 | 298286.0 |
| 2025-06-24 08:00:00 | SPY | ETF | 604.81 | 606.5 | 603.17 | 604.4 | 407748.0 |
| 2025-06-24 09:00:00 | SPY | ETF | 604.33 | 605.45 | 603.8 | 604.05 | 6869234.0 |
| 2025-06-24 10:00:00 | SPY | ETF | 604.02 | 605.355 | 603.41 | 604.95 | 7108054.0 |
| 2025-06-24 11:00:00 | SPY | ETF | 604.96 | 606.165 | 604.94 | 605.755 | 4879237.0 |
| 2025-06-24 12:00:00 | SPY | ETF | 605.77 | 607.175 | 605.655 | 606.6399 | 4434551.0 |
| 2025-06-24 13:00:00 | SPY | ETF | 606.65 | 607.36 | 606.3 | 607.1701 | 4182293.0 |
| 2025-06-24 14:00:00 | SPY | ETF | 607.18 | 607.46 | 606.87 | 607.305 | 4416263.0 |
| 2025-06-24 15:00:00 | SPY | ETF | 607.31 | 607.8499 | 606.75 | 606.77 | 11649294.0 |
| 2025-06-24 16:00:00 | SPY | ETF | 606.76 | 606.95 | 605.891 | 606.73 | 2529189.0 |
| 2025-06-24 17:00:00 | SPY | ETF | 606.7508 | 607.16 | 606.5 | 606.7 | 460435.0 |
| 2025-06-24 18:00:00 | SPY | ETF | 606.7 | 606.8221 | 606.2701 | 606.4599 | 224303.0 |
| 2025-06-24 19:00:00 | SPY | ETF | 606.46 | 607.02 | 606.2301 | 607.02 | 22397.0 |
| 2025-06-24 04:00:00 | QQQ | ETF | 537.47 | 538.03 | 536.12 | 537.34 | 80689.0 |
| 2025-06-24 05:00:00 | QQQ | ETF | 537.37 | 538.5 | 537.37 | 537.62 | 101778.0 |
| 2025-06-24 06:00:00 | QQQ | ETF | 537.6 | 537.77 | 536.8 | 536.91 | 74012.0 |
| 2025-06-24 07:00:00 | QQQ | ETF | 536.92 | 537.44 | 536.12 | 537.39 | 90819.0 |
| 2025-06-24 08:00:00 | QQQ | ETF | 536.71 | 539.0 | 531.252 | 536.92 | 254209.0 |
| 2025-06-24 09:00:00 | QQQ | ETF | 536.92 | 538.04 | 536.27 | 536.99 | 4520544.0 |
| 2025-06-24 10:00:00 | QQQ | ETF | 536.94 | 538.19 | 536.43 | 537.59 | 5042625.0 |
| 2025-06-24 11:00:00 | QQQ | ETF | 537.6 | 539.299 | 537.56 | 538.685 | 3790613.0 |
| 2025-06-24 12:00:00 | QQQ | ETF | 538.69 | 540.005 | 538.585 | 539.575 | 3069456.0 |
| 2025-06-24 13:00:00 | QQQ | ETF | 539.57 | 540.205 | 539.11 | 539.99 | 2518954.0 |
| 2025-06-24 14:00:00 | QQQ | ETF | 540.0 | 540.33 | 539.77 | 540.18 | 2708159.0 |
| 2025-06-24 15:00:00 | QQQ | ETF | 540.17 | 540.7 | 539.73 | 539.735 | 6384970.0 |
| 2025-06-24 16:00:00 | QQQ | ETF | 539.78 | 540.04 | 539.48 | 539.81 | 2654373.0 |
| 2025-06-24 17:00:00 | QQQ | ETF | 539.81 | 540.13 | 539.71 | 539.8 | 122457.0 |
| 2025-06-24 18:00:00 | QQQ | ETF | 539.77 | 539.81 | 539.28 | 539.51 | 56806.0 |
| 2025-06-24 19:00:00 | QQQ | ETF | 539.7 | 540.29 | 539.33 | 540.18 | 47875.0 |
| 2025-06-24 04:00:00 | IWM | ETF | 214.09 | 214.34 | 213.71 | 214.19 | 46602.0 |
| 2025-06-24 05:00:00 | IWM | ETF | 214.13 | 214.27 | 213.87 | 213.93 | 26899.0 |
| 2025-06-24 06:00:00 | IWM | ETF | 214.0 | 214.0 | 213.61 | 213.83 | 41158.0 |
| 2025-06-24 07:00:00 | IWM | ETF | 213.78 | 214.0 | 213.41 | 213.68 | 108493.0 |
| 2025-06-24 08:00:00 | IWM | ETF | 213.75 | 214.7 | 213.35 | 213.57 | 260547.0 |
| 2025-06-24 09:00:00 | IWM | ETF | 213.51 | 213.58 | 212.36 | 212.53 | 3702594.0 |
| 2025-06-24 10:00:00 | IWM | ETF | 212.52 | 214.46 | 212.4 | 214.25 | 3664827.0 |
| 2025-06-24 11:00:00 | IWM | ETF | 214.26 | 214.91 | 213.97 | 214.0188 | 3108478.0 |
| 2025-06-24 12:00:00 | IWM | ETF | 214.03 | 214.41 | 213.99 | 214.28 | 1764319.0 |
| 2025-06-24 13:00:00 | IWM | ETF | 214.28 | 214.34 | 213.88 | 214.26 | 1630990.0 |
| 2025-06-24 14:00:00 | IWM | ETF | 214.27 | 214.93 | 214.265 | 214.64 | 2025985.0 |
| 2025-06-24 15:00:00 | IWM | ETF | 214.635 | 214.85 | 214.3 | 214.425 | 5065583.0 |
| 2025-06-24 16:00:00 | IWM | ETF | 214.43 | 214.7 | 214.21 | 214.37 | 2145354.0 |
| 2025-06-24 17:00:00 | IWM | ETF | 214.46 | 214.51 | 214.24 | 214.41 | 8687.0 |
| 2025-06-24 18:00:00 | IWM | ETF | 214.39 | 214.39 | 214.06 | 214.27 | 19549.0 |
| 2025-06-24 19:00:00 | IWM | ETF | 214.28 | 214.45 | 214.15 | 214.45 | 9532.0 |
| 2025-06-24 04:00:00 | DIA | ETF | 428.16 | 428.91 | 428.14 | 428.65 | 2162.0 |
| 2025-06-24 05:00:00 | DIA | ETF | 428.85 | 429.22 | 428.74 | 428.74 | 5146.0 |
> showing 50 of 25,524 rows — these rows as CSV