PREVIEW / etf_1hour / 2000-12-11
file: by_date/etf_1hour/2000/2000-12-11.parquet size: 10 KB rows: 190
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-11 09:00:00 | SPY | ETF | 137.375 | 137.8438 | 136.7188 | 137.5 | 1260200.0 |
| 2000-12-11 10:00:00 | SPY | ETF | 137.375 | 138.75 | 137.2188 | 138.625 | 979600.0 |
| 2000-12-11 11:00:00 | SPY | ETF | 138.5 | 139.25 | 138.5 | 139.0 | 699800.0 |
| 2000-12-11 12:00:00 | SPY | ETF | 138.9688 | 139.0 | 138.5312 | 138.6875 | 638100.0 |
| 2000-12-11 13:00:00 | SPY | ETF | 138.7812 | 138.7812 | 138.2188 | 138.375 | 386800.0 |
| 2000-12-11 14:00:00 | SPY | ETF | 138.25 | 139.3438 | 138.25 | 139.2188 | 933100.0 |
| 2000-12-11 15:00:00 | SPY | ETF | 139.125 | 139.5625 | 138.5312 | 138.625 | 816300.0 |
| 2000-12-11 16:00:00 | SPY | ETF | 138.4375 | 138.875 | 138.25 | 138.875 | 468100.0 |
| 2000-12-11 09:00:00 | QQQ | ETF | 72.0312 | 72.8125 | 70.9375 | 72.5 | 10146600.0 |
| 2000-12-11 10:00:00 | QQQ | ETF | 72.5 | 73.6875 | 71.875 | 73.1875 | 8360000.0 |
| 2000-12-11 11:00:00 | QQQ | ETF | 73.25 | 74.5 | 73.1875 | 74.0 | 7711300.0 |
| 2000-12-11 12:00:00 | QQQ | ETF | 74.0 | 74.1875 | 73.3438 | 74.125 | 4601800.0 |
| 2000-12-11 13:00:00 | QQQ | ETF | 74.0938 | 74.1875 | 73.0 | 73.0312 | 4161900.0 |
| 2000-12-11 14:00:00 | QQQ | ETF | 73.0 | 74.5 | 72.8438 | 74.375 | 5871400.0 |
| 2000-12-11 15:00:00 | QQQ | ETF | 74.375 | 74.75 | 73.75 | 74.125 | 7440400.0 |
| 2000-12-11 16:00:00 | QQQ | ETF | 74.125 | 74.5 | 73.875 | 74.125 | 879800.0 |
| 2000-12-11 17:00:00 | QQQ | ETF | 74.125 | 74.375 | 74.0 | 74.0625 | 105200.0 |
| 2000-12-11 18:00:00 | QQQ | ETF | 74.25 | 74.5 | 74.0 | 74.0 | 10600.0 |
| 2000-12-11 09:00:00 | IWM | ETF | 47.9688 | 48.0938 | 47.7812 | 48.0938 | 16200.0 |
| 2000-12-11 10:00:00 | IWM | ETF | 48.0781 | 48.3438 | 48.0781 | 48.3438 | 65800.0 |
| 2000-12-11 11:00:00 | IWM | ETF | 48.3906 | 48.5938 | 48.3906 | 48.5938 | 14200.0 |
| 2000-12-11 12:00:00 | IWM | ETF | 48.5312 | 48.5312 | 48.25 | 48.4688 | 42600.0 |
| 2000-12-11 13:00:00 | IWM | ETF | 48.4688 | 48.4688 | 48.2812 | 48.4062 | 8600.0 |
| 2000-12-11 14:00:00 | IWM | ETF | 48.4062 | 48.6562 | 48.2188 | 48.6562 | 46000.0 |
| 2000-12-11 15:00:00 | IWM | ETF | 48.6562 | 48.7188 | 48.5 | 48.5938 | 18600.0 |
| 2000-12-11 16:00:00 | IWM | ETF | 48.7812 | 48.7812 | 48.6406 | 48.7812 | 21200.0 |
| 2000-12-11 09:00:00 | DIA | ETF | 106.625 | 107.375 | 106.625 | 106.875 | 255500.0 |
| 2000-12-11 10:00:00 | DIA | ETF | 107.0 | 107.875 | 106.8125 | 107.75 | 231800.0 |
| 2000-12-11 11:00:00 | DIA | ETF | 107.7812 | 108.0625 | 107.6875 | 107.9375 | 245300.0 |
| 2000-12-11 12:00:00 | DIA | ETF | 107.875 | 107.875 | 107.375 | 107.5 | 70700.0 |
| 2000-12-11 13:00:00 | DIA | ETF | 107.4688 | 107.6875 | 107.3125 | 107.4375 | 36000.0 |
| 2000-12-11 14:00:00 | DIA | ETF | 107.375 | 108.125 | 107.375 | 108.0 | 49600.0 |
| 2000-12-11 15:00:00 | DIA | ETF | 108.0 | 108.1875 | 107.3125 | 107.375 | 94200.0 |
| 2000-12-11 16:00:00 | DIA | ETF | 107.375 | 107.5938 | 107.25 | 107.5938 | 23200.0 |
> showing 34 of 190 rows — these rows as CSV