PREVIEW / etf_30min / 2000-11-27
file: by_date/etf_30min/2000/2000-11-27.parquet size: 11 KB rows: 286
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-27 09:30:00 | SPY | ETF | 136.4688 | 136.5 | 135.9062 | 136.4375 | 1518700.0 |
| 2000-11-27 10:00:00 | SPY | ETF | 136.2812 | 136.6875 | 136.0 | 136.5625 | 781500.0 |
| 2000-11-27 10:30:00 | SPY | ETF | 136.5938 | 136.625 | 135.8125 | 136.4688 | 458500.0 |
| 2000-11-27 11:00:00 | SPY | ETF | 136.5312 | 136.5625 | 136.1875 | 136.3125 | 511500.0 |
| 2000-11-27 11:30:00 | SPY | ETF | 136.375 | 136.4375 | 135.8125 | 136.0625 | 901700.0 |
| 2000-11-27 12:00:00 | SPY | ETF | 136.0938 | 136.2188 | 135.6562 | 135.6562 | 109400.0 |
| 2000-11-27 12:30:00 | SPY | ETF | 135.7188 | 136.0938 | 135.5 | 135.9688 | 93700.0 |
| 2000-11-27 13:00:00 | SPY | ETF | 135.8125 | 136.25 | 135.8125 | 136.0312 | 92000.0 |
| 2000-11-27 13:30:00 | SPY | ETF | 136.0312 | 136.2188 | 135.75 | 135.75 | 53000.0 |
| 2000-11-27 14:00:00 | SPY | ETF | 135.8125 | 135.9375 | 135.4375 | 135.6875 | 108900.0 |
| 2000-11-27 14:30:00 | SPY | ETF | 135.6875 | 135.9375 | 135.3125 | 135.8125 | 168600.0 |
| 2000-11-27 15:00:00 | SPY | ETF | 135.75 | 136.5 | 135.75 | 136.3125 | 223800.0 |
| 2000-11-27 15:30:00 | SPY | ETF | 136.3125 | 136.375 | 135.3125 | 135.5 | 364300.0 |
| 2000-11-27 16:00:00 | SPY | ETF | 135.375 | 136.0312 | 135.3438 | 136.0312 | 296800.0 |
| 2000-11-27 09:30:00 | QQQ | ETF | 72.5625 | 72.9375 | 72.0 | 72.25 | 7673800.0 |
| 2000-11-27 10:00:00 | QQQ | ETF | 72.25 | 72.3438 | 71.5625 | 71.9375 | 3933900.0 |
| 2000-11-27 10:30:00 | QQQ | ETF | 71.875 | 72.0312 | 70.625 | 71.1562 | 3051700.0 |
| 2000-11-27 11:00:00 | QQQ | ETF | 71.1562 | 71.375 | 70.8125 | 71.0 | 1310000.0 |
| 2000-11-27 11:30:00 | QQQ | ETF | 71.0312 | 71.0938 | 70.2812 | 70.7812 | 2171300.0 |
| 2000-11-27 12:00:00 | QQQ | ETF | 70.75 | 70.875 | 69.9375 | 69.9375 | 1993400.0 |
| 2000-11-27 12:30:00 | QQQ | ETF | 69.9375 | 70.375 | 69.8125 | 70.1562 | 1546800.0 |
| 2000-11-27 13:00:00 | QQQ | ETF | 70.2188 | 70.6875 | 70.125 | 70.5312 | 1529200.0 |
| 2000-11-27 13:30:00 | QQQ | ETF | 70.5 | 70.6562 | 69.625 | 69.6875 | 1413400.0 |
| 2000-11-27 14:00:00 | QQQ | ETF | 69.7188 | 69.75 | 69.0 | 69.3438 | 1850000.0 |
| 2000-11-27 14:30:00 | QQQ | ETF | 69.1875 | 69.5 | 68.75 | 69.3438 | 2021600.0 |
| 2000-11-27 15:00:00 | QQQ | ETF | 69.4375 | 70.4375 | 69.125 | 70.2188 | 2570900.0 |
| 2000-11-27 15:30:00 | QQQ | ETF | 70.1875 | 70.3125 | 69.0 | 69.125 | 2454400.0 |
| 2000-11-27 16:00:00 | QQQ | ETF | 69.125 | 69.625 | 69.0625 | 69.5 | 581200.0 |
| 2000-11-27 16:30:00 | QQQ | ETF | 69.4375 | 70.1875 | 69.125 | 69.5 | 6600.0 |
| 2000-11-27 17:00:00 | QQQ | ETF | 69.5625 | 69.625 | 69.375 | 69.5 | 2200.0 |
| 2000-11-27 17:30:00 | QQQ | ETF | 69.375 | 69.625 | 69.375 | 69.5625 | 3100.0 |
| 2000-11-27 18:00:00 | QQQ | ETF | 70.0 | 70.0 | 69.375 | 69.375 | 2100.0 |
| 2000-11-27 09:30:00 | IWM | ETF | 47.9062 | 48.0 | 47.7812 | 47.7812 | 12000.0 |
| 2000-11-27 10:00:00 | IWM | ETF | 48.0469 | 48.0469 | 47.8125 | 48.0 | 5600.0 |
| 2000-11-27 10:30:00 | IWM | ETF | 48.0 | 48.0 | 47.8438 | 47.8438 | 10200.0 |
| 2000-11-27 11:00:00 | IWM | ETF | 47.7812 | 47.7812 | 47.7812 | 47.7812 | 400.0 |
| 2000-11-27 11:30:00 | IWM | ETF | 47.7188 | 47.7188 | 47.625 | 47.625 | 4000.0 |
| 2000-11-27 12:00:00 | IWM | ETF | 47.5938 | 47.6406 | 47.4219 | 47.4219 | 109800.0 |
| 2000-11-27 13:00:00 | IWM | ETF | 47.5 | 47.5 | 47.5 | 47.5 | 4200.0 |
| 2000-11-27 13:30:00 | IWM | ETF | 47.5 | 47.5 | 47.5 | 47.5 | 1800.0 |
| 2000-11-27 14:00:00 | IWM | ETF | 47.4375 | 47.4688 | 47.3125 | 47.3125 | 1400.0 |
| 2000-11-27 14:30:00 | IWM | ETF | 47.25 | 47.25 | 47.2188 | 47.2188 | 2200.0 |
| 2000-11-27 15:00:00 | IWM | ETF | 47.4688 | 47.5625 | 47.4688 | 47.5312 | 20600.0 |
| 2000-11-27 15:30:00 | IWM | ETF | 47.5625 | 47.5625 | 47.0625 | 47.0625 | 27400.0 |
| 2000-11-27 16:00:00 | IWM | ETF | 47.0625 | 47.0625 | 47.0625 | 47.0625 | 30000.0 |
| 2000-11-27 09:30:00 | DIA | ETF | 106.1875 | 106.25 | 105.6562 | 106.0 | 213300.0 |
| 2000-11-27 10:00:00 | DIA | ETF | 106.0625 | 106.2188 | 105.6562 | 106.125 | 29800.0 |
| 2000-11-27 10:30:00 | DIA | ETF | 106.125 | 106.3438 | 105.6562 | 106.2188 | 31700.0 |
| 2000-11-27 11:00:00 | DIA | ETF | 106.125 | 106.2812 | 105.9062 | 105.9062 | 18400.0 |
| 2000-11-27 11:30:00 | DIA | ETF | 106.1875 | 106.1875 | 105.6875 | 106.0625 | 39800.0 |
> showing 50 of 286 rows — these rows as CSV