PREVIEW / etf_1hour / 2000-01-03
file: by_date/etf_1hour/2000/2000-01-03.parquet size: 8 KB rows: 133
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-03 09:00:00 | SPY | ETF | 148.25 | 148.25 | 146.4688 | 146.625 | 963000.0 |
| 2000-01-03 10:00:00 | SPY | ETF | 146.8125 | 147.25 | 144.4062 | 144.625 | 1457100.0 |
| 2000-01-03 11:00:00 | SPY | ETF | 144.6875 | 144.9062 | 143.875 | 144.75 | 1028900.0 |
| 2000-01-03 12:00:00 | SPY | ETF | 144.6875 | 144.9375 | 144.0625 | 144.5312 | 640000.0 |
| 2000-01-03 13:00:00 | SPY | ETF | 144.5625 | 145.1562 | 144.1875 | 144.7188 | 1289400.0 |
| 2000-01-03 14:00:00 | SPY | ETF | 144.6562 | 145.0938 | 144.25 | 144.7812 | 545300.0 |
| 2000-01-03 15:00:00 | SPY | ETF | 144.6562 | 145.5625 | 144.5938 | 145.5625 | 1759400.0 |
| 2000-01-03 16:00:00 | SPY | ETF | 145.5625 | 145.625 | 145.375 | 145.4375 | 429600.0 |
| 2000-01-03 09:00:00 | QQQ | ETF | 96.1875 | 96.1875 | 93.125 | 93.2188 | 7919800.0 |
| 2000-01-03 10:00:00 | QQQ | ETF | 93.25 | 94.3438 | 91.0 | 91.6875 | 8367000.0 |
| 2000-01-03 11:00:00 | QQQ | ETF | 91.7188 | 93.1562 | 90.75 | 92.9062 | 7128600.0 |
| 2000-01-03 12:00:00 | QQQ | ETF | 92.875 | 93.0 | 92.125 | 92.6406 | 2006400.0 |
| 2000-01-03 13:00:00 | QQQ | ETF | 92.7031 | 93.75 | 92.4375 | 93.375 | 2809800.0 |
| 2000-01-03 14:00:00 | QQQ | ETF | 93.3594 | 93.75 | 92.75 | 93.0625 | 2985800.0 |
| 2000-01-03 15:00:00 | QQQ | ETF | 93.1094 | 94.75 | 93.1094 | 94.75 | 4061400.0 |
| 2000-01-03 16:00:00 | QQQ | ETF | 94.5 | 94.8594 | 94.5 | 94.75 | 676800.0 |
| 2000-01-03 09:00:00 | DIA | ETF | 116.0312 | 116.0312 | 114.9375 | 114.9375 | 306700.0 |
| 2000-01-03 10:00:00 | DIA | ETF | 114.9375 | 115.375 | 113.2812 | 113.625 | 205300.0 |
| 2000-01-03 11:00:00 | DIA | ETF | 113.5312 | 113.7812 | 113.0 | 113.5 | 163800.0 |
| 2000-01-03 12:00:00 | DIA | ETF | 113.6562 | 113.7812 | 113.25 | 113.5312 | 54200.0 |
| 2000-01-03 13:00:00 | DIA | ETF | 113.5 | 113.875 | 113.2812 | 113.625 | 48800.0 |
| 2000-01-03 14:00:00 | DIA | ETF | 113.625 | 113.7188 | 113.1875 | 113.375 | 115500.0 |
| 2000-01-03 15:00:00 | DIA | ETF | 113.5312 | 113.9375 | 113.2812 | 113.6562 | 370400.0 |
| 2000-01-03 16:00:00 | DIA | ETF | 113.5 | 113.5 | 113.4688 | 113.5 | 5900.0 |
> showing 24 of 133 rows — these rows as CSV