PREVIEW / etf_1hour / 2000-01-21
file: by_date/etf_1hour/2000/2000-01-21.parquet size: 8 KB rows: 145
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-21 09:00:00 | SPY | ETF | 145.5 | 145.5 | 144.8125 | 145.2188 | 678600.0 |
| 2000-01-21 10:00:00 | SPY | ETF | 145.1875 | 145.3125 | 144.125 | 144.75 | 1691500.0 |
| 2000-01-21 11:00:00 | SPY | ETF | 144.75 | 145.0625 | 144.25 | 144.2812 | 615500.0 |
| 2000-01-21 12:00:00 | SPY | ETF | 144.25 | 144.875 | 144.25 | 144.625 | 1190300.0 |
| 2000-01-21 13:00:00 | SPY | ETF | 144.5 | 145.125 | 144.4375 | 144.9375 | 883800.0 |
| 2000-01-21 14:00:00 | SPY | ETF | 144.875 | 145.0 | 144.2188 | 144.4375 | 212100.0 |
| 2000-01-21 15:00:00 | SPY | ETF | 144.4375 | 144.625 | 144.0938 | 144.125 | 714300.0 |
| 2000-01-21 16:00:00 | SPY | ETF | 144.0625 | 144.625 | 144.0625 | 144.4375 | 217700.0 |
| 2000-01-21 19:00:00 | SPY | ETF | 144.5938 | 144.5938 | 144.5938 | 144.5938 | 150300.0 |
| 2000-01-21 09:00:00 | QQQ | ETF | 96.5 | 96.5625 | 95.9062 | 96.2344 | 2791800.0 |
| 2000-01-21 10:00:00 | QQQ | ETF | 96.1875 | 96.2344 | 95.0625 | 95.8125 | 3428400.0 |
| 2000-01-21 11:00:00 | QQQ | ETF | 95.75 | 96.1562 | 95.25 | 95.4375 | 1979400.0 |
| 2000-01-21 12:00:00 | QQQ | ETF | 95.5 | 96.4375 | 95.4688 | 96.2188 | 3956800.0 |
| 2000-01-21 13:00:00 | QQQ | ETF | 96.1875 | 96.5469 | 95.75 | 96.2812 | 1308000.0 |
| 2000-01-21 14:00:00 | QQQ | ETF | 96.2344 | 96.3125 | 95.8125 | 95.8438 | 1239200.0 |
| 2000-01-21 15:00:00 | QQQ | ETF | 95.8125 | 96.25 | 95.75 | 96.0625 | 3442400.0 |
| 2000-01-21 16:00:00 | QQQ | ETF | 96.125 | 96.4375 | 96.0625 | 96.25 | 304600.0 |
| 2000-01-21 19:00:00 | QQQ | ETF | 96.125 | 96.125 | 96.125 | 96.125 | 297400.0 |
| 2000-01-21 09:00:00 | DIA | ETF | 114.1875 | 114.1875 | 113.375 | 113.5625 | 159500.0 |
| 2000-01-21 10:00:00 | DIA | ETF | 113.5938 | 113.7812 | 112.5938 | 113.0 | 167100.0 |
| 2000-01-21 11:00:00 | DIA | ETF | 113.125 | 113.1875 | 112.6875 | 112.8438 | 52000.0 |
| 2000-01-21 12:00:00 | DIA | ETF | 112.7812 | 113.0 | 112.625 | 112.7812 | 61200.0 |
| 2000-01-21 13:00:00 | DIA | ETF | 112.6562 | 113.1562 | 112.625 | 112.9062 | 135900.0 |
| 2000-01-21 14:00:00 | DIA | ETF | 112.7812 | 113.125 | 112.5312 | 112.7188 | 90200.0 |
| 2000-01-21 15:00:00 | DIA | ETF | 112.7812 | 112.7812 | 112.3125 | 112.5 | 109300.0 |
| 2000-01-21 16:00:00 | DIA | ETF | 112.5 | 112.8125 | 112.3438 | 112.8125 | 8000.0 |
| 2000-01-21 19:00:00 | DIA | ETF | 112.5625 | 112.5625 | 112.5625 | 112.5625 | 46000.0 |
> showing 27 of 145 rows — these rows as CSV