PREVIEW / etf_30min / 2000-07-07
file: by_date/etf_30min/2000/2000-07-07.parquet size: 11 KB rows: 263
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-07-07 09:30:00 | SPY | ETF | 146.6875 | 147.375 | 146.25 | 147.25 | 641300.0 |
| 2000-07-07 10:00:00 | SPY | ETF | 147.1562 | 147.7188 | 147.125 | 147.5938 | 266600.0 |
| 2000-07-07 10:30:00 | SPY | ETF | 147.5938 | 147.7812 | 147.3125 | 147.75 | 123300.0 |
| 2000-07-07 11:00:00 | SPY | ETF | 147.75 | 148.125 | 147.75 | 147.8438 | 200100.0 |
| 2000-07-07 11:30:00 | SPY | ETF | 148.0 | 148.4688 | 147.9375 | 148.0 | 218200.0 |
| 2000-07-07 12:00:00 | SPY | ETF | 148.0625 | 148.3438 | 148.0 | 148.125 | 43300.0 |
| 2000-07-07 12:30:00 | SPY | ETF | 148.1875 | 148.2188 | 147.9688 | 148.0625 | 138900.0 |
| 2000-07-07 13:00:00 | SPY | ETF | 148.1875 | 148.3125 | 147.875 | 147.9375 | 183400.0 |
| 2000-07-07 13:30:00 | SPY | ETF | 147.875 | 148.3125 | 147.875 | 148.0 | 76200.0 |
| 2000-07-07 14:00:00 | SPY | ETF | 148.0 | 148.25 | 148.0 | 148.2188 | 27200.0 |
| 2000-07-07 14:30:00 | SPY | ETF | 148.2188 | 148.5 | 148.0312 | 148.375 | 93400.0 |
| 2000-07-07 15:00:00 | SPY | ETF | 148.5 | 148.7812 | 148.2812 | 148.4688 | 196200.0 |
| 2000-07-07 15:30:00 | SPY | ETF | 148.3125 | 148.5312 | 148.0312 | 148.0938 | 463300.0 |
| 2000-07-07 16:00:00 | SPY | ETF | 148.25 | 148.25 | 147.9062 | 148.0938 | 262700.0 |
| 2000-07-07 16:30:00 | SPY | ETF | 148.0938 | 148.0938 | 148.0938 | 148.0938 | 300.0 |
| 2000-07-07 09:30:00 | QQQ | ETF | 95.0 | 95.875 | 94.4375 | 95.625 | 3149800.0 |
| 2000-07-07 10:00:00 | QQQ | ETF | 95.6562 | 96.3438 | 95.4062 | 96.125 | 1521300.0 |
| 2000-07-07 10:30:00 | QQQ | ETF | 96.125 | 96.5 | 95.875 | 96.4062 | 921100.0 |
| 2000-07-07 11:00:00 | QQQ | ETF | 96.4688 | 96.875 | 96.4375 | 96.5 | 907400.0 |
| 2000-07-07 11:30:00 | QQQ | ETF | 96.5 | 96.875 | 96.5 | 96.5938 | 843700.0 |
| 2000-07-07 12:00:00 | QQQ | ETF | 96.5625 | 96.7812 | 96.5 | 96.5 | 1169100.0 |
| 2000-07-07 12:30:00 | QQQ | ETF | 96.5 | 96.5625 | 96.25 | 96.4375 | 904600.0 |
| 2000-07-07 13:00:00 | QQQ | ETF | 96.4375 | 96.5625 | 95.9375 | 96.125 | 678900.0 |
| 2000-07-07 13:30:00 | QQQ | ETF | 96.125 | 96.5625 | 96.0312 | 96.3125 | 681700.0 |
| 2000-07-07 14:00:00 | QQQ | ETF | 96.3125 | 96.6875 | 96.1875 | 96.6875 | 914500.0 |
| 2000-07-07 14:30:00 | QQQ | ETF | 96.5625 | 96.875 | 96.5 | 96.75 | 898900.0 |
| 2000-07-07 15:00:00 | QQQ | ETF | 96.8125 | 97.0 | 96.375 | 96.4375 | 1505800.0 |
| 2000-07-07 15:30:00 | QQQ | ETF | 96.3125 | 96.5 | 95.75 | 95.875 | 1767200.0 |
| 2000-07-07 16:00:00 | QQQ | ETF | 95.75 | 96.25 | 95.4062 | 95.5 | 610400.0 |
| 2000-07-07 16:30:00 | QQQ | ETF | 95.375 | 95.625 | 95.375 | 95.625 | 700.0 |
| 2000-07-07 17:30:00 | QQQ | ETF | 95.9375 | 95.9375 | 95.9375 | 95.9375 | 600.0 |
| 2000-07-07 09:30:00 | IWM | ETF | 52.4219 | 52.6094 | 52.4219 | 52.5938 | 7200.0 |
| 2000-07-07 10:00:00 | IWM | ETF | 52.5938 | 52.6719 | 52.5312 | 52.6719 | 8800.0 |
| 2000-07-07 10:30:00 | IWM | ETF | 52.7344 | 52.7344 | 52.625 | 52.625 | 800.0 |
| 2000-07-07 11:00:00 | IWM | ETF | 52.6562 | 52.7812 | 52.625 | 52.7812 | 3600.0 |
| 2000-07-07 11:30:00 | IWM | ETF | 52.7969 | 52.7969 | 52.7969 | 52.7969 | 1800.0 |
| 2000-07-07 12:00:00 | IWM | ETF | 52.7812 | 52.7812 | 52.7812 | 52.7812 | 200.0 |
| 2000-07-07 12:30:00 | IWM | ETF | 52.7656 | 52.7656 | 52.6875 | 52.6875 | 12800.0 |
| 2000-07-07 13:00:00 | IWM | ETF | 52.7812 | 52.8438 | 52.7812 | 52.8438 | 10200.0 |
| 2000-07-07 13:30:00 | IWM | ETF | 52.7969 | 52.7969 | 52.7969 | 52.7969 | 200.0 |
| 2000-07-07 14:00:00 | IWM | ETF | 52.8125 | 52.8594 | 52.8125 | 52.8594 | 800.0 |
| 2000-07-07 14:30:00 | IWM | ETF | 52.875 | 52.875 | 52.875 | 52.875 | 400.0 |
| 2000-07-07 15:00:00 | IWM | ETF | 52.9531 | 52.9531 | 52.875 | 52.8906 | 3200.0 |
| 2000-07-07 15:30:00 | IWM | ETF | 52.8125 | 52.8438 | 52.8125 | 52.8438 | 21400.0 |
| 2000-07-07 16:00:00 | IWM | ETF | 52.75 | 52.75 | 52.75 | 52.75 | 400.0 |
| 2000-07-07 09:30:00 | DIA | ETF | 105.5625 | 105.9375 | 105.1562 | 105.6875 | 106100.0 |
| 2000-07-07 10:00:00 | DIA | ETF | 105.75 | 106.1875 | 105.75 | 105.9688 | 74100.0 |
| 2000-07-07 10:30:00 | DIA | ETF | 106.0 | 106.0625 | 105.625 | 106.0625 | 15500.0 |
| 2000-07-07 11:00:00 | DIA | ETF | 106.1562 | 106.375 | 106.0 | 106.25 | 47900.0 |
| 2000-07-07 11:30:00 | DIA | ETF | 106.125 | 106.5 | 106.0625 | 106.25 | 32000.0 |
> showing 50 of 263 rows — these rows as CSV