PREVIEW / etf_30min / 2005-11-25
file: by_date/etf_30min/2005/2005-11-25.parquet size: 31 KB rows: 994
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-25 06:30:00 | SPY | ETF | 126.94 | 126.94 | 126.94 | 126.94 | 1000.0 |
| 2005-11-25 07:30:00 | SPY | ETF | 126.95 | 126.95 | 126.95 | 126.95 | 500.0 |
| 2005-11-25 08:00:00 | SPY | ETF | 126.94 | 126.96 | 126.9 | 126.94 | 14400.0 |
| 2005-11-25 08:30:00 | SPY | ETF | 126.95 | 126.97 | 126.92 | 126.97 | 44700.0 |
| 2005-11-25 09:00:00 | SPY | ETF | 126.96 | 127.02 | 126.71 | 126.97 | 90500.0 |
| 2005-11-25 09:30:00 | SPY | ETF | 126.98 | 127.22 | 126.96 | 127.08 | 3317900.0 |
| 2005-11-25 10:00:00 | SPY | ETF | 127.08 | 127.17 | 126.9 | 126.91 | 1938000.0 |
| 2005-11-25 10:30:00 | SPY | ETF | 126.91 | 127.02 | 126.81 | 126.95 | 3828600.0 |
| 2005-11-25 11:00:00 | SPY | ETF | 126.94 | 127.04 | 126.94 | 126.97 | 1046900.0 |
| 2005-11-25 11:30:00 | SPY | ETF | 126.99 | 127.16 | 126.99 | 127.06 | 1066900.0 |
| 2005-11-25 12:00:00 | SPY | ETF | 127.05 | 127.15 | 127.0 | 127.12 | 825100.0 |
| 2005-11-25 12:30:00 | SPY | ETF | 127.12 | 127.19 | 127.06 | 127.1 | 1739900.0 |
| 2005-11-25 13:00:00 | SPY | ETF | 127.1 | 127.22 | 127.05 | 127.13 | 387200.0 |
| 2005-11-25 09:30:00 | QQQ | ETF | 41.84 | 41.93 | 41.81 | 41.84 | 6222600.0 |
| 2005-11-25 10:00:00 | QQQ | ETF | 41.84 | 41.88 | 41.78 | 41.78 | 2381600.0 |
| 2005-11-25 10:30:00 | QQQ | ETF | 41.79 | 41.82 | 41.73 | 41.77 | 3956700.0 |
| 2005-11-25 11:00:00 | QQQ | ETF | 41.77 | 41.81 | 41.75 | 41.77 | 1547100.0 |
| 2005-11-25 11:30:00 | QQQ | ETF | 41.77 | 41.84 | 41.77 | 41.83 | 970800.0 |
| 2005-11-25 12:00:00 | QQQ | ETF | 41.82 | 41.88 | 41.81 | 41.87 | 1713100.0 |
| 2005-11-25 12:30:00 | QQQ | ETF | 41.87 | 41.94 | 41.87 | 41.9 | 4596600.0 |
| 2005-11-25 13:00:00 | QQQ | ETF | 41.89 | 41.95 | 41.88 | 41.9 | 1183300.0 |
| 2005-11-25 13:30:00 | QQQ | ETF | 41.89 | 41.92 | 41.89 | 41.89 | 19500.0 |
| 2005-11-25 14:00:00 | QQQ | ETF | 41.89 | 41.9 | 41.89 | 41.89 | 2800.0 |
| 2005-11-25 14:30:00 | QQQ | ETF | 41.9 | 41.9 | 41.88 | 41.9 | 20400.0 |
| 2005-11-25 15:00:00 | QQQ | ETF | 41.88 | 41.9 | 41.88 | 41.88 | 7600.0 |
| 2005-11-25 08:00:00 | IWM | ETF | 67.86 | 67.86 | 67.85 | 67.86 | 7500.0 |
| 2005-11-25 08:30:00 | IWM | ETF | 67.91 | 67.91 | 67.91 | 67.91 | 3000.0 |
| 2005-11-25 09:00:00 | IWM | ETF | 67.93 | 68.0 | 67.93 | 67.99 | 16600.0 |
| 2005-11-25 09:30:00 | IWM | ETF | 67.94 | 68.0 | 67.8 | 67.92 | 1704700.0 |
| 2005-11-25 10:00:00 | IWM | ETF | 67.91 | 67.95 | 67.81 | 67.82 | 885800.0 |
| 2005-11-25 10:30:00 | IWM | ETF | 67.81 | 67.88 | 67.77 | 67.8 | 855700.0 |
| 2005-11-25 11:00:00 | IWM | ETF | 67.8 | 67.92 | 67.8 | 67.9 | 981100.0 |
| 2005-11-25 11:30:00 | IWM | ETF | 67.9 | 68.03 | 67.88 | 67.98 | 348200.0 |
| 2005-11-25 12:00:00 | IWM | ETF | 67.97 | 68.08 | 67.89 | 68.06 | 332900.0 |
| 2005-11-25 12:30:00 | IWM | ETF | 68.06 | 68.13 | 68.0 | 68.0 | 566200.0 |
| 2005-11-25 13:00:00 | IWM | ETF | 68.01 | 68.05 | 67.96 | 67.96 | 42000.0 |
| 2005-11-25 08:00:00 | DIA | ETF | 109.21 | 109.21 | 109.17 | 109.2 | 7300.0 |
| 2005-11-25 09:00:00 | DIA | ETF | 109.21 | 109.23 | 109.21 | 109.23 | 20100.0 |
| 2005-11-25 09:30:00 | DIA | ETF | 109.22 | 109.5 | 109.22 | 109.4 | 482200.0 |
| 2005-11-25 10:00:00 | DIA | ETF | 109.4 | 109.49 | 109.28 | 109.28 | 398100.0 |
| 2005-11-25 10:30:00 | DIA | ETF | 109.3 | 109.32 | 109.23 | 109.27 | 177400.0 |
| 2005-11-25 11:00:00 | DIA | ETF | 109.27 | 109.35 | 109.27 | 109.32 | 60000.0 |
| 2005-11-25 11:30:00 | DIA | ETF | 109.33 | 109.38 | 109.32 | 109.33 | 78400.0 |
| 2005-11-25 12:00:00 | DIA | ETF | 109.32 | 109.38 | 109.26 | 109.35 | 85000.0 |
| 2005-11-25 12:30:00 | DIA | ETF | 109.35 | 109.36 | 109.2888 | 109.32 | 121900.0 |
| 2005-11-25 13:00:00 | DIA | ETF | 109.32 | 109.36 | 109.3 | 109.33 | 16800.0 |
| 2005-11-25 08:00:00 | GLD | ETF | 49.18 | 49.18 | 49.18 | 49.18 | 100.0 |
| 2005-11-25 09:00:00 | GLD | ETF | 49.5 | 49.5 | 49.5 | 49.5 | 1100.0 |
| 2005-11-25 09:30:00 | GLD | ETF | 49.45 | 49.5 | 49.4 | 49.44 | 164000.0 |
| 2005-11-25 10:00:00 | GLD | ETF | 49.45 | 49.45 | 49.38 | 49.38 | 81500.0 |
> showing 50 of 994 rows — these rows as CSV