PREVIEW / etf_1hour / 2000-06-16
file: by_date/etf_1hour/2000/2000-06-16.parquet size: 9 KB rows: 163
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-16 09:00:00 | SPY | ETF | 148.3125 | 148.3125 | 147.5312 | 147.625 | 344500.0 |
| 2000-06-16 10:00:00 | SPY | ETF | 147.75 | 147.75 | 146.9062 | 147.4688 | 537100.0 |
| 2000-06-16 11:00:00 | SPY | ETF | 147.4375 | 147.5 | 146.75 | 146.9688 | 269400.0 |
| 2000-06-16 12:00:00 | SPY | ETF | 147.1875 | 147.4062 | 146.75 | 146.8125 | 2152100.0 |
| 2000-06-16 13:00:00 | SPY | ETF | 146.8438 | 147.6875 | 146.8125 | 147.5 | 162900.0 |
| 2000-06-16 14:00:00 | SPY | ETF | 147.375 | 147.625 | 147.0312 | 147.125 | 412200.0 |
| 2000-06-16 15:00:00 | SPY | ETF | 147.0312 | 147.1875 | 145.875 | 146.875 | 1074000.0 |
| 2000-06-16 16:00:00 | SPY | ETF | 146.875 | 147.0625 | 146.5938 | 146.5938 | 603400.0 |
| 2000-06-16 09:00:00 | QQQ | ETF | 94.75 | 94.875 | 94.0 | 94.25 | 2850700.0 |
| 2000-06-16 10:00:00 | QQQ | ETF | 94.25 | 94.375 | 93.0625 | 94.3125 | 3397200.0 |
| 2000-06-16 11:00:00 | QQQ | ETF | 94.25 | 94.5 | 93.625 | 94.3125 | 3214400.0 |
| 2000-06-16 12:00:00 | QQQ | ETF | 94.375 | 95.0 | 94.25 | 94.3125 | 2402000.0 |
| 2000-06-16 13:00:00 | QQQ | ETF | 94.3125 | 95.3125 | 94.25 | 95.125 | 3061800.0 |
| 2000-06-16 14:00:00 | QQQ | ETF | 95.1875 | 95.3125 | 94.3125 | 94.5 | 2080500.0 |
| 2000-06-16 15:00:00 | QQQ | ETF | 94.5938 | 94.8125 | 93.5 | 94.625 | 3827100.0 |
| 2000-06-16 16:00:00 | QQQ | ETF | 94.625 | 95.125 | 94.0 | 94.5 | 324100.0 |
| 2000-06-16 17:00:00 | QQQ | ETF | 94.25 | 94.25 | 94.0 | 94.0 | 900.0 |
| 2000-06-16 18:00:00 | QQQ | ETF | 94.0 | 94.25 | 94.0 | 94.25 | 1900.0 |
| 2000-06-16 09:00:00 | IWM | ETF | 51.4688 | 51.5 | 51.3438 | 51.3438 | 7800.0 |
| 2000-06-16 10:00:00 | IWM | ETF | 51.3125 | 51.3125 | 50.9688 | 51.125 | 5800.0 |
| 2000-06-16 11:00:00 | IWM | ETF | 51.1875 | 51.1875 | 51.1875 | 51.1875 | 2000.0 |
| 2000-06-16 13:00:00 | IWM | ETF | 51.3281 | 51.3281 | 51.3281 | 51.3281 | 1000.0 |
| 2000-06-16 14:00:00 | IWM | ETF | 51.2812 | 51.3125 | 51.2812 | 51.3125 | 6600.0 |
| 2000-06-16 15:00:00 | IWM | ETF | 50.9688 | 50.9688 | 50.9688 | 50.9688 | 7000.0 |
| 2000-06-16 09:00:00 | DIA | ETF | 107.0312 | 107.1562 | 106.5938 | 106.5938 | 53300.0 |
| 2000-06-16 10:00:00 | DIA | ETF | 106.5938 | 106.8125 | 106.0312 | 106.5 | 661200.0 |
| 2000-06-16 11:00:00 | DIA | ETF | 106.5625 | 106.5625 | 105.625 | 105.9688 | 315500.0 |
| 2000-06-16 12:00:00 | DIA | ETF | 105.6875 | 106.1875 | 105.625 | 105.6875 | 340100.0 |
| 2000-06-16 13:00:00 | DIA | ETF | 105.5625 | 106.0625 | 105.5 | 106.0312 | 191100.0 |
| 2000-06-16 14:00:00 | DIA | ETF | 105.8438 | 106.0 | 105.5625 | 105.7188 | 339300.0 |
| 2000-06-16 15:00:00 | DIA | ETF | 105.5 | 105.6562 | 104.625 | 104.9375 | 608700.0 |
| 2000-06-16 16:00:00 | DIA | ETF | 104.9375 | 104.9688 | 104.5 | 104.5 | 116500.0 |
> showing 32 of 163 rows — these rows as CSV