PREVIEW / etf_30min / 2000-09-12
file: by_date/etf_30min/2000/2000-09-12.parquet size: 11 KB rows: 272
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-09-12 09:30:00 | SPY | ETF | 149.75 | 149.875 | 149.375 | 149.5 | 393000.0 |
| 2000-09-12 10:00:00 | SPY | ETF | 149.5938 | 150.0625 | 149.5 | 149.6875 | 365000.0 |
| 2000-09-12 10:30:00 | SPY | ETF | 149.625 | 149.8125 | 149.2812 | 149.8125 | 377700.0 |
| 2000-09-12 11:00:00 | SPY | ETF | 149.8125 | 149.875 | 149.5 | 149.5 | 49700.0 |
| 2000-09-12 11:30:00 | SPY | ETF | 149.5938 | 150.25 | 149.5938 | 149.9062 | 184400.0 |
| 2000-09-12 12:00:00 | SPY | ETF | 150.0 | 150.0625 | 149.75 | 149.8125 | 72600.0 |
| 2000-09-12 12:30:00 | SPY | ETF | 149.7812 | 149.9688 | 149.75 | 149.9688 | 199900.0 |
| 2000-09-12 13:00:00 | SPY | ETF | 149.875 | 149.9688 | 149.75 | 149.8438 | 82200.0 |
| 2000-09-12 13:30:00 | SPY | ETF | 149.7188 | 149.875 | 149.4688 | 149.875 | 310800.0 |
| 2000-09-12 14:00:00 | SPY | ETF | 149.8125 | 149.875 | 149.3125 | 149.3125 | 537500.0 |
| 2000-09-12 14:30:00 | SPY | ETF | 149.375 | 149.4375 | 148.9688 | 149.0 | 414400.0 |
| 2000-09-12 15:00:00 | SPY | ETF | 148.9688 | 149.2188 | 148.6875 | 149.2188 | 714400.0 |
| 2000-09-12 15:30:00 | SPY | ETF | 149.2188 | 149.3125 | 148.4375 | 148.75 | 860800.0 |
| 2000-09-12 16:00:00 | SPY | ETF | 148.625 | 148.7188 | 148.4688 | 148.5 | 203700.0 |
| 2000-09-12 09:30:00 | QQQ | ETF | 93.5 | 94.0 | 93.0 | 93.5 | 3071800.0 |
| 2000-09-12 10:00:00 | QQQ | ETF | 93.5 | 94.5 | 93.3125 | 93.8125 | 2646200.0 |
| 2000-09-12 10:30:00 | QQQ | ETF | 93.7812 | 94.0625 | 93.0625 | 94.0312 | 1567100.0 |
| 2000-09-12 11:00:00 | QQQ | ETF | 94.0625 | 94.2188 | 93.6562 | 94.0 | 734200.0 |
| 2000-09-12 11:30:00 | QQQ | ETF | 93.9375 | 94.6875 | 93.875 | 94.25 | 1200900.0 |
| 2000-09-12 12:00:00 | QQQ | ETF | 94.25 | 94.4375 | 94.0312 | 94.1875 | 598400.0 |
| 2000-09-12 12:30:00 | QQQ | ETF | 94.1875 | 94.625 | 94.0625 | 94.4062 | 472100.0 |
| 2000-09-12 13:00:00 | QQQ | ETF | 94.4062 | 94.5 | 94.125 | 94.1875 | 565800.0 |
| 2000-09-12 13:30:00 | QQQ | ETF | 94.1875 | 94.1875 | 93.5 | 94.0625 | 940100.0 |
| 2000-09-12 14:00:00 | QQQ | ETF | 94.125 | 94.25 | 93.0312 | 93.25 | 941300.0 |
| 2000-09-12 14:30:00 | QQQ | ETF | 93.25 | 93.3125 | 92.25 | 92.3125 | 2649800.0 |
| 2000-09-12 15:00:00 | QQQ | ETF | 92.2812 | 92.375 | 91.375 | 92.0 | 3606100.0 |
| 2000-09-12 15:30:00 | QQQ | ETF | 92.375 | 92.625 | 90.8438 | 91.5938 | 4182500.0 |
| 2000-09-12 16:00:00 | QQQ | ETF | 91.375 | 91.5625 | 91.25 | 91.375 | 948500.0 |
| 2000-09-12 16:30:00 | QQQ | ETF | 91.5 | 91.5 | 90.9375 | 91.25 | 11800.0 |
| 2000-09-12 17:00:00 | QQQ | ETF | 91.1875 | 91.3125 | 91.1875 | 91.25 | 2600.0 |
| 2000-09-12 17:30:00 | QQQ | ETF | 91.25 | 92.0 | 91.25 | 91.625 | 1800.0 |
| 2000-09-12 18:00:00 | QQQ | ETF | 91.5 | 91.5625 | 91.5 | 91.5 | 400.0 |
| 2000-09-12 09:30:00 | IWM | ETF | 53.8125 | 53.8125 | 53.625 | 53.625 | 10400.0 |
| 2000-09-12 10:00:00 | IWM | ETF | 53.5938 | 53.7188 | 53.5938 | 53.7188 | 30200.0 |
| 2000-09-12 10:30:00 | IWM | ETF | 53.5938 | 53.5938 | 53.5312 | 53.5312 | 5000.0 |
| 2000-09-12 11:00:00 | IWM | ETF | 53.5 | 53.6406 | 53.5 | 53.5781 | 2400.0 |
| 2000-09-12 12:00:00 | IWM | ETF | 53.6562 | 53.6562 | 53.6562 | 53.6562 | 200.0 |
| 2000-09-12 13:00:00 | IWM | ETF | 53.6719 | 53.6875 | 53.5938 | 53.6875 | 5600.0 |
| 2000-09-12 13:30:00 | IWM | ETF | 53.625 | 53.625 | 53.625 | 53.625 | 2000.0 |
| 2000-09-12 14:30:00 | IWM | ETF | 53.5625 | 53.5625 | 53.4375 | 53.5469 | 15400.0 |
| 2000-09-12 15:00:00 | IWM | ETF | 53.3125 | 53.3125 | 53.25 | 53.25 | 19800.0 |
| 2000-09-12 15:30:00 | IWM | ETF | 53.2812 | 53.3281 | 53.2812 | 53.3281 | 2000.0 |
| 2000-09-12 09:30:00 | DIA | ETF | 111.9375 | 111.9375 | 111.1562 | 111.4375 | 135600.0 |
| 2000-09-12 10:00:00 | DIA | ETF | 111.375 | 111.625 | 111.25 | 111.4375 | 37500.0 |
| 2000-09-12 10:30:00 | DIA | ETF | 111.4062 | 112.0 | 111.25 | 112.0 | 20900.0 |
| 2000-09-12 11:00:00 | DIA | ETF | 112.0938 | 112.1562 | 111.8438 | 111.9062 | 42700.0 |
| 2000-09-12 11:30:00 | DIA | ETF | 111.9688 | 112.3438 | 111.875 | 112.1875 | 56800.0 |
| 2000-09-12 12:00:00 | DIA | ETF | 112.125 | 112.2188 | 112.0 | 112.2188 | 19300.0 |
| 2000-09-12 12:30:00 | DIA | ETF | 112.1875 | 112.4375 | 112.125 | 112.3125 | 8300.0 |
| 2000-09-12 13:00:00 | DIA | ETF | 112.25 | 112.3438 | 112.125 | 112.1875 | 12600.0 |
> showing 50 of 272 rows — these rows as CSV