PREVIEW / etf_30min / 2000-12-05
file: by_date/etf_30min/2000/2000-12-05.parquet size: 13 KB rows: 331
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-05 09:30:00 | SPY | ETF | 134.875 | 134.9062 | 134.4062 | 134.7188 | 1515000.0 |
| 2000-12-05 10:00:00 | SPY | ETF | 134.6562 | 135.5 | 134.4688 | 135.1875 | 746800.0 |
| 2000-12-05 10:30:00 | SPY | ETF | 135.2812 | 136.625 | 135.125 | 136.375 | 1064800.0 |
| 2000-12-05 11:00:00 | SPY | ETF | 136.4688 | 137.375 | 136.1875 | 136.9688 | 755100.0 |
| 2000-12-05 11:30:00 | SPY | ETF | 136.9688 | 137.3438 | 136.6875 | 137.2812 | 471700.0 |
| 2000-12-05 12:00:00 | SPY | ETF | 137.125 | 137.6875 | 136.7188 | 136.875 | 389600.0 |
| 2000-12-05 12:30:00 | SPY | ETF | 136.875 | 136.9375 | 136.3438 | 136.75 | 449800.0 |
| 2000-12-05 13:00:00 | SPY | ETF | 136.75 | 137.0625 | 136.625 | 136.625 | 108500.0 |
| 2000-12-05 13:30:00 | SPY | ETF | 136.625 | 137.1875 | 136.625 | 136.8125 | 235400.0 |
| 2000-12-05 14:00:00 | SPY | ETF | 136.8125 | 137.3125 | 136.8125 | 137.25 | 510200.0 |
| 2000-12-05 14:30:00 | SPY | ETF | 137.2188 | 137.4062 | 136.875 | 137.0625 | 250500.0 |
| 2000-12-05 15:00:00 | SPY | ETF | 137.2188 | 137.9062 | 137.0 | 137.8438 | 593100.0 |
| 2000-12-05 15:30:00 | SPY | ETF | 137.8438 | 138.1875 | 137.625 | 138.125 | 712000.0 |
| 2000-12-05 16:00:00 | SPY | ETF | 138.1875 | 138.25 | 137.4062 | 137.7188 | 301100.0 |
| 2000-12-05 16:30:00 | SPY | ETF | 137.3438 | 137.7188 | 137.3125 | 137.3125 | 415700.0 |
| 2000-12-05 09:30:00 | QQQ | ETF | 66.0625 | 66.625 | 65.5 | 65.8125 | 10141300.0 |
| 2000-12-05 10:00:00 | QQQ | ETF | 65.8125 | 67.125 | 65.7812 | 67.125 | 7082800.0 |
| 2000-12-05 10:30:00 | QQQ | ETF | 67.125 | 68.8125 | 67.0 | 68.125 | 9956200.0 |
| 2000-12-05 11:00:00 | QQQ | ETF | 68.125 | 69.4375 | 67.875 | 69.1875 | 7802800.0 |
| 2000-12-05 11:30:00 | QQQ | ETF | 69.125 | 69.5625 | 68.75 | 69.375 | 4041600.0 |
| 2000-12-05 12:00:00 | QQQ | ETF | 69.4688 | 69.75 | 68.9375 | 69.125 | 3853000.0 |
| 2000-12-05 12:30:00 | QQQ | ETF | 69.125 | 69.25 | 68.0312 | 68.7188 | 6033000.0 |
| 2000-12-05 13:00:00 | QQQ | ETF | 68.7188 | 69.0625 | 68.375 | 68.6562 | 2282200.0 |
| 2000-12-05 13:30:00 | QQQ | ETF | 68.5312 | 69.3125 | 68.4688 | 68.875 | 2504000.0 |
| 2000-12-05 14:00:00 | QQQ | ETF | 69.0 | 69.625 | 68.875 | 69.5 | 2576800.0 |
| 2000-12-05 14:30:00 | QQQ | ETF | 69.5938 | 69.75 | 69.0312 | 69.5312 | 3752200.0 |
| 2000-12-05 15:00:00 | QQQ | ETF | 69.5625 | 70.625 | 69.4375 | 70.5 | 5296200.0 |
| 2000-12-05 15:30:00 | QQQ | ETF | 70.5938 | 71.0 | 70.1562 | 71.0 | 6352800.0 |
| 2000-12-05 16:00:00 | QQQ | ETF | 70.9688 | 71.0 | 70.5 | 70.625 | 1644500.0 |
| 2000-12-05 16:30:00 | QQQ | ETF | 70.75 | 70.8125 | 70.0 | 70.5 | 348300.0 |
| 2000-12-05 17:00:00 | QQQ | ETF | 70.5 | 70.75 | 70.25 | 70.75 | 26300.0 |
| 2000-12-05 17:30:00 | QQQ | ETF | 70.625 | 71.0 | 70.5 | 70.9375 | 36700.0 |
| 2000-12-05 18:00:00 | QQQ | ETF | 70.8438 | 71.0 | 70.75 | 71.0 | 26400.0 |
| 2000-12-05 09:30:00 | IWM | ETF | 45.75 | 45.9062 | 45.75 | 45.9062 | 21600.0 |
| 2000-12-05 10:00:00 | IWM | ETF | 45.75 | 46.2812 | 45.75 | 46.2812 | 35400.0 |
| 2000-12-05 10:30:00 | IWM | ETF | 46.2812 | 46.6094 | 46.2812 | 46.5 | 67200.0 |
| 2000-12-05 11:00:00 | IWM | ETF | 46.625 | 46.9375 | 46.625 | 46.9375 | 18200.0 |
| 2000-12-05 11:30:00 | IWM | ETF | 46.9375 | 46.9375 | 46.625 | 46.8906 | 46600.0 |
| 2000-12-05 12:00:00 | IWM | ETF | 46.8906 | 46.8906 | 46.6875 | 46.6875 | 27400.0 |
| 2000-12-05 12:30:00 | IWM | ETF | 46.5156 | 46.6562 | 46.5156 | 46.6562 | 2200.0 |
| 2000-12-05 13:00:00 | IWM | ETF | 46.7188 | 46.7188 | 46.7031 | 46.7031 | 800.0 |
| 2000-12-05 13:30:00 | IWM | ETF | 46.5156 | 46.6562 | 46.5156 | 46.6562 | 20400.0 |
| 2000-12-05 14:00:00 | IWM | ETF | 46.6875 | 46.75 | 46.6875 | 46.75 | 7000.0 |
| 2000-12-05 14:30:00 | IWM | ETF | 46.8125 | 46.8125 | 46.6562 | 46.6875 | 6800.0 |
| 2000-12-05 15:00:00 | IWM | ETF | 46.7188 | 47.0 | 46.7188 | 47.0 | 63600.0 |
| 2000-12-05 15:30:00 | IWM | ETF | 47.0 | 47.1875 | 46.9375 | 47.1875 | 60800.0 |
| 2000-12-05 16:00:00 | IWM | ETF | 47.1562 | 47.25 | 47.0625 | 47.25 | 12800.0 |
| 2000-12-05 09:30:00 | DIA | ETF | 107.0 | 107.1875 | 106.625 | 106.9688 | 510700.0 |
| 2000-12-05 10:00:00 | DIA | ETF | 106.875 | 107.625 | 106.875 | 107.625 | 338100.0 |
| 2000-12-05 10:30:00 | DIA | ETF | 107.6562 | 108.6875 | 107.5 | 108.1875 | 337900.0 |
> showing 50 of 331 rows — these rows as CSV