PREVIEW / etf_1hour / 2024-11-11
file: by_date/etf_1hour/2024/2024-11-11.parquet size: 616 KB rows: 22,822
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-11-11 04:00:00 | SPY | ETF | 599.22 | 600.03 | 599.0 | 599.83 | 52906.0 |
| 2024-11-11 05:00:00 | SPY | ETF | 599.86 | 599.95 | 599.65 | 599.65 | 6155.0 |
| 2024-11-11 06:00:00 | SPY | ETF | 599.62 | 600.0 | 599.62 | 599.89 | 20500.0 |
| 2024-11-11 07:00:00 | SPY | ETF | 599.9 | 600.98 | 599.9 | 600.67 | 123588.0 |
| 2024-11-11 08:00:00 | SPY | ETF | 599.9006 | 601.0 | 599.22 | 599.86 | 315092.0 |
| 2024-11-11 09:00:00 | SPY | ETF | 599.88 | 600.17 | 598.8901 | 599.162 | 3461135.0 |
| 2024-11-11 10:00:00 | SPY | ETF | 599.17 | 599.95 | 598.53 | 599.68 | 3464553.0 |
| 2024-11-11 11:00:00 | SPY | ETF | 599.69 | 599.9599 | 598.93 | 599.445 | 1701880.0 |
| 2024-11-11 12:00:00 | SPY | ETF | 599.41 | 599.56 | 598.2106 | 598.23 | 1785237.0 |
| 2024-11-11 13:00:00 | SPY | ETF | 598.21 | 598.64 | 597.0 | 598.23 | 2728340.0 |
| 2024-11-11 14:00:00 | SPY | ETF | 598.24 | 598.41 | 598.0 | 598.2885 | 1671807.0 |
| 2024-11-11 15:00:00 | SPY | ETF | 598.29 | 598.84 | 597.98 | 598.72 | 6127155.0 |
| 2024-11-11 16:00:00 | SPY | ETF | 598.73 | 598.81 | 598.17 | 598.38 | 3144399.0 |
| 2024-11-11 17:00:00 | SPY | ETF | 598.37 | 598.76 | 598.2 | 598.39 | 191553.0 |
| 2024-11-11 18:00:00 | SPY | ETF | 598.39 | 598.4 | 598.03 | 598.271 | 31517.0 |
| 2024-11-11 19:00:00 | SPY | ETF | 598.31 | 598.34 | 597.82 | 598.14 | 45663.0 |
| 2024-11-11 04:00:00 | QQQ | ETF | 515.52 | 515.93 | 515.22 | 515.61 | 69467.0 |
| 2024-11-11 05:00:00 | QQQ | ETF | 515.6 | 515.77 | 515.1 | 515.1 | 19236.0 |
| 2024-11-11 06:00:00 | QQQ | ETF | 515.05 | 515.49 | 515.0 | 515.41 | 34132.0 |
| 2024-11-11 07:00:00 | QQQ | ETF | 515.41 | 516.6 | 515.37 | 516.42 | 86526.0 |
| 2024-11-11 08:00:00 | QQQ | ETF | 515.65 | 516.68 | 514.525 | 515.8 | 151878.0 |
| 2024-11-11 09:00:00 | QQQ | ETF | 515.78 | 515.929 | 512.43 | 512.6297 | 2947041.0 |
| 2024-11-11 10:00:00 | QQQ | ETF | 512.64 | 514.43 | 512.24 | 513.92 | 2769530.0 |
| 2024-11-11 11:00:00 | QQQ | ETF | 513.93 | 514.1494 | 513.13 | 513.41 | 1386094.0 |
| 2024-11-11 12:00:00 | QQQ | ETF | 513.4099 | 513.68 | 512.31 | 512.34 | 1598077.0 |
| 2024-11-11 13:00:00 | QQQ | ETF | 512.31 | 513.29 | 510.92 | 512.88 | 2340824.0 |
| 2024-11-11 14:00:00 | QQQ | ETF | 512.89 | 512.95 | 512.28 | 512.735 | 1190059.0 |
| 2024-11-11 15:00:00 | QQQ | ETF | 512.735 | 513.94 | 512.61 | 513.83 | 3020826.0 |
| 2024-11-11 16:00:00 | QQQ | ETF | 513.85 | 514.14 | 513.3326 | 513.5702 | 1133398.0 |
| 2024-11-11 17:00:00 | QQQ | ETF | 513.59 | 513.84 | 513.55 | 513.76 | 173200.0 |
| 2024-11-11 18:00:00 | QQQ | ETF | 513.7 | 513.7898 | 513.431 | 513.76 | 19368.0 |
| 2024-11-11 19:00:00 | QQQ | ETF | 513.7 | 513.82 | 513.346 | 513.68 | 63308.0 |
| 2024-11-11 04:00:00 | IWM | ETF | 240.38 | 241.29 | 240.0 | 241.29 | 35204.0 |
| 2024-11-11 05:00:00 | IWM | ETF | 241.26 | 241.52 | 241.01 | 241.12 | 21499.0 |
| 2024-11-11 06:00:00 | IWM | ETF | 241.13 | 241.5 | 241.02 | 241.27 | 85807.0 |
| 2024-11-11 07:00:00 | IWM | ETF | 241.24 | 241.68 | 241.09 | 241.381 | 111816.0 |
| 2024-11-11 08:00:00 | IWM | ETF | 241.1511 | 241.6301 | 239.9 | 240.74 | 216078.0 |
| 2024-11-11 09:00:00 | IWM | ETF | 240.7 | 241.82 | 240.2 | 240.63 | 3666775.0 |
| 2024-11-11 10:00:00 | IWM | ETF | 240.68 | 241.625 | 239.85 | 241.44 | 3053493.0 |
| 2024-11-11 11:00:00 | IWM | ETF | 241.44 | 242.2 | 240.96 | 242.19 | 2154311.0 |
| 2024-11-11 12:00:00 | IWM | ETF | 242.18 | 242.3899 | 241.63 | 241.975 | 1789942.0 |
| 2024-11-11 13:00:00 | IWM | ETF | 241.97 | 242.03 | 240.44 | 241.71 | 2372041.0 |
| 2024-11-11 14:00:00 | IWM | ETF | 241.71 | 241.79 | 241.355 | 241.44 | 1465469.0 |
| 2024-11-11 15:00:00 | IWM | ETF | 241.44 | 241.95 | 241.17 | 241.68 | 4080566.0 |
| 2024-11-11 16:00:00 | IWM | ETF | 241.7 | 241.8112 | 241.5 | 241.6 | 1433235.0 |
| 2024-11-11 17:00:00 | IWM | ETF | 241.64 | 241.79 | 241.6 | 241.77 | 88956.0 |
| 2024-11-11 18:00:00 | IWM | ETF | 241.7 | 241.7 | 241.28 | 241.46 | 32710.0 |
| 2024-11-11 19:00:00 | IWM | ETF | 241.45 | 241.46 | 241.11 | 241.22 | 37976.0 |
| 2024-11-11 05:00:00 | DIA | ETF | 441.5 | 441.72 | 441.5 | 441.61 | 4448.0 |
| 2024-11-11 06:00:00 | DIA | ETF | 441.6 | 441.98 | 441.6 | 441.94 | 4850.0 |
> showing 50 of 22,822 rows — these rows as CSV