PREVIEW / etf_1hour / 2024-12-31
file: by_date/etf_1hour/2024/2024-12-31.parquet size: 612 KB rows: 23,172
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-12-31 04:00:00 | SPY | ETF | 587.5 | 590.39 | 587.5 | 590.08 | 25243.0 |
| 2024-12-31 05:00:00 | SPY | ETF | 590.07 | 590.5 | 589.98 | 590.5 | 13437.0 |
| 2024-12-31 06:00:00 | SPY | ETF | 590.53 | 590.74 | 590.14 | 590.52 | 37656.0 |
| 2024-12-31 07:00:00 | SPY | ETF | 590.53 | 590.99 | 589.91 | 589.91 | 134718.0 |
| 2024-12-31 08:00:00 | SPY | ETF | 590.4916 | 590.94 | 587.6 | 590.0 | 239913.0 |
| 2024-12-31 09:00:00 | SPY | ETF | 589.92 | 590.58 | 588.5559 | 590.015 | 2968898.0 |
| 2024-12-31 10:00:00 | SPY | ETF | 590.01 | 590.6399 | 588.1701 | 588.66 | 3137834.0 |
| 2024-12-31 11:00:00 | SPY | ETF | 588.69 | 588.8 | 586.54 | 587.045 | 2782422.0 |
| 2024-12-31 12:00:00 | SPY | ETF | 587.06 | 587.4 | 584.9 | 587.22 | 3691052.0 |
| 2024-12-31 13:00:00 | SPY | ETF | 587.225 | 587.68 | 584.79 | 585.34 | 3309128.0 |
| 2024-12-31 14:00:00 | SPY | ETF | 585.36 | 586.5599 | 584.42 | 586.33 | 5091713.0 |
| 2024-12-31 15:00:00 | SPY | ETF | 586.31 | 587.4999 | 584.97 | 586.01 | 12698684.0 |
| 2024-12-31 16:00:00 | SPY | ETF | 586.02 | 586.7 | 585.65 | 586.34 | 5752147.0 |
| 2024-12-31 17:00:00 | SPY | ETF | 586.31 | 586.4 | 586.18 | 586.25 | 31590.0 |
| 2024-12-31 18:00:00 | SPY | ETF | 586.4 | 586.5708 | 586.34 | 586.5 | 15270.0 |
| 2024-12-31 19:00:00 | SPY | ETF | 586.57 | 586.74 | 586.45 | 586.51 | 11877.0 |
| 2024-12-31 04:00:00 | QQQ | ETF | 515.01 | 518.14 | 515.01 | 517.54 | 80988.0 |
| 2024-12-31 05:00:00 | QQQ | ETF | 517.57 | 518.1 | 517.36 | 517.85 | 34787.0 |
| 2024-12-31 06:00:00 | QQQ | ETF | 517.95 | 518.32 | 517.4 | 517.89 | 25643.0 |
| 2024-12-31 07:00:00 | QQQ | ETF | 517.93 | 518.46 | 516.94 | 517.13 | 129169.0 |
| 2024-12-31 08:00:00 | QQQ | ETF | 518.2 | 518.4592 | 514.81 | 517.1 | 194757.0 |
| 2024-12-31 09:00:00 | QQQ | ETF | 516.9096 | 517.66 | 514.8 | 516.34 | 2227916.0 |
| 2024-12-31 10:00:00 | QQQ | ETF | 516.21 | 517.1996 | 513.99 | 515.108 | 2426204.0 |
| 2024-12-31 11:00:00 | QQQ | ETF | 515.08 | 515.16 | 512.86 | 513.8784 | 1942828.0 |
| 2024-12-31 12:00:00 | QQQ | ETF | 513.85 | 514.22 | 510.95 | 513.47 | 2180211.0 |
| 2024-12-31 13:00:00 | QQQ | ETF | 513.44 | 513.98 | 510.85 | 511.18 | 1846808.0 |
| 2024-12-31 14:00:00 | QQQ | ETF | 511.18 | 512.49 | 510.26 | 512.34 | 2747608.0 |
| 2024-12-31 15:00:00 | QQQ | ETF | 512.33 | 513.46 | 510.45 | 511.21 | 5460848.0 |
| 2024-12-31 16:00:00 | QQQ | ETF | 511.21 | 511.88 | 510.7 | 511.55 | 806812.0 |
| 2024-12-31 17:00:00 | QQQ | ETF | 511.62 | 511.781 | 511.31 | 511.5 | 28621.0 |
| 2024-12-31 18:00:00 | QQQ | ETF | 511.4 | 511.4 | 511.18 | 511.18 | 12130.0 |
| 2024-12-31 19:00:00 | QQQ | ETF | 511.24 | 511.3999 | 511.17 | 511.24 | 13368.0 |
| 2024-12-31 04:00:00 | IWM | ETF | 221.04 | 221.75 | 221.01 | 221.67 | 21246.0 |
| 2024-12-31 05:00:00 | IWM | ETF | 221.6 | 221.72 | 221.53 | 221.62 | 9359.0 |
| 2024-12-31 06:00:00 | IWM | ETF | 221.72 | 221.77 | 221.56 | 221.73 | 36807.0 |
| 2024-12-31 07:00:00 | IWM | ETF | 221.75 | 222.37 | 221.73 | 221.92 | 142126.0 |
| 2024-12-31 08:00:00 | IWM | ETF | 221.6919 | 222.4099 | 220.78 | 222.08 | 80676.0 |
| 2024-12-31 09:00:00 | IWM | ETF | 222.03 | 222.3 | 221.02 | 222.27 | 2150745.0 |
| 2024-12-31 10:00:00 | IWM | ETF | 222.26 | 223.28 | 221.58 | 221.87 | 3587299.0 |
| 2024-12-31 11:00:00 | IWM | ETF | 221.89 | 222.11 | 221.01 | 221.4 | 2419869.0 |
| 2024-12-31 12:00:00 | IWM | ETF | 221.4 | 221.62 | 220.15 | 221.55 | 2366759.0 |
| 2024-12-31 13:00:00 | IWM | ETF | 221.54 | 221.59 | 220.53 | 220.98 | 1663747.0 |
| 2024-12-31 14:00:00 | IWM | ETF | 220.9401 | 221.59 | 220.4 | 221.2 | 2048076.0 |
| 2024-12-31 15:00:00 | IWM | ETF | 221.16 | 221.81 | 220.73 | 220.95 | 4117475.0 |
| 2024-12-31 16:00:00 | IWM | ETF | 220.96 | 221.29 | 220.86 | 220.97 | 1415680.0 |
| 2024-12-31 17:00:00 | IWM | ETF | 221.23 | 221.23 | 220.97 | 221.1 | 6908.0 |
| 2024-12-31 18:00:00 | IWM | ETF | 220.96 | 221.0616 | 220.91 | 221.0 | 1222.0 |
| 2024-12-31 19:00:00 | IWM | ETF | 220.85 | 221.35 | 220.81 | 221.0 | 3080.0 |
| 2024-12-31 04:00:00 | DIA | ETF | 426.13 | 426.81 | 426.13 | 426.81 | 555.0 |
| 2024-12-31 06:00:00 | DIA | ETF | 427.02 | 427.02 | 426.93 | 426.93 | 300.0 |
> showing 50 of 23,172 rows — these rows as CSV