PREVIEW / etf_1hour / 2000-03-27
file: by_date/etf_1hour/2000/2000-03-27.parquet size: 8 KB rows: 128
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-27 09:00:00 | SPY | ETF | 153.375 | 153.5625 | 152.875 | 153.0312 | 1814500.0 |
| 2000-03-27 10:00:00 | SPY | ETF | 153.1875 | 153.7812 | 152.25 | 152.5 | 2158100.0 |
| 2000-03-27 11:00:00 | SPY | ETF | 152.4375 | 153.0 | 152.375 | 152.625 | 664700.0 |
| 2000-03-27 12:00:00 | SPY | ETF | 152.6875 | 153.1562 | 152.5 | 153.1562 | 894400.0 |
| 2000-03-27 13:00:00 | SPY | ETF | 153.1875 | 153.3125 | 152.625 | 152.625 | 386600.0 |
| 2000-03-27 14:00:00 | SPY | ETF | 152.8125 | 152.9375 | 152.0 | 152.5 | 950100.0 |
| 2000-03-27 15:00:00 | SPY | ETF | 152.375 | 152.9062 | 152.0625 | 152.5 | 1220100.0 |
| 2000-03-27 16:00:00 | SPY | ETF | 152.5 | 152.5625 | 151.8125 | 151.9375 | 649800.0 |
| 2000-03-27 09:00:00 | QQQ | ETF | 118.0 | 118.5 | 117.125 | 117.625 | 1780400.0 |
| 2000-03-27 10:00:00 | QQQ | ETF | 117.5625 | 119.5 | 117.5 | 117.7812 | 2408500.0 |
| 2000-03-27 11:00:00 | QQQ | ETF | 117.75 | 119.0 | 117.75 | 118.75 | 890900.0 |
| 2000-03-27 12:00:00 | QQQ | ETF | 118.75 | 119.0625 | 118.25 | 119.0 | 1240400.0 |
| 2000-03-27 13:00:00 | QQQ | ETF | 119.1875 | 119.375 | 118.25 | 118.4688 | 1626100.0 |
| 2000-03-27 14:00:00 | QQQ | ETF | 118.5 | 118.6875 | 117.125 | 118.0 | 1651600.0 |
| 2000-03-27 15:00:00 | QQQ | ETF | 117.9062 | 118.4375 | 117.125 | 117.6875 | 1891700.0 |
| 2000-03-27 16:00:00 | QQQ | ETF | 117.6875 | 117.6875 | 117.125 | 117.3438 | 206400.0 |
| 2000-03-27 17:00:00 | QQQ | ETF | 117.5 | 117.5 | 117.5 | 117.5 | 100.0 |
| 2000-03-27 18:00:00 | QQQ | ETF | 117.75 | 117.75 | 117.75 | 117.75 | 300.0 |
| 2000-03-27 09:00:00 | DIA | ETF | 111.3438 | 111.6875 | 111.125 | 111.375 | 214400.0 |
| 2000-03-27 10:00:00 | DIA | ETF | 111.5938 | 111.9062 | 110.4375 | 110.5 | 259800.0 |
| 2000-03-27 11:00:00 | DIA | ETF | 110.5625 | 110.875 | 110.4062 | 110.875 | 183500.0 |
| 2000-03-27 12:00:00 | DIA | ETF | 110.875 | 110.875 | 110.4062 | 110.8438 | 126700.0 |
| 2000-03-27 13:00:00 | DIA | ETF | 110.6562 | 110.9375 | 110.1875 | 110.3438 | 103800.0 |
| 2000-03-27 14:00:00 | DIA | ETF | 110.25 | 110.5938 | 109.6875 | 110.125 | 342600.0 |
| 2000-03-27 15:00:00 | DIA | ETF | 110.0 | 110.4375 | 109.8438 | 110.1562 | 169400.0 |
| 2000-03-27 16:00:00 | DIA | ETF | 110.0625 | 110.2188 | 109.75 | 109.8125 | 27000.0 |
> showing 26 of 128 rows — these rows as CSV