PREVIEW / etf_1hour / 2000-10-10
file: by_date/etf_1hour/2000/2000-10-10.parquet size: 10 KB rows: 179
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-10-10 09:00:00 | SPY | ETF | 140.0938 | 141.1562 | 140.0938 | 141.1562 | 1205700.0 |
| 2000-10-10 10:00:00 | SPY | ETF | 141.0625 | 141.25 | 140.0312 | 140.125 | 707100.0 |
| 2000-10-10 11:00:00 | SPY | ETF | 140.0312 | 141.0 | 139.75 | 139.75 | 766100.0 |
| 2000-10-10 12:00:00 | SPY | ETF | 139.6562 | 140.0 | 139.0 | 139.25 | 1130600.0 |
| 2000-10-10 13:00:00 | SPY | ETF | 139.2812 | 140.2812 | 139.2812 | 140.0 | 356200.0 |
| 2000-10-10 14:00:00 | SPY | ETF | 140.0625 | 140.2188 | 138.6875 | 139.0625 | 629100.0 |
| 2000-10-10 15:00:00 | SPY | ETF | 139.1562 | 139.6562 | 138.5625 | 138.875 | 893000.0 |
| 2000-10-10 16:00:00 | SPY | ETF | 138.8125 | 138.9375 | 137.6875 | 137.6875 | 387000.0 |
| 2000-10-10 17:00:00 | SPY | ETF | 138.0 | 138.0 | 138.0 | 138.0 | 200.0 |
| 2000-10-10 09:00:00 | QQQ | ETF | 81.8125 | 83.25 | 81.375 | 83.25 | 4689000.0 |
| 2000-10-10 10:00:00 | QQQ | ETF | 83.25 | 83.3125 | 81.125 | 81.375 | 5678600.0 |
| 2000-10-10 11:00:00 | QQQ | ETF | 81.25 | 82.0 | 80.3125 | 80.375 | 3900000.0 |
| 2000-10-10 12:00:00 | QQQ | ETF | 80.25 | 81.0 | 80.0 | 80.4375 | 3791100.0 |
| 2000-10-10 13:00:00 | QQQ | ETF | 80.375 | 81.4375 | 80.375 | 81.0312 | 3248600.0 |
| 2000-10-10 14:00:00 | QQQ | ETF | 81.0 | 81.125 | 79.625 | 79.8125 | 4564100.0 |
| 2000-10-10 15:00:00 | QQQ | ETF | 79.9375 | 80.75 | 79.125 | 79.5 | 6548000.0 |
| 2000-10-10 16:00:00 | QQQ | ETF | 79.5 | 80.75 | 77.625 | 78.5625 | 2447900.0 |
| 2000-10-10 17:00:00 | QQQ | ETF | 78.5625 | 78.75 | 77.75 | 77.75 | 188100.0 |
| 2000-10-10 18:00:00 | QQQ | ETF | 77.8125 | 78.6875 | 77.375 | 77.6875 | 48000.0 |
| 2000-10-10 09:00:00 | IWM | ETF | 48.7969 | 48.9688 | 48.6562 | 48.875 | 88400.0 |
| 2000-10-10 10:00:00 | IWM | ETF | 49.0 | 49.0469 | 48.75 | 48.75 | 26400.0 |
| 2000-10-10 11:00:00 | IWM | ETF | 48.7656 | 48.7656 | 48.75 | 48.75 | 4800.0 |
| 2000-10-10 12:00:00 | IWM | ETF | 48.5312 | 48.6406 | 48.375 | 48.375 | 5800.0 |
| 2000-10-10 13:00:00 | IWM | ETF | 48.4375 | 48.5312 | 48.4375 | 48.5312 | 5200.0 |
| 2000-10-10 14:00:00 | IWM | ETF | 48.2969 | 48.2969 | 48.1094 | 48.1094 | 1600.0 |
| 2000-10-10 15:00:00 | IWM | ETF | 48.1406 | 48.2656 | 47.9688 | 48.125 | 287600.0 |
| 2000-10-10 16:00:00 | IWM | ETF | 47.875 | 47.875 | 47.5625 | 47.5625 | 600.0 |
| 2000-10-10 09:00:00 | DIA | ETF | 106.0 | 106.25 | 105.7188 | 106.0312 | 53200.0 |
| 2000-10-10 10:00:00 | DIA | ETF | 106.125 | 106.2188 | 105.7812 | 105.9375 | 56100.0 |
| 2000-10-10 11:00:00 | DIA | ETF | 106.0 | 106.375 | 105.8125 | 105.9062 | 39000.0 |
| 2000-10-10 12:00:00 | DIA | ETF | 105.9375 | 105.9375 | 105.0938 | 105.2812 | 90600.0 |
| 2000-10-10 13:00:00 | DIA | ETF | 105.3125 | 105.9062 | 105.3125 | 105.9062 | 20700.0 |
| 2000-10-10 14:00:00 | DIA | ETF | 105.875 | 105.875 | 104.9375 | 105.375 | 125200.0 |
| 2000-10-10 15:00:00 | DIA | ETF | 105.375 | 105.7812 | 104.9375 | 105.4375 | 111900.0 |
| 2000-10-10 16:00:00 | DIA | ETF | 105.5 | 105.5 | 104.875 | 104.9062 | 68100.0 |
> showing 35 of 179 rows — these rows as CSV