PREVIEW / etf_30min / 2000-09-11
file: by_date/etf_30min/2000/2000-09-11.parquet size: 12 KB rows: 305
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-11 09:30:00 | SPY | ETF | 149.75 | 149.8438 | 149.4375 | 149.4375 | 420600.0 |
| 2000-09-11 10:00:00 | SPY | ETF | 149.4375 | 150.5 | 149.3125 | 150.375 | 357600.0 |
| 2000-09-11 10:30:00 | SPY | ETF | 150.4688 | 151.1562 | 150.3125 | 151.125 | 323100.0 |
| 2000-09-11 11:00:00 | SPY | ETF | 151.0 | 151.1875 | 150.75 | 150.8438 | 167700.0 |
| 2000-09-11 11:30:00 | SPY | ETF | 150.75 | 150.8125 | 150.5 | 150.6875 | 180400.0 |
| 2000-09-11 12:00:00 | SPY | ETF | 150.5625 | 150.5625 | 150.2812 | 150.2812 | 234200.0 |
| 2000-09-11 12:30:00 | SPY | ETF | 150.4062 | 150.5312 | 150.25 | 150.3438 | 134900.0 |
| 2000-09-11 13:00:00 | SPY | ETF | 150.3438 | 150.3438 | 150.0625 | 150.125 | 132300.0 |
| 2000-09-11 13:30:00 | SPY | ETF | 150.0625 | 150.5 | 150.0625 | 150.4375 | 171800.0 |
| 2000-09-11 14:00:00 | SPY | ETF | 150.4375 | 150.4375 | 149.8438 | 149.9062 | 230900.0 |
| 2000-09-11 14:30:00 | SPY | ETF | 149.9062 | 150.0312 | 149.0 | 149.25 | 570400.0 |
| 2000-09-11 15:00:00 | SPY | ETF | 149.1875 | 149.4688 | 148.6875 | 149.3125 | 431800.0 |
| 2000-09-11 15:30:00 | SPY | ETF | 149.3125 | 149.5625 | 149.0 | 149.4688 | 317000.0 |
| 2000-09-11 16:00:00 | SPY | ETF | 149.4688 | 149.6875 | 149.375 | 149.5938 | 242400.0 |
| 2000-09-11 09:30:00 | QQQ | ETF | 94.5 | 94.7812 | 93.2812 | 93.4375 | 4105400.0 |
| 2000-09-11 10:00:00 | QQQ | ETF | 93.625 | 95.5 | 93.0938 | 95.25 | 6642900.0 |
| 2000-09-11 10:30:00 | QQQ | ETF | 95.25 | 95.9375 | 94.8125 | 95.875 | 1980900.0 |
| 2000-09-11 11:00:00 | QQQ | ETF | 95.7188 | 96.125 | 95.375 | 95.625 | 1490200.0 |
| 2000-09-11 11:30:00 | QQQ | ETF | 95.5 | 95.5 | 95.0 | 95.4062 | 900100.0 |
| 2000-09-11 12:00:00 | QQQ | ETF | 95.2188 | 95.3125 | 94.375 | 94.6562 | 1132300.0 |
| 2000-09-11 12:30:00 | QQQ | ETF | 94.6562 | 95.1562 | 94.4375 | 94.875 | 501300.0 |
| 2000-09-11 13:00:00 | QQQ | ETF | 94.875 | 94.9062 | 94.125 | 94.1875 | 653800.0 |
| 2000-09-11 13:30:00 | QQQ | ETF | 94.1562 | 94.6875 | 94.0625 | 94.5938 | 555800.0 |
| 2000-09-11 14:00:00 | QQQ | ETF | 94.5 | 94.8125 | 93.875 | 94.0625 | 887300.0 |
| 2000-09-11 14:30:00 | QQQ | ETF | 94.0625 | 94.2188 | 92.625 | 93.0625 | 1913500.0 |
| 2000-09-11 15:00:00 | QQQ | ETF | 93.0938 | 93.125 | 92.125 | 92.875 | 2776100.0 |
| 2000-09-11 15:30:00 | QQQ | ETF | 92.875 | 93.0938 | 92.0 | 92.625 | 3037400.0 |
| 2000-09-11 16:00:00 | QQQ | ETF | 92.625 | 93.125 | 92.5 | 92.875 | 494200.0 |
| 2000-09-11 16:30:00 | QQQ | ETF | 92.8125 | 93.125 | 92.75 | 93.0 | 13000.0 |
| 2000-09-11 17:00:00 | QQQ | ETF | 92.875 | 93.0 | 92.875 | 93.0 | 2600.0 |
| 2000-09-11 17:30:00 | QQQ | ETF | 92.9375 | 93.0 | 92.625 | 92.625 | 2500.0 |
| 2000-09-11 18:00:00 | QQQ | ETF | 92.7812 | 92.8125 | 92.7812 | 92.8125 | 3000.0 |
| 2000-09-11 09:30:00 | IWM | ETF | 53.7031 | 53.7031 | 53.5625 | 53.5625 | 800.0 |
| 2000-09-11 10:00:00 | IWM | ETF | 53.6562 | 53.75 | 53.5312 | 53.75 | 68000.0 |
| 2000-09-11 10:30:00 | IWM | ETF | 53.8125 | 53.9062 | 53.7812 | 53.8906 | 31800.0 |
| 2000-09-11 11:00:00 | IWM | ETF | 53.875 | 53.9062 | 53.7812 | 53.7812 | 23000.0 |
| 2000-09-11 11:30:00 | IWM | ETF | 53.9062 | 53.9062 | 53.6875 | 53.75 | 52600.0 |
| 2000-09-11 12:00:00 | IWM | ETF | 53.7188 | 53.7188 | 53.6875 | 53.6875 | 3400.0 |
| 2000-09-11 12:30:00 | IWM | ETF | 53.7188 | 53.8281 | 53.6875 | 53.75 | 40400.0 |
| 2000-09-11 13:00:00 | IWM | ETF | 53.7812 | 53.7812 | 53.5938 | 53.75 | 41200.0 |
| 2000-09-11 13:30:00 | IWM | ETF | 53.7812 | 53.8438 | 53.7812 | 53.7812 | 1800.0 |
| 2000-09-11 14:00:00 | IWM | ETF | 53.5312 | 53.5312 | 53.5312 | 53.5312 | 400.0 |
| 2000-09-11 14:30:00 | IWM | ETF | 53.7188 | 53.7188 | 53.3438 | 53.3438 | 10400.0 |
| 2000-09-11 15:00:00 | IWM | ETF | 53.375 | 53.4062 | 53.3125 | 53.4062 | 15200.0 |
| 2000-09-11 15:30:00 | IWM | ETF | 53.3125 | 53.5312 | 53.3125 | 53.4688 | 24600.0 |
| 2000-09-11 16:00:00 | IWM | ETF | 53.5 | 53.5 | 53.5 | 53.5 | 1000.0 |
| 2000-09-11 09:30:00 | DIA | ETF | 111.9688 | 112.5 | 111.9688 | 112.1875 | 148500.0 |
| 2000-09-11 10:00:00 | DIA | ETF | 112.1875 | 112.6875 | 112.0625 | 112.5 | 152400.0 |
| 2000-09-11 10:30:00 | DIA | ETF | 112.4375 | 113.0 | 112.375 | 112.8125 | 127500.0 |
| 2000-09-11 11:00:00 | DIA | ETF | 112.8125 | 112.875 | 112.625 | 112.6875 | 59400.0 |
> showing 50 of 305 rows — these rows as CSV