PREVIEW / etf_1hour / 2024-12-19
file: by_date/etf_1hour/2024/2024-12-19.parquet size: 629 KB rows: 24,237
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-19 04:00:00 | SPY | ETF | 588.61 | 589.19 | 588.28 | 588.91 | 70428.0 |
| 2024-12-19 05:00:00 | SPY | ETF | 588.97 | 589.65 | 588.65 | 588.65 | 31896.0 |
| 2024-12-19 06:00:00 | SPY | ETF | 588.69 | 589.38 | 588.51 | 589.14 | 86828.0 |
| 2024-12-19 07:00:00 | SPY | ETF | 589.14 | 591.37 | 589.02 | 591.29 | 649967.0 |
| 2024-12-19 08:00:00 | SPY | ETF | 589.09 | 591.6 | 586.31 | 590.35 | 740502.0 |
| 2024-12-19 09:00:00 | SPY | ETF | 590.33 | 593.0 | 589.81 | 590.53 | 5920892.0 |
| 2024-12-19 10:00:00 | SPY | ETF | 590.515 | 590.92 | 587.79 | 589.72 | 8031517.0 |
| 2024-12-19 11:00:00 | SPY | ETF | 589.72 | 591.4 | 587.823 | 589.8797 | 5351607.0 |
| 2024-12-19 12:00:00 | SPY | ETF | 589.86 | 590.1487 | 587.4605 | 589.06 | 3604634.0 |
| 2024-12-19 13:00:00 | SPY | ETF | 589.02 | 591.26 | 587.28 | 591.25 | 3539540.0 |
| 2024-12-19 14:00:00 | SPY | ETF | 591.22 | 591.26 | 588.05 | 588.06 | 4438873.0 |
| 2024-12-19 15:00:00 | SPY | ETF | 588.09 | 589.43 | 585.85 | 586.12 | 13695559.0 |
| 2024-12-19 16:00:00 | SPY | ETF | 586.14 | 586.99 | 585.79 | 586.8 | 6401367.0 |
| 2024-12-19 17:00:00 | SPY | ETF | 586.76 | 586.93 | 586.1006 | 586.87 | 221599.0 |
| 2024-12-19 18:00:00 | SPY | ETF | 586.87 | 586.91 | 586.04 | 586.19 | 419355.0 |
| 2024-12-19 19:00:00 | SPY | ETF | 586.3 | 586.5 | 584.14 | 584.31 | 443342.0 |
| 2024-12-19 04:00:00 | QQQ | ETF | 518.97 | 519.24 | 517.78 | 518.49 | 202957.0 |
| 2024-12-19 05:00:00 | QQQ | ETF | 518.55 | 519.63 | 518.5 | 518.57 | 210332.0 |
| 2024-12-19 06:00:00 | QQQ | ETF | 518.66 | 519.06 | 518.17 | 518.63 | 184824.0 |
| 2024-12-19 07:00:00 | QQQ | ETF | 518.71 | 521.18 | 518.5 | 521.18 | 464680.0 |
| 2024-12-19 08:00:00 | QQQ | ETF | 518.79 | 521.34 | 515.5 | 520.01 | 570193.0 |
| 2024-12-19 09:00:00 | QQQ | ETF | 519.96 | 521.7599 | 518.28 | 518.91 | 5384582.0 |
| 2024-12-19 10:00:00 | QQQ | ETF | 518.87 | 520.21 | 516.12 | 518.217 | 6114989.0 |
| 2024-12-19 11:00:00 | QQQ | ETF | 518.2 | 520.12 | 516.08 | 518.56 | 3602263.0 |
| 2024-12-19 12:00:00 | QQQ | ETF | 518.5001 | 518.72 | 515.38 | 517.5201 | 3273985.0 |
| 2024-12-19 13:00:00 | QQQ | ETF | 517.47 | 519.48 | 515.56 | 519.4401 | 2661635.0 |
| 2024-12-19 14:00:00 | QQQ | ETF | 519.43 | 519.47 | 516.16 | 516.17 | 2320632.0 |
| 2024-12-19 15:00:00 | QQQ | ETF | 516.23 | 517.82 | 513.83 | 514.17 | 6869482.0 |
| 2024-12-19 16:00:00 | QQQ | ETF | 514.17 | 517.8595 | 513.37 | 514.95 | 1692499.0 |
| 2024-12-19 17:00:00 | QQQ | ETF | 514.9694 | 515.09 | 514.6 | 514.81 | 63721.0 |
| 2024-12-19 18:00:00 | QQQ | ETF | 514.95 | 515.2 | 513.8202 | 514.0 | 129237.0 |
| 2024-12-19 19:00:00 | QQQ | ETF | 514.17 | 514.34 | 511.5 | 511.7 | 178654.0 |
| 2024-12-19 04:00:00 | IWM | ETF | 222.0 | 222.48 | 221.66 | 222.11 | 149439.0 |
| 2024-12-19 05:00:00 | IWM | ETF | 222.28 | 222.63 | 221.83 | 221.84 | 121037.0 |
| 2024-12-19 06:00:00 | IWM | ETF | 221.75 | 222.03 | 221.67 | 221.76 | 24660.0 |
| 2024-12-19 07:00:00 | IWM | ETF | 221.74 | 222.78 | 221.69 | 222.77 | 257839.0 |
| 2024-12-19 08:00:00 | IWM | ETF | 221.61 | 223.1 | 220.54 | 222.53 | 554038.0 |
| 2024-12-19 09:00:00 | IWM | ETF | 222.53 | 224.43 | 221.94 | 222.27 | 5437743.0 |
| 2024-12-19 10:00:00 | IWM | ETF | 222.28 | 222.4 | 219.59 | 220.85 | 6270482.0 |
| 2024-12-19 11:00:00 | IWM | ETF | 220.83 | 221.98 | 219.68 | 221.25 | 4217049.0 |
| 2024-12-19 12:00:00 | IWM | ETF | 221.23 | 221.34 | 219.56 | 220.0 | 3050287.0 |
| 2024-12-19 13:00:00 | IWM | ETF | 219.99 | 221.43 | 219.3299 | 221.38 | 2800171.0 |
| 2024-12-19 14:00:00 | IWM | ETF | 221.37 | 221.44 | 220.24 | 220.26 | 2885425.0 |
| 2024-12-19 15:00:00 | IWM | ETF | 220.29 | 221.48 | 219.8 | 219.92 | 8885576.0 |
| 2024-12-19 16:00:00 | IWM | ETF | 219.86 | 220.35 | 219.7 | 220.01 | 2435463.0 |
| 2024-12-19 17:00:00 | IWM | ETF | 220.09 | 220.09 | 219.87 | 220.0 | 23203.0 |
| 2024-12-19 18:00:00 | IWM | ETF | 219.99 | 220.1 | 219.5304 | 219.65 | 42479.0 |
| 2024-12-19 19:00:00 | IWM | ETF | 219.65 | 219.75 | 218.6 | 218.61 | 111281.0 |
| 2024-12-19 04:00:00 | DIA | ETF | 425.93 | 426.03 | 425.19 | 425.53 | 22429.0 |
| 2024-12-19 05:00:00 | DIA | ETF | 425.99 | 426.23 | 425.7 | 425.7 | 4367.0 |
> showing 50 of 24,237 rows — these rows as CSV