PREVIEW / etf_1hour / 2024-06-21
file: by_date/etf_1hour/2024/2024-06-21.parquet size: 533 KB rows: 19,825
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 |
|---|---|---|---|---|---|---|---|
| 2024-06-21 04:00:00 | SPY | ETF | 544.93 | 545.02 | 543.92 | 544.23 | 97958.0 |
| 2024-06-21 05:00:00 | SPY | ETF | 544.36 | 544.93 | 544.07 | 544.72 | 10651.0 |
| 2024-06-21 06:00:00 | SPY | ETF | 544.81 | 545.03 | 544.26 | 544.78 | 11833.0 |
| 2024-06-21 07:00:00 | SPY | ETF | 544.82 | 545.37 | 544.46 | 544.52 | 137324.0 |
| 2024-06-21 08:00:00 | SPY | ETF | 544.94 | 546.09 | 544.12 | 545.17 | 327395.0 |
| 2024-06-21 09:00:00 | SPY | ETF | 545.12 | 545.35 | 543.02 | 543.85 | 4899023.0 |
| 2024-06-21 10:00:00 | SPY | ETF | 543.85 | 544.9 | 543.78 | 544.81 | 3394605.0 |
| 2024-06-21 11:00:00 | SPY | ETF | 544.8 | 545.54 | 544.0098 | 545.52 | 3202080.0 |
| 2024-06-21 12:00:00 | SPY | ETF | 545.55 | 545.65 | 544.455 | 544.5507 | 1976209.0 |
| 2024-06-21 13:00:00 | SPY | ETF | 544.54 | 544.84 | 543.5589 | 543.96 | 2515333.0 |
| 2024-06-21 14:00:00 | SPY | ETF | 543.95 | 544.755 | 543.77 | 544.29 | 2912593.0 |
| 2024-06-21 15:00:00 | SPY | ETF | 544.3 | 545.22 | 544.08 | 544.13 | 10202722.0 |
| 2024-06-21 16:00:00 | SPY | ETF | 544.1 | 544.94 | 544.05 | 544.7 | 7385105.0 |
| 2024-06-21 17:00:00 | SPY | ETF | 544.7 | 545.04 | 544.277 | 544.72 | 740088.0 |
| 2024-06-21 18:00:00 | SPY | ETF | 544.74 | 544.8 | 544.5 | 544.5 | 65527.0 |
| 2024-06-21 19:00:00 | SPY | ETF | 544.55 | 544.55 | 544.35 | 544.36 | 18503.0 |
| 2024-06-21 04:00:00 | QQQ | ETF | 481.44 | 482.58 | 479.5 | 480.15 | 228771.0 |
| 2024-06-21 05:00:00 | QQQ | ETF | 480.21 | 481.19 | 480.01 | 480.94 | 80010.0 |
| 2024-06-21 06:00:00 | QQQ | ETF | 481.01 | 481.45 | 480.45 | 481.23 | 56636.0 |
| 2024-06-21 07:00:00 | QQQ | ETF | 481.18 | 481.82 | 480.61 | 480.72 | 137504.0 |
| 2024-06-21 08:00:00 | QQQ | ETF | 481.37 | 482.51 | 479.51 | 481.6 | 289173.0 |
| 2024-06-21 09:00:00 | QQQ | ETF | 481.65 | 481.85 | 478.67 | 479.62 | 3601876.0 |
| 2024-06-21 10:00:00 | QQQ | ETF | 479.62 | 481.05 | 479.4 | 480.99 | 3128908.0 |
| 2024-06-21 11:00:00 | QQQ | ETF | 481.01 | 482.41 | 480.2399 | 482.41 | 2385882.0 |
| 2024-06-21 12:00:00 | QQQ | ETF | 482.41 | 482.535 | 480.56 | 480.73 | 1922096.0 |
| 2024-06-21 13:00:00 | QQQ | ETF | 480.67 | 481.08 | 479.52 | 479.85 | 1957701.0 |
| 2024-06-21 14:00:00 | QQQ | ETF | 479.85 | 480.8 | 479.74 | 480.31 | 1568695.0 |
| 2024-06-21 15:00:00 | QQQ | ETF | 480.31 | 481.05 | 479.99 | 480.06 | 4708278.0 |
| 2024-06-21 16:00:00 | QQQ | ETF | 480.06 | 480.97 | 480.02 | 480.9 | 3253279.0 |
| 2024-06-21 17:00:00 | QQQ | ETF | 480.86 | 481.0 | 480.18 | 480.9 | 1016055.0 |
| 2024-06-21 18:00:00 | QQQ | ETF | 480.91 | 480.95 | 480.73 | 480.77 | 19637.0 |
| 2024-06-21 19:00:00 | QQQ | ETF | 480.77 | 480.85 | 480.5 | 480.5 | 27891.0 |
| 2024-06-21 04:00:00 | IWM | ETF | 200.01 | 200.04 | 199.77 | 199.94 | 15494.0 |
| 2024-06-21 05:00:00 | IWM | ETF | 199.99 | 200.12 | 199.77 | 199.97 | 7477.0 |
| 2024-06-21 06:00:00 | IWM | ETF | 200.04 | 200.11 | 199.74 | 199.87 | 12654.0 |
| 2024-06-21 07:00:00 | IWM | ETF | 199.88 | 200.2 | 199.71 | 199.79 | 56527.0 |
| 2024-06-21 08:00:00 | IWM | ETF | 200.15 | 200.31 | 199.72 | 200.18 | 104236.0 |
| 2024-06-21 09:00:00 | IWM | ETF | 200.21 | 200.49 | 198.46 | 199.09 | 2882839.0 |
| 2024-06-21 10:00:00 | IWM | ETF | 199.1 | 200.2184 | 199.06 | 199.94 | 1806024.0 |
| 2024-06-21 11:00:00 | IWM | ETF | 199.92 | 200.1 | 199.46 | 199.94 | 1808974.0 |
| 2024-06-21 12:00:00 | IWM | ETF | 199.95 | 200.0563 | 199.68 | 199.99 | 1104718.0 |
| 2024-06-21 13:00:00 | IWM | ETF | 199.98 | 200.18 | 199.64 | 199.87 | 998836.0 |
| 2024-06-21 14:00:00 | IWM | ETF | 199.875 | 200.16 | 199.36 | 199.67 | 1612265.0 |
| 2024-06-21 15:00:00 | IWM | ETF | 199.665 | 200.41 | 199.65 | 200.29 | 3889488.0 |
| 2024-06-21 16:00:00 | IWM | ETF | 200.35 | 200.63 | 200.29 | 200.39 | 3453262.0 |
| 2024-06-21 17:00:00 | IWM | ETF | 200.45 | 200.5 | 200.27 | 200.35 | 84253.0 |
| 2024-06-21 18:00:00 | IWM | ETF | 200.3 | 200.3 | 200.11 | 200.17 | 32141.0 |
| 2024-06-21 19:00:00 | IWM | ETF | 200.15 | 200.2 | 200.11 | 200.19 | 6569.0 |
| 2024-06-21 04:00:00 | DIA | ETF | 390.67 | 390.98 | 390.67 | 390.98 | 4850.0 |
| 2024-06-21 05:00:00 | DIA | ETF | 390.97 | 390.99 | 390.85 | 390.92 | 2082.0 |
> showing 50 of 19,825 rows — these rows as CSV