PREVIEW / etf_30min / 2000-05-30
file: by_date/etf_30min/2000/2000-05-30.parquet size: 10 KB rows: 216
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-05-30 09:30:00 | SPY | ETF | 140.0 | 140.3438 | 139.75 | 140.0625 | 965300.0 |
| 2000-05-30 10:00:00 | SPY | ETF | 139.9375 | 140.5 | 139.4688 | 140.1875 | 525100.0 |
| 2000-05-30 10:30:00 | SPY | ETF | 140.0625 | 140.6875 | 140.0312 | 140.5 | 341700.0 |
| 2000-05-30 11:00:00 | SPY | ETF | 140.625 | 140.7188 | 140.2188 | 140.375 | 243900.0 |
| 2000-05-30 11:30:00 | SPY | ETF | 140.3125 | 140.5 | 140.1875 | 140.3125 | 113900.0 |
| 2000-05-30 12:00:00 | SPY | ETF | 140.25 | 140.7188 | 140.25 | 140.5625 | 175300.0 |
| 2000-05-30 12:30:00 | SPY | ETF | 140.5625 | 140.9688 | 140.375 | 140.75 | 350600.0 |
| 2000-05-30 13:00:00 | SPY | ETF | 140.75 | 141.0312 | 140.6875 | 141.0 | 143600.0 |
| 2000-05-30 13:30:00 | SPY | ETF | 140.9375 | 141.0312 | 140.5625 | 140.6562 | 125800.0 |
| 2000-05-30 14:00:00 | SPY | ETF | 140.6875 | 141.5 | 140.5625 | 141.375 | 397000.0 |
| 2000-05-30 14:30:00 | SPY | ETF | 141.5 | 141.8125 | 141.3125 | 141.7188 | 357600.0 |
| 2000-05-30 15:00:00 | SPY | ETF | 141.6875 | 142.4688 | 141.6875 | 142.1562 | 468000.0 |
| 2000-05-30 15:30:00 | SPY | ETF | 142.1875 | 142.6875 | 141.9688 | 142.625 | 525700.0 |
| 2000-05-30 16:00:00 | SPY | ETF | 142.6875 | 142.9375 | 142.4688 | 142.4688 | 466200.0 |
| 2000-05-30 16:30:00 | SPY | ETF | 142.4688 | 142.7188 | 142.4688 | 142.7188 | 400.0 |
| 2000-05-30 18:00:00 | SPY | ETF | 142.5 | 142.5 | 142.5 | 142.5 | 100.0 |
| 2000-05-30 09:30:00 | QQQ | ETF | 80.0 | 81.0 | 80.0 | 80.5 | 7186000.0 |
| 2000-05-30 10:00:00 | QQQ | ETF | 80.5 | 81.4375 | 80.0 | 81.125 | 3088300.0 |
| 2000-05-30 10:30:00 | QQQ | ETF | 81.125 | 81.75 | 80.75 | 81.7188 | 1827800.0 |
| 2000-05-30 11:00:00 | QQQ | ETF | 81.7188 | 81.75 | 81.125 | 81.375 | 1612900.0 |
| 2000-05-30 11:30:00 | QQQ | ETF | 81.375 | 81.5 | 81.0 | 81.125 | 874000.0 |
| 2000-05-30 12:00:00 | QQQ | ETF | 81.125 | 81.875 | 81.0938 | 81.75 | 840700.0 |
| 2000-05-30 12:30:00 | QQQ | ETF | 81.75 | 82.2188 | 81.625 | 81.75 | 1139500.0 |
| 2000-05-30 13:00:00 | QQQ | ETF | 81.75 | 82.125 | 81.75 | 82.0625 | 702500.0 |
| 2000-05-30 13:30:00 | QQQ | ETF | 82.125 | 82.2188 | 81.625 | 81.625 | 758500.0 |
| 2000-05-30 14:00:00 | QQQ | ETF | 81.7188 | 83.0 | 81.625 | 82.9375 | 3443800.0 |
| 2000-05-30 14:30:00 | QQQ | ETF | 82.9375 | 83.5 | 82.625 | 83.5 | 2125300.0 |
| 2000-05-30 15:00:00 | QQQ | ETF | 83.25 | 84.1875 | 83.0625 | 83.875 | 2240600.0 |
| 2000-05-30 15:30:00 | QQQ | ETF | 83.9375 | 85.25 | 83.625 | 85.0 | 3355600.0 |
| 2000-05-30 16:00:00 | QQQ | ETF | 85.0 | 85.6875 | 80.75 | 85.25 | 854400.0 |
| 2000-05-30 16:30:00 | QQQ | ETF | 85.5 | 85.5 | 85.25 | 85.5 | 5100.0 |
| 2000-05-30 17:00:00 | QQQ | ETF | 85.25 | 85.5 | 85.25 | 85.4375 | 2000.0 |
| 2000-05-30 17:30:00 | QQQ | ETF | 85.25 | 85.5625 | 84.0 | 85.5 | 3800.0 |
| 2000-05-30 18:00:00 | QQQ | ETF | 85.625 | 85.625 | 85.5625 | 85.5625 | 900.0 |
| 2000-05-30 09:30:00 | IWM | ETF | 46.375 | 46.375 | 46.375 | 46.375 | 2000.0 |
| 2000-05-30 11:00:00 | IWM | ETF | 46.8438 | 46.8438 | 46.8438 | 46.8438 | 2400.0 |
| 2000-05-30 15:00:00 | IWM | ETF | 47.2812 | 47.2812 | 47.2812 | 47.2812 | 3200.0 |
| 2000-05-30 15:30:00 | IWM | ETF | 47.3125 | 47.4062 | 47.3125 | 47.4062 | 50000.0 |
| 2000-05-30 09:30:00 | DIA | ETF | 104.125 | 104.2188 | 103.8125 | 103.8125 | 153200.0 |
| 2000-05-30 10:00:00 | DIA | ETF | 103.8125 | 104.2812 | 103.5312 | 104.0 | 134500.0 |
| 2000-05-30 10:30:00 | DIA | ETF | 104.1562 | 104.4688 | 103.875 | 104.4062 | 65800.0 |
| 2000-05-30 11:00:00 | DIA | ETF | 104.25 | 104.4688 | 104.0938 | 104.2812 | 37800.0 |
| 2000-05-30 11:30:00 | DIA | ETF | 104.375 | 104.4375 | 104.2188 | 104.2188 | 32500.0 |
| 2000-05-30 12:00:00 | DIA | ETF | 104.25 | 104.4688 | 104.25 | 104.3438 | 42500.0 |
| 2000-05-30 12:30:00 | DIA | ETF | 104.4375 | 104.7812 | 104.375 | 104.6875 | 26800.0 |
| 2000-05-30 13:00:00 | DIA | ETF | 104.4688 | 104.8125 | 104.4688 | 104.5938 | 6900.0 |
| 2000-05-30 13:30:00 | DIA | ETF | 104.5625 | 104.7812 | 104.1875 | 104.4062 | 69200.0 |
| 2000-05-30 14:00:00 | DIA | ETF | 104.25 | 104.9062 | 104.25 | 104.7188 | 45700.0 |
| 2000-05-30 14:30:00 | DIA | ETF | 104.6875 | 104.9688 | 104.5625 | 104.75 | 55600.0 |
| 2000-05-30 15:00:00 | DIA | ETF | 104.875 | 105.125 | 104.75 | 105.125 | 35000.0 |
> showing 50 of 216 rows — these rows as CSV