PREVIEW / etf_1hour / 2000-01-13
file: by_date/etf_1hour/2000/2000-01-13.parquet size: 8 KB rows: 124
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-13 09:00:00 | SPY | ETF | 144.4688 | 144.6562 | 143.7812 | 143.9375 | 875600.0 |
| 2000-01-13 10:00:00 | SPY | ETF | 143.875 | 144.25 | 143.2812 | 143.9375 | 718600.0 |
| 2000-01-13 11:00:00 | SPY | ETF | 143.875 | 144.5625 | 143.75 | 143.9375 | 934200.0 |
| 2000-01-13 12:00:00 | SPY | ETF | 144.0625 | 144.25 | 143.75 | 143.9688 | 213500.0 |
| 2000-01-13 13:00:00 | SPY | ETF | 144.125 | 144.875 | 143.875 | 144.7812 | 405600.0 |
| 2000-01-13 14:00:00 | SPY | ETF | 144.8438 | 145.375 | 144.625 | 145.0 | 545600.0 |
| 2000-01-13 15:00:00 | SPY | ETF | 144.875 | 145.75 | 144.875 | 145.125 | 1016600.0 |
| 2000-01-13 16:00:00 | SPY | ETF | 145.0312 | 145.1875 | 144.6875 | 145.0 | 407300.0 |
| 2000-01-13 09:00:00 | QQQ | ETF | 88.5 | 89.25 | 87.875 | 88.0938 | 4074200.0 |
| 2000-01-13 10:00:00 | QQQ | ETF | 88.0938 | 88.625 | 87.0781 | 88.0625 | 5220200.0 |
| 2000-01-13 11:00:00 | QQQ | ETF | 88.0625 | 88.7188 | 87.5625 | 87.8594 | 2275600.0 |
| 2000-01-13 12:00:00 | QQQ | ETF | 87.875 | 88.1875 | 87.625 | 87.9062 | 1177000.0 |
| 2000-01-13 13:00:00 | QQQ | ETF | 87.9062 | 88.6875 | 87.8125 | 88.625 | 2575600.0 |
| 2000-01-13 14:00:00 | QQQ | ETF | 88.625 | 89.125 | 88.3125 | 88.7031 | 2801200.0 |
| 2000-01-13 15:00:00 | QQQ | ETF | 88.6875 | 90.3125 | 88.6562 | 90.125 | 6128200.0 |
| 2000-01-13 16:00:00 | QQQ | ETF | 90.0 | 91.25 | 89.75 | 91.25 | 532200.0 |
| 2000-01-13 17:00:00 | QQQ | ETF | 91.25 | 91.5 | 90.75 | 91.25 | 4800.0 |
| 2000-01-13 18:00:00 | QQQ | ETF | 91.25 | 91.25 | 91.25 | 91.25 | 200.0 |
| 2000-01-13 09:00:00 | DIA | ETF | 116.0312 | 116.2188 | 115.5312 | 115.75 | 340700.0 |
| 2000-01-13 10:00:00 | DIA | ETF | 115.75 | 116.0 | 115.2188 | 115.625 | 130600.0 |
| 2000-01-13 11:00:00 | DIA | ETF | 115.6875 | 116.0 | 115.5 | 115.5 | 137200.0 |
| 2000-01-13 12:00:00 | DIA | ETF | 115.6875 | 115.7812 | 115.5 | 115.6562 | 44600.0 |
| 2000-01-13 13:00:00 | DIA | ETF | 115.5312 | 115.9688 | 115.5 | 115.9688 | 108300.0 |
| 2000-01-13 14:00:00 | DIA | ETF | 115.875 | 116.4062 | 115.75 | 116.25 | 203000.0 |
| 2000-01-13 15:00:00 | DIA | ETF | 116.3438 | 116.625 | 115.875 | 115.9062 | 175400.0 |
| 2000-01-13 16:00:00 | DIA | ETF | 115.9375 | 115.9688 | 115.7188 | 115.875 | 51800.0 |
> showing 26 of 124 rows — these rows as CSV