PREVIEW / etf_1hour / 2000-06-30
file: by_date/etf_1hour/2000/2000-06-30.parquet size: 9 KB rows: 152
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-30 09:00:00 | SPY | ETF | 143.9375 | 144.4062 | 143.875 | 144.0312 | 530500.0 |
| 2000-06-30 10:00:00 | SPY | ETF | 144.0625 | 144.8438 | 143.9062 | 144.625 | 930700.0 |
| 2000-06-30 11:00:00 | SPY | ETF | 144.625 | 145.2188 | 144.5312 | 144.6875 | 876500.0 |
| 2000-06-30 12:00:00 | SPY | ETF | 144.75 | 145.0625 | 144.625 | 145.0312 | 821700.0 |
| 2000-06-30 13:00:00 | SPY | ETF | 145.0312 | 145.25 | 144.625 | 144.8125 | 982700.0 |
| 2000-06-30 14:00:00 | SPY | ETF | 144.9375 | 144.9375 | 144.1875 | 144.875 | 799900.0 |
| 2000-06-30 15:00:00 | SPY | ETF | 144.875 | 145.5312 | 144.0312 | 145.375 | 1696900.0 |
| 2000-06-30 16:00:00 | SPY | ETF | 145.4062 | 145.5938 | 145.2812 | 145.2812 | 753500.0 |
| 2000-06-30 09:00:00 | QQQ | ETF | 91.8125 | 92.4688 | 91.75 | 92.125 | 2308600.0 |
| 2000-06-30 10:00:00 | QQQ | ETF | 92.1875 | 93.25 | 92.0625 | 92.9375 | 2091800.0 |
| 2000-06-30 11:00:00 | QQQ | ETF | 92.9375 | 93.5 | 92.8125 | 92.9688 | 1353000.0 |
| 2000-06-30 12:00:00 | QQQ | ETF | 92.9688 | 93.25 | 92.75 | 93.0938 | 771600.0 |
| 2000-06-30 13:00:00 | QQQ | ETF | 93.0312 | 93.4375 | 92.875 | 93.0 | 1411800.0 |
| 2000-06-30 14:00:00 | QQQ | ETF | 92.875 | 93.125 | 92.3125 | 92.9375 | 2279800.0 |
| 2000-06-30 15:00:00 | QQQ | ETF | 93.0 | 93.9375 | 92.25 | 93.75 | 3892600.0 |
| 2000-06-30 16:00:00 | QQQ | ETF | 93.6875 | 93.9375 | 92.75 | 93.3125 | 999100.0 |
| 2000-06-30 17:00:00 | QQQ | ETF | 93.4375 | 93.4375 | 93.4375 | 93.4375 | 8200.0 |
| 2000-06-30 09:00:00 | IWM | ETF | 51.2188 | 51.2188 | 50.9688 | 50.9688 | 50400.0 |
| 2000-06-30 10:00:00 | IWM | ETF | 51.25 | 51.4062 | 51.25 | 51.4062 | 113800.0 |
| 2000-06-30 11:00:00 | IWM | ETF | 51.4219 | 51.4219 | 51.1875 | 51.1875 | 104600.0 |
| 2000-06-30 12:00:00 | IWM | ETF | 51.2812 | 51.3125 | 51.1875 | 51.2969 | 106400.0 |
| 2000-06-30 13:00:00 | IWM | ETF | 51.2969 | 51.2969 | 51.2188 | 51.2812 | 101400.0 |
| 2000-06-30 14:00:00 | IWM | ETF | 51.2344 | 51.2344 | 50.9375 | 50.9688 | 152600.0 |
| 2000-06-30 15:00:00 | IWM | ETF | 51.2188 | 51.6719 | 50.7969 | 51.625 | 378800.0 |
| 2000-06-30 16:00:00 | IWM | ETF | 51.6094 | 51.6719 | 51.6094 | 51.6719 | 163800.0 |
| 2000-06-30 09:00:00 | DIA | ETF | 103.5312 | 103.9062 | 103.5 | 103.6875 | 143800.0 |
| 2000-06-30 10:00:00 | DIA | ETF | 103.5 | 103.8125 | 103.3438 | 103.7188 | 106700.0 |
| 2000-06-30 11:00:00 | DIA | ETF | 103.75 | 104.1875 | 103.7188 | 103.8125 | 46800.0 |
| 2000-06-30 12:00:00 | DIA | ETF | 103.9062 | 104.25 | 103.6562 | 104.1875 | 43400.0 |
| 2000-06-30 13:00:00 | DIA | ETF | 104.25 | 104.375 | 103.9062 | 104.0625 | 15900.0 |
| 2000-06-30 14:00:00 | DIA | ETF | 103.875 | 104.125 | 103.4375 | 103.9688 | 73900.0 |
| 2000-06-30 15:00:00 | DIA | ETF | 103.875 | 104.5 | 103.5 | 104.4688 | 181500.0 |
| 2000-06-30 16:00:00 | DIA | ETF | 104.2812 | 104.5 | 104.2812 | 104.375 | 42700.0 |
> showing 33 of 152 rows — these rows as CSV