PREVIEW / etf_1hour / 2000-03-01
file: by_date/etf_1hour/2000/2000-03-01.parquet size: 8 KB rows: 132
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-03-01 09:00:00 | SPY | ETF | 137.625 | 138.2812 | 137.5625 | 138.0625 | 808000.0 |
| 2000-03-01 10:00:00 | SPY | ETF | 138.2188 | 138.5 | 137.4062 | 137.75 | 887900.0 |
| 2000-03-01 11:00:00 | SPY | ETF | 137.6875 | 138.375 | 137.5625 | 137.8125 | 830600.0 |
| 2000-03-01 12:00:00 | SPY | ETF | 137.9062 | 138.4688 | 137.7188 | 138.125 | 1232200.0 |
| 2000-03-01 13:00:00 | SPY | ETF | 138.125 | 138.4062 | 137.5 | 137.6875 | 1133100.0 |
| 2000-03-01 14:00:00 | SPY | ETF | 137.5625 | 138.0625 | 137.2188 | 137.75 | 687000.0 |
| 2000-03-01 15:00:00 | SPY | ETF | 137.75 | 138.8438 | 137.5625 | 138.3125 | 820800.0 |
| 2000-03-01 16:00:00 | SPY | ETF | 138.1875 | 138.5 | 138.125 | 138.4375 | 439000.0 |
| 2000-03-01 09:00:00 | QQQ | ETF | 107.25 | 108.375 | 107.0938 | 107.75 | 3703200.0 |
| 2000-03-01 10:00:00 | QQQ | ETF | 107.75 | 108.5625 | 106.75 | 107.0156 | 4326600.0 |
| 2000-03-01 11:00:00 | QQQ | ETF | 107.2188 | 107.9375 | 106.75 | 107.4375 | 3096800.0 |
| 2000-03-01 12:00:00 | QQQ | ETF | 107.3906 | 108.375 | 107.25 | 108.1875 | 2321200.0 |
| 2000-03-01 13:00:00 | QQQ | ETF | 108.0938 | 108.375 | 107.0156 | 107.0312 | 2172000.0 |
| 2000-03-01 14:00:00 | QQQ | ETF | 107.0312 | 107.7031 | 106.5 | 107.375 | 3553400.0 |
| 2000-03-01 15:00:00 | QQQ | ETF | 107.375 | 108.1875 | 107.25 | 107.5625 | 4563000.0 |
| 2000-03-01 16:00:00 | QQQ | ETF | 107.625 | 107.7344 | 107.375 | 107.625 | 213600.0 |
| 2000-03-01 17:00:00 | QQQ | ETF | 107.625 | 107.625 | 107.625 | 107.625 | 2000.0 |
| 2000-03-01 09:00:00 | DIA | ETF | 101.7812 | 102.7812 | 101.375 | 101.5 | 169700.0 |
| 2000-03-01 10:00:00 | DIA | ETF | 101.4062 | 101.7188 | 100.6875 | 100.9375 | 363500.0 |
| 2000-03-01 11:00:00 | DIA | ETF | 101.0938 | 101.5938 | 100.9688 | 101.0625 | 82100.0 |
| 2000-03-01 12:00:00 | DIA | ETF | 101.125 | 101.6875 | 101.0625 | 101.5938 | 51500.0 |
| 2000-03-01 13:00:00 | DIA | ETF | 101.4375 | 101.6562 | 101.0625 | 101.25 | 118700.0 |
| 2000-03-01 14:00:00 | DIA | ETF | 101.1562 | 101.6875 | 101.0 | 101.1875 | 130100.0 |
| 2000-03-01 15:00:00 | DIA | ETF | 101.375 | 102.0 | 101.0312 | 101.3125 | 189200.0 |
| 2000-03-01 16:00:00 | DIA | ETF | 101.375 | 101.625 | 101.2812 | 101.625 | 9600.0 |
> showing 25 of 132 rows — these rows as CSV