PREVIEW / etf_30min / 2005-04-28
file: by_date/etf_30min/2005/2005-04-28.parquet size: 45 KB rows: 1,514
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-04-28 04:30:00 | SPY | ETF | 115.6 | 115.62 | 115.6 | 115.62 | 3800.0 |
| 2005-04-28 05:00:00 | SPY | ETF | 115.62 | 115.62 | 115.62 | 115.62 | 400.0 |
| 2005-04-28 05:30:00 | SPY | ETF | 115.6 | 115.6 | 115.6 | 115.6 | 5000.0 |
| 2005-04-28 06:30:00 | SPY | ETF | 115.34 | 115.34 | 115.34 | 115.34 | 400.0 |
| 2005-04-28 07:00:00 | SPY | ETF | 115.34 | 115.5 | 115.33 | 115.46 | 40200.0 |
| 2005-04-28 07:30:00 | SPY | ETF | 115.47 | 115.52 | 115.4 | 115.45 | 86100.0 |
| 2005-04-28 08:00:00 | SPY | ETF | 115.44 | 115.68 | 115.4 | 115.68 | 235000.0 |
| 2005-04-28 08:30:00 | SPY | ETF | 115.44 | 115.47 | 115.19 | 115.26 | 973500.0 |
| 2005-04-28 09:00:00 | SPY | ETF | 115.28 | 115.37 | 115.25 | 115.27 | 284000.0 |
| 2005-04-28 09:30:00 | SPY | ETF | 115.27 | 115.45 | 114.83 | 114.95 | 7248700.0 |
| 2005-04-28 10:00:00 | SPY | ETF | 114.95 | 115.46 | 114.89 | 115.44 | 7720700.0 |
| 2005-04-28 10:30:00 | SPY | ETF | 115.44 | 115.68 | 115.16 | 115.27 | 5184900.0 |
| 2005-04-28 11:00:00 | SPY | ETF | 115.31 | 115.44 | 115.21 | 115.23 | 2489400.0 |
| 2005-04-28 11:30:00 | SPY | ETF | 115.22 | 115.24 | 115.0 | 115.068 | 3601100.0 |
| 2005-04-28 12:00:00 | SPY | ETF | 115.05 | 115.43 | 114.85 | 115.03 | 3101700.0 |
| 2005-04-28 12:30:00 | SPY | ETF | 115.04 | 115.2 | 115.02 | 115.09 | 2114200.0 |
| 2005-04-28 13:00:00 | SPY | ETF | 115.1 | 115.13 | 114.94 | 114.99 | 1893000.0 |
| 2005-04-28 13:30:00 | SPY | ETF | 115.0 | 115.35 | 114.9 | 115.32 | 3486500.0 |
| 2005-04-28 14:00:00 | SPY | ETF | 115.32 | 115.35 | 114.51 | 114.65 | 6614800.0 |
| 2005-04-28 14:30:00 | SPY | ETF | 114.64 | 114.81 | 114.47 | 114.79 | 8953500.0 |
| 2005-04-28 15:00:00 | SPY | ETF | 114.78 | 114.87 | 114.59 | 114.72 | 5878300.0 |
| 2005-04-28 15:30:00 | SPY | ETF | 114.72 | 114.75 | 114.35 | 114.4 | 7925100.0 |
| 2005-04-28 16:00:00 | SPY | ETF | 114.35 | 114.878 | 114.06 | 114.37 | 2228900.0 |
| 2005-04-28 16:30:00 | SPY | ETF | 114.38 | 114.4 | 114.2 | 114.29 | 714600.0 |
| 2005-04-28 17:00:00 | SPY | ETF | 114.3 | 114.32 | 114.15 | 114.22 | 90200.0 |
| 2005-04-28 17:30:00 | SPY | ETF | 114.22 | 114.22 | 114.15 | 114.16 | 17100.0 |
| 2005-04-28 18:00:00 | SPY | ETF | 114.19 | 114.23 | 114.18 | 114.23 | 6500.0 |
| 2005-04-28 18:30:00 | SPY | ETF | 114.21 | 114.21 | 114.21 | 114.21 | 50000.0 |
| 2005-04-28 19:00:00 | SPY | ETF | 114.23 | 114.24 | 114.23 | 114.24 | 200.0 |
| 2005-04-28 19:30:00 | SPY | ETF | 114.24 | 114.24 | 114.24 | 114.24 | 1100.0 |
| 2005-04-28 09:30:00 | QQQ | ETF | 34.92 | 35.07 | 34.87 | 34.93 | 14536200.0 |
| 2005-04-28 10:00:00 | QQQ | ETF | 34.93 | 35.1 | 34.85 | 35.02 | 7930300.0 |
| 2005-04-28 10:30:00 | QQQ | ETF | 35.02 | 35.15 | 34.92 | 34.97 | 7574500.0 |
| 2005-04-28 11:00:00 | QQQ | ETF | 34.97 | 35.05 | 34.94 | 34.97 | 3784100.0 |
| 2005-04-28 11:30:00 | QQQ | ETF | 34.96 | 34.97 | 34.83 | 34.87 | 7890200.0 |
| 2005-04-28 12:00:00 | QQQ | ETF | 34.87 | 34.92 | 34.8 | 34.87 | 4178200.0 |
| 2005-04-28 12:30:00 | QQQ | ETF | 34.87 | 34.97 | 34.87 | 34.91 | 2746400.0 |
| 2005-04-28 13:00:00 | QQQ | ETF | 34.91 | 34.93 | 34.85 | 34.87 | 2102600.0 |
| 2005-04-28 13:30:00 | QQQ | ETF | 34.87 | 35.91 | 34.83 | 35.01 | 4208300.0 |
| 2005-04-28 14:00:00 | QQQ | ETF | 35.02 | 35.05 | 34.77 | 34.81 | 8454100.0 |
| 2005-04-28 14:30:00 | QQQ | ETF | 34.81 | 34.85 | 34.72 | 34.82 | 9090300.0 |
| 2005-04-28 15:00:00 | QQQ | ETF | 34.82 | 34.85 | 34.76 | 34.82 | 5064800.0 |
| 2005-04-28 15:30:00 | QQQ | ETF | 34.81 | 34.84 | 34.72 | 34.75 | 10834900.0 |
| 2005-04-28 08:30:00 | IWM | ETF | 58.21 | 58.21 | 58.025 | 58.055 | 28200.0 |
| 2005-04-28 09:00:00 | IWM | ETF | 58.025 | 58.15 | 58.02 | 58.145 | 16400.0 |
| 2005-04-28 09:30:00 | IWM | ETF | 58.135 | 58.15 | 57.695 | 57.781 | 2578600.0 |
| 2005-04-28 10:00:00 | IWM | ETF | 57.78 | 58.015 | 57.68 | 57.985 | 1948000.0 |
| 2005-04-28 10:30:00 | IWM | ETF | 57.995 | 58.15 | 57.78 | 57.83 | 2790400.0 |
| 2005-04-28 11:00:00 | IWM | ETF | 57.825 | 57.99 | 57.75 | 57.785 | 924600.0 |
| 2005-04-28 11:30:00 | IWM | ETF | 57.785 | 57.785 | 57.595 | 57.67 | 2705800.0 |
> showing 50 of 1,514 rows — these rows as CSV