PREVIEW / etf_1hour / 2000-12-28
file: by_date/etf_1hour/2000/2000-12-28.parquet size: 10 KB rows: 213
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-12-28 09:00:00 | SPY | ETF | 132.8125 | 133.7188 | 132.75 | 133.3125 | 1302100.0 |
| 2000-12-28 10:00:00 | SPY | ETF | 133.3438 | 133.6875 | 133.0312 | 133.5312 | 994600.0 |
| 2000-12-28 11:00:00 | SPY | ETF | 133.5312 | 133.7188 | 132.9062 | 133.0938 | 961300.0 |
| 2000-12-28 12:00:00 | SPY | ETF | 132.9688 | 133.2812 | 132.5938 | 133.2188 | 559800.0 |
| 2000-12-28 13:00:00 | SPY | ETF | 133.2188 | 133.4375 | 132.9062 | 133.1875 | 687400.0 |
| 2000-12-28 14:00:00 | SPY | ETF | 133.2188 | 133.6562 | 133.125 | 133.5938 | 915900.0 |
| 2000-12-28 15:00:00 | SPY | ETF | 133.625 | 133.8125 | 133.0938 | 133.5938 | 1594300.0 |
| 2000-12-28 16:00:00 | SPY | ETF | 133.5938 | 133.875 | 133.4062 | 133.7188 | 521400.0 |
| 2000-12-28 09:00:00 | QQQ | ETF | 60.7812 | 62.4688 | 60.625 | 61.9375 | 5996300.0 |
| 2000-12-28 10:00:00 | QQQ | ETF | 61.875 | 62.3125 | 61.4688 | 61.8125 | 3960600.0 |
| 2000-12-28 11:00:00 | QQQ | ETF | 61.8438 | 61.875 | 60.5 | 60.875 | 4317800.0 |
| 2000-12-28 12:00:00 | QQQ | ETF | 60.875 | 61.0312 | 60.5 | 61.0 | 3220200.0 |
| 2000-12-28 13:00:00 | QQQ | ETF | 61.0 | 61.125 | 60.25 | 60.375 | 3108300.0 |
| 2000-12-28 14:00:00 | QQQ | ETF | 60.4375 | 61.5 | 60.3438 | 61.4688 | 3362900.0 |
| 2000-12-28 15:00:00 | QQQ | ETF | 61.5 | 61.7812 | 60.9375 | 61.2812 | 5912400.0 |
| 2000-12-28 16:00:00 | QQQ | ETF | 61.3438 | 61.625 | 61.125 | 61.375 | 974100.0 |
| 2000-12-28 17:00:00 | QQQ | ETF | 61.375 | 61.5 | 61.25 | 61.5 | 17300.0 |
| 2000-12-28 18:00:00 | QQQ | ETF | 61.4375 | 61.625 | 61.4375 | 61.625 | 3600.0 |
| 2000-12-28 09:00:00 | IWM | ETF | 47.7188 | 48.1875 | 47.7188 | 47.8594 | 88400.0 |
| 2000-12-28 10:00:00 | IWM | ETF | 47.875 | 48.4375 | 47.875 | 48.4375 | 301000.0 |
| 2000-12-28 11:00:00 | IWM | ETF | 48.3438 | 48.6875 | 48.3438 | 48.6875 | 46800.0 |
| 2000-12-28 12:00:00 | IWM | ETF | 48.4375 | 48.625 | 48.4375 | 48.625 | 60200.0 |
| 2000-12-28 13:00:00 | IWM | ETF | 48.75 | 48.8125 | 48.625 | 48.7812 | 237200.0 |
| 2000-12-28 14:00:00 | IWM | ETF | 48.7656 | 49.125 | 48.7656 | 49.125 | 188800.0 |
| 2000-12-28 15:00:00 | IWM | ETF | 49.1562 | 49.3594 | 48.8438 | 49.1875 | 220200.0 |
| 2000-12-28 16:00:00 | IWM | ETF | 49.1875 | 49.375 | 49.1875 | 49.2812 | 40600.0 |
| 2000-12-28 09:00:00 | DIA | ETF | 107.9375 | 108.25 | 107.7188 | 107.9375 | 109500.0 |
| 2000-12-28 10:00:00 | DIA | ETF | 107.7812 | 108.3438 | 107.7188 | 108.25 | 439500.0 |
| 2000-12-28 11:00:00 | DIA | ETF | 108.125 | 108.4375 | 108.0 | 108.125 | 230200.0 |
| 2000-12-28 12:00:00 | DIA | ETF | 108.25 | 108.4062 | 108.0 | 108.4062 | 57600.0 |
| 2000-12-28 13:00:00 | DIA | ETF | 108.3125 | 108.7188 | 108.2812 | 108.6562 | 40700.0 |
| 2000-12-28 14:00:00 | DIA | ETF | 108.5312 | 108.9688 | 108.5 | 108.75 | 67600.0 |
| 2000-12-28 15:00:00 | DIA | ETF | 108.875 | 109.0 | 108.5 | 108.75 | 137900.0 |
| 2000-12-28 16:00:00 | DIA | ETF | 108.625 | 108.875 | 108.625 | 108.875 | 18000.0 |
> showing 34 of 213 rows — these rows as CSV