PREVIEW / etf_1hour / 2000-10-17
file: by_date/etf_1hour/2000/2000-10-17.parquet size: 10 KB rows: 184
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-17 09:00:00 | SPY | ETF | 138.4375 | 138.5625 | 137.625 | 137.625 | 913400.0 |
| 2000-10-17 10:00:00 | SPY | ETF | 137.6875 | 137.6875 | 136.5 | 136.625 | 1091100.0 |
| 2000-10-17 11:00:00 | SPY | ETF | 136.7188 | 136.8438 | 135.7812 | 135.9375 | 839600.0 |
| 2000-10-17 12:00:00 | SPY | ETF | 135.9375 | 136.125 | 135.625 | 135.75 | 296800.0 |
| 2000-10-17 13:00:00 | SPY | ETF | 135.7812 | 136.1875 | 134.9375 | 134.9375 | 839100.0 |
| 2000-10-17 14:00:00 | SPY | ETF | 134.9375 | 135.2812 | 134.4062 | 134.625 | 978600.0 |
| 2000-10-17 15:00:00 | SPY | ETF | 134.5625 | 135.5625 | 134.4375 | 135.4688 | 2135500.0 |
| 2000-10-17 16:00:00 | SPY | ETF | 135.375 | 135.4375 | 134.5 | 134.5 | 528300.0 |
| 2000-10-17 17:00:00 | SPY | ETF | 134.4375 | 135.0 | 134.3125 | 134.75 | 8500.0 |
| 2000-10-17 09:00:00 | QQQ | ETF | 83.125 | 83.1562 | 81.5625 | 81.875 | 13410600.0 |
| 2000-10-17 10:00:00 | QQQ | ETF | 81.8438 | 81.9375 | 79.9688 | 80.4688 | 8490200.0 |
| 2000-10-17 11:00:00 | QQQ | ETF | 80.4688 | 80.7188 | 79.0312 | 79.25 | 6161300.0 |
| 2000-10-17 12:00:00 | QQQ | ETF | 79.0312 | 79.6875 | 78.75 | 79.2812 | 4089400.0 |
| 2000-10-17 13:00:00 | QQQ | ETF | 79.25 | 80.0 | 78.375 | 78.4688 | 3852700.0 |
| 2000-10-17 14:00:00 | QQQ | ETF | 78.4688 | 78.875 | 78.0 | 78.5 | 5265900.0 |
| 2000-10-17 15:00:00 | QQQ | ETF | 78.5625 | 79.5 | 78.25 | 79.3125 | 6932100.0 |
| 2000-10-17 16:00:00 | QQQ | ETF | 79.3125 | 79.5938 | 78.1562 | 79.0 | 2031600.0 |
| 2000-10-17 17:00:00 | QQQ | ETF | 79.0 | 79.0 | 78.25 | 78.4375 | 105800.0 |
| 2000-10-17 18:00:00 | QQQ | ETF | 78.375 | 79.25 | 77.8125 | 79.25 | 45900.0 |
| 2000-10-17 09:00:00 | IWM | ETF | 48.125 | 48.25 | 48.0625 | 48.0625 | 9400.0 |
| 2000-10-17 10:00:00 | IWM | ETF | 48.0625 | 48.0625 | 47.6875 | 47.7812 | 14200.0 |
| 2000-10-17 11:00:00 | IWM | ETF | 47.4688 | 47.5938 | 47.1562 | 47.1562 | 22400.0 |
| 2000-10-17 12:00:00 | IWM | ETF | 47.0938 | 47.0938 | 47.0 | 47.0625 | 78000.0 |
| 2000-10-17 13:00:00 | IWM | ETF | 47.1562 | 47.1562 | 46.8125 | 46.8125 | 29400.0 |
| 2000-10-17 14:00:00 | IWM | ETF | 46.75 | 46.9219 | 46.5625 | 46.9062 | 57400.0 |
| 2000-10-17 15:00:00 | IWM | ETF | 46.75 | 47.25 | 46.75 | 46.9688 | 51600.0 |
| 2000-10-17 16:00:00 | IWM | ETF | 47.0312 | 47.0312 | 46.9062 | 46.9062 | 400.0 |
| 2000-10-17 09:00:00 | DIA | ETF | 102.9688 | 103.1562 | 102.625 | 102.6875 | 57800.0 |
| 2000-10-17 10:00:00 | DIA | ETF | 102.625 | 102.625 | 101.5312 | 101.75 | 132600.0 |
| 2000-10-17 11:00:00 | DIA | ETF | 101.8438 | 101.8438 | 101.25 | 101.5312 | 84800.0 |
| 2000-10-17 12:00:00 | DIA | ETF | 101.4375 | 101.4375 | 101.0 | 101.125 | 47800.0 |
| 2000-10-17 13:00:00 | DIA | ETF | 101.375 | 101.375 | 100.625 | 100.6562 | 48700.0 |
| 2000-10-17 14:00:00 | DIA | ETF | 100.5 | 101.125 | 100.375 | 100.8125 | 239700.0 |
| 2000-10-17 15:00:00 | DIA | ETF | 100.6875 | 101.3125 | 100.5625 | 101.0625 | 234700.0 |
| 2000-10-17 16:00:00 | DIA | ETF | 101.0312 | 101.0312 | 100.5938 | 100.5938 | 45000.0 |
| 2000-10-17 18:00:00 | DIA | ETF | 100.5 | 100.5 | 100.5 | 100.5 | 100.0 |
> showing 36 of 184 rows — these rows as CSV