PREVIEW / etf_1hour / 2000-05-16
file: by_date/etf_1hour/2000/2000-05-16.parquet size: 8 KB rows: 130
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-05-16 09:00:00 | SPY | ETF | 146.5625 | 147.375 | 146.3438 | 146.9062 | 1929900.0 |
| 2000-05-16 10:00:00 | SPY | ETF | 146.9062 | 147.125 | 146.625 | 146.8125 | 725100.0 |
| 2000-05-16 11:00:00 | SPY | ETF | 146.9688 | 147.4688 | 146.6562 | 147.0625 | 391000.0 |
| 2000-05-16 12:00:00 | SPY | ETF | 147.0625 | 147.25 | 146.875 | 147.0 | 312000.0 |
| 2000-05-16 13:00:00 | SPY | ETF | 147.0 | 147.3125 | 146.9375 | 147.0 | 404900.0 |
| 2000-05-16 14:00:00 | SPY | ETF | 147.0 | 147.7188 | 145.3125 | 146.875 | 3189600.0 |
| 2000-05-16 15:00:00 | SPY | ETF | 146.9688 | 147.4375 | 146.4375 | 147.0 | 575600.0 |
| 2000-05-16 16:00:00 | SPY | ETF | 147.0 | 147.125 | 146.5625 | 146.5625 | 354100.0 |
| 2000-05-16 17:00:00 | SPY | ETF | 146.6875 | 146.6875 | 146.6875 | 146.6875 | 200.0 |
| 2000-05-16 09:00:00 | QQQ | ETF | 90.0 | 90.6875 | 89.8125 | 90.375 | 3750000.0 |
| 2000-05-16 10:00:00 | QQQ | ETF | 90.25 | 91.375 | 90.125 | 90.5625 | 2368300.0 |
| 2000-05-16 11:00:00 | QQQ | ETF | 90.5625 | 91.125 | 90.0 | 90.7812 | 1634200.0 |
| 2000-05-16 12:00:00 | QQQ | ETF | 90.6875 | 90.9375 | 90.5 | 90.625 | 1346400.0 |
| 2000-05-16 13:00:00 | QQQ | ETF | 90.75 | 91.125 | 90.625 | 90.875 | 1946200.0 |
| 2000-05-16 14:00:00 | QQQ | ETF | 90.875 | 91.5 | 88.0625 | 89.75 | 7785100.0 |
| 2000-05-16 15:00:00 | QQQ | ETF | 90.1875 | 91.2812 | 89.375 | 91.125 | 4299300.0 |
| 2000-05-16 16:00:00 | QQQ | ETF | 91.125 | 91.25 | 90.75 | 91.0 | 547600.0 |
| 2000-05-16 17:00:00 | QQQ | ETF | 91.0 | 91.25 | 90.9375 | 91.25 | 1400.0 |
| 2000-05-16 18:00:00 | QQQ | ETF | 91.0625 | 91.125 | 90.8125 | 90.8125 | 1000.0 |
| 2000-05-16 09:00:00 | DIA | ETF | 108.875 | 109.2188 | 108.5625 | 109.1875 | 146800.0 |
| 2000-05-16 10:00:00 | DIA | ETF | 109.1562 | 109.3125 | 108.75 | 109.0312 | 195200.0 |
| 2000-05-16 11:00:00 | DIA | ETF | 109.0 | 109.75 | 109.0 | 109.375 | 49200.0 |
| 2000-05-16 12:00:00 | DIA | ETF | 109.5 | 109.6875 | 109.25 | 109.4688 | 59400.0 |
| 2000-05-16 13:00:00 | DIA | ETF | 109.375 | 109.625 | 109.2812 | 109.3125 | 31700.0 |
| 2000-05-16 14:00:00 | DIA | ETF | 109.5 | 109.5938 | 108.1875 | 109.0 | 477400.0 |
| 2000-05-16 15:00:00 | DIA | ETF | 109.2188 | 109.7812 | 108.8438 | 109.1562 | 189500.0 |
| 2000-05-16 16:00:00 | DIA | ETF | 109.1875 | 109.3125 | 109.1562 | 109.3125 | 6100.0 |
> showing 27 of 130 rows — these rows as CSV