PREVIEW / etf_1hour / 2000-02-08
file: by_date/etf_1hour/2000/2000-02-08.parquet size: 8 KB rows: 138
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-02-08 09:00:00 | SPY | ETF | 143.9688 | 144.5 | 143.75 | 144.375 | 1266100.0 |
| 2000-02-08 10:00:00 | SPY | ETF | 144.3125 | 144.5312 | 143.7812 | 143.9062 | 1111400.0 |
| 2000-02-08 11:00:00 | SPY | ETF | 143.9375 | 144.2188 | 143.75 | 143.9688 | 292000.0 |
| 2000-02-08 12:00:00 | SPY | ETF | 144.0 | 144.2188 | 143.625 | 143.9375 | 466900.0 |
| 2000-02-08 13:00:00 | SPY | ETF | 143.9375 | 144.2188 | 143.6562 | 144.0 | 185900.0 |
| 2000-02-08 14:00:00 | SPY | ETF | 144.0312 | 144.3438 | 143.875 | 144.25 | 559900.0 |
| 2000-02-08 15:00:00 | SPY | ETF | 144.2812 | 144.5625 | 143.7812 | 144.2812 | 636700.0 |
| 2000-02-08 16:00:00 | SPY | ETF | 144.3125 | 144.5312 | 144.1875 | 144.3125 | 379700.0 |
| 2000-02-08 09:00:00 | QQQ | ETF | 99.375 | 100.5 | 99.375 | 100.0938 | 4461200.0 |
| 2000-02-08 10:00:00 | QQQ | ETF | 100.1875 | 100.5312 | 99.75 | 99.875 | 4519800.0 |
| 2000-02-08 11:00:00 | QQQ | ETF | 99.9688 | 100.25 | 99.6406 | 100.0 | 1700200.0 |
| 2000-02-08 12:00:00 | QQQ | ETF | 99.9688 | 100.3125 | 99.875 | 100.0938 | 1176800.0 |
| 2000-02-08 13:00:00 | QQQ | ETF | 100.1875 | 100.7344 | 100.0312 | 100.4688 | 1463200.0 |
| 2000-02-08 14:00:00 | QQQ | ETF | 100.4531 | 100.9375 | 100.3125 | 100.9062 | 2920600.0 |
| 2000-02-08 15:00:00 | QQQ | ETF | 100.9062 | 101.4062 | 100.4375 | 101.4062 | 4709800.0 |
| 2000-02-08 16:00:00 | QQQ | ETF | 101.4062 | 102.0 | 101.25 | 102.0 | 874600.0 |
| 2000-02-08 17:00:00 | QQQ | ETF | 102.0 | 102.5938 | 101.75 | 102.5 | 8600.0 |
| 2000-02-08 18:00:00 | QQQ | ETF | 102.5 | 102.875 | 102.5 | 102.625 | 9000.0 |
| 2000-02-08 09:00:00 | DIA | ETF | 109.9062 | 110.3438 | 109.75 | 110.0312 | 180900.0 |
| 2000-02-08 10:00:00 | DIA | ETF | 110.1875 | 110.2188 | 109.75 | 109.75 | 282500.0 |
| 2000-02-08 11:00:00 | DIA | ETF | 109.8125 | 110.0625 | 109.5312 | 109.9688 | 75500.0 |
| 2000-02-08 12:00:00 | DIA | ETF | 109.8438 | 110.0625 | 109.625 | 109.8125 | 73700.0 |
| 2000-02-08 13:00:00 | DIA | ETF | 109.8125 | 109.875 | 109.625 | 109.7812 | 39200.0 |
| 2000-02-08 14:00:00 | DIA | ETF | 109.625 | 109.875 | 109.5312 | 109.8438 | 91900.0 |
| 2000-02-08 15:00:00 | DIA | ETF | 109.75 | 109.9062 | 109.125 | 109.5 | 237100.0 |
| 2000-02-08 16:00:00 | DIA | ETF | 109.4688 | 109.5938 | 109.3125 | 109.3125 | 12300.0 |
> showing 26 of 138 rows — these rows as CSV