PREVIEW / etf_1hour / 2000-05-09
file: by_date/etf_1hour/2000/2000-05-09.parquet size: 8 KB rows: 118
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-09 09:00:00 | SPY | ETF | 143.0625 | 143.4062 | 142.7812 | 142.9688 | 456300.0 |
| 2000-05-09 10:00:00 | SPY | ETF | 142.9688 | 143.0 | 141.5 | 141.7812 | 1192100.0 |
| 2000-05-09 11:00:00 | SPY | ETF | 141.875 | 142.3438 | 141.3125 | 141.8438 | 490900.0 |
| 2000-05-09 12:00:00 | SPY | ETF | 141.8125 | 142.0 | 141.0625 | 141.3125 | 581200.0 |
| 2000-05-09 13:00:00 | SPY | ETF | 141.2812 | 141.6562 | 140.6562 | 140.7812 | 628200.0 |
| 2000-05-09 14:00:00 | SPY | ETF | 140.8438 | 141.625 | 140.25 | 141.3438 | 1165800.0 |
| 2000-05-09 15:00:00 | SPY | ETF | 141.5312 | 142.375 | 140.7812 | 141.625 | 710900.0 |
| 2000-05-09 16:00:00 | SPY | ETF | 141.8438 | 141.8438 | 141.3125 | 141.3125 | 363900.0 |
| 2000-05-09 09:00:00 | QQQ | ETF | 88.5 | 89.125 | 87.75 | 88.0 | 2614000.0 |
| 2000-05-09 10:00:00 | QQQ | ETF | 87.75 | 88.0 | 85.375 | 86.125 | 4847100.0 |
| 2000-05-09 11:00:00 | QQQ | ETF | 86.1875 | 86.8125 | 85.0 | 86.4062 | 1947900.0 |
| 2000-05-09 12:00:00 | QQQ | ETF | 86.375 | 86.5 | 85.5625 | 85.8125 | 1268300.0 |
| 2000-05-09 13:00:00 | QQQ | ETF | 85.75 | 86.1875 | 85.125 | 85.25 | 1566100.0 |
| 2000-05-09 14:00:00 | QQQ | ETF | 85.1875 | 87.0 | 84.75 | 86.75 | 3667100.0 |
| 2000-05-09 15:00:00 | QQQ | ETF | 86.625 | 87.5625 | 85.875 | 86.1562 | 3518800.0 |
| 2000-05-09 16:00:00 | QQQ | ETF | 86.0625 | 86.0625 | 85.375 | 85.5 | 288800.0 |
| 2000-05-09 17:00:00 | QQQ | ETF | 85.75 | 85.75 | 85.75 | 85.75 | 4100.0 |
| 2000-05-09 18:00:00 | QQQ | ETF | 85.5 | 86.0 | 85.5 | 86.0 | 1200.0 |
| 2000-05-09 09:00:00 | DIA | ETF | 106.0625 | 106.6875 | 106.0625 | 106.4375 | 110200.0 |
| 2000-05-09 10:00:00 | DIA | ETF | 106.625 | 106.9375 | 105.75 | 106.0938 | 228000.0 |
| 2000-05-09 11:00:00 | DIA | ETF | 105.9375 | 106.5 | 105.5 | 105.75 | 201300.0 |
| 2000-05-09 12:00:00 | DIA | ETF | 105.7812 | 105.9375 | 105.375 | 105.4062 | 163800.0 |
| 2000-05-09 13:00:00 | DIA | ETF | 105.5 | 105.8125 | 105.125 | 105.25 | 230300.0 |
| 2000-05-09 14:00:00 | DIA | ETF | 105.1875 | 105.625 | 105.0 | 105.5938 | 101000.0 |
| 2000-05-09 15:00:00 | DIA | ETF | 105.4375 | 105.875 | 105.0938 | 105.5625 | 153800.0 |
| 2000-05-09 16:00:00 | DIA | ETF | 105.3438 | 105.5 | 105.3125 | 105.375 | 6200.0 |
> showing 26 of 118 rows — these rows as CSV