PREVIEW / etf_1hour / 2000-04-18
file: by_date/etf_1hour/2000/2000-04-18.parquet size: 8 KB rows: 131
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-04-18 09:00:00 | SPY | ETF | 140.5625 | 141.5 | 139.7812 | 141.125 | 1282200.0 |
| 2000-04-18 10:00:00 | SPY | ETF | 140.9688 | 141.75 | 140.6875 | 141.75 | 1404800.0 |
| 2000-04-18 11:00:00 | SPY | ETF | 141.625 | 142.9062 | 141.375 | 142.75 | 2331900.0 |
| 2000-04-18 12:00:00 | SPY | ETF | 142.9062 | 143.5 | 142.5625 | 143.0 | 1070900.0 |
| 2000-04-18 13:00:00 | SPY | ETF | 143.1875 | 143.5 | 142.5 | 143.4062 | 937400.0 |
| 2000-04-18 14:00:00 | SPY | ETF | 143.5 | 143.7188 | 142.5625 | 143.125 | 920000.0 |
| 2000-04-18 15:00:00 | SPY | ETF | 143.0312 | 144.2188 | 142.0 | 144.2188 | 2613800.0 |
| 2000-04-18 16:00:00 | SPY | ETF | 144.2812 | 144.4688 | 144.0 | 144.4688 | 364400.0 |
| 2000-04-18 17:00:00 | SPY | ETF | 144.4688 | 144.4688 | 144.4688 | 144.4688 | 115000.0 |
| 2000-04-18 09:00:00 | QQQ | ETF | 89.4688 | 90.125 | 87.375 | 89.5625 | 6193000.0 |
| 2000-04-18 10:00:00 | QQQ | ETF | 89.875 | 90.5625 | 88.0312 | 89.125 | 6883300.0 |
| 2000-04-18 11:00:00 | QQQ | ETF | 89.1875 | 91.3125 | 89.0 | 90.9688 | 4986800.0 |
| 2000-04-18 12:00:00 | QQQ | ETF | 90.9688 | 92.25 | 90.625 | 91.9375 | 4068300.0 |
| 2000-04-18 13:00:00 | QQQ | ETF | 91.875 | 92.0 | 90.75 | 91.9375 | 2976100.0 |
| 2000-04-18 14:00:00 | QQQ | ETF | 91.9688 | 92.375 | 90.5 | 91.0 | 2846500.0 |
| 2000-04-18 15:00:00 | QQQ | ETF | 91.0 | 92.625 | 89.5 | 92.5 | 6929900.0 |
| 2000-04-18 16:00:00 | QQQ | ETF | 92.375 | 93.0 | 91.375 | 92.25 | 1158800.0 |
| 2000-04-18 17:00:00 | QQQ | ETF | 92.25 | 92.5 | 91.0 | 91.25 | 7600.0 |
| 2000-04-18 18:00:00 | QQQ | ETF | 91.875 | 92.0 | 91.75 | 92.0 | 4200.0 |
| 2000-04-18 09:00:00 | DIA | ETF | 106.4688 | 106.7812 | 105.875 | 106.5 | 421600.0 |
| 2000-04-18 10:00:00 | DIA | ETF | 106.625 | 106.9375 | 106.1875 | 106.6875 | 330700.0 |
| 2000-04-18 11:00:00 | DIA | ETF | 106.5938 | 107.5 | 106.5938 | 107.4062 | 234700.0 |
| 2000-04-18 12:00:00 | DIA | ETF | 107.4062 | 107.5938 | 107.0312 | 107.4062 | 182900.0 |
| 2000-04-18 13:00:00 | DIA | ETF | 107.625 | 107.625 | 107.0312 | 107.4688 | 66800.0 |
| 2000-04-18 14:00:00 | DIA | ETF | 107.375 | 107.625 | 106.4375 | 107.125 | 92700.0 |
| 2000-04-18 15:00:00 | DIA | ETF | 107.0625 | 107.6562 | 106.25 | 107.5938 | 235600.0 |
| 2000-04-18 16:00:00 | DIA | ETF | 107.5625 | 107.7812 | 107.5 | 107.7812 | 10600.0 |
| 2000-04-18 17:00:00 | DIA | ETF | 107.0625 | 107.0625 | 107.0625 | 107.0625 | 100.0 |
> showing 28 of 131 rows — these rows as CSV