PREVIEW / etf_1hour / 2025-04-21
file: by_date/etf_1hour/2025/2025-04-21.parquet size: 651 KB rows: 25,541
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-04-21 04:00:00 | SPY | ETF | 522.78 | 522.78 | 520.71 | 521.25 | 33875.0 |
| 2025-04-21 05:00:00 | SPY | ETF | 521.36 | 521.36 | 520.5 | 520.92 | 21747.0 |
| 2025-04-21 06:00:00 | SPY | ETF | 521.18 | 521.72 | 520.75 | 521.65 | 38439.0 |
| 2025-04-21 07:00:00 | SPY | ETF | 521.65 | 522.41 | 519.26 | 520.0 | 311648.0 |
| 2025-04-21 08:00:00 | SPY | ETF | 522.31 | 523.05 | 519.3789 | 520.99 | 363097.0 |
| 2025-04-21 09:00:00 | SPY | ETF | 520.84 | 521.7 | 517.52 | 517.56 | 4053450.0 |
| 2025-04-21 10:00:00 | SPY | ETF | 517.51 | 517.51 | 514.389 | 514.6 | 6656938.0 |
| 2025-04-21 11:00:00 | SPY | ETF | 514.58 | 515.06 | 510.8 | 511.0699 | 5897288.0 |
| 2025-04-21 12:00:00 | SPY | ETF | 511.05 | 513.25 | 511.01 | 511.24 | 5344435.0 |
| 2025-04-21 13:00:00 | SPY | ETF | 511.2562 | 511.7399 | 508.74 | 508.94 | 5347379.0 |
| 2025-04-21 14:00:00 | SPY | ETF | 508.95 | 510.66 | 508.46 | 508.7701 | 5376316.0 |
| 2025-04-21 15:00:00 | SPY | ETF | 508.77 | 514.87 | 508.73 | 513.98 | 12989487.0 |
| 2025-04-21 16:00:00 | SPY | ETF | 513.99 | 514.24 | 510.05 | 513.84 | 4253115.0 |
| 2025-04-21 17:00:00 | SPY | ETF | 513.83 | 514.15 | 513.83 | 513.88 | 56163.0 |
| 2025-04-21 18:00:00 | SPY | ETF | 514.02 | 514.21 | 512.77 | 513.63 | 210620.0 |
| 2025-04-21 19:00:00 | SPY | ETF | 513.7 | 516.099 | 513.6 | 516.05 | 97221.0 |
| 2025-04-21 04:00:00 | QQQ | ETF | 438.92 | 440.0 | 438.68 | 439.4 | 82788.0 |
| 2025-04-21 05:00:00 | QQQ | ETF | 439.28 | 439.48 | 438.38 | 439.29 | 41402.0 |
| 2025-04-21 06:00:00 | QQQ | ETF | 439.26 | 439.64 | 438.63 | 439.64 | 29734.0 |
| 2025-04-21 07:00:00 | QQQ | ETF | 439.7 | 440.3 | 437.03 | 437.66 | 162940.0 |
| 2025-04-21 08:00:00 | QQQ | ETF | 440.0 | 443.767 | 437.05 | 438.07 | 187463.0 |
| 2025-04-21 09:00:00 | QQQ | ETF | 438.0 | 439.08 | 434.97 | 434.9899 | 3024377.0 |
| 2025-04-21 10:00:00 | QQQ | ETF | 434.96 | 435.035 | 432.65 | 433.4885 | 4356176.0 |
| 2025-04-21 11:00:00 | QQQ | ETF | 433.5 | 433.9004 | 430.0 | 430.22 | 3446266.0 |
| 2025-04-21 12:00:00 | QQQ | ETF | 430.2453 | 432.14 | 430.04 | 430.16 | 2789920.0 |
| 2025-04-21 13:00:00 | QQQ | ETF | 430.17 | 430.64 | 428.0 | 428.2115 | 2669094.0 |
| 2025-04-21 14:00:00 | QQQ | ETF | 428.235 | 429.8765 | 427.93 | 428.1212 | 3016597.0 |
| 2025-04-21 15:00:00 | QQQ | ETF | 428.12 | 434.0 | 428.07 | 433.23 | 6437596.0 |
| 2025-04-21 16:00:00 | QQQ | ETF | 433.22 | 433.41 | 432.51 | 432.92 | 2173437.0 |
| 2025-04-21 17:00:00 | QQQ | ETF | 433.12 | 433.2388 | 432.97 | 433.1 | 53826.0 |
| 2025-04-21 18:00:00 | QQQ | ETF | 433.1 | 433.37 | 431.9 | 432.54 | 96163.0 |
| 2025-04-21 19:00:00 | QQQ | ETF | 432.7 | 435.22 | 432.5707 | 435.1 | 210039.0 |
| 2025-04-21 04:00:00 | IWM | ETF | 184.95 | 185.82 | 184.5 | 184.88 | 17690.0 |
| 2025-04-21 05:00:00 | IWM | ETF | 184.9 | 184.99 | 184.73 | 184.83 | 9826.0 |
| 2025-04-21 06:00:00 | IWM | ETF | 184.95 | 185.15 | 184.8 | 185.02 | 58765.0 |
| 2025-04-21 07:00:00 | IWM | ETF | 185.15 | 185.32 | 184.29 | 184.59 | 126835.0 |
| 2025-04-21 08:00:00 | IWM | ETF | 184.51 | 185.5 | 184.37 | 184.77 | 89650.0 |
| 2025-04-21 09:00:00 | IWM | ETF | 184.8 | 185.29 | 183.67 | 183.67 | 2314538.0 |
| 2025-04-21 10:00:00 | IWM | ETF | 183.66 | 184.08 | 182.92 | 183.1 | 2669311.0 |
| 2025-04-21 11:00:00 | IWM | ETF | 183.07 | 183.21 | 181.73 | 181.84 | 1856957.0 |
| 2025-04-21 12:00:00 | IWM | ETF | 181.85 | 182.79 | 181.7 | 181.76 | 1861564.0 |
| 2025-04-21 13:00:00 | IWM | ETF | 181.765 | 181.99 | 180.765 | 180.9 | 2048824.0 |
| 2025-04-21 14:00:00 | IWM | ETF | 180.88 | 181.58 | 180.78 | 181.03 | 2095768.0 |
| 2025-04-21 15:00:00 | IWM | ETF | 181.04 | 182.915 | 180.99 | 182.74 | 4579176.0 |
| 2025-04-21 16:00:00 | IWM | ETF | 182.74 | 182.75 | 182.19 | 182.33 | 1261831.0 |
| 2025-04-21 17:00:00 | IWM | ETF | 182.48 | 182.59 | 182.4 | 182.5 | 18830.0 |
| 2025-04-21 18:00:00 | IWM | ETF | 182.5 | 182.65 | 182.22 | 182.46 | 150258.0 |
| 2025-04-21 19:00:00 | IWM | ETF | 182.46 | 183.23 | 182.41 | 183.17 | 66855.0 |
| 2025-04-21 04:00:00 | DIA | ETF | 387.39 | 388.01 | 387.31 | 388.01 | 2480.0 |
| 2025-04-21 05:00:00 | DIA | ETF | 387.96 | 387.97 | 387.65 | 387.65 | 800.0 |
> showing 50 of 25,541 rows — these rows as CSV