PREVIEW / etf_1hour / 2000-01-06
file: by_date/etf_1hour/2000/2000-01-06.parquet size: 8 KB rows: 138
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-01-06 09:00:00 | SPY | ETF | 139.625 | 140.5 | 139.625 | 139.625 | 1263500.0 |
| 2000-01-06 10:00:00 | SPY | ETF | 139.6875 | 140.625 | 139.25 | 140.3125 | 910700.0 |
| 2000-01-06 11:00:00 | SPY | ETF | 140.3125 | 140.6875 | 140.0 | 140.3438 | 354800.0 |
| 2000-01-06 12:00:00 | SPY | ETF | 140.375 | 141.0938 | 140.1875 | 141.0938 | 317000.0 |
| 2000-01-06 13:00:00 | SPY | ETF | 141.125 | 141.4062 | 140.7812 | 141.25 | 460700.0 |
| 2000-01-06 14:00:00 | SPY | ETF | 141.2812 | 141.5 | 140.5938 | 140.875 | 525200.0 |
| 2000-01-06 15:00:00 | SPY | ETF | 140.9375 | 141.1875 | 139.5938 | 140.3438 | 1396500.0 |
| 2000-01-06 16:00:00 | SPY | ETF | 140.375 | 140.375 | 138.625 | 138.625 | 858100.0 |
| 2000-01-06 17:00:00 | SPY | ETF | 137.75 | 137.75 | 137.75 | 137.75 | 70400.0 |
| 2000-01-06 09:00:00 | QQQ | ETF | 86.875 | 88.0 | 86.0156 | 86.1875 | 5899000.0 |
| 2000-01-06 10:00:00 | QQQ | ETF | 86.1562 | 87.0 | 84.875 | 85.9375 | 7390400.0 |
| 2000-01-06 11:00:00 | QQQ | ETF | 86.0 | 86.2031 | 85.125 | 85.4688 | 2040800.0 |
| 2000-01-06 12:00:00 | QQQ | ETF | 85.4375 | 86.4062 | 85.375 | 86.375 | 3296000.0 |
| 2000-01-06 13:00:00 | QQQ | ETF | 86.4844 | 86.625 | 85.4062 | 85.75 | 2871200.0 |
| 2000-01-06 14:00:00 | QQQ | ETF | 85.875 | 85.9375 | 84.125 | 84.5 | 3840400.0 |
| 2000-01-06 15:00:00 | QQQ | ETF | 84.75 | 85.2188 | 83.0 | 83.5625 | 8358800.0 |
| 2000-01-06 16:00:00 | QQQ | ETF | 83.5625 | 83.75 | 80.625 | 80.75 | 3102800.0 |
| 2000-01-06 17:00:00 | QQQ | ETF | 80.9688 | 81.5312 | 79.75 | 80.0 | 105600.0 |
| 2000-01-06 18:00:00 | QQQ | ETF | 80.0938 | 80.125 | 80.0 | 80.0938 | 2800.0 |
| 2000-01-06 09:00:00 | DIA | ETF | 111.4062 | 111.75 | 111.1875 | 111.4062 | 466100.0 |
| 2000-01-06 10:00:00 | DIA | ETF | 111.375 | 112.0 | 111.3125 | 111.9688 | 784600.0 |
| 2000-01-06 11:00:00 | DIA | ETF | 111.9688 | 112.2188 | 111.75 | 112.1562 | 85900.0 |
| 2000-01-06 12:00:00 | DIA | ETF | 112.1562 | 112.75 | 112.0 | 112.7188 | 251800.0 |
| 2000-01-06 13:00:00 | DIA | ETF | 112.625 | 113.0938 | 112.5 | 112.8438 | 78500.0 |
| 2000-01-06 14:00:00 | DIA | ETF | 112.875 | 113.1562 | 112.75 | 112.9375 | 160500.0 |
| 2000-01-06 15:00:00 | DIA | ETF | 112.8125 | 113.125 | 111.9375 | 112.6875 | 585000.0 |
| 2000-01-06 16:00:00 | DIA | ETF | 112.5 | 112.5625 | 111.5625 | 111.75 | 168700.0 |
> showing 27 of 138 rows — these rows as CSV