PREVIEW / etf_1hour / 2000-04-26
file: by_date/etf_1hour/2000/2000-04-26.parquet size: 8 KB rows: 127
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-26 09:00:00 | SPY | ETF | 147.9688 | 148.1875 | 147.5 | 148.0 | 813200.0 |
| 2000-04-26 10:00:00 | SPY | ETF | 148.1875 | 148.75 | 147.6562 | 148.4062 | 1093000.0 |
| 2000-04-26 11:00:00 | SPY | ETF | 148.3438 | 148.5938 | 147.2812 | 147.375 | 822300.0 |
| 2000-04-26 12:00:00 | SPY | ETF | 147.5 | 147.6562 | 147.0 | 147.0938 | 848700.0 |
| 2000-04-26 13:00:00 | SPY | ETF | 147.125 | 147.75 | 146.75 | 147.25 | 898600.0 |
| 2000-04-26 14:00:00 | SPY | ETF | 147.3438 | 147.5 | 146.6875 | 147.0312 | 695700.0 |
| 2000-04-26 15:00:00 | SPY | ETF | 146.9688 | 147.375 | 146.0 | 146.375 | 2154900.0 |
| 2000-04-26 16:00:00 | SPY | ETF | 146.5 | 146.5625 | 146.25 | 146.4688 | 316000.0 |
| 2000-04-26 09:00:00 | QQQ | ETF | 90.625 | 91.0 | 88.75 | 90.0 | 3585800.0 |
| 2000-04-26 10:00:00 | QQQ | ETF | 90.125 | 92.4062 | 90.0 | 91.75 | 4053400.0 |
| 2000-04-26 11:00:00 | QQQ | ETF | 91.625 | 91.75 | 89.5 | 89.5 | 3384200.0 |
| 2000-04-26 12:00:00 | QQQ | ETF | 89.5 | 89.9688 | 88.75 | 89.375 | 3411700.0 |
| 2000-04-26 13:00:00 | QQQ | ETF | 89.375 | 90.5938 | 88.75 | 90.0 | 3227800.0 |
| 2000-04-26 14:00:00 | QQQ | ETF | 90.0 | 90.1875 | 88.6875 | 89.125 | 2280900.0 |
| 2000-04-26 15:00:00 | QQQ | ETF | 89.125 | 89.625 | 87.25 | 87.25 | 5256900.0 |
| 2000-04-26 16:00:00 | QQQ | ETF | 87.25 | 87.875 | 87.125 | 87.375 | 409700.0 |
| 2000-04-26 17:00:00 | QQQ | ETF | 87.375 | 87.5 | 87.25 | 87.375 | 8600.0 |
| 2000-04-26 18:00:00 | QQQ | ETF | 87.375 | 87.375 | 87.375 | 87.375 | 500.0 |
| 2000-04-26 09:00:00 | DIA | ETF | 111.5625 | 111.5625 | 111.0 | 111.5625 | 188800.0 |
| 2000-04-26 10:00:00 | DIA | ETF | 111.5625 | 111.5625 | 110.625 | 110.8125 | 165100.0 |
| 2000-04-26 11:00:00 | DIA | ETF | 110.9688 | 110.9688 | 110.0625 | 110.1562 | 264300.0 |
| 2000-04-26 12:00:00 | DIA | ETF | 110.0625 | 110.3438 | 109.75 | 109.875 | 117400.0 |
| 2000-04-26 13:00:00 | DIA | ETF | 110.0 | 110.3125 | 109.5312 | 110.0625 | 148000.0 |
| 2000-04-26 14:00:00 | DIA | ETF | 110.0938 | 110.0938 | 109.375 | 109.8438 | 195300.0 |
| 2000-04-26 15:00:00 | DIA | ETF | 109.8125 | 110.0312 | 108.9375 | 109.3125 | 962400.0 |
| 2000-04-26 16:00:00 | DIA | ETF | 109.2188 | 109.4688 | 109.125 | 109.4688 | 7200.0 |
| 2000-04-26 18:00:00 | DIA | ETF | 109.0 | 109.0 | 109.0 | 109.0 | 100.0 |
> showing 27 of 127 rows — these rows as CSV