PREVIEW / etf_1hour / 2000-11-24
file: by_date/etf_1hour/2000/2000-11-24.parquet size: 8 KB rows: 97
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-11-24 09:00:00 | SPY | ETF | 133.625 | 134.25 | 133.625 | 134.0 | 1063000.0 |
| 2000-11-24 10:00:00 | SPY | ETF | 133.9688 | 134.625 | 133.9688 | 134.25 | 627300.0 |
| 2000-11-24 11:00:00 | SPY | ETF | 134.3125 | 134.5938 | 134.25 | 134.25 | 393600.0 |
| 2000-11-24 12:00:00 | SPY | ETF | 134.2812 | 134.9688 | 134.2188 | 134.4375 | 1107200.0 |
| 2000-11-24 13:00:00 | SPY | ETF | 134.5312 | 134.875 | 134.4062 | 134.8438 | 99500.0 |
| 2000-11-24 09:00:00 | QQQ | ETF | 68.375 | 69.1562 | 68.1562 | 68.9062 | 4595100.0 |
| 2000-11-24 10:00:00 | QQQ | ETF | 68.9375 | 69.75 | 68.75 | 69.4688 | 5443700.0 |
| 2000-11-24 11:00:00 | QQQ | ETF | 69.4688 | 70.125 | 69.3125 | 69.625 | 3569500.0 |
| 2000-11-24 12:00:00 | QQQ | ETF | 69.6875 | 70.5625 | 69.625 | 70.5 | 5294600.0 |
| 2000-11-24 13:00:00 | QQQ | ETF | 70.5625 | 70.625 | 70.3125 | 70.4375 | 324100.0 |
| 2000-11-24 09:00:00 | IWM | ETF | 46.2031 | 46.2188 | 46.1875 | 46.1875 | 22800.0 |
| 2000-11-24 10:00:00 | IWM | ETF | 46.2188 | 46.5625 | 46.2188 | 46.5625 | 34200.0 |
| 2000-11-24 11:00:00 | IWM | ETF | 46.6562 | 46.8125 | 46.5 | 46.8125 | 11600.0 |
| 2000-11-24 12:00:00 | IWM | ETF | 46.9688 | 47.0938 | 46.9375 | 46.9375 | 8200.0 |
| 2000-11-24 09:00:00 | DIA | ETF | 104.9688 | 104.9688 | 104.5625 | 104.75 | 253300.0 |
| 2000-11-24 10:00:00 | DIA | ETF | 104.75 | 105.25 | 104.75 | 105.0312 | 50100.0 |
| 2000-11-24 11:00:00 | DIA | ETF | 104.875 | 105.2188 | 104.875 | 105.0625 | 69100.0 |
| 2000-11-24 12:00:00 | DIA | ETF | 105.0312 | 105.25 | 104.625 | 104.875 | 111300.0 |
| 2000-11-24 13:00:00 | DIA | ETF | 104.875 | 105.0625 | 104.875 | 105.0625 | 20600.0 |
> showing 19 of 97 rows — these rows as CSV