PREVIEW / etf_1hour / 2000-12-08
file: by_date/etf_1hour/2000/2000-12-08.parquet size: 10 KB rows: 203
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-08 09:00:00 | SPY | ETF | 137.0625 | 137.0625 | 136.25 | 136.9375 | 1274200.0 |
| 2000-12-08 10:00:00 | SPY | ETF | 136.9688 | 137.4062 | 136.5 | 136.7188 | 1332100.0 |
| 2000-12-08 11:00:00 | SPY | ETF | 136.7188 | 137.0 | 136.0938 | 136.75 | 638300.0 |
| 2000-12-08 12:00:00 | SPY | ETF | 136.875 | 137.8125 | 136.6562 | 137.5625 | 1208800.0 |
| 2000-12-08 13:00:00 | SPY | ETF | 137.5625 | 137.9375 | 137.2188 | 137.9375 | 638100.0 |
| 2000-12-08 14:00:00 | SPY | ETF | 138.0 | 139.125 | 137.0312 | 137.2188 | 1675200.0 |
| 2000-12-08 15:00:00 | SPY | ETF | 137.2188 | 137.9688 | 136.875 | 137.6562 | 1081400.0 |
| 2000-12-08 16:00:00 | SPY | ETF | 137.75 | 137.9062 | 133.5 | 133.8125 | 1964900.0 |
| 2000-12-08 17:00:00 | SPY | ETF | 134.0 | 134.3125 | 134.0 | 134.25 | 144900.0 |
| 2000-12-08 18:00:00 | SPY | ETF | 134.25 | 134.25 | 134.25 | 134.25 | 200.0 |
| 2000-12-08 09:00:00 | QQQ | ETF | 71.0938 | 71.5 | 69.6875 | 71.4375 | 9933800.0 |
| 2000-12-08 10:00:00 | QQQ | ETF | 71.375 | 72.0312 | 70.6875 | 71.0 | 10516300.0 |
| 2000-12-08 11:00:00 | QQQ | ETF | 70.9375 | 71.1875 | 70.2188 | 70.7188 | 6189000.0 |
| 2000-12-08 12:00:00 | QQQ | ETF | 70.6875 | 71.8125 | 70.625 | 71.4688 | 3895400.0 |
| 2000-12-08 13:00:00 | QQQ | ETF | 71.5 | 71.9375 | 71.125 | 71.875 | 3256000.0 |
| 2000-12-08 14:00:00 | QQQ | ETF | 72.0 | 73.5 | 71.0 | 71.125 | 12840300.0 |
| 2000-12-08 15:00:00 | QQQ | ETF | 71.125 | 72.1875 | 70.375 | 71.875 | 8765200.0 |
| 2000-12-08 16:00:00 | QQQ | ETF | 72.0625 | 72.25 | 67.625 | 68.4375 | 6600000.0 |
| 2000-12-08 17:00:00 | QQQ | ETF | 68.5 | 69.0 | 68.0 | 69.0 | 246100.0 |
| 2000-12-08 18:00:00 | QQQ | ETF | 69.0 | 69.3125 | 68.875 | 69.125 | 35000.0 |
| 2000-12-08 09:00:00 | IWM | ETF | 46.9688 | 47.1875 | 46.9688 | 47.1875 | 123000.0 |
| 2000-12-08 10:00:00 | IWM | ETF | 47.3125 | 47.4375 | 47.2188 | 47.25 | 26000.0 |
| 2000-12-08 11:00:00 | IWM | ETF | 47.375 | 47.375 | 47.25 | 47.25 | 74800.0 |
| 2000-12-08 12:00:00 | IWM | ETF | 47.2188 | 47.4062 | 47.2188 | 47.4062 | 6800.0 |
| 2000-12-08 13:00:00 | IWM | ETF | 47.4062 | 47.4062 | 47.375 | 47.375 | 1400.0 |
| 2000-12-08 14:00:00 | IWM | ETF | 47.5 | 47.75 | 47.25 | 47.3594 | 31400.0 |
| 2000-12-08 15:00:00 | IWM | ETF | 47.2969 | 47.7812 | 47.25 | 47.7812 | 23600.0 |
| 2000-12-08 16:00:00 | IWM | ETF | 47.875 | 47.875 | 46.6562 | 46.6562 | 80400.0 |
| 2000-12-08 09:00:00 | DIA | ETF | 107.6562 | 107.6562 | 106.875 | 107.1562 | 739500.0 |
| 2000-12-08 10:00:00 | DIA | ETF | 107.1562 | 107.5312 | 106.875 | 106.9375 | 106600.0 |
| 2000-12-08 11:00:00 | DIA | ETF | 107.0938 | 107.375 | 106.6875 | 107.125 | 45100.0 |
| 2000-12-08 12:00:00 | DIA | ETF | 107.3125 | 107.9375 | 107.1562 | 107.625 | 85100.0 |
| 2000-12-08 13:00:00 | DIA | ETF | 107.6875 | 107.875 | 107.25 | 107.875 | 36000.0 |
| 2000-12-08 14:00:00 | DIA | ETF | 107.8438 | 108.4688 | 107.125 | 107.3125 | 298300.0 |
| 2000-12-08 15:00:00 | DIA | ETF | 107.2812 | 107.875 | 106.9688 | 107.4688 | 137500.0 |
| 2000-12-08 16:00:00 | DIA | ETF | 107.4375 | 107.5 | 104.125 | 104.125 | 199500.0 |
> showing 36 of 203 rows — these rows as CSV