PREVIEW / etf_1hour / 2025-03-12
file: by_date/etf_1hour/2025/2025-03-12.parquet size: 640 KB rows: 24,780
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-12 04:00:00 | SPY | ETF | 558.17 | 559.66 | 557.4 | 559.66 | 44337.0 |
| 2025-03-12 05:00:00 | SPY | ETF | 559.8 | 560.14 | 559.35 | 560.14 | 23998.0 |
| 2025-03-12 06:00:00 | SPY | ETF | 560.14 | 560.25 | 559.18 | 559.92 | 52156.0 |
| 2025-03-12 07:00:00 | SPY | ETF | 559.91 | 561.25 | 559.9 | 560.84 | 251105.0 |
| 2025-03-12 08:00:00 | SPY | ETF | 560.43 | 567.0 | 555.92 | 562.96 | 2319080.0 |
| 2025-03-12 09:00:00 | SPY | ETF | 562.89 | 563.16 | 558.34 | 559.48 | 9993117.0 |
| 2025-03-12 10:00:00 | SPY | ETF | 559.46 | 560.5805 | 555.5 | 555.6001 | 6474516.0 |
| 2025-03-12 11:00:00 | SPY | ETF | 555.62 | 559.23 | 553.69 | 559.12 | 6129843.0 |
| 2025-03-12 12:00:00 | SPY | ETF | 559.1 | 561.26 | 558.24 | 559.07 | 4837129.0 |
| 2025-03-12 13:00:00 | SPY | ETF | 559.1 | 561.78 | 557.94 | 558.01 | 3409493.0 |
| 2025-03-12 14:00:00 | SPY | ETF | 558.04 | 561.9 | 557.81 | 561.2246 | 3683042.0 |
| 2025-03-12 15:00:00 | SPY | ETF | 561.2 | 561.2 | 558.17 | 558.91 | 9213874.0 |
| 2025-03-12 16:00:00 | SPY | ETF | 558.91 | 559.0844 | 556.3729 | 558.39 | 3620552.0 |
| 2025-03-12 17:00:00 | SPY | ETF | 558.37 | 558.61 | 558.31 | 558.4 | 62890.0 |
| 2025-03-12 18:00:00 | SPY | ETF | 558.52 | 559.71 | 558.15 | 559.36 | 98205.0 |
| 2025-03-12 19:00:00 | SPY | ETF | 559.5 | 560.72 | 559.5 | 560.71 | 84049.0 |
| 2025-03-12 20:00:00 | SPY | ETF | 560.67 | 560.67 | 560.67 | 560.67 | 340.0 |
| 2025-03-12 04:00:00 | QQQ | ETF | 473.74 | 475.68 | 472.95 | 475.47 | 95873.0 |
| 2025-03-12 05:00:00 | QQQ | ETF | 475.55 | 475.83 | 475.0 | 475.79 | 76523.0 |
| 2025-03-12 06:00:00 | QQQ | ETF | 475.68 | 475.82 | 474.93 | 475.62 | 63301.0 |
| 2025-03-12 07:00:00 | QQQ | ETF | 475.53 | 476.94 | 475.51 | 476.4 | 293261.0 |
| 2025-03-12 08:00:00 | QQQ | ETF | 475.89 | 481.6 | 471.79 | 479.7 | 1911732.0 |
| 2025-03-12 09:00:00 | QQQ | ETF | 479.74 | 481.06 | 476.54 | 477.86 | 6006490.0 |
| 2025-03-12 10:00:00 | QQQ | ETF | 477.81 | 479.8 | 473.6438 | 473.73 | 5201871.0 |
| 2025-03-12 11:00:00 | QQQ | ETF | 473.745 | 477.7 | 471.79 | 477.59 | 5009645.0 |
| 2025-03-12 12:00:00 | QQQ | ETF | 477.61 | 479.89 | 476.46 | 477.44 | 3827053.0 |
| 2025-03-12 13:00:00 | QQQ | ETF | 477.46 | 479.69 | 475.25 | 475.34 | 2563403.0 |
| 2025-03-12 14:00:00 | QQQ | ETF | 475.37 | 479.39 | 475.15 | 478.7161 | 2822970.0 |
| 2025-03-12 15:00:00 | QQQ | ETF | 478.6027 | 478.7 | 475.71 | 477.08 | 4462500.0 |
| 2025-03-12 16:00:00 | QQQ | ETF | 477.05 | 477.5185 | 475.95 | 476.17 | 1248100.0 |
| 2025-03-12 17:00:00 | QQQ | ETF | 476.2 | 476.6 | 476.16 | 476.5 | 45137.0 |
| 2025-03-12 18:00:00 | QQQ | ETF | 476.5 | 477.74 | 476.09 | 477.37 | 182678.0 |
| 2025-03-12 19:00:00 | QQQ | ETF | 477.55 | 478.94 | 477.49 | 478.91 | 116714.0 |
| 2025-03-12 04:00:00 | IWM | ETF | 201.8 | 202.32 | 201.4 | 202.3 | 24987.0 |
| 2025-03-12 05:00:00 | IWM | ETF | 202.35 | 202.35 | 201.67 | 202.0 | 21553.0 |
| 2025-03-12 06:00:00 | IWM | ETF | 202.01 | 202.03 | 201.54 | 201.89 | 43958.0 |
| 2025-03-12 07:00:00 | IWM | ETF | 201.86 | 202.25 | 201.86 | 201.99 | 222075.0 |
| 2025-03-12 08:00:00 | IWM | ETF | 202.0 | 206.21 | 201.37 | 203.35 | 1971201.0 |
| 2025-03-12 09:00:00 | IWM | ETF | 203.26 | 203.75 | 200.91 | 201.65 | 4480209.0 |
| 2025-03-12 10:00:00 | IWM | ETF | 201.65 | 201.84 | 199.95 | 200.05 | 4129936.0 |
| 2025-03-12 11:00:00 | IWM | ETF | 200.05 | 200.95 | 199.55 | 200.5599 | 3456700.0 |
| 2025-03-12 12:00:00 | IWM | ETF | 200.54 | 201.63 | 200.09 | 200.765 | 2953857.0 |
| 2025-03-12 13:00:00 | IWM | ETF | 200.79 | 202.23 | 200.66 | 200.82 | 2971200.0 |
| 2025-03-12 14:00:00 | IWM | ETF | 200.84 | 202.72 | 200.74 | 202.32 | 3079494.0 |
| 2025-03-12 15:00:00 | IWM | ETF | 202.315 | 202.315 | 201.11 | 201.12 | 4075062.0 |
| 2025-03-12 16:00:00 | IWM | ETF | 201.1 | 201.3 | 200.62 | 200.85 | 1460630.0 |
| 2025-03-12 17:00:00 | IWM | ETF | 200.81 | 201.14 | 200.76 | 201.05 | 18660.0 |
| 2025-03-12 18:00:00 | IWM | ETF | 201.03 | 201.37 | 200.87 | 201.2 | 47007.0 |
| 2025-03-12 19:00:00 | IWM | ETF | 201.28 | 201.69 | 201.28 | 201.6 | 88503.0 |
| 2025-03-12 04:00:00 | DIA | ETF | 416.03 | 416.44 | 415.76 | 416.43 | 1175.0 |
> showing 50 of 24,780 rows — these rows as CSV