PREVIEW / etf_1hour / 2000-07-28
file: by_date/etf_1hour/2000/2000-07-28.parquet size: 9 KB rows: 173
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-07-28 09:00:00 | SPY | ETF | 145.7188 | 145.9062 | 145.0938 | 145.3125 | 463000.0 |
| 2000-07-28 10:00:00 | SPY | ETF | 145.375 | 145.4688 | 142.5 | 142.5 | 946100.0 |
| 2000-07-28 11:00:00 | SPY | ETF | 142.5 | 143.5625 | 142.125 | 143.125 | 947000.0 |
| 2000-07-28 12:00:00 | SPY | ETF | 143.125 | 143.25 | 142.8125 | 143.0625 | 222200.0 |
| 2000-07-28 13:00:00 | SPY | ETF | 143.0625 | 143.4062 | 142.8125 | 143.1875 | 559200.0 |
| 2000-07-28 14:00:00 | SPY | ETF | 143.125 | 143.25 | 142.0938 | 142.625 | 864600.0 |
| 2000-07-28 15:00:00 | SPY | ETF | 142.625 | 143.0312 | 141.5 | 142.25 | 1483000.0 |
| 2000-07-28 16:00:00 | SPY | ETF | 142.125 | 142.9375 | 142.0625 | 142.0938 | 677500.0 |
| 2000-07-28 09:00:00 | QQQ | ETF | 92.1875 | 92.875 | 91.6875 | 91.9375 | 2687500.0 |
| 2000-07-28 10:00:00 | QQQ | ETF | 91.75 | 91.8438 | 87.125 | 87.375 | 9408400.0 |
| 2000-07-28 11:00:00 | QQQ | ETF | 87.3438 | 89.0 | 87.0312 | 88.375 | 6603800.0 |
| 2000-07-28 12:00:00 | QQQ | ETF | 88.5938 | 88.7188 | 88.0 | 88.3438 | 1874900.0 |
| 2000-07-28 13:00:00 | QQQ | ETF | 88.3125 | 89.2188 | 88.0 | 88.875 | 2865000.0 |
| 2000-07-28 14:00:00 | QQQ | ETF | 88.9375 | 88.9688 | 87.1875 | 87.8125 | 4746700.0 |
| 2000-07-28 15:00:00 | QQQ | ETF | 87.9062 | 88.375 | 86.0 | 86.875 | 7480500.0 |
| 2000-07-28 16:00:00 | QQQ | ETF | 86.75 | 87.125 | 86.625 | 87.125 | 565800.0 |
| 2000-07-28 17:00:00 | QQQ | ETF | 87.25 | 87.25 | 86.5 | 86.7812 | 6600.0 |
| 2000-07-28 18:00:00 | QQQ | ETF | 86.5 | 87.0 | 86.5 | 86.875 | 2300.0 |
| 2000-07-28 09:00:00 | IWM | ETF | 50.1562 | 50.1562 | 50.0469 | 50.0938 | 2000.0 |
| 2000-07-28 10:00:00 | IWM | ETF | 49.875 | 49.875 | 48.9375 | 48.9375 | 32200.0 |
| 2000-07-28 11:00:00 | IWM | ETF | 48.875 | 49.1562 | 48.875 | 49.0312 | 29600.0 |
| 2000-07-28 12:00:00 | IWM | ETF | 49.1719 | 49.2812 | 49.0781 | 49.2812 | 2000.0 |
| 2000-07-28 13:00:00 | IWM | ETF | 49.2812 | 49.2812 | 49.2812 | 49.2812 | 2800.0 |
| 2000-07-28 14:00:00 | IWM | ETF | 49.0312 | 49.0469 | 49.0312 | 49.0469 | 400.0 |
| 2000-07-28 15:00:00 | IWM | ETF | 49.1562 | 49.1562 | 48.9375 | 48.9375 | 102400.0 |
| 2000-07-28 16:00:00 | IWM | ETF | 49.0 | 49.0 | 49.0 | 49.0 | 200.0 |
| 2000-07-28 09:00:00 | DIA | ETF | 106.25 | 106.5 | 106.0 | 106.125 | 83700.0 |
| 2000-07-28 10:00:00 | DIA | ETF | 106.125 | 106.3438 | 104.875 | 104.875 | 75700.0 |
| 2000-07-28 11:00:00 | DIA | ETF | 104.875 | 105.2188 | 104.5312 | 105.125 | 125400.0 |
| 2000-07-28 12:00:00 | DIA | ETF | 105.1562 | 105.4375 | 104.875 | 105.1875 | 60400.0 |
| 2000-07-28 13:00:00 | DIA | ETF | 105.0 | 105.4062 | 105.0 | 105.1875 | 21900.0 |
| 2000-07-28 14:00:00 | DIA | ETF | 105.2812 | 105.2812 | 104.625 | 105.0 | 67800.0 |
| 2000-07-28 15:00:00 | DIA | ETF | 105.1875 | 105.3438 | 104.5625 | 104.9688 | 46800.0 |
| 2000-07-28 16:00:00 | DIA | ETF | 104.9688 | 105.125 | 104.9688 | 105.0 | 41400.0 |
> showing 34 of 173 rows — these rows as CSV