PREVIEW / etf_1hour / 2025-03-21
file: by_date/etf_1hour/2025/2025-03-21.parquet size: 613 KB rows: 23,157
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-21 04:00:00 | SPY | ETF | 563.09 | 563.84 | 561.32 | 562.02 | 47205.0 |
| 2025-03-21 05:00:00 | SPY | ETF | 561.88 | 562.46 | 561.53 | 562.14 | 21782.0 |
| 2025-03-21 06:00:00 | SPY | ETF | 562.44 | 563.11 | 561.7 | 562.5 | 122166.0 |
| 2025-03-21 07:00:00 | SPY | ETF | 562.47 | 563.01 | 562.06 | 562.3 | 106477.0 |
| 2025-03-21 08:00:00 | SPY | ETF | 562.25 | 564.35 | 559.32 | 559.48 | 554448.0 |
| 2025-03-21 09:00:00 | SPY | ETF | 559.35 | 560.32 | 558.04 | 559.841 | 6213881.0 |
| 2025-03-21 10:00:00 | SPY | ETF | 559.85 | 561.48 | 558.03 | 561.47 | 4078015.0 |
| 2025-03-21 11:00:00 | SPY | ETF | 561.47 | 561.81 | 558.8 | 559.44 | 2947003.0 |
| 2025-03-21 12:00:00 | SPY | ETF | 559.37 | 563.685 | 558.76 | 563.6504 | 4728852.0 |
| 2025-03-21 13:00:00 | SPY | ETF | 563.65 | 563.93 | 561.52 | 562.905 | 2982751.0 |
| 2025-03-21 14:00:00 | SPY | ETF | 562.905 | 563.3062 | 562.05 | 562.49 | 3258681.0 |
| 2025-03-21 15:00:00 | SPY | ETF | 562.495 | 564.89 | 561.48 | 564.19 | 12651515.0 |
| 2025-03-21 16:00:00 | SPY | ETF | 564.2 | 564.8 | 563.94 | 564.59 | 5668045.0 |
| 2025-03-21 17:00:00 | SPY | ETF | 564.56 | 564.98 | 564.56 | 564.8892 | 117567.0 |
| 2025-03-21 18:00:00 | SPY | ETF | 564.9 | 565.1 | 564.86 | 565.04 | 28699.0 |
| 2025-03-21 19:00:00 | SPY | ETF | 565.074 | 565.11 | 564.7 | 565.0 | 49433.0 |
| 2025-03-21 04:00:00 | QQQ | ETF | 478.54 | 479.21 | 476.67 | 477.39 | 46932.0 |
| 2025-03-21 05:00:00 | QQQ | ETF | 477.22 | 477.93 | 476.63 | 477.38 | 35687.0 |
| 2025-03-21 06:00:00 | QQQ | ETF | 477.48 | 478.51 | 476.83 | 477.49 | 43170.0 |
| 2025-03-21 07:00:00 | QQQ | ETF | 477.45 | 478.15 | 477.25 | 477.4 | 92497.0 |
| 2025-03-21 08:00:00 | QQQ | ETF | 477.53 | 479.62 | 474.55 | 474.72 | 505071.0 |
| 2025-03-21 09:00:00 | QQQ | ETF | 474.6 | 476.34 | 472.905 | 475.52 | 4375084.0 |
| 2025-03-21 10:00:00 | QQQ | ETF | 475.56 | 477.39 | 474.21 | 477.34 | 3622300.0 |
| 2025-03-21 11:00:00 | QQQ | ETF | 477.39 | 477.77 | 474.59 | 475.34 | 2760657.0 |
| 2025-03-21 12:00:00 | QQQ | ETF | 475.31 | 479.74 | 474.6 | 479.72 | 3586574.0 |
| 2025-03-21 13:00:00 | QQQ | ETF | 479.72 | 479.83 | 477.47 | 478.78 | 2821269.0 |
| 2025-03-21 14:00:00 | QQQ | ETF | 478.77 | 479.5191 | 478.2 | 478.81 | 2029587.0 |
| 2025-03-21 15:00:00 | QQQ | ETF | 478.83 | 481.61 | 477.69 | 481.12 | 6012422.0 |
| 2025-03-21 16:00:00 | QQQ | ETF | 481.12 | 481.66 | 480.62 | 481.37 | 3044638.0 |
| 2025-03-21 17:00:00 | QQQ | ETF | 481.27 | 481.59 | 481.2 | 481.49 | 43470.0 |
| 2025-03-21 18:00:00 | QQQ | ETF | 481.49 | 481.78 | 481.48 | 481.56 | 58394.0 |
| 2025-03-21 19:00:00 | QQQ | ETF | 481.55 | 481.7 | 481.35 | 481.61 | 26613.0 |
| 2025-03-21 04:00:00 | IWM | ETF | 204.24 | 204.7 | 203.19 | 203.76 | 59463.0 |
| 2025-03-21 05:00:00 | IWM | ETF | 203.62 | 204.13 | 203.52 | 204.02 | 13624.0 |
| 2025-03-21 06:00:00 | IWM | ETF | 204.05 | 204.47 | 203.92 | 204.37 | 13763.0 |
| 2025-03-21 07:00:00 | IWM | ETF | 204.42 | 204.44 | 204.02 | 204.05 | 40294.0 |
| 2025-03-21 08:00:00 | IWM | ETF | 204.13 | 205.08 | 202.9012 | 203.0 | 199123.0 |
| 2025-03-21 09:00:00 | IWM | ETF | 202.98 | 203.27 | 202.27 | 202.96 | 3564279.0 |
| 2025-03-21 10:00:00 | IWM | ETF | 202.97 | 203.3503 | 201.76 | 203.3503 | 3371445.0 |
| 2025-03-21 11:00:00 | IWM | ETF | 203.35 | 203.48 | 202.58 | 202.81 | 2473623.0 |
| 2025-03-21 12:00:00 | IWM | ETF | 202.78 | 204.3236 | 202.625 | 204.28 | 2871982.0 |
| 2025-03-21 13:00:00 | IWM | ETF | 204.25 | 204.415 | 203.59 | 203.91 | 2021682.0 |
| 2025-03-21 14:00:00 | IWM | ETF | 203.9 | 204.33 | 203.72 | 203.96 | 2488464.0 |
| 2025-03-21 15:00:00 | IWM | ETF | 203.97 | 204.02 | 203.37 | 203.84 | 6340049.0 |
| 2025-03-21 16:00:00 | IWM | ETF | 203.84 | 204.17 | 203.59 | 204.16 | 2248499.0 |
| 2025-03-21 17:00:00 | IWM | ETF | 204.15 | 204.32 | 204.1 | 204.12 | 45979.0 |
| 2025-03-21 18:00:00 | IWM | ETF | 204.1 | 204.49 | 204.1 | 204.29 | 24601.0 |
| 2025-03-21 19:00:00 | IWM | ETF | 204.3 | 204.44 | 204.02 | 204.02 | 11830.0 |
| 2025-03-21 04:00:00 | DIA | ETF | 418.64 | 418.96 | 417.47 | 417.74 | 8046.0 |
| 2025-03-21 05:00:00 | DIA | ETF | 417.77 | 418.22 | 417.43 | 418.1 | 2762.0 |
> showing 50 of 23,157 rows — these rows as CSV