PREVIEW / etf_1hour / 2025-03-20
file: by_date/etf_1hour/2025/2025-03-20.parquet size: 619 KB rows: 23,806
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-03-20 04:00:00 | SPY | ETF | 568.27 | 569.81 | 568.27 | 569.35 | 26438.0 |
| 2025-03-20 05:00:00 | SPY | ETF | 569.41 | 569.41 | 566.73 | 567.19 | 42535.0 |
| 2025-03-20 06:00:00 | SPY | ETF | 566.89 | 566.92 | 562.5 | 564.28 | 198615.0 |
| 2025-03-20 07:00:00 | SPY | ETF | 564.29 | 565.4 | 563.77 | 565.37 | 295299.0 |
| 2025-03-20 08:00:00 | SPY | ETF | 564.14 | 569.84 | 563.7625 | 564.35 | 489761.0 |
| 2025-03-20 09:00:00 | SPY | ETF | 564.25 | 566.77 | 562.6012 | 566.61 | 3944176.0 |
| 2025-03-20 10:00:00 | SPY | ETF | 566.65 | 570.57 | 566.46 | 569.4 | 5475482.0 |
| 2025-03-20 11:00:00 | SPY | ETF | 569.43 | 569.88 | 567.69 | 568.1698 | 3630144.0 |
| 2025-03-20 12:00:00 | SPY | ETF | 568.15 | 569.42 | 565.61 | 565.87 | 4015539.0 |
| 2025-03-20 13:00:00 | SPY | ETF | 565.86 | 567.21 | 564.66 | 565.16 | 3231946.0 |
| 2025-03-20 14:00:00 | SPY | ETF | 565.19 | 566.2 | 563.7703 | 564.45 | 4440001.0 |
| 2025-03-20 15:00:00 | SPY | ETF | 564.451 | 566.68 | 564.38 | 565.68 | 8825544.0 |
| 2025-03-20 16:00:00 | SPY | ETF | 565.69 | 566.1 | 565.49 | 565.821 | 4975539.0 |
| 2025-03-20 17:00:00 | SPY | ETF | 565.85 | 566.0 | 565.64 | 565.838 | 46562.0 |
| 2025-03-20 18:00:00 | SPY | ETF | 565.71 | 566.17 | 565.6 | 565.69 | 33914.0 |
| 2025-03-20 19:00:00 | SPY | ETF | 565.73 | 565.77 | 564.96 | 565.68 | 70047.0 |
| 2025-03-20 04:00:00 | QQQ | ETF | 483.02 | 483.78 | 483.01 | 483.27 | 39861.0 |
| 2025-03-20 05:00:00 | QQQ | ETF | 483.3 | 483.38 | 480.41 | 480.95 | 113853.0 |
| 2025-03-20 06:00:00 | QQQ | ETF | 480.89 | 480.89 | 475.65 | 477.66 | 320048.0 |
| 2025-03-20 07:00:00 | QQQ | ETF | 477.59 | 478.61 | 477.14 | 478.42 | 271935.0 |
| 2025-03-20 08:00:00 | QQQ | ETF | 477.59 | 484.17 | 476.692 | 477.88 | 337601.0 |
| 2025-03-20 09:00:00 | QQQ | ETF | 477.88 | 480.59 | 476.18 | 480.42 | 3402323.0 |
| 2025-03-20 10:00:00 | QQQ | ETF | 480.47 | 484.55 | 480.25 | 483.075 | 4516488.0 |
| 2025-03-20 11:00:00 | QQQ | ETF | 483.0521 | 483.55 | 481.26 | 481.74 | 2529089.0 |
| 2025-03-20 12:00:00 | QQQ | ETF | 481.73 | 483.0 | 478.75 | 479.11 | 3419146.0 |
| 2025-03-20 13:00:00 | QQQ | ETF | 479.125 | 480.7 | 477.95 | 478.49 | 2380773.0 |
| 2025-03-20 14:00:00 | QQQ | ETF | 478.52 | 479.69 | 477.24 | 477.79 | 3864067.0 |
| 2025-03-20 15:00:00 | QQQ | ETF | 477.78 | 480.21 | 477.71 | 479.29 | 3559923.0 |
| 2025-03-20 16:00:00 | QQQ | ETF | 479.28 | 479.98 | 479.21 | 479.53 | 1313341.0 |
| 2025-03-20 17:00:00 | QQQ | ETF | 479.63 | 479.6787 | 479.35 | 479.48 | 30960.0 |
| 2025-03-20 18:00:00 | QQQ | ETF | 479.52 | 479.88 | 479.19 | 479.34 | 49443.0 |
| 2025-03-20 19:00:00 | QQQ | ETF | 479.3098 | 479.41 | 478.5 | 479.37 | 65276.0 |
| 2025-03-20 04:00:00 | IWM | ETF | 207.21 | 207.55 | 207.08 | 207.4 | 21325.0 |
| 2025-03-20 05:00:00 | IWM | ETF | 207.24 | 207.34 | 206.11 | 206.37 | 25810.0 |
| 2025-03-20 06:00:00 | IWM | ETF | 206.14 | 206.24 | 204.58 | 205.21 | 75385.0 |
| 2025-03-20 07:00:00 | IWM | ETF | 205.25 | 205.49 | 204.99 | 205.48 | 172986.0 |
| 2025-03-20 08:00:00 | IWM | ETF | 205.01 | 207.64 | 204.85 | 204.93 | 139221.0 |
| 2025-03-20 09:00:00 | IWM | ETF | 204.85 | 206.15 | 204.195 | 206.04 | 2443916.0 |
| 2025-03-20 10:00:00 | IWM | ETF | 206.06 | 207.25 | 205.98 | 206.88 | 3127495.0 |
| 2025-03-20 11:00:00 | IWM | ETF | 206.91 | 207.3 | 206.54 | 206.67 | 1887276.0 |
| 2025-03-20 12:00:00 | IWM | ETF | 206.66 | 207.18 | 205.48 | 205.61 | 2242020.0 |
| 2025-03-20 13:00:00 | IWM | ETF | 205.59 | 206.29 | 205.1351 | 205.35 | 1625092.0 |
| 2025-03-20 14:00:00 | IWM | ETF | 205.355 | 205.67 | 204.85 | 205.11 | 1774874.0 |
| 2025-03-20 15:00:00 | IWM | ETF | 205.1 | 205.86 | 204.95 | 205.09 | 3527807.0 |
| 2025-03-20 16:00:00 | IWM | ETF | 205.06 | 205.23 | 204.93 | 204.98 | 762422.0 |
| 2025-03-20 17:00:00 | IWM | ETF | 205.0 | 205.14 | 204.95 | 205.06 | 48957.0 |
| 2025-03-20 18:00:00 | IWM | ETF | 205.06 | 205.34 | 205.05 | 205.06 | 71453.0 |
| 2025-03-20 19:00:00 | IWM | ETF | 205.04 | 205.12 | 204.81 | 205.08 | 21690.0 |
| 2025-03-20 04:00:00 | DIA | ETF | 421.45 | 421.89 | 421.45 | 421.58 | 815.0 |
| 2025-03-20 05:00:00 | DIA | ETF | 421.52 | 421.52 | 420.28 | 420.28 | 3220.0 |
> showing 50 of 23,806 rows — these rows as CSV