PREVIEW / etf_30min / 2000-09-15
file: by_date/etf_30min/2000/2000-09-15.parquet size: 11 KB rows: 261
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-09-15 09:30:00 | SPY | ETF | 148.1875 | 148.1875 | 147.6875 | 148.0312 | 488700.0 |
| 2000-09-15 10:00:00 | SPY | ETF | 148.0 | 148.25 | 147.2812 | 147.375 | 198700.0 |
| 2000-09-15 10:30:00 | SPY | ETF | 147.375 | 147.6875 | 147.2188 | 147.6562 | 208900.0 |
| 2000-09-15 11:00:00 | SPY | ETF | 147.6562 | 147.75 | 147.2812 | 147.5 | 319100.0 |
| 2000-09-15 11:30:00 | SPY | ETF | 147.5625 | 147.7812 | 147.4375 | 147.625 | 337100.0 |
| 2000-09-15 12:00:00 | SPY | ETF | 147.625 | 147.7188 | 147.3125 | 147.3125 | 153300.0 |
| 2000-09-15 12:30:00 | SPY | ETF | 147.3438 | 147.6875 | 147.3438 | 147.5625 | 86600.0 |
| 2000-09-15 13:00:00 | SPY | ETF | 147.625 | 147.6562 | 147.3125 | 147.375 | 50300.0 |
| 2000-09-15 13:30:00 | SPY | ETF | 147.4375 | 147.4688 | 146.9375 | 147.0312 | 353700.0 |
| 2000-09-15 14:00:00 | SPY | ETF | 147.0625 | 147.1562 | 146.5 | 146.625 | 262200.0 |
| 2000-09-15 14:30:00 | SPY | ETF | 146.5938 | 146.8438 | 146.25 | 146.75 | 504000.0 |
| 2000-09-15 15:00:00 | SPY | ETF | 146.75 | 146.9062 | 146.125 | 146.3125 | 408700.0 |
| 2000-09-15 15:30:00 | SPY | ETF | 146.375 | 146.875 | 146.0312 | 146.75 | 448500.0 |
| 2000-09-15 16:00:00 | SPY | ETF | 146.75 | 146.75 | 146.0938 | 146.0938 | 260500.0 |
| 2000-09-15 16:30:00 | SPY | ETF | 146.0 | 146.0 | 146.0 | 146.0 | 3000.0 |
| 2000-09-15 09:30:00 | QQQ | ETF | 93.125 | 93.625 | 92.375 | 93.3438 | 4161600.0 |
| 2000-09-15 10:00:00 | QQQ | ETF | 93.375 | 93.4375 | 91.625 | 91.625 | 2095300.0 |
| 2000-09-15 10:30:00 | QQQ | ETF | 91.6875 | 92.3125 | 91.375 | 92.125 | 2211400.0 |
| 2000-09-15 11:00:00 | QQQ | ETF | 92.1875 | 92.4375 | 91.75 | 92.125 | 1385600.0 |
| 2000-09-15 11:30:00 | QQQ | ETF | 92.0625 | 92.8125 | 92.0625 | 92.4375 | 1173500.0 |
| 2000-09-15 12:00:00 | QQQ | ETF | 92.4375 | 92.6562 | 91.9375 | 92.0 | 695600.0 |
| 2000-09-15 12:30:00 | QQQ | ETF | 92.0625 | 92.4375 | 92.0 | 92.2188 | 1009600.0 |
| 2000-09-15 13:00:00 | QQQ | ETF | 92.1875 | 92.375 | 91.9062 | 92.0 | 1029400.0 |
| 2000-09-15 13:30:00 | QQQ | ETF | 91.9375 | 92.0625 | 91.25 | 91.5 | 1147400.0 |
| 2000-09-15 14:00:00 | QQQ | ETF | 91.4375 | 91.5625 | 90.9375 | 91.1562 | 1409400.0 |
| 2000-09-15 14:30:00 | QQQ | ETF | 91.0312 | 91.6875 | 90.6875 | 91.5312 | 2144100.0 |
| 2000-09-15 15:00:00 | QQQ | ETF | 91.5625 | 91.8125 | 90.8125 | 91.125 | 1894300.0 |
| 2000-09-15 15:30:00 | QQQ | ETF | 91.0 | 91.8125 | 90.75 | 91.5625 | 3344500.0 |
| 2000-09-15 16:00:00 | QQQ | ETF | 91.625 | 91.6875 | 91.25 | 91.25 | 1099900.0 |
| 2000-09-15 16:30:00 | QQQ | ETF | 91.375 | 91.375 | 91.1875 | 91.1875 | 2100.0 |
| 2000-09-15 17:00:00 | QQQ | ETF | 91.3125 | 91.3125 | 91.25 | 91.25 | 1700.0 |
| 2000-09-15 17:30:00 | QQQ | ETF | 91.25 | 91.3125 | 91.25 | 91.3125 | 1100.0 |
| 2000-09-15 18:00:00 | QQQ | ETF | 91.3125 | 91.3125 | 91.3125 | 91.3125 | 1100.0 |
| 2000-09-15 09:30:00 | IWM | ETF | 53.625 | 53.625 | 53.625 | 53.625 | 2800.0 |
| 2000-09-15 10:00:00 | IWM | ETF | 53.6875 | 53.6875 | 53.4219 | 53.4219 | 2600.0 |
| 2000-09-15 10:30:00 | IWM | ETF | 53.4688 | 53.4688 | 53.25 | 53.25 | 1400.0 |
| 2000-09-15 11:30:00 | IWM | ETF | 53.4375 | 53.4375 | 53.4375 | 53.4375 | 1200.0 |
| 2000-09-15 12:30:00 | IWM | ETF | 53.4375 | 53.4375 | 53.4062 | 53.4062 | 19200.0 |
| 2000-09-15 13:00:00 | IWM | ETF | 53.4688 | 53.4688 | 53.4688 | 53.4688 | 200.0 |
| 2000-09-15 13:30:00 | IWM | ETF | 53.4688 | 53.4688 | 53.4688 | 53.4688 | 800.0 |
| 2000-09-15 14:00:00 | IWM | ETF | 53.3906 | 53.3906 | 53.3906 | 53.3906 | 200.0 |
| 2000-09-15 15:00:00 | IWM | ETF | 53.2812 | 53.3906 | 53.2812 | 53.3906 | 400.0 |
| 2000-09-15 15:30:00 | IWM | ETF | 53.2812 | 53.2812 | 52.9062 | 52.9062 | 12800.0 |
| 2000-09-15 16:00:00 | IWM | ETF | 52.8125 | 52.9062 | 52.8125 | 52.9062 | 23000.0 |
| 2000-09-15 09:30:00 | DIA | ETF | 110.7812 | 111.0 | 110.6562 | 110.8125 | 49000.0 |
| 2000-09-15 10:00:00 | DIA | ETF | 110.8438 | 110.875 | 110.5 | 110.5625 | 12400.0 |
| 2000-09-15 10:30:00 | DIA | ETF | 110.5 | 110.8438 | 110.5 | 110.6875 | 19600.0 |
| 2000-09-15 11:00:00 | DIA | ETF | 110.6875 | 110.9062 | 110.625 | 110.6875 | 23900.0 |
| 2000-09-15 11:30:00 | DIA | ETF | 110.625 | 110.8125 | 110.5 | 110.6562 | 33100.0 |
| 2000-09-15 12:00:00 | DIA | ETF | 110.5938 | 110.6875 | 110.5 | 110.5 | 19100.0 |
> showing 50 of 261 rows — these rows as CSV