PREVIEW / etf_1hour / 2000-12-27
file: by_date/etf_1hour/2000/2000-12-27.parquet size: 10 KB rows: 196
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-27 09:00:00 | SPY | ETF | 132.0 | 132.125 | 131.4062 | 131.9062 | 480000.0 |
| 2000-12-27 10:00:00 | SPY | ETF | 131.9375 | 132.5312 | 131.25 | 132.4062 | 358200.0 |
| 2000-12-27 11:00:00 | SPY | ETF | 132.4062 | 133.4062 | 132.25 | 133.25 | 739700.0 |
| 2000-12-27 12:00:00 | SPY | ETF | 133.25 | 133.4688 | 132.625 | 133.0 | 692200.0 |
| 2000-12-27 13:00:00 | SPY | ETF | 133.0 | 133.25 | 132.5938 | 133.0625 | 392600.0 |
| 2000-12-27 14:00:00 | SPY | ETF | 133.25 | 133.3438 | 132.4375 | 133.1875 | 622400.0 |
| 2000-12-27 15:00:00 | SPY | ETF | 133.25 | 133.6562 | 132.8125 | 133.125 | 901500.0 |
| 2000-12-27 16:00:00 | SPY | ETF | 133.125 | 133.7188 | 133.0312 | 133.3125 | 451600.0 |
| 2000-12-27 09:00:00 | QQQ | ETF | 59.6875 | 60.25 | 59.25 | 59.625 | 5106700.0 |
| 2000-12-27 10:00:00 | QQQ | ETF | 59.6562 | 61.0 | 58.9375 | 60.6875 | 6989100.0 |
| 2000-12-27 11:00:00 | QQQ | ETF | 60.7188 | 61.5 | 60.4375 | 61.375 | 5266900.0 |
| 2000-12-27 12:00:00 | QQQ | ETF | 61.4375 | 61.75 | 60.8125 | 61.0 | 3928000.0 |
| 2000-12-27 13:00:00 | QQQ | ETF | 61.0938 | 61.2188 | 60.5 | 61.0 | 2788900.0 |
| 2000-12-27 14:00:00 | QQQ | ETF | 61.0312 | 61.375 | 60.5 | 61.125 | 2961000.0 |
| 2000-12-27 15:00:00 | QQQ | ETF | 61.125 | 61.625 | 60.6875 | 61.25 | 5164000.0 |
| 2000-12-27 16:00:00 | QQQ | ETF | 61.2188 | 61.75 | 61.125 | 61.625 | 554400.0 |
| 2000-12-27 17:00:00 | QQQ | ETF | 61.5625 | 61.7812 | 61.5 | 61.7812 | 28500.0 |
| 2000-12-27 18:00:00 | QQQ | ETF | 61.6875 | 61.75 | 61.625 | 61.6875 | 3900.0 |
| 2000-12-27 09:00:00 | IWM | ETF | 46.5 | 46.5 | 46.1875 | 46.1875 | 88600.0 |
| 2000-12-27 10:00:00 | IWM | ETF | 46.1875 | 46.6562 | 46.1875 | 46.6562 | 282800.0 |
| 2000-12-27 11:00:00 | IWM | ETF | 46.8125 | 46.9062 | 46.75 | 46.8906 | 59000.0 |
| 2000-12-27 12:00:00 | IWM | ETF | 46.8125 | 47.0 | 46.8125 | 46.9688 | 14800.0 |
| 2000-12-27 13:00:00 | IWM | ETF | 46.9688 | 47.0625 | 46.7812 | 47.0625 | 40200.0 |
| 2000-12-27 14:00:00 | IWM | ETF | 47.0625 | 47.2188 | 46.9688 | 47.0625 | 158200.0 |
| 2000-12-27 15:00:00 | IWM | ETF | 47.0938 | 47.5 | 47.0312 | 47.5 | 71800.0 |
| 2000-12-27 16:00:00 | IWM | ETF | 47.625 | 47.75 | 47.625 | 47.75 | 25800.0 |
| 2000-12-27 09:00:00 | DIA | ETF | 107.0 | 107.0 | 106.5 | 106.75 | 662200.0 |
| 2000-12-27 10:00:00 | DIA | ETF | 106.625 | 107.2812 | 106.3125 | 107.0625 | 258400.0 |
| 2000-12-27 11:00:00 | DIA | ETF | 107.125 | 107.8438 | 107.0312 | 107.8438 | 129700.0 |
| 2000-12-27 12:00:00 | DIA | ETF | 107.8438 | 107.9688 | 107.3125 | 107.625 | 88200.0 |
| 2000-12-27 13:00:00 | DIA | ETF | 107.6875 | 108.0312 | 107.5 | 108.0312 | 75700.0 |
| 2000-12-27 14:00:00 | DIA | ETF | 108.0312 | 108.2188 | 107.5938 | 108.0 | 274300.0 |
| 2000-12-27 15:00:00 | DIA | ETF | 108.0625 | 108.3125 | 107.8438 | 108.0 | 262400.0 |
| 2000-12-27 16:00:00 | DIA | ETF | 108.0 | 108.4375 | 107.8438 | 108.25 | 16600.0 |
> showing 34 of 196 rows — these rows as CSV