PREVIEW / etf_1hour / 2024-12-03
file: by_date/etf_1hour/2024/2024-12-03.parquet size: 606 KB rows: 22,590
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-03 04:00:00 | SPY | ETF | 604.01 | 604.14 | 603.83 | 604.04 | 6088.0 |
| 2024-12-03 05:00:00 | SPY | ETF | 604.0 | 604.04 | 603.6 | 603.6 | 6618.0 |
| 2024-12-03 06:00:00 | SPY | ETF | 603.6 | 603.88 | 603.36 | 603.88 | 14314.0 |
| 2024-12-03 07:00:00 | SPY | ETF | 603.91 | 604.11 | 603.72 | 603.84 | 23432.0 |
| 2024-12-03 08:00:00 | SPY | ETF | 603.79 | 604.24 | 603.6291 | 603.65 | 116708.0 |
| 2024-12-03 09:00:00 | SPY | ETF | 603.65 | 603.94 | 602.77 | 603.35 | 2178045.0 |
| 2024-12-03 10:00:00 | SPY | ETF | 603.35 | 603.62 | 602.341 | 602.8845 | 2502407.0 |
| 2024-12-03 11:00:00 | SPY | ETF | 602.89 | 603.5 | 602.37 | 602.5572 | 2088767.0 |
| 2024-12-03 12:00:00 | SPY | ETF | 602.56 | 603.7299 | 602.53 | 603.71 | 1335408.0 |
| 2024-12-03 13:00:00 | SPY | ETF | 603.71 | 603.85 | 603.29 | 603.44 | 1407583.0 |
| 2024-12-03 14:00:00 | SPY | ETF | 603.43 | 604.16 | 603.17 | 604.03 | 1948307.0 |
| 2024-12-03 15:00:00 | SPY | ETF | 604.0201 | 604.14 | 603.49 | 603.85 | 4713027.0 |
| 2024-12-03 16:00:00 | SPY | ETF | 603.86 | 604.6 | 603.4002 | 604.25 | 2048697.0 |
| 2024-12-03 17:00:00 | SPY | ETF | 604.274 | 604.43 | 604.0 | 604.28 | 61650.0 |
| 2024-12-03 18:00:00 | SPY | ETF | 604.25 | 604.52 | 603.9 | 604.5149 | 33825.0 |
| 2024-12-03 19:00:00 | SPY | ETF | 604.45 | 604.45 | 604.11 | 604.1901 | 14226.0 |
| 2024-12-03 04:00:00 | QQQ | ETF | 515.39 | 515.5 | 515.24 | 515.32 | 22803.0 |
| 2024-12-03 05:00:00 | QQQ | ETF | 515.35 | 515.47 | 515.0 | 515.0 | 13229.0 |
| 2024-12-03 06:00:00 | QQQ | ETF | 515.0 | 515.2 | 514.66 | 515.15 | 24365.0 |
| 2024-12-03 07:00:00 | QQQ | ETF | 515.13 | 515.45 | 514.72 | 515.18 | 48282.0 |
| 2024-12-03 08:00:00 | QQQ | ETF | 514.96 | 515.88 | 514.7301 | 514.88 | 118404.0 |
| 2024-12-03 09:00:00 | QQQ | ETF | 514.88 | 515.2 | 513.37 | 515.0555 | 2464817.0 |
| 2024-12-03 10:00:00 | QQQ | ETF | 515.03 | 515.79 | 514.13 | 515.15 | 1969419.0 |
| 2024-12-03 11:00:00 | QQQ | ETF | 515.15 | 516.48 | 514.885 | 515.11 | 1917618.0 |
| 2024-12-03 12:00:00 | QQQ | ETF | 515.13 | 516.0 | 514.75 | 515.99 | 914523.0 |
| 2024-12-03 13:00:00 | QQQ | ETF | 515.97 | 516.09 | 515.33 | 515.77 | 999080.0 |
| 2024-12-03 14:00:00 | QQQ | ETF | 515.74 | 516.46 | 515.56 | 516.31 | 874867.0 |
| 2024-12-03 15:00:00 | QQQ | ETF | 516.3 | 517.15 | 515.92 | 516.91 | 1992951.0 |
| 2024-12-03 16:00:00 | QQQ | ETF | 516.9 | 518.06 | 515.29 | 517.99 | 816840.0 |
| 2024-12-03 17:00:00 | QQQ | ETF | 518.03 | 518.08 | 517.82 | 518.0 | 41178.0 |
| 2024-12-03 18:00:00 | QQQ | ETF | 517.93 | 518.27 | 517.55 | 518.21 | 74532.0 |
| 2024-12-03 19:00:00 | QQQ | ETF | 518.22 | 518.22 | 517.81 | 517.97 | 30969.0 |
| 2024-12-03 04:00:00 | IWM | ETF | 241.83 | 242.1 | 241.71 | 242.1 | 9634.0 |
| 2024-12-03 05:00:00 | IWM | ETF | 242.12 | 242.12 | 241.52 | 241.52 | 3237.0 |
| 2024-12-03 06:00:00 | IWM | ETF | 241.72 | 241.9 | 241.47 | 241.9 | 5711.0 |
| 2024-12-03 07:00:00 | IWM | ETF | 241.83 | 242.08 | 241.6 | 241.6 | 55092.0 |
| 2024-12-03 08:00:00 | IWM | ETF | 241.9999 | 242.06 | 241.5 | 241.5 | 75983.0 |
| 2024-12-03 09:00:00 | IWM | ETF | 241.51 | 242.14 | 240.825 | 241.01 | 1392643.0 |
| 2024-12-03 10:00:00 | IWM | ETF | 240.99 | 241.37 | 239.96 | 240.33 | 2588939.0 |
| 2024-12-03 11:00:00 | IWM | ETF | 240.31 | 240.425 | 239.49 | 239.62 | 1422756.0 |
| 2024-12-03 12:00:00 | IWM | ETF | 239.61 | 240.63 | 239.37 | 240.54 | 1437939.0 |
| 2024-12-03 13:00:00 | IWM | ETF | 240.5446 | 240.7 | 239.62 | 239.785 | 1009840.0 |
| 2024-12-03 14:00:00 | IWM | ETF | 239.785 | 240.21 | 239.585 | 240.16 | 799984.0 |
| 2024-12-03 15:00:00 | IWM | ETF | 240.175 | 240.21 | 239.7 | 240.09 | 3069167.0 |
| 2024-12-03 16:00:00 | IWM | ETF | 240.09 | 240.09 | 239.82 | 239.9 | 2850343.0 |
| 2024-12-03 17:00:00 | IWM | ETF | 239.9 | 239.99 | 239.86 | 239.98 | 4914.0 |
| 2024-12-03 18:00:00 | IWM | ETF | 239.88 | 239.9 | 238.0 | 239.87 | 207034.0 |
| 2024-12-03 19:00:00 | IWM | ETF | 239.9 | 239.9 | 239.51 | 239.5614 | 17087.0 |
| 2024-12-03 04:00:00 | DIA | ETF | 448.94 | 448.94 | 448.68 | 448.68 | 595.0 |
| 2024-12-03 05:00:00 | DIA | ETF | 448.76 | 448.76 | 448.52 | 448.52 | 313.0 |
> showing 50 of 22,590 rows — these rows as CSV