PREVIEW / etf_1hour / 2000-12-19
file: by_date/etf_1hour/2000/2000-12-19.parquet size: 10 KB rows: 203
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-19 09:00:00 | SPY | ETF | 132.4688 | 133.3438 | 132.0 | 133.2188 | 655600.0 |
| 2000-12-19 10:00:00 | SPY | ETF | 133.375 | 133.5938 | 133.0 | 133.1875 | 760100.0 |
| 2000-12-19 11:00:00 | SPY | ETF | 133.125 | 133.75 | 133.0625 | 133.75 | 590300.0 |
| 2000-12-19 12:00:00 | SPY | ETF | 133.75 | 134.0 | 133.625 | 133.9688 | 401000.0 |
| 2000-12-19 13:00:00 | SPY | ETF | 134.0 | 134.9688 | 133.875 | 134.7188 | 793000.0 |
| 2000-12-19 14:00:00 | SPY | ETF | 134.8125 | 134.875 | 132.5 | 132.7188 | 2299700.0 |
| 2000-12-19 15:00:00 | SPY | ETF | 132.625 | 132.8438 | 130.5 | 130.5625 | 2960400.0 |
| 2000-12-19 16:00:00 | SPY | ETF | 130.7188 | 130.7188 | 130.0 | 130.0 | 526100.0 |
| 2000-12-19 17:00:00 | SPY | ETF | 130.0 | 130.0 | 130.0 | 130.0 | 800.0 |
| 2000-12-19 18:00:00 | SPY | ETF | 130.25 | 130.25 | 130.25 | 130.25 | 8000.0 |
| 2000-12-19 09:00:00 | QQQ | ETF | 63.4375 | 64.9375 | 62.875 | 64.75 | 5678300.0 |
| 2000-12-19 10:00:00 | QQQ | ETF | 64.6562 | 65.3438 | 64.25 | 64.625 | 8123000.0 |
| 2000-12-19 11:00:00 | QQQ | ETF | 64.625 | 65.625 | 64.5 | 65.5312 | 3113100.0 |
| 2000-12-19 12:00:00 | QQQ | ETF | 65.5 | 65.7188 | 65.0312 | 65.4062 | 3966300.0 |
| 2000-12-19 13:00:00 | QQQ | ETF | 65.3125 | 65.8438 | 65.125 | 65.25 | 5956800.0 |
| 2000-12-19 14:00:00 | QQQ | ETF | 65.3125 | 65.4375 | 62.25 | 62.375 | 24584000.0 |
| 2000-12-19 15:00:00 | QQQ | ETF | 62.3125 | 62.5 | 59.7812 | 60.0 | 23228300.0 |
| 2000-12-19 16:00:00 | QQQ | ETF | 59.8125 | 65.75 | 58.75 | 59.0938 | 2292400.0 |
| 2000-12-19 17:00:00 | QQQ | ETF | 59.125 | 60.0625 | 58.75 | 59.1875 | 200100.0 |
| 2000-12-19 18:00:00 | QQQ | ETF | 59.25 | 59.5 | 59.0 | 59.25 | 19400.0 |
| 2000-12-19 09:00:00 | IWM | ETF | 46.25 | 46.25 | 45.9375 | 46.125 | 15200.0 |
| 2000-12-19 10:00:00 | IWM | ETF | 46.3125 | 46.4688 | 46.3125 | 46.375 | 38000.0 |
| 2000-12-19 11:00:00 | IWM | ETF | 46.375 | 46.5312 | 46.3438 | 46.4375 | 12400.0 |
| 2000-12-19 12:00:00 | IWM | ETF | 46.4375 | 46.5938 | 46.4375 | 46.5781 | 30400.0 |
| 2000-12-19 13:00:00 | IWM | ETF | 46.5781 | 46.6875 | 46.5625 | 46.6875 | 115400.0 |
| 2000-12-19 14:00:00 | IWM | ETF | 46.5625 | 46.75 | 46.1875 | 46.1875 | 79200.0 |
| 2000-12-19 15:00:00 | IWM | ETF | 46.1562 | 46.1562 | 45.5 | 45.625 | 116800.0 |
| 2000-12-19 16:00:00 | IWM | ETF | 45.5 | 45.5625 | 45.5 | 45.5625 | 34000.0 |
| 2000-12-19 09:00:00 | DIA | ETF | 106.5312 | 106.8125 | 106.25 | 106.8125 | 81300.0 |
| 2000-12-19 10:00:00 | DIA | ETF | 106.9688 | 106.9688 | 106.0938 | 106.3125 | 155100.0 |
| 2000-12-19 11:00:00 | DIA | ETF | 106.25 | 106.7812 | 106.25 | 106.5938 | 68300.0 |
| 2000-12-19 12:00:00 | DIA | ETF | 106.75 | 107.0 | 106.5938 | 107.0 | 60400.0 |
| 2000-12-19 13:00:00 | DIA | ETF | 106.9375 | 107.875 | 106.9375 | 107.7188 | 181800.0 |
| 2000-12-19 14:00:00 | DIA | ETF | 107.625 | 107.9062 | 106.25 | 106.6562 | 517300.0 |
| 2000-12-19 15:00:00 | DIA | ETF | 106.6562 | 106.8125 | 105.75 | 105.9062 | 428700.0 |
| 2000-12-19 16:00:00 | DIA | ETF | 105.9062 | 105.9062 | 105.5 | 105.5 | 39500.0 |
> showing 36 of 203 rows — these rows as CSV