PREVIEW / etf_30min / 2000-08-15
file: by_date/etf_30min/2000/2000-08-15.parquet size: 11 KB rows: 274
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-08-15 09:30:00 | SPY | ETF | 149.3438 | 149.4062 | 149.0625 | 149.2188 | 416400.0 |
| 2000-08-15 10:00:00 | SPY | ETF | 149.3125 | 149.5938 | 149.0625 | 149.375 | 245200.0 |
| 2000-08-15 10:30:00 | SPY | ETF | 149.375 | 149.4375 | 148.8125 | 149.0625 | 463900.0 |
| 2000-08-15 11:00:00 | SPY | ETF | 149.0625 | 149.1562 | 148.5625 | 148.8438 | 526900.0 |
| 2000-08-15 11:30:00 | SPY | ETF | 148.8438 | 149.0 | 148.75 | 148.9375 | 222800.0 |
| 2000-08-15 12:00:00 | SPY | ETF | 149.0 | 149.0 | 148.8125 | 148.9375 | 179800.0 |
| 2000-08-15 12:30:00 | SPY | ETF | 148.9375 | 149.2188 | 148.8438 | 149.125 | 293000.0 |
| 2000-08-15 13:00:00 | SPY | ETF | 149.125 | 149.3125 | 148.9375 | 149.1875 | 349100.0 |
| 2000-08-15 13:30:00 | SPY | ETF | 149.0625 | 149.1875 | 148.8125 | 148.9375 | 218900.0 |
| 2000-08-15 14:00:00 | SPY | ETF | 149.0938 | 149.4375 | 149.0312 | 149.375 | 218300.0 |
| 2000-08-15 14:30:00 | SPY | ETF | 149.3125 | 149.8125 | 149.1875 | 149.6875 | 154800.0 |
| 2000-08-15 15:00:00 | SPY | ETF | 149.625 | 149.7188 | 148.8125 | 149.0 | 762200.0 |
| 2000-08-15 15:30:00 | SPY | ETF | 148.9062 | 149.1562 | 148.625 | 149.0312 | 557200.0 |
| 2000-08-15 16:00:00 | SPY | ETF | 149.0625 | 149.1562 | 148.875 | 149.1562 | 902900.0 |
| 2000-08-15 16:30:00 | SPY | ETF | 149.1562 | 149.1562 | 149.1562 | 149.1562 | 1100.0 |
| 2000-08-15 09:30:00 | QQQ | ETF | 92.75 | 93.125 | 92.375 | 92.625 | 1684500.0 |
| 2000-08-15 10:00:00 | QQQ | ETF | 92.625 | 93.6875 | 92.5 | 93.4688 | 1900300.0 |
| 2000-08-15 10:30:00 | QQQ | ETF | 93.5 | 93.5625 | 92.5625 | 93.0625 | 1190600.0 |
| 2000-08-15 11:00:00 | QQQ | ETF | 93.0625 | 93.125 | 92.0 | 92.375 | 1173000.0 |
| 2000-08-15 11:30:00 | QQQ | ETF | 92.5 | 92.75 | 92.25 | 92.4688 | 586800.0 |
| 2000-08-15 12:00:00 | QQQ | ETF | 92.4375 | 92.4688 | 92.0625 | 92.375 | 461700.0 |
| 2000-08-15 12:30:00 | QQQ | ETF | 92.3125 | 92.75 | 92.1562 | 92.6562 | 483100.0 |
| 2000-08-15 13:00:00 | QQQ | ETF | 92.625 | 92.875 | 92.5 | 92.6562 | 378200.0 |
| 2000-08-15 13:30:00 | QQQ | ETF | 92.625 | 92.7188 | 92.25 | 92.4375 | 605900.0 |
| 2000-08-15 14:00:00 | QQQ | ETF | 92.4375 | 93.25 | 92.4375 | 93.1875 | 901000.0 |
| 2000-08-15 14:30:00 | QQQ | ETF | 93.125 | 93.9688 | 92.9375 | 93.9375 | 1451800.0 |
| 2000-08-15 15:00:00 | QQQ | ETF | 93.9375 | 93.9375 | 92.875 | 93.0938 | 1200600.0 |
| 2000-08-15 15:30:00 | QQQ | ETF | 93.0625 | 93.25 | 92.625 | 92.9688 | 1559400.0 |
| 2000-08-15 16:00:00 | QQQ | ETF | 92.9375 | 93.1562 | 92.875 | 93.0625 | 427600.0 |
| 2000-08-15 16:30:00 | QQQ | ETF | 93.0 | 93.1875 | 93.0 | 93.1875 | 700.0 |
| 2000-08-15 17:00:00 | QQQ | ETF | 93.0 | 93.0 | 93.0 | 93.0 | 400.0 |
| 2000-08-15 09:30:00 | IWM | ETF | 51.5469 | 51.5469 | 51.3125 | 51.3125 | 2400.0 |
| 2000-08-15 10:00:00 | IWM | ETF | 51.5156 | 51.625 | 51.3438 | 51.625 | 5800.0 |
| 2000-08-15 10:30:00 | IWM | ETF | 51.5 | 51.5 | 51.25 | 51.25 | 3800.0 |
| 2000-08-15 11:00:00 | IWM | ETF | 51.0469 | 51.0469 | 51.0469 | 51.0469 | 800.0 |
| 2000-08-15 11:30:00 | IWM | ETF | 51.1875 | 51.2812 | 51.1875 | 51.2812 | 2400.0 |
| 2000-08-15 12:00:00 | IWM | ETF | 51.25 | 51.25 | 51.0312 | 51.0312 | 50800.0 |
| 2000-08-15 12:30:00 | IWM | ETF | 51.2188 | 51.2188 | 51.2188 | 51.2188 | 400.0 |
| 2000-08-15 13:30:00 | IWM | ETF | 51.125 | 51.2031 | 51.125 | 51.2031 | 2400.0 |
| 2000-08-15 14:00:00 | IWM | ETF | 51.2812 | 51.2812 | 51.2812 | 51.2812 | 2000.0 |
| 2000-08-15 14:30:00 | IWM | ETF | 51.125 | 51.3438 | 51.125 | 51.3438 | 2400.0 |
| 2000-08-15 15:00:00 | IWM | ETF | 51.3438 | 51.3438 | 51.3438 | 51.3438 | 600.0 |
| 2000-08-15 15:30:00 | IWM | ETF | 51.1875 | 51.1875 | 50.9062 | 50.9062 | 115400.0 |
| 2000-08-15 09:30:00 | DIA | ETF | 111.4688 | 111.5 | 111.0938 | 111.25 | 101500.0 |
| 2000-08-15 10:00:00 | DIA | ETF | 111.2812 | 111.4062 | 111.0 | 111.125 | 373100.0 |
| 2000-08-15 10:30:00 | DIA | ETF | 111.0625 | 111.1562 | 110.7812 | 110.875 | 102800.0 |
| 2000-08-15 11:00:00 | DIA | ETF | 110.9375 | 110.9688 | 110.625 | 110.6562 | 176400.0 |
| 2000-08-15 11:30:00 | DIA | ETF | 110.75 | 110.9688 | 110.75 | 110.9062 | 59100.0 |
| 2000-08-15 12:00:00 | DIA | ETF | 110.9062 | 111.0 | 110.8125 | 111.0 | 17500.0 |
| 2000-08-15 12:30:00 | DIA | ETF | 110.9688 | 111.125 | 110.875 | 111.125 | 28900.0 |
> showing 50 of 274 rows — these rows as CSV