PREVIEW / etf_30min / 2000-12-27
file: by_date/etf_30min/2000/2000-12-27.parquet size: 13 KB rows: 329
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-12-27 09:30:00 | SPY | ETF | 132.0 | 132.125 | 131.4062 | 131.9062 | 480000.0 |
| 2000-12-27 10:00:00 | SPY | ETF | 131.9375 | 132.3438 | 131.25 | 132.3438 | 144600.0 |
| 2000-12-27 10:30:00 | SPY | ETF | 132.25 | 132.5312 | 132.0625 | 132.4062 | 213600.0 |
| 2000-12-27 11:00:00 | SPY | ETF | 132.4062 | 132.9062 | 132.25 | 132.5938 | 397200.0 |
| 2000-12-27 11:30:00 | SPY | ETF | 132.625 | 133.4062 | 132.5625 | 133.25 | 342500.0 |
| 2000-12-27 12:00:00 | SPY | ETF | 133.25 | 133.4688 | 132.6875 | 132.75 | 389900.0 |
| 2000-12-27 12:30:00 | SPY | ETF | 132.8438 | 133.125 | 132.625 | 133.0 | 302300.0 |
| 2000-12-27 13:00:00 | SPY | ETF | 133.0 | 133.125 | 132.625 | 132.7812 | 200000.0 |
| 2000-12-27 13:30:00 | SPY | ETF | 132.8438 | 133.25 | 132.5938 | 133.0625 | 192600.0 |
| 2000-12-27 14:00:00 | SPY | ETF | 133.25 | 133.3438 | 132.75 | 132.8438 | 190800.0 |
| 2000-12-27 14:30:00 | SPY | ETF | 133.0 | 133.1875 | 132.4375 | 133.1875 | 431600.0 |
| 2000-12-27 15:00:00 | SPY | ETF | 133.25 | 133.4688 | 132.9062 | 133.2812 | 234900.0 |
| 2000-12-27 15:30:00 | SPY | ETF | 133.2188 | 133.6562 | 132.8125 | 133.125 | 666600.0 |
| 2000-12-27 16:00:00 | SPY | ETF | 133.125 | 133.7188 | 133.0312 | 133.5 | 450900.0 |
| 2000-12-27 16:30:00 | SPY | ETF | 133.3125 | 133.3125 | 133.3125 | 133.3125 | 700.0 |
| 2000-12-27 09:30:00 | QQQ | ETF | 59.6875 | 60.25 | 59.25 | 59.625 | 5106700.0 |
| 2000-12-27 10:00:00 | QQQ | ETF | 59.6562 | 60.375 | 58.9375 | 60.375 | 3587800.0 |
| 2000-12-27 10:30:00 | QQQ | ETF | 60.1875 | 61.0 | 60.1562 | 60.6875 | 3401300.0 |
| 2000-12-27 11:00:00 | QQQ | ETF | 60.7188 | 61.2812 | 60.5625 | 60.6875 | 2891300.0 |
| 2000-12-27 11:30:00 | QQQ | ETF | 60.6875 | 61.5 | 60.4375 | 61.375 | 2375600.0 |
| 2000-12-27 12:00:00 | QQQ | ETF | 61.4375 | 61.75 | 61.0 | 61.125 | 2552900.0 |
| 2000-12-27 12:30:00 | QQQ | ETF | 61.125 | 61.3125 | 60.8125 | 61.0 | 1375100.0 |
| 2000-12-27 13:00:00 | QQQ | ETF | 61.0938 | 61.2188 | 60.625 | 60.75 | 1061100.0 |
| 2000-12-27 13:30:00 | QQQ | ETF | 60.7188 | 61.125 | 60.5 | 61.0 | 1727800.0 |
| 2000-12-27 14:00:00 | QQQ | ETF | 61.0312 | 61.375 | 60.6875 | 60.9375 | 1782300.0 |
| 2000-12-27 14:30:00 | QQQ | ETF | 60.9688 | 61.125 | 60.5 | 61.125 | 1178700.0 |
| 2000-12-27 15:00:00 | QQQ | ETF | 61.125 | 61.625 | 60.875 | 61.0625 | 2051800.0 |
| 2000-12-27 15:30:00 | QQQ | ETF | 61.0312 | 61.625 | 60.6875 | 61.25 | 3112200.0 |
| 2000-12-27 16:00:00 | QQQ | ETF | 61.2188 | 61.75 | 61.125 | 61.6875 | 523300.0 |
| 2000-12-27 16:30:00 | QQQ | ETF | 61.625 | 61.75 | 61.4375 | 61.625 | 31100.0 |
| 2000-12-27 17:00:00 | QQQ | ETF | 61.5625 | 61.6875 | 61.5 | 61.625 | 14300.0 |
| 2000-12-27 17:30:00 | QQQ | ETF | 61.625 | 61.7812 | 61.5938 | 61.7812 | 14200.0 |
| 2000-12-27 18:00:00 | QQQ | ETF | 61.6875 | 61.75 | 61.625 | 61.6875 | 3900.0 |
| 2000-12-27 09:30:00 | IWM | ETF | 46.5 | 46.5 | 46.1875 | 46.1875 | 88600.0 |
| 2000-12-27 10:00:00 | IWM | ETF | 46.1875 | 46.1875 | 46.1875 | 46.1875 | 1000.0 |
| 2000-12-27 10:30:00 | IWM | ETF | 46.4375 | 46.6562 | 46.375 | 46.6562 | 281800.0 |
| 2000-12-27 11:00:00 | IWM | ETF | 46.8125 | 46.9062 | 46.8125 | 46.9062 | 30600.0 |
| 2000-12-27 11:30:00 | IWM | ETF | 46.75 | 46.8906 | 46.75 | 46.8906 | 28400.0 |
| 2000-12-27 12:00:00 | IWM | ETF | 46.8125 | 47.0 | 46.8125 | 46.8125 | 13400.0 |
| 2000-12-27 12:30:00 | IWM | ETF | 46.9062 | 46.9688 | 46.9062 | 46.9688 | 1400.0 |
| 2000-12-27 13:00:00 | IWM | ETF | 46.9688 | 47.0 | 46.8125 | 46.8125 | 36600.0 |
| 2000-12-27 13:30:00 | IWM | ETF | 46.7812 | 47.0625 | 46.7812 | 47.0625 | 3600.0 |
| 2000-12-27 14:00:00 | IWM | ETF | 47.0625 | 47.2188 | 46.9688 | 46.9688 | 155200.0 |
| 2000-12-27 14:30:00 | IWM | ETF | 47.0 | 47.0625 | 47.0 | 47.0625 | 3000.0 |
| 2000-12-27 15:00:00 | IWM | ETF | 47.0938 | 47.2656 | 47.0312 | 47.2656 | 34000.0 |
| 2000-12-27 15:30:00 | IWM | ETF | 47.2812 | 47.5 | 47.2188 | 47.5 | 37800.0 |
| 2000-12-27 16:00:00 | IWM | ETF | 47.625 | 47.75 | 47.625 | 47.75 | 25800.0 |
| 2000-12-27 09:30:00 | DIA | ETF | 107.0 | 107.0 | 106.5 | 106.75 | 662200.0 |
| 2000-12-27 10:00:00 | DIA | ETF | 106.625 | 107.0 | 106.3125 | 107.0 | 142000.0 |
| 2000-12-27 10:30:00 | DIA | ETF | 107.0 | 107.2812 | 106.8438 | 107.0625 | 116400.0 |
> showing 50 of 329 rows — these rows as CSV