PREVIEW / etf_1hour / 2000-11-20
file: by_date/etf_1hour/2000/2000-11-20.parquet size: 10 KB rows: 186
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-20 09:00:00 | SPY | ETF | 135.75 | 136.25 | 135.2812 | 135.9688 | 583300.0 |
| 2000-11-20 10:00:00 | SPY | ETF | 136.0 | 136.375 | 134.9062 | 135.0 | 1012200.0 |
| 2000-11-20 11:00:00 | SPY | ETF | 135.0938 | 135.25 | 134.5625 | 135.2188 | 541800.0 |
| 2000-11-20 12:00:00 | SPY | ETF | 135.2188 | 135.25 | 134.75 | 134.875 | 447300.0 |
| 2000-11-20 13:00:00 | SPY | ETF | 135.0938 | 135.2188 | 134.5 | 135.2188 | 493400.0 |
| 2000-11-20 14:00:00 | SPY | ETF | 135.2188 | 136.0312 | 135.0938 | 135.8438 | 579800.0 |
| 2000-11-20 15:00:00 | SPY | ETF | 135.8438 | 136.375 | 134.375 | 134.6875 | 1134300.0 |
| 2000-11-20 16:00:00 | SPY | ETF | 134.5938 | 134.7812 | 134.3125 | 134.6875 | 463900.0 |
| 2000-11-20 09:00:00 | QQQ | ETF | 70.9375 | 71.5 | 70.375 | 71.125 | 6865900.0 |
| 2000-11-20 10:00:00 | QQQ | ETF | 71.125 | 71.5 | 69.75 | 69.7812 | 8819800.0 |
| 2000-11-20 11:00:00 | QQQ | ETF | 69.8125 | 70.6875 | 69.375 | 70.5938 | 7241500.0 |
| 2000-11-20 12:00:00 | QQQ | ETF | 70.5938 | 70.625 | 69.8125 | 70.0 | 3054800.0 |
| 2000-11-20 13:00:00 | QQQ | ETF | 70.0 | 70.4375 | 69.25 | 70.375 | 5037900.0 |
| 2000-11-20 14:00:00 | QQQ | ETF | 70.4062 | 71.5625 | 70.3438 | 71.3438 | 5539100.0 |
| 2000-11-20 15:00:00 | QQQ | ETF | 71.25 | 72.0625 | 69.5938 | 69.7188 | 7237900.0 |
| 2000-11-20 16:00:00 | QQQ | ETF | 69.625 | 71.0 | 69.4375 | 70.0 | 1005300.0 |
| 2000-11-20 17:00:00 | QQQ | ETF | 70.0 | 70.4375 | 69.875 | 69.875 | 15800.0 |
| 2000-11-20 18:00:00 | QQQ | ETF | 70.0 | 70.125 | 70.0 | 70.0625 | 2100.0 |
| 2000-11-20 09:00:00 | IWM | ETF | 47.6875 | 47.8438 | 47.625 | 47.625 | 29200.0 |
| 2000-11-20 10:00:00 | IWM | ETF | 47.625 | 47.625 | 47.3438 | 47.3438 | 9200.0 |
| 2000-11-20 11:00:00 | IWM | ETF | 46.875 | 47.2812 | 46.875 | 47.2812 | 9800.0 |
| 2000-11-20 12:00:00 | IWM | ETF | 47.1875 | 47.2344 | 47.0625 | 47.1875 | 11800.0 |
| 2000-11-20 13:00:00 | IWM | ETF | 47.1875 | 47.2812 | 47.1875 | 47.2812 | 600.0 |
| 2000-11-20 14:00:00 | IWM | ETF | 47.25 | 47.5 | 47.25 | 47.3125 | 13000.0 |
| 2000-11-20 15:00:00 | IWM | ETF | 47.4219 | 47.4219 | 47.125 | 47.125 | 4400.0 |
| 2000-11-20 16:00:00 | IWM | ETF | 46.9688 | 46.9688 | 46.9062 | 46.9062 | 600.0 |
| 2000-11-20 09:00:00 | DIA | ETF | 105.8125 | 106.0 | 105.3125 | 105.6562 | 66500.0 |
| 2000-11-20 10:00:00 | DIA | ETF | 105.5625 | 105.9062 | 104.75 | 104.875 | 329300.0 |
| 2000-11-20 11:00:00 | DIA | ETF | 104.7812 | 105.1562 | 104.6875 | 105.125 | 188500.0 |
| 2000-11-20 12:00:00 | DIA | ETF | 105.0938 | 105.1562 | 104.75 | 104.9688 | 73400.0 |
| 2000-11-20 13:00:00 | DIA | ETF | 104.75 | 105.125 | 104.5625 | 105.0 | 106900.0 |
| 2000-11-20 14:00:00 | DIA | ETF | 105.125 | 105.5 | 104.875 | 105.3125 | 78600.0 |
| 2000-11-20 15:00:00 | DIA | ETF | 105.25 | 105.5312 | 104.5 | 104.625 | 223000.0 |
| 2000-11-20 16:00:00 | DIA | ETF | 104.5 | 104.6875 | 104.5 | 104.6875 | 8500.0 |
> showing 34 of 186 rows — these rows as CSV