PREVIEW / etf_1hour / 2000-03-23
file: by_date/etf_1hour/2000/2000-03-23.parquet size: 8 KB rows: 140
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-03-23 09:00:00 | SPY | ETF | 149.1562 | 150.2188 | 149.1562 | 149.875 | 912800.0 |
| 2000-03-23 10:00:00 | SPY | ETF | 150.0 | 150.8125 | 149.375 | 150.625 | 1332500.0 |
| 2000-03-23 11:00:00 | SPY | ETF | 150.4375 | 150.625 | 150.0 | 150.5 | 1068300.0 |
| 2000-03-23 12:00:00 | SPY | ETF | 150.3438 | 152.125 | 150.3438 | 152.0 | 1523900.0 |
| 2000-03-23 13:00:00 | SPY | ETF | 152.0 | 153.0938 | 151.8125 | 153.0 | 2220200.0 |
| 2000-03-23 14:00:00 | SPY | ETF | 153.0312 | 153.4688 | 151.9375 | 153.0 | 1804400.0 |
| 2000-03-23 15:00:00 | SPY | ETF | 153.2188 | 153.375 | 152.4375 | 152.625 | 1308600.0 |
| 2000-03-23 16:00:00 | SPY | ETF | 152.625 | 153.1562 | 152.5 | 152.5 | 1106300.0 |
| 2000-03-23 17:00:00 | SPY | ETF | 152.6562 | 152.6562 | 152.6562 | 152.6562 | 600.0 |
| 2000-03-23 09:00:00 | QQQ | ETF | 114.4688 | 115.75 | 113.5625 | 115.375 | 2052800.0 |
| 2000-03-23 10:00:00 | QQQ | ETF | 115.0625 | 115.9375 | 114.0 | 115.6875 | 3224900.0 |
| 2000-03-23 11:00:00 | QQQ | ETF | 115.5 | 115.6875 | 114.5 | 115.3438 | 2209200.0 |
| 2000-03-23 12:00:00 | QQQ | ETF | 115.25 | 116.5 | 115.1875 | 116.4375 | 1557400.0 |
| 2000-03-23 13:00:00 | QQQ | ETF | 116.4375 | 117.7188 | 116.25 | 117.6875 | 4316600.0 |
| 2000-03-23 14:00:00 | QQQ | ETF | 117.6875 | 117.75 | 116.375 | 117.2188 | 2728100.0 |
| 2000-03-23 15:00:00 | QQQ | ETF | 117.2188 | 117.4688 | 115.6875 | 116.5 | 2137000.0 |
| 2000-03-23 16:00:00 | QQQ | ETF | 116.4688 | 116.75 | 116.0312 | 116.5 | 933500.0 |
| 2000-03-23 17:00:00 | QQQ | ETF | 117.0 | 117.0 | 116.375 | 116.375 | 700.0 |
| 2000-03-23 18:00:00 | QQQ | ETF | 116.5 | 116.5 | 116.0 | 116.0 | 300.0 |
| 2000-03-23 09:00:00 | DIA | ETF | 108.375 | 109.0625 | 108.25 | 108.9062 | 220400.0 |
| 2000-03-23 10:00:00 | DIA | ETF | 108.7812 | 109.5625 | 108.4375 | 109.25 | 285900.0 |
| 2000-03-23 11:00:00 | DIA | ETF | 109.1875 | 109.4688 | 108.7812 | 108.875 | 148500.0 |
| 2000-03-23 12:00:00 | DIA | ETF | 108.9375 | 110.4688 | 108.9375 | 110.4688 | 293100.0 |
| 2000-03-23 13:00:00 | DIA | ETF | 110.3125 | 110.875 | 110.0625 | 110.8125 | 174800.0 |
| 2000-03-23 14:00:00 | DIA | ETF | 110.625 | 111.1875 | 109.875 | 110.9062 | 421600.0 |
| 2000-03-23 15:00:00 | DIA | ETF | 111.0938 | 111.5 | 110.75 | 111.0 | 280400.0 |
| 2000-03-23 16:00:00 | DIA | ETF | 111.0625 | 111.1875 | 110.9688 | 111.125 | 54000.0 |
> showing 27 of 140 rows — these rows as CSV