PREVIEW / etf_1hour / 2000-06-12
file: by_date/etf_1hour/2000/2000-06-12.parquet size: 9 KB rows: 156
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-06-12 09:00:00 | SPY | ETF | 146.9688 | 146.9688 | 146.5 | 146.6562 | 234100.0 |
| 2000-06-12 10:00:00 | SPY | ETF | 146.5312 | 146.6875 | 145.8125 | 146.1562 | 442900.0 |
| 2000-06-12 11:00:00 | SPY | ETF | 146.1875 | 146.1875 | 145.5625 | 145.5625 | 178100.0 |
| 2000-06-12 12:00:00 | SPY | ETF | 145.5312 | 145.875 | 145.3125 | 145.875 | 357000.0 |
| 2000-06-12 13:00:00 | SPY | ETF | 145.9375 | 145.9688 | 145.4062 | 145.625 | 239200.0 |
| 2000-06-12 14:00:00 | SPY | ETF | 145.625 | 145.875 | 145.25 | 145.75 | 195700.0 |
| 2000-06-12 15:00:00 | SPY | ETF | 145.7812 | 146.0625 | 145.125 | 145.2812 | 1432400.0 |
| 2000-06-12 16:00:00 | SPY | ETF | 145.2812 | 145.2812 | 144.875 | 145.125 | 396900.0 |
| 2000-06-12 09:00:00 | QQQ | ETF | 94.3125 | 94.3125 | 93.0 | 93.4375 | 1923700.0 |
| 2000-06-12 10:00:00 | QQQ | ETF | 93.375 | 93.5625 | 91.875 | 92.3438 | 3011800.0 |
| 2000-06-12 11:00:00 | QQQ | ETF | 92.25 | 92.4688 | 91.5625 | 91.8125 | 1831500.0 |
| 2000-06-12 12:00:00 | QQQ | ETF | 91.75 | 92.125 | 91.25 | 92.0625 | 1898600.0 |
| 2000-06-12 13:00:00 | QQQ | ETF | 92.0938 | 92.3125 | 91.375 | 91.5 | 1667500.0 |
| 2000-06-12 14:00:00 | QQQ | ETF | 91.4375 | 92.125 | 91.375 | 92.125 | 1545000.0 |
| 2000-06-12 15:00:00 | QQQ | ETF | 92.1875 | 92.75 | 90.875 | 90.9688 | 3836200.0 |
| 2000-06-12 16:00:00 | QQQ | ETF | 91.0 | 91.25 | 90.8125 | 91.0 | 683800.0 |
| 2000-06-12 17:00:00 | QQQ | ETF | 90.875 | 90.875 | 90.75 | 90.75 | 1300.0 |
| 2000-06-12 18:00:00 | QQQ | ETF | 90.75 | 90.75 | 90.75 | 90.75 | 200.0 |
| 2000-06-12 09:00:00 | IWM | ETF | 52.5 | 52.5 | 52.25 | 52.25 | 13600.0 |
| 2000-06-12 10:00:00 | IWM | ETF | 52.1719 | 52.1875 | 51.7812 | 51.8438 | 3000.0 |
| 2000-06-12 12:00:00 | IWM | ETF | 51.1875 | 51.1875 | 51.0938 | 51.1094 | 13400.0 |
| 2000-06-12 13:00:00 | IWM | ETF | 51.2969 | 51.2969 | 51.1094 | 51.1094 | 2800.0 |
| 2000-06-12 14:00:00 | IWM | ETF | 51.1719 | 51.2188 | 51.125 | 51.125 | 5000.0 |
| 2000-06-12 15:00:00 | IWM | ETF | 51.1875 | 51.2812 | 50.75 | 50.75 | 47200.0 |
| 2000-06-12 16:00:00 | IWM | ETF | 50.7812 | 50.7812 | 50.7812 | 50.7812 | 200.0 |
| 2000-06-12 09:00:00 | DIA | ETF | 106.625 | 106.6875 | 106.2812 | 106.375 | 34200.0 |
| 2000-06-12 10:00:00 | DIA | ETF | 106.3125 | 106.5 | 106.0 | 106.2812 | 71600.0 |
| 2000-06-12 11:00:00 | DIA | ETF | 106.3125 | 106.4688 | 105.8438 | 105.9688 | 55600.0 |
| 2000-06-12 12:00:00 | DIA | ETF | 105.9375 | 106.2188 | 105.7188 | 106.125 | 145300.0 |
| 2000-06-12 13:00:00 | DIA | ETF | 106.1562 | 106.2812 | 106.0 | 106.0312 | 6400.0 |
| 2000-06-12 14:00:00 | DIA | ETF | 106.0 | 106.2812 | 105.9062 | 106.0625 | 63500.0 |
| 2000-06-12 15:00:00 | DIA | ETF | 106.0938 | 106.2188 | 105.6562 | 105.7188 | 46400.0 |
| 2000-06-12 16:00:00 | DIA | ETF | 105.75 | 105.75 | 105.6562 | 105.7188 | 1700.0 |
> showing 33 of 156 rows — these rows as CSV