PREVIEW / etf_1hour / 2000-12-26
file: by_date/etf_1hour/2000/2000-12-26.parquet size: 10 KB rows: 197
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 |
|---|---|---|---|---|---|---|---|
| 2000-12-26 09:00:00 | SPY | ETF | 130.8438 | 131.9375 | 130.8438 | 131.6562 | 395000.0 |
| 2000-12-26 10:00:00 | SPY | ETF | 131.5625 | 131.7188 | 130.875 | 131.375 | 597400.0 |
| 2000-12-26 11:00:00 | SPY | ETF | 131.4375 | 131.4688 | 130.7188 | 130.9688 | 473100.0 |
| 2000-12-26 12:00:00 | SPY | ETF | 130.8438 | 131.25 | 130.625 | 130.875 | 388000.0 |
| 2000-12-26 13:00:00 | SPY | ETF | 130.8125 | 131.0625 | 130.4062 | 130.5625 | 372800.0 |
| 2000-12-26 14:00:00 | SPY | ETF | 130.5938 | 131.0938 | 130.2812 | 131.0 | 564100.0 |
| 2000-12-26 15:00:00 | SPY | ETF | 131.0 | 131.9062 | 130.9062 | 131.875 | 1513800.0 |
| 2000-12-26 16:00:00 | SPY | ETF | 131.7812 | 133.0 | 131.7188 | 132.0 | 351000.0 |
| 2000-12-26 17:00:00 | SPY | ETF | 132.0 | 132.0 | 131.75 | 131.75 | 300.0 |
| 2000-12-26 09:00:00 | QQQ | ETF | 60.5938 | 61.9062 | 60.4375 | 61.0625 | 7907100.0 |
| 2000-12-26 10:00:00 | QQQ | ETF | 61.0625 | 61.1562 | 59.375 | 59.9688 | 7289000.0 |
| 2000-12-26 11:00:00 | QQQ | ETF | 59.9688 | 60.375 | 59.125 | 59.5 | 3302900.0 |
| 2000-12-26 12:00:00 | QQQ | ETF | 59.5 | 59.8125 | 58.875 | 59.4688 | 3040700.0 |
| 2000-12-26 13:00:00 | QQQ | ETF | 59.4062 | 59.625 | 58.8125 | 59.0312 | 1963300.0 |
| 2000-12-26 14:00:00 | QQQ | ETF | 59.0 | 59.125 | 58.0625 | 58.7812 | 4468500.0 |
| 2000-12-26 15:00:00 | QQQ | ETF | 58.7812 | 60.1875 | 58.625 | 60.0938 | 6802900.0 |
| 2000-12-26 16:00:00 | QQQ | ETF | 60.1875 | 61.75 | 59.375 | 60.75 | 1732300.0 |
| 2000-12-26 17:00:00 | QQQ | ETF | 60.5 | 61.0 | 60.5 | 60.875 | 12300.0 |
| 2000-12-26 18:00:00 | QQQ | ETF | 60.875 | 60.9062 | 60.75 | 60.75 | 5700.0 |
| 2000-12-26 09:00:00 | IWM | ETF | 46.25 | 46.4062 | 46.1875 | 46.1875 | 154800.0 |
| 2000-12-26 10:00:00 | IWM | ETF | 46.2812 | 46.4062 | 46.0312 | 46.2344 | 72800.0 |
| 2000-12-26 11:00:00 | IWM | ETF | 46.25 | 46.2812 | 46.0938 | 46.0938 | 13600.0 |
| 2000-12-26 12:00:00 | IWM | ETF | 46.1562 | 46.2188 | 46.0156 | 46.2188 | 50600.0 |
| 2000-12-26 13:00:00 | IWM | ETF | 46.0312 | 46.25 | 46.0312 | 46.0625 | 19600.0 |
| 2000-12-26 14:00:00 | IWM | ETF | 46.125 | 46.3125 | 46.0312 | 46.3125 | 62400.0 |
| 2000-12-26 15:00:00 | IWM | ETF | 46.3125 | 46.6094 | 46.3125 | 46.6094 | 139800.0 |
| 2000-12-26 16:00:00 | IWM | ETF | 46.5156 | 46.5156 | 46.5156 | 46.5156 | 400.0 |
| 2000-12-26 09:00:00 | DIA | ETF | 106.9375 | 107.1562 | 106.3438 | 106.5625 | 194300.0 |
| 2000-12-26 10:00:00 | DIA | ETF | 106.6875 | 106.8438 | 106.0312 | 106.5 | 173600.0 |
| 2000-12-26 11:00:00 | DIA | ETF | 106.4375 | 106.5 | 106.0625 | 106.2812 | 50500.0 |
| 2000-12-26 12:00:00 | DIA | ETF | 106.2812 | 106.4375 | 106.0312 | 106.4375 | 88200.0 |
| 2000-12-26 13:00:00 | DIA | ETF | 106.3125 | 106.3125 | 105.9688 | 106.1562 | 60700.0 |
| 2000-12-26 14:00:00 | DIA | ETF | 106.1562 | 106.7812 | 106.0 | 106.625 | 80500.0 |
| 2000-12-26 15:00:00 | DIA | ETF | 106.7188 | 107.0625 | 106.5625 | 107.0 | 223500.0 |
| 2000-12-26 16:00:00 | DIA | ETF | 107.0312 | 107.5625 | 106.9688 | 107.5 | 62600.0 |
> showing 35 of 197 rows — these rows as CSV