PREVIEW / etf_1hour / 2000-09-12
file: by_date/etf_1hour/2000/2000-09-12.parquet size: 9 KB rows: 173
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-09-12 09:00:00 | SPY | ETF | 149.75 | 149.875 | 149.375 | 149.5 | 393000.0 |
| 2000-09-12 10:00:00 | SPY | ETF | 149.5938 | 150.0625 | 149.2812 | 149.8125 | 742700.0 |
| 2000-09-12 11:00:00 | SPY | ETF | 149.8125 | 150.25 | 149.5 | 149.9062 | 234100.0 |
| 2000-09-12 12:00:00 | SPY | ETF | 150.0 | 150.0625 | 149.75 | 149.9688 | 272500.0 |
| 2000-09-12 13:00:00 | SPY | ETF | 149.875 | 149.9688 | 149.4688 | 149.875 | 393000.0 |
| 2000-09-12 14:00:00 | SPY | ETF | 149.8125 | 149.875 | 148.9688 | 149.0 | 951900.0 |
| 2000-09-12 15:00:00 | SPY | ETF | 148.9688 | 149.3125 | 148.4375 | 148.75 | 1575200.0 |
| 2000-09-12 16:00:00 | SPY | ETF | 148.625 | 148.7188 | 148.4688 | 148.5 | 203700.0 |
| 2000-09-12 09:00:00 | QQQ | ETF | 93.5 | 94.0 | 93.0 | 93.5 | 3071800.0 |
| 2000-09-12 10:00:00 | QQQ | ETF | 93.5 | 94.5 | 93.0625 | 94.0312 | 4213300.0 |
| 2000-09-12 11:00:00 | QQQ | ETF | 94.0625 | 94.6875 | 93.6562 | 94.25 | 1935100.0 |
| 2000-09-12 12:00:00 | QQQ | ETF | 94.25 | 94.625 | 94.0312 | 94.4062 | 1070500.0 |
| 2000-09-12 13:00:00 | QQQ | ETF | 94.4062 | 94.5 | 93.5 | 94.0625 | 1505900.0 |
| 2000-09-12 14:00:00 | QQQ | ETF | 94.125 | 94.25 | 92.25 | 92.3125 | 3591100.0 |
| 2000-09-12 15:00:00 | QQQ | ETF | 92.2812 | 92.625 | 90.8438 | 91.5938 | 7788600.0 |
| 2000-09-12 16:00:00 | QQQ | ETF | 91.375 | 91.5625 | 90.9375 | 91.25 | 960300.0 |
| 2000-09-12 17:00:00 | QQQ | ETF | 91.1875 | 92.0 | 91.1875 | 91.625 | 4400.0 |
| 2000-09-12 18:00:00 | QQQ | ETF | 91.5 | 91.5625 | 91.5 | 91.5 | 400.0 |
| 2000-09-12 09:00:00 | IWM | ETF | 53.8125 | 53.8125 | 53.625 | 53.625 | 10400.0 |
| 2000-09-12 10:00:00 | IWM | ETF | 53.5938 | 53.7188 | 53.5312 | 53.5312 | 35200.0 |
| 2000-09-12 11:00:00 | IWM | ETF | 53.5 | 53.6406 | 53.5 | 53.5781 | 2400.0 |
| 2000-09-12 12:00:00 | IWM | ETF | 53.6562 | 53.6562 | 53.6562 | 53.6562 | 200.0 |
| 2000-09-12 13:00:00 | IWM | ETF | 53.6719 | 53.6875 | 53.5938 | 53.625 | 7600.0 |
| 2000-09-12 14:00:00 | IWM | ETF | 53.5625 | 53.5625 | 53.4375 | 53.5469 | 15400.0 |
| 2000-09-12 15:00:00 | IWM | ETF | 53.3125 | 53.3281 | 53.25 | 53.3281 | 21800.0 |
| 2000-09-12 09:00:00 | DIA | ETF | 111.9375 | 111.9375 | 111.1562 | 111.4375 | 135600.0 |
| 2000-09-12 10:00:00 | DIA | ETF | 111.375 | 112.0 | 111.25 | 112.0 | 58400.0 |
| 2000-09-12 11:00:00 | DIA | ETF | 112.0938 | 112.3438 | 111.8438 | 112.1875 | 99500.0 |
| 2000-09-12 12:00:00 | DIA | ETF | 112.125 | 112.4375 | 112.0 | 112.3125 | 27600.0 |
| 2000-09-12 13:00:00 | DIA | ETF | 112.25 | 112.375 | 112.125 | 112.375 | 46500.0 |
| 2000-09-12 14:00:00 | DIA | ETF | 112.375 | 112.375 | 111.9062 | 112.0312 | 43700.0 |
| 2000-09-12 15:00:00 | DIA | ETF | 112.0 | 112.625 | 111.875 | 112.4375 | 124000.0 |
| 2000-09-12 16:00:00 | DIA | ETF | 112.4688 | 113.0625 | 112.4062 | 112.9062 | 82300.0 |
> showing 33 of 173 rows — these rows as CSV