PREVIEW / etf_1hour / 2000-01-18
file: by_date/etf_1hour/2000/2000-01-18.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-01-18 09:00:00 | SPY | ETF | 145.3438 | 145.9375 | 145.25 | 145.9375 | 863200.0 |
| 2000-01-18 10:00:00 | SPY | ETF | 145.875 | 146.4688 | 145.3438 | 145.5 | 1468100.0 |
| 2000-01-18 11:00:00 | SPY | ETF | 145.6562 | 145.8438 | 145.1875 | 145.5625 | 816500.0 |
| 2000-01-18 12:00:00 | SPY | ETF | 145.625 | 146.0 | 145.4688 | 145.75 | 801200.0 |
| 2000-01-18 13:00:00 | SPY | ETF | 145.75 | 146.25 | 145.5625 | 145.75 | 675900.0 |
| 2000-01-18 14:00:00 | SPY | ETF | 145.75 | 146.5312 | 145.6562 | 146.0312 | 773200.0 |
| 2000-01-18 15:00:00 | SPY | ETF | 146.25 | 146.625 | 145.5 | 145.625 | 761500.0 |
| 2000-01-18 16:00:00 | SPY | ETF | 145.5625 | 146.0625 | 145.5625 | 145.8125 | 261200.0 |
| 2000-01-18 09:00:00 | QQQ | ETF | 92.0625 | 92.5 | 91.4375 | 92.4844 | 2429600.0 |
| 2000-01-18 10:00:00 | QQQ | ETF | 92.25 | 93.4375 | 91.9375 | 92.8438 | 4416800.0 |
| 2000-01-18 11:00:00 | QQQ | ETF | 92.8125 | 92.9688 | 92.25 | 92.75 | 1976800.0 |
| 2000-01-18 12:00:00 | QQQ | ETF | 92.7188 | 93.25 | 92.6875 | 93.125 | 708800.0 |
| 2000-01-18 13:00:00 | QQQ | ETF | 93.125 | 93.5 | 92.9219 | 92.9688 | 1523800.0 |
| 2000-01-18 14:00:00 | QQQ | ETF | 92.9688 | 94.375 | 92.8125 | 93.9375 | 2222400.0 |
| 2000-01-18 15:00:00 | QQQ | ETF | 93.875 | 94.4375 | 93.5625 | 93.875 | 2657800.0 |
| 2000-01-18 16:00:00 | QQQ | ETF | 93.9062 | 94.25 | 93.8438 | 94.0 | 350600.0 |
| 2000-01-18 17:00:00 | QQQ | ETF | 93.5 | 93.5 | 93.5 | 93.5 | 1000.0 |
| 2000-01-18 18:00:00 | QQQ | ETF | 93.5312 | 93.875 | 93.5312 | 93.875 | 2400.0 |
| 2000-01-18 09:00:00 | DIA | ETF | 116.4375 | 116.625 | 116.0625 | 116.5625 | 205800.0 |
| 2000-01-18 10:00:00 | DIA | ETF | 116.5938 | 116.875 | 116.0312 | 116.1875 | 65500.0 |
| 2000-01-18 11:00:00 | DIA | ETF | 116.1875 | 116.4688 | 115.875 | 116.2812 | 63400.0 |
| 2000-01-18 12:00:00 | DIA | ETF | 116.0938 | 116.3438 | 116.0625 | 116.2188 | 39600.0 |
| 2000-01-18 13:00:00 | DIA | ETF | 116.0625 | 116.5 | 116.0625 | 116.0625 | 24900.0 |
| 2000-01-18 14:00:00 | DIA | ETF | 116.1562 | 116.4688 | 116.0938 | 116.1562 | 53400.0 |
| 2000-01-18 15:00:00 | DIA | ETF | 116.25 | 116.5312 | 115.5 | 115.625 | 194000.0 |
| 2000-01-18 16:00:00 | DIA | ETF | 115.7188 | 115.7188 | 115.7188 | 115.7188 | 100.0 |
> showing 26 of 140 rows — these rows as CSV