PREVIEW / etf_30min / 2000-12-26
file: by_date/etf_30min/2000/2000-12-26.parquet size: 12 KB rows: 316
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-26 09:30:00 | SPY | ETF | 130.8438 | 131.9375 | 130.8438 | 131.6562 | 395000.0 |
| 2000-12-26 10:00:00 | SPY | ETF | 131.5625 | 131.625 | 130.875 | 131.5312 | 266700.0 |
| 2000-12-26 10:30:00 | SPY | ETF | 131.5625 | 131.7188 | 131.0 | 131.375 | 330700.0 |
| 2000-12-26 11:00:00 | SPY | ETF | 131.4375 | 131.4688 | 131.0 | 131.0625 | 270300.0 |
| 2000-12-26 11:30:00 | SPY | ETF | 131.125 | 131.1562 | 130.7188 | 130.9688 | 202800.0 |
| 2000-12-26 12:00:00 | SPY | ETF | 130.8438 | 131.0938 | 130.625 | 131.0625 | 115100.0 |
| 2000-12-26 12:30:00 | SPY | ETF | 131.0625 | 131.25 | 130.875 | 130.875 | 272900.0 |
| 2000-12-26 13:00:00 | SPY | ETF | 130.8125 | 131.0625 | 130.625 | 130.625 | 218400.0 |
| 2000-12-26 13:30:00 | SPY | ETF | 130.7812 | 130.9375 | 130.4062 | 130.5625 | 154400.0 |
| 2000-12-26 14:00:00 | SPY | ETF | 130.5938 | 131.0 | 130.2812 | 130.7812 | 185500.0 |
| 2000-12-26 14:30:00 | SPY | ETF | 130.75 | 131.0938 | 130.75 | 131.0 | 378600.0 |
| 2000-12-26 15:00:00 | SPY | ETF | 131.0 | 131.6562 | 130.9062 | 131.5 | 879100.0 |
| 2000-12-26 15:30:00 | SPY | ETF | 131.5 | 131.9062 | 131.25 | 131.875 | 634700.0 |
| 2000-12-26 16:00:00 | SPY | ETF | 131.7812 | 132.3438 | 131.7188 | 132.3125 | 344900.0 |
| 2000-12-26 16:30:00 | SPY | ETF | 132.3438 | 133.0 | 132.0 | 132.0 | 6100.0 |
| 2000-12-26 17:00:00 | SPY | ETF | 132.0 | 132.0 | 132.0 | 132.0 | 100.0 |
| 2000-12-26 17:30:00 | SPY | ETF | 131.75 | 131.75 | 131.75 | 131.75 | 200.0 |
| 2000-12-26 09:30:00 | QQQ | ETF | 60.5938 | 61.9062 | 60.4375 | 61.0625 | 7907100.0 |
| 2000-12-26 10:00:00 | QQQ | ETF | 61.0625 | 61.1562 | 59.375 | 60.5 | 4500700.0 |
| 2000-12-26 10:30:00 | QQQ | ETF | 60.4375 | 60.6562 | 59.625 | 59.9688 | 2788300.0 |
| 2000-12-26 11:00:00 | QQQ | ETF | 59.9688 | 60.375 | 59.875 | 59.9375 | 1383600.0 |
| 2000-12-26 11:30:00 | QQQ | ETF | 59.9375 | 60.0 | 59.125 | 59.5 | 1919300.0 |
| 2000-12-26 12:00:00 | QQQ | ETF | 59.5 | 59.625 | 58.875 | 59.5312 | 1850900.0 |
| 2000-12-26 12:30:00 | QQQ | ETF | 59.5 | 59.8125 | 59.125 | 59.4688 | 1189800.0 |
| 2000-12-26 13:00:00 | QQQ | ETF | 59.4062 | 59.625 | 59.0 | 59.0938 | 788200.0 |
| 2000-12-26 13:30:00 | QQQ | ETF | 59.0625 | 59.375 | 58.8125 | 59.0312 | 1175100.0 |
| 2000-12-26 14:00:00 | QQQ | ETF | 59.0 | 59.125 | 58.0625 | 58.6562 | 2373800.0 |
| 2000-12-26 14:30:00 | QQQ | ETF | 58.625 | 59.0 | 58.5 | 58.7812 | 2094700.0 |
| 2000-12-26 15:00:00 | QQQ | ETF | 58.7812 | 59.875 | 58.625 | 59.5 | 3443900.0 |
| 2000-12-26 15:30:00 | QQQ | ETF | 59.5938 | 60.1875 | 59.0625 | 60.0938 | 3359000.0 |
| 2000-12-26 16:00:00 | QQQ | ETF | 60.1875 | 61.75 | 59.375 | 60.9375 | 1689000.0 |
| 2000-12-26 16:30:00 | QQQ | ETF | 60.875 | 60.9375 | 60.25 | 60.75 | 43300.0 |
| 2000-12-26 17:00:00 | QQQ | ETF | 60.5 | 60.75 | 60.5 | 60.75 | 9200.0 |
| 2000-12-26 17:30:00 | QQQ | ETF | 60.9688 | 61.0 | 60.625 | 60.875 | 3100.0 |
| 2000-12-26 18:00:00 | QQQ | ETF | 60.875 | 60.9062 | 60.75 | 60.75 | 5700.0 |
| 2000-12-26 09:30:00 | IWM | ETF | 46.25 | 46.4062 | 46.1875 | 46.1875 | 154800.0 |
| 2000-12-26 10:00:00 | IWM | ETF | 46.2812 | 46.4062 | 46.0312 | 46.1719 | 61400.0 |
| 2000-12-26 10:30:00 | IWM | ETF | 46.1875 | 46.2812 | 46.1875 | 46.2344 | 11400.0 |
| 2000-12-26 11:00:00 | IWM | ETF | 46.25 | 46.2812 | 46.25 | 46.2812 | 7400.0 |
| 2000-12-26 11:30:00 | IWM | ETF | 46.2812 | 46.2812 | 46.0938 | 46.0938 | 6200.0 |
| 2000-12-26 12:00:00 | IWM | ETF | 46.1562 | 46.2188 | 46.0156 | 46.2188 | 50600.0 |
| 2000-12-26 13:00:00 | IWM | ETF | 46.0312 | 46.0312 | 46.0312 | 46.0312 | 13200.0 |
| 2000-12-26 13:30:00 | IWM | ETF | 46.2188 | 46.25 | 46.0625 | 46.0625 | 6400.0 |
| 2000-12-26 14:00:00 | IWM | ETF | 46.125 | 46.1875 | 46.0312 | 46.125 | 61000.0 |
| 2000-12-26 14:30:00 | IWM | ETF | 46.125 | 46.3125 | 46.125 | 46.3125 | 1400.0 |
| 2000-12-26 15:00:00 | IWM | ETF | 46.3125 | 46.4844 | 46.3125 | 46.4844 | 12200.0 |
| 2000-12-26 15:30:00 | IWM | ETF | 46.4844 | 46.6094 | 46.4375 | 46.6094 | 127600.0 |
| 2000-12-26 16:00:00 | IWM | ETF | 46.5156 | 46.5156 | 46.5156 | 46.5156 | 400.0 |
| 2000-12-26 09:30:00 | DIA | ETF | 106.9375 | 107.1562 | 106.3438 | 106.5625 | 194300.0 |
| 2000-12-26 10:00:00 | DIA | ETF | 106.6875 | 106.6875 | 106.0312 | 106.375 | 76400.0 |
> showing 50 of 316 rows — these rows as CSV