PREVIEW / etf_30min / 2000-04-25
file: by_date/etf_30min/2000/2000-04-25.parquet size: 10 KB rows: 211
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-04-25 09:30:00 | SPY | ETF | 144.625 | 145.4375 | 144.4375 | 145.25 | 2115500.0 |
| 2000-04-25 10:00:00 | SPY | ETF | 145.25 | 145.4062 | 144.5625 | 145.2812 | 1957000.0 |
| 2000-04-25 10:30:00 | SPY | ETF | 145.0312 | 145.75 | 145.0 | 145.5 | 281600.0 |
| 2000-04-25 11:00:00 | SPY | ETF | 145.625 | 146.1875 | 145.5625 | 145.9062 | 436200.0 |
| 2000-04-25 11:30:00 | SPY | ETF | 145.8125 | 146.125 | 145.375 | 146.0625 | 694600.0 |
| 2000-04-25 12:00:00 | SPY | ETF | 146.0625 | 146.375 | 145.75 | 145.9688 | 1486500.0 |
| 2000-04-25 12:30:00 | SPY | ETF | 145.9688 | 146.0 | 145.5625 | 145.7188 | 308500.0 |
| 2000-04-25 13:00:00 | SPY | ETF | 145.75 | 146.25 | 145.5 | 146.25 | 205000.0 |
| 2000-04-25 13:30:00 | SPY | ETF | 146.25 | 146.6562 | 146.0 | 146.6562 | 1764400.0 |
| 2000-04-25 14:00:00 | SPY | ETF | 146.6562 | 147.3125 | 146.5312 | 147.25 | 1706100.0 |
| 2000-04-25 14:30:00 | SPY | ETF | 147.4375 | 147.4688 | 146.8125 | 146.9375 | 567000.0 |
| 2000-04-25 15:00:00 | SPY | ETF | 147.125 | 147.75 | 147.0 | 147.25 | 1125900.0 |
| 2000-04-25 15:30:00 | SPY | ETF | 147.375 | 147.9688 | 147.125 | 147.875 | 1103500.0 |
| 2000-04-25 16:00:00 | SPY | ETF | 147.9062 | 148.1562 | 147.8125 | 148.1562 | 344200.0 |
| 2000-04-25 09:30:00 | QQQ | ETF | 86.5 | 88.0938 | 86.25 | 87.9375 | 4539600.0 |
| 2000-04-25 10:00:00 | QQQ | ETF | 87.9375 | 88.125 | 86.0 | 87.3125 | 2664500.0 |
| 2000-04-25 10:30:00 | QQQ | ETF | 87.3125 | 87.75 | 86.6875 | 87.5312 | 1355800.0 |
| 2000-04-25 11:00:00 | QQQ | ETF | 87.5625 | 88.25 | 87.25 | 87.5 | 1497400.0 |
| 2000-04-25 11:30:00 | QQQ | ETF | 87.5938 | 87.7188 | 87.0 | 87.4375 | 1881900.0 |
| 2000-04-25 12:00:00 | QQQ | ETF | 87.375 | 87.9375 | 86.75 | 86.75 | 1220500.0 |
| 2000-04-25 12:30:00 | QQQ | ETF | 86.75 | 87.25 | 86.5625 | 86.7812 | 2095100.0 |
| 2000-04-25 13:00:00 | QQQ | ETF | 86.75 | 87.0 | 86.5 | 87.0 | 1343400.0 |
| 2000-04-25 13:30:00 | QQQ | ETF | 87.0 | 87.625 | 87.0 | 87.5938 | 1040000.0 |
| 2000-04-25 14:00:00 | QQQ | ETF | 87.5625 | 88.2188 | 87.5 | 88.1562 | 1289200.0 |
| 2000-04-25 14:30:00 | QQQ | ETF | 88.125 | 88.375 | 87.5625 | 88.1875 | 1856800.0 |
| 2000-04-25 15:00:00 | QQQ | ETF | 88.2188 | 89.0 | 87.875 | 88.875 | 2870000.0 |
| 2000-04-25 15:30:00 | QQQ | ETF | 88.8125 | 90.25 | 88.3125 | 90.1875 | 3813200.0 |
| 2000-04-25 16:00:00 | QQQ | ETF | 90.125 | 90.5 | 90.0 | 90.0 | 834100.0 |
| 2000-04-25 16:30:00 | QQQ | ETF | 90.0625 | 90.5 | 90.0 | 90.0 | 2100.0 |
| 2000-04-25 17:00:00 | QQQ | ETF | 90.0 | 90.4375 | 90.0 | 90.4375 | 50300.0 |
| 2000-04-25 17:30:00 | QQQ | ETF | 90.25 | 90.25 | 90.125 | 90.25 | 400.0 |
| 2000-04-25 18:00:00 | QQQ | ETF | 90.0625 | 90.4688 | 90.0625 | 90.4688 | 400.0 |
| 2000-04-25 09:30:00 | DIA | ETF | 109.7188 | 110.0 | 109.125 | 109.4688 | 445200.0 |
| 2000-04-25 10:00:00 | DIA | ETF | 109.3438 | 109.5 | 108.7812 | 109.25 | 115800.0 |
| 2000-04-25 10:30:00 | DIA | ETF | 109.3438 | 109.7812 | 109.3438 | 109.625 | 181300.0 |
| 2000-04-25 11:00:00 | DIA | ETF | 109.5 | 110.125 | 109.5 | 109.6875 | 260900.0 |
| 2000-04-25 11:30:00 | DIA | ETF | 109.9062 | 109.9062 | 109.5 | 109.8125 | 520100.0 |
| 2000-04-25 12:00:00 | DIA | ETF | 109.625 | 110.1875 | 109.5938 | 109.7812 | 276400.0 |
| 2000-04-25 12:30:00 | DIA | ETF | 110.0312 | 110.1875 | 109.7188 | 109.9062 | 237300.0 |
| 2000-04-25 13:00:00 | DIA | ETF | 110.0625 | 110.2188 | 109.8125 | 110.1875 | 49200.0 |
| 2000-04-25 13:30:00 | DIA | ETF | 110.1875 | 110.3125 | 110.0 | 110.3125 | 77300.0 |
| 2000-04-25 14:00:00 | DIA | ETF | 110.25 | 110.875 | 110.25 | 110.875 | 269000.0 |
| 2000-04-25 14:30:00 | DIA | ETF | 110.7812 | 110.9688 | 110.5938 | 110.7812 | 70500.0 |
| 2000-04-25 15:00:00 | DIA | ETF | 110.75 | 111.1875 | 110.75 | 110.9062 | 75500.0 |
| 2000-04-25 15:30:00 | DIA | ETF | 110.9688 | 111.4375 | 110.7812 | 111.3125 | 144700.0 |
| 2000-04-25 16:00:00 | DIA | ETF | 111.1875 | 111.625 | 111.1875 | 111.5312 | 73500.0 |
| 2000-04-25 18:00:00 | DIA | ETF | 111.2812 | 111.2812 | 111.2812 | 111.2812 | 100.0 |
> showing 47 of 211 rows — these rows as CSV