PREVIEW / etf_1hour / 2000-12-18
file: by_date/etf_1hour/2000/2000-12-18.parquet size: 10 KB rows: 206
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-18 09:00:00 | SPY | ETF | 132.0625 | 133.0625 | 132.0625 | 132.5625 | 963500.0 |
| 2000-12-18 10:00:00 | SPY | ETF | 132.5 | 133.4688 | 132.4688 | 132.8438 | 1031800.0 |
| 2000-12-18 11:00:00 | SPY | ETF | 132.9375 | 133.25 | 132.1875 | 132.7188 | 838300.0 |
| 2000-12-18 12:00:00 | SPY | ETF | 132.7188 | 132.875 | 132.125 | 132.7812 | 651200.0 |
| 2000-12-18 13:00:00 | SPY | ETF | 132.8125 | 133.2188 | 132.5 | 132.8125 | 961400.0 |
| 2000-12-18 14:00:00 | SPY | ETF | 132.875 | 132.9688 | 132.3438 | 132.5625 | 582900.0 |
| 2000-12-18 15:00:00 | SPY | ETF | 132.5938 | 132.625 | 131.75 | 132.375 | 1338900.0 |
| 2000-12-18 16:00:00 | SPY | ETF | 132.4688 | 132.9688 | 132.3125 | 132.7188 | 394300.0 |
| 2000-12-18 09:00:00 | QQQ | ETF | 65.1562 | 65.9688 | 64.75 | 64.875 | 7915700.0 |
| 2000-12-18 10:00:00 | QQQ | ETF | 64.875 | 65.875 | 64.3125 | 64.6562 | 8609200.0 |
| 2000-12-18 11:00:00 | QQQ | ETF | 64.625 | 64.9375 | 62.8125 | 63.5625 | 6454900.0 |
| 2000-12-18 12:00:00 | QQQ | ETF | 63.5625 | 64.0 | 62.75 | 63.875 | 3533900.0 |
| 2000-12-18 13:00:00 | QQQ | ETF | 63.8125 | 64.625 | 63.375 | 63.8125 | 4165100.0 |
| 2000-12-18 14:00:00 | QQQ | ETF | 63.8438 | 64.25 | 63.25 | 63.7188 | 3010400.0 |
| 2000-12-18 15:00:00 | QQQ | ETF | 63.75 | 63.8125 | 62.5625 | 63.375 | 6027900.0 |
| 2000-12-18 16:00:00 | QQQ | ETF | 63.4375 | 64.1875 | 63.3125 | 64.125 | 993100.0 |
| 2000-12-18 17:00:00 | QQQ | ETF | 64.125 | 64.25 | 64.0 | 64.1875 | 126800.0 |
| 2000-12-18 18:00:00 | QQQ | ETF | 64.1875 | 64.5 | 64.0938 | 64.125 | 216800.0 |
| 2000-12-18 09:00:00 | IWM | ETF | 45.8438 | 46.3125 | 45.8438 | 46.125 | 102000.0 |
| 2000-12-18 10:00:00 | IWM | ETF | 46.0156 | 46.4688 | 46.0156 | 46.2188 | 22800.0 |
| 2000-12-18 11:00:00 | IWM | ETF | 46.0312 | 46.0312 | 45.8125 | 46.0 | 33800.0 |
| 2000-12-18 12:00:00 | IWM | ETF | 46.0156 | 46.0156 | 45.8125 | 45.8125 | 800.0 |
| 2000-12-18 13:00:00 | IWM | ETF | 46.1562 | 46.2188 | 46.0 | 46.125 | 8600.0 |
| 2000-12-18 14:00:00 | IWM | ETF | 46.1562 | 46.1875 | 46.0156 | 46.125 | 10200.0 |
| 2000-12-18 15:00:00 | IWM | ETF | 46.0312 | 46.1875 | 45.8125 | 46.1875 | 36000.0 |
| 2000-12-18 16:00:00 | IWM | ETF | 46.25 | 46.3125 | 46.25 | 46.3125 | 24200.0 |
| 2000-12-18 09:00:00 | DIA | ETF | 105.4375 | 105.875 | 105.4062 | 105.6875 | 544800.0 |
| 2000-12-18 10:00:00 | DIA | ETF | 105.625 | 106.3438 | 105.5625 | 106.0312 | 233800.0 |
| 2000-12-18 11:00:00 | DIA | ETF | 106.0938 | 106.4375 | 105.9062 | 106.4375 | 419200.0 |
| 2000-12-18 12:00:00 | DIA | ETF | 106.25 | 106.5 | 106.0 | 106.5 | 171700.0 |
| 2000-12-18 13:00:00 | DIA | ETF | 106.5 | 106.7812 | 106.3125 | 106.6875 | 319400.0 |
| 2000-12-18 14:00:00 | DIA | ETF | 106.625 | 106.75 | 106.1562 | 106.375 | 233700.0 |
| 2000-12-18 15:00:00 | DIA | ETF | 106.5 | 106.5 | 105.9062 | 106.375 | 374000.0 |
| 2000-12-18 16:00:00 | DIA | ETF | 106.375 | 106.875 | 106.2812 | 106.625 | 85200.0 |
| 2000-12-18 17:00:00 | DIA | ETF | 106.125 | 106.125 | 106.125 | 106.125 | 200.0 |
> showing 35 of 206 rows — these rows as CSV