PREVIEW / etf_30min / 2000-06-21
file: by_date/etf_30min/2000/2000-06-21.parquet size: 10 KB rows: 250
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-21 09:30:00 | SPY | ETF | 146.9375 | 147.5625 | 146.9375 | 147.3438 | 232100.0 |
| 2000-06-21 10:00:00 | SPY | ETF | 147.4062 | 147.9062 | 147.3438 | 147.7812 | 310000.0 |
| 2000-06-21 10:30:00 | SPY | ETF | 147.8125 | 147.875 | 147.25 | 147.2812 | 183900.0 |
| 2000-06-21 11:00:00 | SPY | ETF | 147.375 | 147.4375 | 147.125 | 147.125 | 67300.0 |
| 2000-06-21 11:30:00 | SPY | ETF | 147.0 | 147.3125 | 146.875 | 147.2188 | 65000.0 |
| 2000-06-21 12:00:00 | SPY | ETF | 147.375 | 147.5938 | 147.375 | 147.375 | 89600.0 |
| 2000-06-21 12:30:00 | SPY | ETF | 147.3438 | 147.375 | 147.2188 | 147.375 | 70300.0 |
| 2000-06-21 13:00:00 | SPY | ETF | 147.125 | 147.375 | 147.0312 | 147.375 | 44100.0 |
| 2000-06-21 13:30:00 | SPY | ETF | 147.4688 | 147.8125 | 147.3125 | 147.7812 | 46700.0 |
| 2000-06-21 14:00:00 | SPY | ETF | 147.625 | 147.75 | 147.125 | 147.4062 | 715200.0 |
| 2000-06-21 14:30:00 | SPY | ETF | 147.3125 | 147.9688 | 147.2812 | 147.7812 | 586000.0 |
| 2000-06-21 15:00:00 | SPY | ETF | 147.75 | 148.2188 | 147.5625 | 148.2188 | 270100.0 |
| 2000-06-21 15:30:00 | SPY | ETF | 148.0625 | 148.4375 | 147.9375 | 147.9375 | 266100.0 |
| 2000-06-21 16:00:00 | SPY | ETF | 147.9688 | 148.125 | 147.8125 | 147.8438 | 162600.0 |
| 2000-06-21 18:00:00 | SPY | ETF | 147.875 | 147.875 | 147.875 | 147.875 | 100.0 |
| 2000-06-21 09:30:00 | QQQ | ETF | 96.8125 | 97.9375 | 96.6875 | 97.875 | 2890900.0 |
| 2000-06-21 10:00:00 | QQQ | ETF | 97.75 | 99.0 | 97.75 | 98.8125 | 1959100.0 |
| 2000-06-21 10:30:00 | QQQ | ETF | 98.8125 | 98.875 | 97.625 | 97.875 | 2779100.0 |
| 2000-06-21 11:00:00 | QQQ | ETF | 97.875 | 98.3125 | 97.625 | 97.75 | 709100.0 |
| 2000-06-21 11:30:00 | QQQ | ETF | 97.6875 | 97.875 | 97.3125 | 97.875 | 1579300.0 |
| 2000-06-21 12:00:00 | QQQ | ETF | 97.8125 | 98.25 | 97.8125 | 98.1875 | 1249500.0 |
| 2000-06-21 12:30:00 | QQQ | ETF | 98.0 | 98.1875 | 97.625 | 97.7188 | 346400.0 |
| 2000-06-21 13:00:00 | QQQ | ETF | 97.7188 | 97.9062 | 97.4062 | 97.875 | 659600.0 |
| 2000-06-21 13:30:00 | QQQ | ETF | 97.8125 | 98.625 | 97.8125 | 98.375 | 2458800.0 |
| 2000-06-21 14:00:00 | QQQ | ETF | 98.5 | 98.625 | 98.0 | 98.125 | 1333500.0 |
| 2000-06-21 14:30:00 | QQQ | ETF | 98.1875 | 99.125 | 98.125 | 98.75 | 1508500.0 |
| 2000-06-21 15:00:00 | QQQ | ETF | 99.0 | 99.125 | 98.625 | 99.125 | 1228300.0 |
| 2000-06-21 15:30:00 | QQQ | ETF | 99.125 | 99.7188 | 98.6875 | 98.9375 | 1744400.0 |
| 2000-06-21 16:00:00 | QQQ | ETF | 98.9375 | 98.9375 | 98.5 | 98.6875 | 307300.0 |
| 2000-06-21 16:30:00 | QQQ | ETF | 98.75 | 98.875 | 98.75 | 98.875 | 2900.0 |
| 2000-06-21 17:00:00 | QQQ | ETF | 98.875 | 98.875 | 98.875 | 98.875 | 400.0 |
| 2000-06-21 09:30:00 | IWM | ETF | 52.125 | 52.125 | 52.125 | 52.125 | 6600.0 |
| 2000-06-21 10:00:00 | IWM | ETF | 52.5938 | 52.75 | 52.5938 | 52.75 | 1800.0 |
| 2000-06-21 10:30:00 | IWM | ETF | 52.6875 | 52.6875 | 52.6094 | 52.6094 | 4000.0 |
| 2000-06-21 11:00:00 | IWM | ETF | 52.6094 | 52.6094 | 52.6094 | 52.6094 | 800.0 |
| 2000-06-21 11:30:00 | IWM | ETF | 52.5312 | 52.5312 | 52.5312 | 52.5312 | 3000.0 |
| 2000-06-21 12:00:00 | IWM | ETF | 52.5312 | 52.5312 | 52.5312 | 52.5312 | 1000.0 |
| 2000-06-21 13:00:00 | IWM | ETF | 52.5156 | 52.5156 | 52.5156 | 52.5156 | 1000.0 |
| 2000-06-21 13:30:00 | IWM | ETF | 52.625 | 52.625 | 52.625 | 52.625 | 2000.0 |
| 2000-06-21 14:00:00 | IWM | ETF | 52.625 | 52.625 | 52.625 | 52.625 | 19000.0 |
| 2000-06-21 14:30:00 | IWM | ETF | 52.75 | 52.8594 | 52.75 | 52.8594 | 3000.0 |
| 2000-06-21 15:00:00 | IWM | ETF | 52.7812 | 52.7812 | 52.75 | 52.75 | 6000.0 |
| 2000-06-21 15:30:00 | IWM | ETF | 52.8438 | 52.9375 | 52.8125 | 52.8438 | 18600.0 |
| 2000-06-21 09:30:00 | DIA | ETF | 104.3125 | 104.625 | 104.2188 | 104.5 | 129500.0 |
| 2000-06-21 10:00:00 | DIA | ETF | 104.5 | 104.75 | 104.3438 | 104.5 | 39100.0 |
| 2000-06-21 10:30:00 | DIA | ETF | 104.625 | 104.6562 | 104.1875 | 104.4688 | 72000.0 |
| 2000-06-21 11:00:00 | DIA | ETF | 104.2812 | 104.4375 | 104.1875 | 104.1875 | 17500.0 |
| 2000-06-21 11:30:00 | DIA | ETF | 104.1875 | 104.5 | 104.125 | 104.375 | 18100.0 |
| 2000-06-21 12:00:00 | DIA | ETF | 104.625 | 104.8438 | 104.5312 | 104.625 | 10000.0 |
| 2000-06-21 12:30:00 | DIA | ETF | 104.5 | 104.7188 | 104.5 | 104.5 | 20700.0 |
> showing 50 of 250 rows — these rows as CSV