PREVIEW / etf_1hour / 2000-04-06
file: by_date/etf_1hour/2000/2000-04-06.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-04-06 09:00:00 | SPY | ETF | 150.25 | 150.7812 | 149.5625 | 150.4688 | 787600.0 |
| 2000-04-06 10:00:00 | SPY | ETF | 150.4375 | 151.6875 | 150.1562 | 151.0312 | 1738700.0 |
| 2000-04-06 11:00:00 | SPY | ETF | 151.2188 | 151.5 | 150.4062 | 150.7188 | 821500.0 |
| 2000-04-06 12:00:00 | SPY | ETF | 150.625 | 150.8438 | 150.1875 | 150.5625 | 500600.0 |
| 2000-04-06 13:00:00 | SPY | ETF | 150.4688 | 151.0 | 150.3438 | 150.4688 | 248300.0 |
| 2000-04-06 14:00:00 | SPY | ETF | 150.5625 | 150.875 | 149.5312 | 149.5625 | 658200.0 |
| 2000-04-06 15:00:00 | SPY | ETF | 149.5 | 150.5 | 149.0 | 150.3125 | 1019300.0 |
| 2000-04-06 16:00:00 | SPY | ETF | 150.25 | 150.7188 | 150.1875 | 150.4688 | 568600.0 |
| 2000-04-06 09:00:00 | QQQ | ETF | 102.375 | 103.125 | 101.25 | 102.5 | 5500500.0 |
| 2000-04-06 10:00:00 | QQQ | ETF | 102.6875 | 103.75 | 102.0 | 103.25 | 4766700.0 |
| 2000-04-06 11:00:00 | QQQ | ETF | 103.0 | 103.875 | 101.75 | 102.375 | 4568800.0 |
| 2000-04-06 12:00:00 | QQQ | ETF | 102.4375 | 103.2188 | 101.9375 | 102.4375 | 2774000.0 |
| 2000-04-06 13:00:00 | QQQ | ETF | 102.4375 | 103.25 | 102.0625 | 102.75 | 2484300.0 |
| 2000-04-06 14:00:00 | QQQ | ETF | 102.75 | 103.2188 | 100.5625 | 100.5625 | 3331400.0 |
| 2000-04-06 15:00:00 | QQQ | ETF | 100.625 | 102.5 | 99.75 | 101.8125 | 4516400.0 |
| 2000-04-06 16:00:00 | QQQ | ETF | 101.5 | 102.3438 | 101.5 | 102.25 | 2450000.0 |
| 2000-04-06 17:00:00 | QQQ | ETF | 102.3125 | 102.5 | 102.25 | 102.5 | 1600.0 |
| 2000-04-06 18:00:00 | QQQ | ETF | 102.5 | 102.5 | 102.5 | 102.5 | 100.0 |
| 2000-04-06 09:00:00 | DIA | ETF | 111.375 | 111.4375 | 110.6562 | 111.1875 | 97400.0 |
| 2000-04-06 10:00:00 | DIA | ETF | 111.2188 | 112.2188 | 111.0312 | 111.9688 | 1705000.0 |
| 2000-04-06 11:00:00 | DIA | ETF | 111.7812 | 112.0938 | 111.25 | 111.4062 | 111300.0 |
| 2000-04-06 12:00:00 | DIA | ETF | 111.3438 | 111.5 | 111.25 | 111.4375 | 80400.0 |
| 2000-04-06 13:00:00 | DIA | ETF | 111.5 | 111.7188 | 111.375 | 111.4375 | 39700.0 |
| 2000-04-06 14:00:00 | DIA | ETF | 111.2812 | 111.5 | 110.5938 | 110.7188 | 190300.0 |
| 2000-04-06 15:00:00 | DIA | ETF | 110.875 | 111.375 | 110.375 | 111.2188 | 53600.0 |
| 2000-04-06 16:00:00 | DIA | ETF | 111.25 | 111.4062 | 111.25 | 111.4062 | 2000.0 |
> showing 26 of 130 rows — these rows as CSV