PREVIEW / etf_1hour / 2024-12-10
file: by_date/etf_1hour/2024/2024-12-10.parquet size: 603 KB rows: 22,396
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-10 04:00:00 | SPY | ETF | 604.5 | 604.5 | 604.0 | 604.14 | 14939.0 |
| 2024-12-10 05:00:00 | SPY | ETF | 604.4 | 604.84 | 604.4 | 604.82 | 5056.0 |
| 2024-12-10 06:00:00 | SPY | ETF | 604.8 | 605.33 | 604.8 | 605.13 | 56707.0 |
| 2024-12-10 07:00:00 | SPY | ETF | 605.18 | 605.31 | 605.1 | 605.25 | 115395.0 |
| 2024-12-10 08:00:00 | SPY | ETF | 605.13 | 605.32 | 604.17 | 604.79 | 154851.0 |
| 2024-12-10 09:00:00 | SPY | ETF | 604.87 | 605.41 | 604.2737 | 605.09 | 2212914.0 |
| 2024-12-10 10:00:00 | SPY | ETF | 605.075 | 605.8 | 604.88 | 605.0083 | 2352730.0 |
| 2024-12-10 11:00:00 | SPY | ETF | 605.0 | 605.27 | 604.31 | 604.57 | 1977157.0 |
| 2024-12-10 12:00:00 | SPY | ETF | 604.56 | 605.02 | 604.18 | 604.3101 | 1361878.0 |
| 2024-12-10 13:00:00 | SPY | ETF | 604.32 | 604.62 | 604.04 | 604.05 | 1626554.0 |
| 2024-12-10 14:00:00 | SPY | ETF | 604.04 | 604.11 | 603.53 | 603.655 | 2971739.0 |
| 2024-12-10 15:00:00 | SPY | ETF | 603.65 | 603.66 | 602.13 | 602.87 | 7037832.0 |
| 2024-12-10 16:00:00 | SPY | ETF | 602.87 | 603.44 | 602.6371 | 603.36 | 2846870.0 |
| 2024-12-10 17:00:00 | SPY | ETF | 603.2975 | 603.48 | 603.26 | 603.35 | 31519.0 |
| 2024-12-10 18:00:00 | SPY | ETF | 603.4 | 603.59 | 603.06 | 603.26 | 43933.0 |
| 2024-12-10 19:00:00 | SPY | ETF | 603.26 | 603.3 | 603.02 | 603.16 | 29134.0 |
| 2024-12-10 04:00:00 | QQQ | ETF | 521.36 | 521.96 | 521.36 | 521.73 | 18812.0 |
| 2024-12-10 05:00:00 | QQQ | ETF | 521.91 | 522.7 | 521.89 | 522.6 | 25955.0 |
| 2024-12-10 06:00:00 | QQQ | ETF | 522.67 | 523.23 | 522.62 | 523.04 | 42345.0 |
| 2024-12-10 07:00:00 | QQQ | ETF | 523.06 | 523.67 | 522.96 | 523.5 | 61824.0 |
| 2024-12-10 08:00:00 | QQQ | ETF | 523.07 | 523.7 | 521.65 | 522.8 | 189722.0 |
| 2024-12-10 09:00:00 | QQQ | ETF | 522.88 | 524.95 | 522.67 | 523.97 | 2360671.0 |
| 2024-12-10 10:00:00 | QQQ | ETF | 523.96 | 525.38 | 522.72 | 522.9349 | 2185816.0 |
| 2024-12-10 11:00:00 | QQQ | ETF | 522.94 | 523.1599 | 521.5301 | 522.36 | 2278608.0 |
| 2024-12-10 12:00:00 | QQQ | ETF | 522.37 | 522.82 | 521.41 | 522.04 | 1562860.0 |
| 2024-12-10 13:00:00 | QQQ | ETF | 522.04 | 522.4 | 521.55 | 521.59 | 1390523.0 |
| 2024-12-10 14:00:00 | QQQ | ETF | 521.61 | 521.77 | 520.3 | 520.58 | 1980639.0 |
| 2024-12-10 15:00:00 | QQQ | ETF | 520.58 | 520.6198 | 519.16 | 520.55 | 4417205.0 |
| 2024-12-10 16:00:00 | QQQ | ETF | 520.5331 | 521.22 | 520.5331 | 521.13 | 1153238.0 |
| 2024-12-10 17:00:00 | QQQ | ETF | 521.11 | 521.15 | 520.95 | 521.01 | 34487.0 |
| 2024-12-10 18:00:00 | QQQ | ETF | 521.08 | 521.31 | 520.79 | 520.99 | 44050.0 |
| 2024-12-10 19:00:00 | QQQ | ETF | 520.9 | 521.01 | 520.57 | 520.85 | 28174.0 |
| 2024-12-10 04:00:00 | IWM | ETF | 237.52 | 237.77 | 237.3 | 237.66 | 17141.0 |
| 2024-12-10 05:00:00 | IWM | ETF | 237.75 | 237.88 | 237.7 | 237.82 | 3463.0 |
| 2024-12-10 06:00:00 | IWM | ETF | 237.85 | 238.44 | 237.8 | 238.38 | 40051.0 |
| 2024-12-10 07:00:00 | IWM | ETF | 238.38 | 238.44 | 238.02 | 238.09 | 91206.0 |
| 2024-12-10 08:00:00 | IWM | ETF | 238.4 | 238.44 | 237.15 | 237.46 | 124285.0 |
| 2024-12-10 09:00:00 | IWM | ETF | 237.4901 | 237.6901 | 235.92 | 236.9 | 1978107.0 |
| 2024-12-10 10:00:00 | IWM | ETF | 236.92 | 237.96 | 236.2 | 237.96 | 1765759.0 |
| 2024-12-10 11:00:00 | IWM | ETF | 237.96 | 238.37 | 237.53 | 238.005 | 1496893.0 |
| 2024-12-10 12:00:00 | IWM | ETF | 238.0 | 238.815 | 237.8 | 238.11 | 1445021.0 |
| 2024-12-10 13:00:00 | IWM | ETF | 238.11 | 238.63 | 237.96 | 238.1704 | 778539.0 |
| 2024-12-10 14:00:00 | IWM | ETF | 238.175 | 238.565 | 237.94 | 238.1 | 895770.0 |
| 2024-12-10 15:00:00 | IWM | ETF | 238.0901 | 238.0901 | 236.41 | 236.77 | 3855393.0 |
| 2024-12-10 16:00:00 | IWM | ETF | 236.76 | 237.27 | 236.7 | 237.2 | 1319453.0 |
| 2024-12-10 17:00:00 | IWM | ETF | 237.18 | 237.29 | 237.07 | 237.14 | 13213.0 |
| 2024-12-10 18:00:00 | IWM | ETF | 237.21 | 237.2704 | 236.92 | 237.1086 | 13883.0 |
| 2024-12-10 19:00:00 | IWM | ETF | 236.93 | 237.27 | 236.9101 | 237.15 | 31665.0 |
| 2024-12-10 04:00:00 | DIA | ETF | 444.74 | 444.9 | 444.74 | 444.9 | 220.0 |
| 2024-12-10 05:00:00 | DIA | ETF | 444.93 | 445.09 | 444.92 | 445.03 | 1716.0 |
> showing 50 of 22,396 rows — these rows as CSV