PREVIEW / etf_1hour / 2000-05-19
file: by_date/etf_1hour/2000/2000-05-19.parquet size: 8 KB rows: 130
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-05-19 09:00:00 | SPY | ETF | 142.5625 | 143.2188 | 142.1562 | 142.25 | 824800.0 |
| 2000-05-19 10:00:00 | SPY | ETF | 142.375 | 142.4062 | 141.2812 | 141.6875 | 983400.0 |
| 2000-05-19 11:00:00 | SPY | ETF | 141.5938 | 142.0938 | 141.0625 | 141.5 | 806600.0 |
| 2000-05-19 12:00:00 | SPY | ETF | 141.5625 | 141.7188 | 141.1562 | 141.1562 | 511000.0 |
| 2000-05-19 13:00:00 | SPY | ETF | 141.375 | 141.5625 | 140.5 | 141.0 | 491000.0 |
| 2000-05-19 14:00:00 | SPY | ETF | 141.0938 | 141.75 | 140.4062 | 141.625 | 999800.0 |
| 2000-05-19 15:00:00 | SPY | ETF | 141.5 | 141.875 | 140.6875 | 140.875 | 1083500.0 |
| 2000-05-19 16:00:00 | SPY | ETF | 140.8438 | 141.3125 | 140.8125 | 141.125 | 796600.0 |
| 2000-05-19 09:00:00 | QQQ | ETF | 83.75 | 85.0 | 83.25 | 83.625 | 3469600.0 |
| 2000-05-19 10:00:00 | QQQ | ETF | 83.625 | 83.75 | 82.5625 | 82.5625 | 4761200.0 |
| 2000-05-19 11:00:00 | QQQ | ETF | 82.625 | 83.2812 | 82.0312 | 82.75 | 3665700.0 |
| 2000-05-19 12:00:00 | QQQ | ETF | 82.8125 | 82.8125 | 82.1875 | 82.3125 | 1831000.0 |
| 2000-05-19 13:00:00 | QQQ | ETF | 82.375 | 82.5625 | 81.375 | 81.9375 | 3938100.0 |
| 2000-05-19 14:00:00 | QQQ | ETF | 82.0 | 83.25 | 81.5 | 83.0 | 4588300.0 |
| 2000-05-19 15:00:00 | QQQ | ETF | 82.9375 | 83.0 | 81.3125 | 81.5938 | 4558600.0 |
| 2000-05-19 16:00:00 | QQQ | ETF | 81.375 | 81.9375 | 81.3125 | 81.6875 | 1303800.0 |
| 2000-05-19 09:00:00 | DIA | ETF | 106.5625 | 107.0312 | 106.5 | 106.6875 | 227200.0 |
| 2000-05-19 10:00:00 | DIA | ETF | 106.5625 | 106.7188 | 106.0312 | 106.375 | 251100.0 |
| 2000-05-19 11:00:00 | DIA | ETF | 106.375 | 106.8125 | 106.125 | 106.4375 | 166000.0 |
| 2000-05-19 12:00:00 | DIA | ETF | 106.3125 | 106.5312 | 106.0938 | 106.0938 | 127500.0 |
| 2000-05-19 13:00:00 | DIA | ETF | 106.0938 | 106.4062 | 105.625 | 106.1562 | 191800.0 |
| 2000-05-19 14:00:00 | DIA | ETF | 106.1562 | 106.25 | 105.5 | 106.1875 | 99700.0 |
| 2000-05-19 15:00:00 | DIA | ETF | 106.2188 | 106.5 | 105.75 | 105.9375 | 207500.0 |
| 2000-05-19 16:00:00 | DIA | ETF | 106.1562 | 106.625 | 105.9375 | 106.5625 | 98400.0 |
> showing 24 of 130 rows — these rows as CSV