PREVIEW / etf_1hour / 2000-04-25
file: by_date/etf_1hour/2000/2000-04-25.parquet size: 8 KB rows: 127
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-04-25 09:00:00 | SPY | ETF | 144.625 | 145.4375 | 144.4375 | 145.25 | 2115500.0 |
| 2000-04-25 10:00:00 | SPY | ETF | 145.25 | 145.75 | 144.5625 | 145.5 | 2238600.0 |
| 2000-04-25 11:00:00 | SPY | ETF | 145.625 | 146.1875 | 145.375 | 146.0625 | 1130800.0 |
| 2000-04-25 12:00:00 | SPY | ETF | 146.0625 | 146.375 | 145.5625 | 145.7188 | 1795000.0 |
| 2000-04-25 13:00:00 | SPY | ETF | 145.75 | 146.6562 | 145.5 | 146.6562 | 1969400.0 |
| 2000-04-25 14:00:00 | SPY | ETF | 146.6562 | 147.4688 | 146.5312 | 146.9375 | 2273100.0 |
| 2000-04-25 15:00:00 | SPY | ETF | 147.125 | 147.9688 | 147.0 | 147.875 | 2229400.0 |
| 2000-04-25 16:00:00 | SPY | ETF | 147.9062 | 148.1562 | 147.8125 | 148.1562 | 344200.0 |
| 2000-04-25 09:00:00 | QQQ | ETF | 86.5 | 88.0938 | 86.25 | 87.9375 | 4539600.0 |
| 2000-04-25 10:00:00 | QQQ | ETF | 87.9375 | 88.125 | 86.0 | 87.5312 | 4020300.0 |
| 2000-04-25 11:00:00 | QQQ | ETF | 87.5625 | 88.25 | 87.0 | 87.4375 | 3379300.0 |
| 2000-04-25 12:00:00 | QQQ | ETF | 87.375 | 87.9375 | 86.5625 | 86.7812 | 3315600.0 |
| 2000-04-25 13:00:00 | QQQ | ETF | 86.75 | 87.625 | 86.5 | 87.5938 | 2383400.0 |
| 2000-04-25 14:00:00 | QQQ | ETF | 87.5625 | 88.375 | 87.5 | 88.1875 | 3146000.0 |
| 2000-04-25 15:00:00 | QQQ | ETF | 88.2188 | 90.25 | 87.875 | 90.1875 | 6683200.0 |
| 2000-04-25 16:00:00 | QQQ | ETF | 90.125 | 90.5 | 90.0 | 90.0 | 836200.0 |
| 2000-04-25 17:00:00 | QQQ | ETF | 90.0 | 90.4375 | 90.0 | 90.25 | 50700.0 |
| 2000-04-25 18:00:00 | QQQ | ETF | 90.0625 | 90.4688 | 90.0625 | 90.4688 | 400.0 |
| 2000-04-25 09:00:00 | DIA | ETF | 109.7188 | 110.0 | 109.125 | 109.4688 | 445200.0 |
| 2000-04-25 10:00:00 | DIA | ETF | 109.3438 | 109.7812 | 108.7812 | 109.625 | 297100.0 |
| 2000-04-25 11:00:00 | DIA | ETF | 109.5 | 110.125 | 109.5 | 109.8125 | 781000.0 |
| 2000-04-25 12:00:00 | DIA | ETF | 109.625 | 110.1875 | 109.5938 | 109.9062 | 513700.0 |
| 2000-04-25 13:00:00 | DIA | ETF | 110.0625 | 110.3125 | 109.8125 | 110.3125 | 126500.0 |
| 2000-04-25 14:00:00 | DIA | ETF | 110.25 | 110.9688 | 110.25 | 110.7812 | 339500.0 |
| 2000-04-25 15:00:00 | DIA | ETF | 110.75 | 111.4375 | 110.75 | 111.3125 | 220200.0 |
| 2000-04-25 16:00:00 | DIA | ETF | 111.1875 | 111.625 | 111.1875 | 111.5312 | 73500.0 |
| 2000-04-25 18:00:00 | DIA | ETF | 111.2812 | 111.2812 | 111.2812 | 111.2812 | 100.0 |
> showing 27 of 127 rows — these rows as CSV