PREVIEW / etf_1hour / 2000-08-28
file: by_date/etf_1hour/2000/2000-08-28.parquet size: 9 KB rows: 174
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-08-28 09:00:00 | SPY | ETF | 151.25 | 151.625 | 151.25 | 151.4062 | 731100.0 |
| 2000-08-28 10:00:00 | SPY | ETF | 151.5312 | 152.5 | 151.4062 | 152.4688 | 1781700.0 |
| 2000-08-28 11:00:00 | SPY | ETF | 152.4375 | 152.875 | 152.2188 | 152.75 | 810500.0 |
| 2000-08-28 12:00:00 | SPY | ETF | 152.75 | 152.9062 | 152.5938 | 152.8125 | 191500.0 |
| 2000-08-28 13:00:00 | SPY | ETF | 152.8125 | 152.8125 | 152.375 | 152.625 | 188900.0 |
| 2000-08-28 14:00:00 | SPY | ETF | 152.5312 | 152.8125 | 152.3125 | 152.375 | 556300.0 |
| 2000-08-28 15:00:00 | SPY | ETF | 152.4688 | 152.4688 | 151.7812 | 151.7812 | 763000.0 |
| 2000-08-28 16:00:00 | SPY | ETF | 151.8125 | 152.1562 | 151.75 | 151.75 | 440900.0 |
| 2000-08-28 09:00:00 | QQQ | ETF | 98.25 | 98.5938 | 97.9375 | 98.0625 | 1341100.0 |
| 2000-08-28 10:00:00 | QQQ | ETF | 98.0312 | 99.5 | 98.0312 | 99.3125 | 3305700.0 |
| 2000-08-28 11:00:00 | QQQ | ETF | 99.3125 | 99.5625 | 99.125 | 99.375 | 1554800.0 |
| 2000-08-28 12:00:00 | QQQ | ETF | 99.3125 | 99.5 | 99.125 | 99.1875 | 1073700.0 |
| 2000-08-28 13:00:00 | QQQ | ETF | 99.1875 | 99.3125 | 98.8125 | 99.1875 | 1290400.0 |
| 2000-08-28 14:00:00 | QQQ | ETF | 99.1875 | 99.3438 | 98.75 | 99.0 | 995200.0 |
| 2000-08-28 15:00:00 | QQQ | ETF | 98.9375 | 99.2188 | 98.375 | 98.6875 | 2284800.0 |
| 2000-08-28 16:00:00 | QQQ | ETF | 98.7188 | 98.7188 | 98.3125 | 98.3125 | 312600.0 |
| 2000-08-28 17:00:00 | QQQ | ETF | 98.5 | 98.5 | 98.3125 | 98.3125 | 600.0 |
| 2000-08-28 18:00:00 | QQQ | ETF | 98.5 | 98.5 | 98.5 | 98.5 | 300.0 |
| 2000-08-28 09:00:00 | IWM | ETF | 52.8125 | 52.8438 | 52.8125 | 52.8281 | 34600.0 |
| 2000-08-28 10:00:00 | IWM | ETF | 52.9062 | 53.125 | 52.9062 | 53.0312 | 2600.0 |
| 2000-08-28 11:00:00 | IWM | ETF | 52.875 | 52.9062 | 52.875 | 52.875 | 600.0 |
| 2000-08-28 12:00:00 | IWM | ETF | 53.0 | 53.0 | 53.0 | 53.0 | 200.0 |
| 2000-08-28 13:00:00 | IWM | ETF | 52.9688 | 52.9688 | 52.6875 | 52.6875 | 11200.0 |
| 2000-08-28 14:00:00 | IWM | ETF | 52.7969 | 52.8281 | 52.6719 | 52.6719 | 1400.0 |
| 2000-08-28 15:00:00 | IWM | ETF | 52.7969 | 52.8125 | 52.6094 | 52.7969 | 41200.0 |
| 2000-08-28 16:00:00 | IWM | ETF | 52.6562 | 52.6562 | 52.5625 | 52.5625 | 50200.0 |
| 2000-08-28 09:00:00 | DIA | ETF | 112.2188 | 112.4375 | 112.0625 | 112.375 | 139000.0 |
| 2000-08-28 10:00:00 | DIA | ETF | 112.3438 | 113.1875 | 112.3125 | 112.875 | 136700.0 |
| 2000-08-28 11:00:00 | DIA | ETF | 112.875 | 113.2188 | 112.875 | 113.1562 | 58000.0 |
| 2000-08-28 12:00:00 | DIA | ETF | 113.0938 | 113.3125 | 113.0312 | 113.125 | 87300.0 |
| 2000-08-28 13:00:00 | DIA | ETF | 113.125 | 113.2188 | 112.9062 | 113.0 | 16300.0 |
| 2000-08-28 14:00:00 | DIA | ETF | 113.1875 | 113.2188 | 112.75 | 112.9688 | 51900.0 |
| 2000-08-28 15:00:00 | DIA | ETF | 112.8125 | 113.0938 | 112.625 | 112.7812 | 38000.0 |
| 2000-08-28 16:00:00 | DIA | ETF | 112.6562 | 112.6875 | 112.5625 | 112.6875 | 4500.0 |
> showing 34 of 174 rows — these rows as CSV