PREVIEW / etf_1hour / 2000-03-20
file: by_date/etf_1hour/2000/2000-03-20.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-03-20 09:00:00 | SPY | ETF | 146.875 | 147.3438 | 146.5 | 147.0312 | 899500.0 |
| 2000-03-20 10:00:00 | SPY | ETF | 147.0 | 147.2812 | 146.1875 | 146.5312 | 850000.0 |
| 2000-03-20 11:00:00 | SPY | ETF | 146.5625 | 147.1562 | 146.375 | 146.8125 | 1248000.0 |
| 2000-03-20 12:00:00 | SPY | ETF | 146.9375 | 147.1562 | 146.5 | 146.7812 | 3104300.0 |
| 2000-03-20 13:00:00 | SPY | ETF | 146.625 | 146.9375 | 146.1875 | 146.25 | 895400.0 |
| 2000-03-20 14:00:00 | SPY | ETF | 146.1875 | 146.6875 | 144.7812 | 145.8125 | 2611500.0 |
| 2000-03-20 15:00:00 | SPY | ETF | 145.5625 | 146.1875 | 145.2812 | 145.9688 | 2478000.0 |
| 2000-03-20 16:00:00 | SPY | ETF | 145.8125 | 146.7812 | 145.8125 | 146.7812 | 344200.0 |
| 2000-03-20 17:00:00 | SPY | ETF | 146.1875 | 146.1875 | 146.1875 | 146.1875 | 200.0 |
| 2000-03-20 09:00:00 | QQQ | ETF | 111.0 | 111.5 | 110.0625 | 110.75 | 2712900.0 |
| 2000-03-20 10:00:00 | QQQ | ETF | 110.7812 | 111.3438 | 109.125 | 109.7188 | 2694900.0 |
| 2000-03-20 11:00:00 | QQQ | ETF | 109.5312 | 110.7188 | 109.125 | 110.1875 | 1958800.0 |
| 2000-03-20 12:00:00 | QQQ | ETF | 110.125 | 110.625 | 109.375 | 109.5 | 1979400.0 |
| 2000-03-20 13:00:00 | QQQ | ETF | 109.5 | 109.5 | 108.125 | 108.25 | 2732300.0 |
| 2000-03-20 14:00:00 | QQQ | ETF | 108.25 | 108.625 | 106.25 | 107.25 | 4385900.0 |
| 2000-03-20 15:00:00 | QQQ | ETF | 107.375 | 107.75 | 106.5 | 106.75 | 3866200.0 |
| 2000-03-20 16:00:00 | QQQ | ETF | 106.75 | 107.75 | 106.6875 | 107.25 | 635800.0 |
| 2000-03-20 17:00:00 | QQQ | ETF | 107.5 | 107.6875 | 107.0 | 107.6875 | 2900.0 |
| 2000-03-20 18:00:00 | QQQ | ETF | 107.6875 | 107.6875 | 107.6875 | 107.6875 | 300.0 |
| 2000-03-20 09:00:00 | DIA | ETF | 106.2812 | 106.8438 | 106.125 | 106.625 | 153100.0 |
| 2000-03-20 10:00:00 | DIA | ETF | 106.75 | 106.9375 | 106.3125 | 106.875 | 177100.0 |
| 2000-03-20 11:00:00 | DIA | ETF | 106.875 | 107.3438 | 106.8125 | 107.0 | 275900.0 |
| 2000-03-20 12:00:00 | DIA | ETF | 107.0625 | 107.25 | 106.6875 | 106.7812 | 133000.0 |
| 2000-03-20 13:00:00 | DIA | ETF | 106.7812 | 107.25 | 106.625 | 106.9375 | 195600.0 |
| 2000-03-20 14:00:00 | DIA | ETF | 106.8125 | 107.1875 | 105.875 | 106.375 | 408300.0 |
| 2000-03-20 15:00:00 | DIA | ETF | 106.375 | 107.0 | 106.25 | 106.6875 | 341700.0 |
| 2000-03-20 16:00:00 | DIA | ETF | 106.6875 | 106.9375 | 106.5625 | 106.8125 | 30900.0 |
> showing 27 of 131 rows — these rows as CSV