PREVIEW / etf_30min / 2000-06-15
file: by_date/etf_30min/2000/2000-06-15.parquet size: 11 KB rows: 247
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-06-15 09:30:00 | SPY | ETF | 148.125 | 148.2188 | 147.375 | 147.5 | 619400.0 |
| 2000-06-15 10:00:00 | SPY | ETF | 147.4375 | 147.9375 | 147.25 | 147.375 | 706300.0 |
| 2000-06-15 10:30:00 | SPY | ETF | 147.375 | 147.5 | 146.8438 | 147.0312 | 118900.0 |
| 2000-06-15 11:00:00 | SPY | ETF | 147.0625 | 147.7812 | 147.0625 | 147.5625 | 508000.0 |
| 2000-06-15 11:30:00 | SPY | ETF | 147.5 | 147.75 | 147.3125 | 147.4375 | 171200.0 |
| 2000-06-15 12:00:00 | SPY | ETF | 147.5 | 147.6562 | 147.4062 | 147.6562 | 101800.0 |
| 2000-06-15 12:30:00 | SPY | ETF | 147.6562 | 148.0625 | 147.5625 | 147.875 | 176000.0 |
| 2000-06-15 13:00:00 | SPY | ETF | 147.875 | 148.4375 | 147.6875 | 148.2812 | 106200.0 |
| 2000-06-15 13:30:00 | SPY | ETF | 148.375 | 148.5938 | 148.2188 | 148.375 | 216600.0 |
| 2000-06-15 14:00:00 | SPY | ETF | 148.5312 | 148.6562 | 148.1875 | 148.3125 | 640300.0 |
| 2000-06-15 14:30:00 | SPY | ETF | 148.375 | 148.4375 | 148.0625 | 148.1562 | 583700.0 |
| 2000-06-15 15:00:00 | SPY | ETF | 148.25 | 148.25 | 147.625 | 147.625 | 281600.0 |
| 2000-06-15 15:30:00 | SPY | ETF | 147.5625 | 148.75 | 147.5312 | 148.25 | 1331800.0 |
| 2000-06-15 16:00:00 | SPY | ETF | 148.25 | 148.25 | 147.75 | 148.1562 | 315800.0 |
| 2000-06-15 16:30:00 | SPY | ETF | 148.1562 | 148.1562 | 148.1562 | 148.1562 | 100.0 |
| 2000-06-15 09:30:00 | QQQ | ETF | 91.875 | 92.375 | 90.875 | 90.9375 | 1976000.0 |
| 2000-06-15 10:00:00 | QQQ | ETF | 91.0 | 92.1875 | 90.875 | 91.5 | 2869100.0 |
| 2000-06-15 10:30:00 | QQQ | ETF | 91.4375 | 91.5938 | 90.9375 | 91.0 | 1596700.0 |
| 2000-06-15 11:00:00 | QQQ | ETF | 91.0 | 91.9375 | 91.0 | 91.625 | 1392200.0 |
| 2000-06-15 11:30:00 | QQQ | ETF | 91.5625 | 91.75 | 91.3125 | 91.625 | 426800.0 |
| 2000-06-15 12:00:00 | QQQ | ETF | 91.625 | 92.25 | 91.5312 | 92.25 | 609200.0 |
| 2000-06-15 12:30:00 | QQQ | ETF | 92.25 | 92.875 | 92.125 | 92.625 | 1828900.0 |
| 2000-06-15 13:00:00 | QQQ | ETF | 92.625 | 93.125 | 92.5 | 93.0625 | 1194800.0 |
| 2000-06-15 13:30:00 | QQQ | ETF | 93.125 | 93.4375 | 93.0312 | 93.375 | 1123600.0 |
| 2000-06-15 14:00:00 | QQQ | ETF | 93.4375 | 93.8125 | 93.0625 | 93.0625 | 1549100.0 |
| 2000-06-15 14:30:00 | QQQ | ETF | 93.0625 | 93.5 | 92.875 | 93.3438 | 760600.0 |
| 2000-06-15 15:00:00 | QQQ | ETF | 93.375 | 93.375 | 92.1875 | 92.25 | 1102300.0 |
| 2000-06-15 15:30:00 | QQQ | ETF | 92.3125 | 93.5625 | 92.25 | 93.5625 | 1544400.0 |
| 2000-06-15 16:00:00 | QQQ | ETF | 93.5625 | 93.7812 | 93.25 | 93.7812 | 802400.0 |
| 2000-06-15 16:30:00 | QQQ | ETF | 93.625 | 93.8125 | 93.625 | 93.8125 | 4500.0 |
| 2000-06-15 17:00:00 | QQQ | ETF | 93.875 | 93.875 | 93.875 | 93.875 | 100.0 |
| 2000-06-15 17:30:00 | QQQ | ETF | 93.75 | 93.75 | 93.75 | 93.75 | 300.0 |
| 2000-06-15 09:30:00 | IWM | ETF | 50.875 | 50.875 | 50.875 | 50.875 | 3000.0 |
| 2000-06-15 10:30:00 | IWM | ETF | 50.6875 | 50.6875 | 50.6875 | 50.6875 | 200.0 |
| 2000-06-15 11:00:00 | IWM | ETF | 50.375 | 50.4688 | 50.375 | 50.4688 | 1200.0 |
| 2000-06-15 11:30:00 | IWM | ETF | 50.4375 | 50.4375 | 50.4375 | 50.4375 | 400.0 |
| 2000-06-15 12:00:00 | IWM | ETF | 50.6562 | 50.6562 | 50.6562 | 50.6562 | 200.0 |
| 2000-06-15 13:00:00 | IWM | ETF | 50.7188 | 50.7188 | 50.7188 | 50.7188 | 200.0 |
| 2000-06-15 13:30:00 | IWM | ETF | 51.0 | 51.0 | 51.0 | 51.0 | 2000.0 |
| 2000-06-15 14:30:00 | IWM | ETF | 50.9688 | 50.9688 | 50.9688 | 50.9688 | 400.0 |
| 2000-06-15 15:00:00 | IWM | ETF | 50.7969 | 50.7969 | 50.7969 | 50.7969 | 1000.0 |
| 2000-06-15 15:30:00 | IWM | ETF | 50.9375 | 51.25 | 50.9375 | 51.25 | 18200.0 |
| 2000-06-15 09:30:00 | DIA | ETF | 107.125 | 107.5625 | 106.9062 | 107.4062 | 36900.0 |
| 2000-06-15 10:00:00 | DIA | ETF | 107.0625 | 107.4375 | 106.75 | 106.7812 | 8200.0 |
| 2000-06-15 10:30:00 | DIA | ETF | 107.0 | 107.125 | 106.625 | 106.625 | 18900.0 |
| 2000-06-15 11:00:00 | DIA | ETF | 106.6875 | 107.3125 | 106.6562 | 107.2812 | 145000.0 |
| 2000-06-15 11:30:00 | DIA | ETF | 107.0312 | 107.25 | 106.875 | 107.0312 | 28900.0 |
| 2000-06-15 12:00:00 | DIA | ETF | 107.0312 | 107.1562 | 106.875 | 107.1562 | 21900.0 |
| 2000-06-15 12:30:00 | DIA | ETF | 107.25 | 107.375 | 107.0625 | 107.3438 | 108000.0 |
| 2000-06-15 13:00:00 | DIA | ETF | 107.3125 | 107.5625 | 107.1875 | 107.5625 | 25200.0 |
> showing 50 of 247 rows — these rows as CSV