PREVIEW / etf_1hour / 2000-06-15
file: by_date/etf_1hour/2000/2000-06-15.parquet size: 9 KB rows: 152
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-15 09:00:00 | SPY | ETF | 148.125 | 148.2188 | 147.375 | 147.5 | 619400.0 |
| 2000-06-15 10:00:00 | SPY | ETF | 147.4375 | 147.9375 | 146.8438 | 147.0312 | 825200.0 |
| 2000-06-15 11:00:00 | SPY | ETF | 147.0625 | 147.7812 | 147.0625 | 147.4375 | 679200.0 |
| 2000-06-15 12:00:00 | SPY | ETF | 147.5 | 148.0625 | 147.4062 | 147.875 | 277800.0 |
| 2000-06-15 13:00:00 | SPY | ETF | 147.875 | 148.5938 | 147.6875 | 148.375 | 322800.0 |
| 2000-06-15 14:00:00 | SPY | ETF | 148.5312 | 148.6562 | 148.0625 | 148.1562 | 1224000.0 |
| 2000-06-15 15:00:00 | SPY | ETF | 148.25 | 148.75 | 147.5312 | 148.25 | 1613400.0 |
| 2000-06-15 16:00:00 | SPY | ETF | 148.25 | 148.25 | 147.75 | 148.1562 | 315900.0 |
| 2000-06-15 09:00:00 | QQQ | ETF | 91.875 | 92.375 | 90.875 | 90.9375 | 1976000.0 |
| 2000-06-15 10:00:00 | QQQ | ETF | 91.0 | 92.1875 | 90.875 | 91.0 | 4465800.0 |
| 2000-06-15 11:00:00 | QQQ | ETF | 91.0 | 91.9375 | 91.0 | 91.625 | 1819000.0 |
| 2000-06-15 12:00:00 | QQQ | ETF | 91.625 | 92.875 | 91.5312 | 92.625 | 2438100.0 |
| 2000-06-15 13:00:00 | QQQ | ETF | 92.625 | 93.4375 | 92.5 | 93.375 | 2318400.0 |
| 2000-06-15 14:00:00 | QQQ | ETF | 93.4375 | 93.8125 | 92.875 | 93.3438 | 2309700.0 |
| 2000-06-15 15:00:00 | QQQ | ETF | 93.375 | 93.5625 | 92.1875 | 93.5625 | 2646700.0 |
| 2000-06-15 16:00:00 | QQQ | ETF | 93.5625 | 93.8125 | 93.25 | 93.8125 | 806900.0 |
| 2000-06-15 17:00:00 | QQQ | ETF | 93.875 | 93.875 | 93.75 | 93.75 | 400.0 |
| 2000-06-15 09:00:00 | IWM | ETF | 50.875 | 50.875 | 50.875 | 50.875 | 3000.0 |
| 2000-06-15 10:00:00 | IWM | ETF | 50.6875 | 50.6875 | 50.6875 | 50.6875 | 200.0 |
| 2000-06-15 11:00:00 | IWM | ETF | 50.375 | 50.4688 | 50.375 | 50.4375 | 1600.0 |
| 2000-06-15 12:00:00 | IWM | ETF | 50.6562 | 50.6562 | 50.6562 | 50.6562 | 200.0 |
| 2000-06-15 13:00:00 | IWM | ETF | 50.7188 | 51.0 | 50.7188 | 51.0 | 2200.0 |
| 2000-06-15 14:00:00 | IWM | ETF | 50.9688 | 50.9688 | 50.9688 | 50.9688 | 400.0 |
| 2000-06-15 15:00:00 | IWM | ETF | 50.7969 | 51.25 | 50.7969 | 51.25 | 19200.0 |
| 2000-06-15 09:00:00 | DIA | ETF | 107.125 | 107.5625 | 106.9062 | 107.4062 | 36900.0 |
| 2000-06-15 10:00:00 | DIA | ETF | 107.0625 | 107.4375 | 106.625 | 106.625 | 27100.0 |
| 2000-06-15 11:00:00 | DIA | ETF | 106.6875 | 107.3125 | 106.6562 | 107.0312 | 173900.0 |
| 2000-06-15 12:00:00 | DIA | ETF | 107.0312 | 107.375 | 106.875 | 107.3438 | 129900.0 |
| 2000-06-15 13:00:00 | DIA | ETF | 107.3125 | 107.75 | 107.1875 | 107.6875 | 39100.0 |
| 2000-06-15 14:00:00 | DIA | ETF | 107.7188 | 107.7188 | 107.375 | 107.375 | 16100.0 |
| 2000-06-15 15:00:00 | DIA | ETF | 107.375 | 107.6562 | 106.75 | 106.875 | 224200.0 |
| 2000-06-15 16:00:00 | DIA | ETF | 106.8438 | 106.8438 | 106.8438 | 106.8438 | 500.0 |
> showing 32 of 152 rows — these rows as CSV