PREVIEW / etf_1hour / 2000-11-15
file: by_date/etf_1hour/2000/2000-11-15.parquet size: 10 KB rows: 182
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-11-15 09:00:00 | SPY | ETF | 139.0625 | 139.0625 | 138.3125 | 138.4375 | 617300.0 |
| 2000-11-15 10:00:00 | SPY | ETF | 138.375 | 139.4062 | 138.0938 | 139.2812 | 1007100.0 |
| 2000-11-15 11:00:00 | SPY | ETF | 139.3438 | 139.375 | 138.8438 | 139.3125 | 508500.0 |
| 2000-11-15 12:00:00 | SPY | ETF | 139.375 | 139.75 | 139.2812 | 139.375 | 558800.0 |
| 2000-11-15 13:00:00 | SPY | ETF | 139.4375 | 139.9375 | 139.375 | 139.5 | 718300.0 |
| 2000-11-15 14:00:00 | SPY | ETF | 139.5938 | 140.0938 | 137.75 | 138.2188 | 2569500.0 |
| 2000-11-15 15:00:00 | SPY | ETF | 138.25 | 139.25 | 138.0 | 139.1875 | 1522600.0 |
| 2000-11-15 16:00:00 | SPY | ETF | 139.125 | 139.625 | 137.9688 | 139.5 | 984900.0 |
| 2000-11-15 18:00:00 | SPY | ETF | 139.0 | 139.0 | 139.0 | 139.0 | 300.0 |
| 2000-11-15 09:00:00 | QQQ | ETF | 75.5625 | 76.25 | 75.375 | 75.4375 | 3554000.0 |
| 2000-11-15 10:00:00 | QQQ | ETF | 75.4062 | 76.9375 | 75.25 | 76.8438 | 5493800.0 |
| 2000-11-15 11:00:00 | QQQ | ETF | 76.8438 | 77.1875 | 76.4062 | 77.1875 | 3125000.0 |
| 2000-11-15 12:00:00 | QQQ | ETF | 77.1875 | 77.75 | 77.0 | 77.4375 | 3050300.0 |
| 2000-11-15 13:00:00 | QQQ | ETF | 77.4375 | 78.0625 | 77.0 | 77.4375 | 3591400.0 |
| 2000-11-15 14:00:00 | QQQ | ETF | 77.4375 | 77.875 | 75.25 | 75.625 | 10642600.0 |
| 2000-11-15 15:00:00 | QQQ | ETF | 75.625 | 76.875 | 74.7812 | 76.8125 | 5664500.0 |
| 2000-11-15 16:00:00 | QQQ | ETF | 76.8125 | 77.75 | 76.625 | 77.5 | 848700.0 |
| 2000-11-15 17:00:00 | QQQ | ETF | 77.4375 | 77.625 | 76.875 | 77.0 | 29300.0 |
| 2000-11-15 18:00:00 | QQQ | ETF | 77.0 | 77.1875 | 76.8125 | 77.0625 | 5900.0 |
| 2000-11-15 09:00:00 | IWM | ETF | 48.7188 | 48.75 | 48.5625 | 48.5625 | 26600.0 |
| 2000-11-15 10:00:00 | IWM | ETF | 48.6562 | 49.1094 | 48.6562 | 48.9375 | 198200.0 |
| 2000-11-15 11:00:00 | IWM | ETF | 49.125 | 49.1875 | 48.9688 | 49.1875 | 53600.0 |
| 2000-11-15 12:00:00 | IWM | ETF | 49.1719 | 49.2656 | 49.0781 | 49.25 | 7000.0 |
| 2000-11-15 13:00:00 | IWM | ETF | 49.4062 | 49.4062 | 49.4062 | 49.4062 | 800.0 |
| 2000-11-15 14:00:00 | IWM | ETF | 49.4375 | 49.4375 | 49.0938 | 49.0938 | 5800.0 |
| 2000-11-15 15:00:00 | IWM | ETF | 48.9062 | 49.3125 | 48.75 | 49.2188 | 33600.0 |
| 2000-11-15 16:00:00 | IWM | ETF | 49.3125 | 49.3125 | 49.0938 | 49.2812 | 95400.0 |
| 2000-11-15 09:00:00 | DIA | ETF | 106.875 | 107.1562 | 106.625 | 106.625 | 38500.0 |
| 2000-11-15 10:00:00 | DIA | ETF | 106.625 | 107.5625 | 106.625 | 107.4688 | 60700.0 |
| 2000-11-15 11:00:00 | DIA | ETF | 107.4688 | 107.875 | 107.25 | 107.875 | 71100.0 |
| 2000-11-15 12:00:00 | DIA | ETF | 107.875 | 108.0 | 107.5938 | 107.6875 | 34600.0 |
| 2000-11-15 13:00:00 | DIA | ETF | 107.8438 | 108.1562 | 107.8125 | 107.9375 | 90600.0 |
| 2000-11-15 14:00:00 | DIA | ETF | 107.75 | 108.25 | 106.5 | 106.8125 | 149700.0 |
| 2000-11-15 15:00:00 | DIA | ETF | 106.8438 | 107.2812 | 106.5 | 107.2188 | 52800.0 |
| 2000-11-15 16:00:00 | DIA | ETF | 107.2188 | 107.3125 | 107.1875 | 107.3125 | 17600.0 |
> showing 35 of 182 rows — these rows as CSV