PREVIEW / etf_1hour / 2000-06-22
file: by_date/etf_1hour/2000/2000-06-22.parquet size: 9 KB rows: 161
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-06-22 09:00:00 | SPY | ETF | 147.5625 | 147.6875 | 146.5625 | 147.0312 | 947800.0 |
| 2000-06-22 10:00:00 | SPY | ETF | 147.1875 | 147.4375 | 145.9375 | 146.25 | 1152000.0 |
| 2000-06-22 11:00:00 | SPY | ETF | 146.0938 | 146.5 | 145.6875 | 146.375 | 1082600.0 |
| 2000-06-22 12:00:00 | SPY | ETF | 146.3125 | 146.6562 | 146.125 | 146.25 | 210400.0 |
| 2000-06-22 13:00:00 | SPY | ETF | 146.2812 | 146.7188 | 146.1562 | 146.5312 | 585900.0 |
| 2000-06-22 14:00:00 | SPY | ETF | 146.4375 | 146.625 | 145.5312 | 145.5625 | 788500.0 |
| 2000-06-22 15:00:00 | SPY | ETF | 145.5 | 145.9375 | 145.0 | 145.5312 | 1327900.0 |
| 2000-06-22 16:00:00 | SPY | ETF | 145.375 | 145.7188 | 145.375 | 145.625 | 426200.0 |
| 2000-06-22 09:00:00 | QQQ | ETF | 98.625 | 99.0 | 97.25 | 98.0625 | 2517600.0 |
| 2000-06-22 10:00:00 | QQQ | ETF | 98.0312 | 98.5 | 97.0 | 97.1875 | 3589100.0 |
| 2000-06-22 11:00:00 | QQQ | ETF | 97.1875 | 97.6562 | 96.8125 | 97.5 | 2805800.0 |
| 2000-06-22 12:00:00 | QQQ | ETF | 97.5 | 97.875 | 97.125 | 97.125 | 735800.0 |
| 2000-06-22 13:00:00 | QQQ | ETF | 97.125 | 98.2188 | 97.125 | 98.0 | 1525400.0 |
| 2000-06-22 14:00:00 | QQQ | ETF | 98.125 | 98.125 | 96.25 | 96.25 | 3696300.0 |
| 2000-06-22 15:00:00 | QQQ | ETF | 96.5 | 96.625 | 95.0 | 95.0 | 6063100.0 |
| 2000-06-22 16:00:00 | QQQ | ETF | 95.25 | 96.25 | 94.5 | 95.0 | 526900.0 |
| 2000-06-22 17:00:00 | QQQ | ETF | 95.25 | 95.5 | 95.25 | 95.5 | 2300.0 |
| 2000-06-22 18:00:00 | QQQ | ETF | 95.5 | 95.5 | 95.0 | 95.25 | 3500.0 |
| 2000-06-22 09:00:00 | IWM | ETF | 53.0 | 53.0 | 52.7344 | 52.7344 | 2600.0 |
| 2000-06-22 10:00:00 | IWM | ETF | 52.9375 | 52.9531 | 52.4688 | 52.4688 | 49400.0 |
| 2000-06-22 11:00:00 | IWM | ETF | 52.5625 | 52.5625 | 52.3125 | 52.5 | 8800.0 |
| 2000-06-22 12:00:00 | IWM | ETF | 52.5781 | 52.5781 | 52.5781 | 52.5781 | 800.0 |
| 2000-06-22 13:00:00 | IWM | ETF | 52.5 | 52.5469 | 52.5 | 52.5469 | 600.0 |
| 2000-06-22 14:00:00 | IWM | ETF | 52.25 | 52.25 | 52.0938 | 52.0938 | 28200.0 |
| 2000-06-22 15:00:00 | IWM | ETF | 52.0625 | 52.0625 | 51.3438 | 51.3438 | 48800.0 |
| 2000-06-22 16:00:00 | IWM | ETF | 51.25 | 51.25 | 51.25 | 51.25 | 400.0 |
| 2000-06-22 09:00:00 | DIA | ETF | 104.5938 | 105.0312 | 104.5312 | 104.6875 | 168500.0 |
| 2000-06-22 10:00:00 | DIA | ETF | 104.5 | 104.8125 | 103.875 | 104.2188 | 121800.0 |
| 2000-06-22 11:00:00 | DIA | ETF | 104.0312 | 104.5625 | 103.75 | 104.5312 | 107000.0 |
| 2000-06-22 12:00:00 | DIA | ETF | 104.3125 | 104.5625 | 104.1562 | 104.5 | 36900.0 |
| 2000-06-22 13:00:00 | DIA | ETF | 104.375 | 104.75 | 104.25 | 104.625 | 80900.0 |
| 2000-06-22 14:00:00 | DIA | ETF | 104.5625 | 104.5938 | 104.0312 | 104.0625 | 78400.0 |
| 2000-06-22 15:00:00 | DIA | ETF | 104.0312 | 104.125 | 103.375 | 104.0 | 257100.0 |
| 2000-06-22 16:00:00 | DIA | ETF | 103.9688 | 104.125 | 103.875 | 104.0 | 37600.0 |
> showing 34 of 161 rows — these rows as CSV