PREVIEW / etf_1hour / 2000-01-12
file: by_date/etf_1hour/2000/2000-01-12.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-01-12 09:00:00 | SPY | ETF | 144.5938 | 144.5938 | 143.1562 | 143.5 | 828300.0 |
| 2000-01-12 10:00:00 | SPY | ETF | 143.5 | 144.25 | 142.875 | 144.0312 | 1079700.0 |
| 2000-01-12 11:00:00 | SPY | ETF | 144.1562 | 144.5312 | 143.7188 | 144.4062 | 1899600.0 |
| 2000-01-12 12:00:00 | SPY | ETF | 144.2812 | 144.4375 | 143.5938 | 143.6562 | 862300.0 |
| 2000-01-12 13:00:00 | SPY | ETF | 143.8125 | 144.375 | 143.7812 | 143.8125 | 316100.0 |
| 2000-01-12 14:00:00 | SPY | ETF | 143.9375 | 144.0625 | 143.4062 | 143.5625 | 943200.0 |
| 2000-01-12 15:00:00 | SPY | ETF | 143.5 | 144.0 | 143.125 | 143.3438 | 641000.0 |
| 2000-01-12 16:00:00 | SPY | ETF | 143.4375 | 143.5 | 143.0625 | 143.0625 | 245900.0 |
| 2000-01-12 09:00:00 | QQQ | ETF | 89.0 | 89.2344 | 86.0 | 86.875 | 5636800.0 |
| 2000-01-12 10:00:00 | QQQ | ETF | 87.0 | 88.3438 | 86.0 | 87.75 | 6870000.0 |
| 2000-01-12 11:00:00 | QQQ | ETF | 87.75 | 89.0625 | 87.375 | 88.8438 | 3193400.0 |
| 2000-01-12 12:00:00 | QQQ | ETF | 88.875 | 88.9062 | 87.5312 | 88.125 | 2365400.0 |
| 2000-01-12 13:00:00 | QQQ | ETF | 88.25 | 88.5 | 87.8125 | 88.125 | 2010200.0 |
| 2000-01-12 14:00:00 | QQQ | ETF | 88.125 | 88.3594 | 87.0 | 87.125 | 3070400.0 |
| 2000-01-12 15:00:00 | QQQ | ETF | 87.0938 | 87.875 | 86.1875 | 87.0625 | 4659600.0 |
| 2000-01-12 16:00:00 | QQQ | ETF | 86.9375 | 87.0625 | 86.25 | 86.5625 | 1119000.0 |
| 2000-01-12 18:00:00 | QQQ | ETF | 86.25 | 86.25 | 86.0625 | 86.0625 | 600.0 |
| 2000-01-12 09:00:00 | DIA | ETF | 115.5 | 115.6562 | 115.1562 | 115.375 | 111000.0 |
| 2000-01-12 10:00:00 | DIA | ETF | 115.4375 | 115.9062 | 115.2188 | 115.8438 | 271900.0 |
| 2000-01-12 11:00:00 | DIA | ETF | 115.875 | 116.0938 | 115.5 | 115.8438 | 98100.0 |
| 2000-01-12 12:00:00 | DIA | ETF | 115.9688 | 115.9688 | 115.5938 | 115.75 | 15700.0 |
| 2000-01-12 13:00:00 | DIA | ETF | 115.75 | 116.1875 | 115.7188 | 115.75 | 80200.0 |
| 2000-01-12 14:00:00 | DIA | ETF | 115.875 | 115.9688 | 115.375 | 115.625 | 120400.0 |
| 2000-01-12 15:00:00 | DIA | ETF | 115.6562 | 115.9688 | 115.5 | 115.6562 | 80400.0 |
| 2000-01-12 16:00:00 | DIA | ETF | 115.4688 | 115.625 | 115.4062 | 115.4375 | 35600.0 |
> showing 25 of 132 rows — these rows as CSV