PREVIEW / etf_1hour / 2000-11-30
file: by_date/etf_1hour/2000/2000-11-30.parquet size: 10 KB rows: 195
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-30 09:00:00 | SPY | ETF | 132.5 | 133.0938 | 132.125 | 132.7812 | 1114300.0 |
| 2000-11-30 10:00:00 | SPY | ETF | 132.9062 | 133.5 | 132.25 | 132.625 | 1342100.0 |
| 2000-11-30 11:00:00 | SPY | ETF | 132.8125 | 132.9375 | 131.5 | 131.7812 | 692100.0 |
| 2000-11-30 12:00:00 | SPY | ETF | 131.9062 | 132.0 | 130.875 | 131.125 | 1236900.0 |
| 2000-11-30 13:00:00 | SPY | ETF | 131.2812 | 131.5625 | 130.0625 | 130.5312 | 979300.0 |
| 2000-11-30 14:00:00 | SPY | ETF | 130.4375 | 131.4062 | 129.75 | 130.625 | 1750500.0 |
| 2000-11-30 15:00:00 | SPY | ETF | 130.5625 | 133.0625 | 130.5312 | 131.625 | 2626400.0 |
| 2000-11-30 16:00:00 | SPY | ETF | 131.75 | 132.2812 | 131.0312 | 131.0625 | 1025500.0 |
| 2000-11-30 17:00:00 | SPY | ETF | 132.2812 | 132.2812 | 132.2812 | 132.2812 | 1100.0 |
| 2000-11-30 09:00:00 | QQQ | ETF | 61.75 | 62.375 | 61.25 | 61.9062 | 10728100.0 |
| 2000-11-30 10:00:00 | QQQ | ETF | 61.75 | 63.5 | 61.3125 | 62.5 | 13399700.0 |
| 2000-11-30 11:00:00 | QQQ | ETF | 62.375 | 62.6875 | 61.25 | 61.6875 | 6719700.0 |
| 2000-11-30 12:00:00 | QQQ | ETF | 61.6875 | 61.8125 | 60.625 | 61.125 | 8269200.0 |
| 2000-11-30 13:00:00 | QQQ | ETF | 61.125 | 61.7188 | 60.5 | 61.5 | 6059600.0 |
| 2000-11-30 14:00:00 | QQQ | ETF | 61.5 | 62.625 | 60.8125 | 62.125 | 10718100.0 |
| 2000-11-30 15:00:00 | QQQ | ETF | 62.125 | 64.25 | 61.875 | 62.4688 | 13612500.0 |
| 2000-11-30 16:00:00 | QQQ | ETF | 62.375 | 63.3125 | 62.0938 | 63.125 | 1612800.0 |
| 2000-11-30 17:00:00 | QQQ | ETF | 63.125 | 63.8125 | 63.0625 | 63.5 | 74600.0 |
| 2000-11-30 18:00:00 | QQQ | ETF | 63.5 | 64.0 | 63.375 | 63.6875 | 21200.0 |
| 2000-11-30 09:00:00 | IWM | ETF | 45.0 | 45.0 | 44.7969 | 44.9375 | 22800.0 |
| 2000-11-30 10:00:00 | IWM | ETF | 44.8438 | 45.0625 | 44.75 | 44.875 | 74600.0 |
| 2000-11-30 11:00:00 | IWM | ETF | 44.875 | 44.875 | 44.5 | 44.5 | 9200.0 |
| 2000-11-30 12:00:00 | IWM | ETF | 44.4375 | 44.4688 | 44.2812 | 44.3438 | 9600.0 |
| 2000-11-30 13:00:00 | IWM | ETF | 44.375 | 44.375 | 44.0312 | 44.0312 | 14600.0 |
| 2000-11-30 14:00:00 | IWM | ETF | 44.0938 | 44.4844 | 43.9688 | 44.375 | 5000.0 |
| 2000-11-30 15:00:00 | IWM | ETF | 44.5 | 45.2812 | 44.5 | 44.7812 | 46000.0 |
| 2000-11-30 16:00:00 | IWM | ETF | 44.5625 | 44.5625 | 44.5625 | 44.5625 | 200.0 |
| 2000-11-30 09:00:00 | DIA | ETF | 105.25 | 105.9375 | 105.0625 | 105.75 | 107700.0 |
| 2000-11-30 10:00:00 | DIA | ETF | 105.75 | 105.9375 | 105.1875 | 105.4688 | 168900.0 |
| 2000-11-30 11:00:00 | DIA | ETF | 105.4062 | 105.4688 | 104.5 | 104.75 | 237600.0 |
| 2000-11-30 12:00:00 | DIA | ETF | 104.625 | 104.75 | 104.0312 | 104.25 | 177400.0 |
| 2000-11-30 13:00:00 | DIA | ETF | 104.25 | 104.3438 | 103.1562 | 103.4375 | 281300.0 |
| 2000-11-30 14:00:00 | DIA | ETF | 103.6875 | 103.9688 | 102.875 | 103.4688 | 396500.0 |
| 2000-11-30 15:00:00 | DIA | ETF | 103.4688 | 104.9688 | 103.1875 | 104.0625 | 385700.0 |
| 2000-11-30 16:00:00 | DIA | ETF | 104.0625 | 104.4062 | 103.875 | 104.4062 | 46500.0 |
> showing 35 of 195 rows — these rows as CSV