PREVIEW / etf_30min / 2005-05-23
file: by_date/etf_30min/2005/2005-05-23.parquet size: 43 KB rows: 1,526
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-05-23 07:00:00 | SPY | ETF | 119.29 | 119.29 | 119.26 | 119.26 | 7800.0 |
| 2005-05-23 07:30:00 | SPY | ETF | 119.3 | 119.4 | 119.3 | 119.32 | 220800.0 |
| 2005-05-23 08:00:00 | SPY | ETF | 119.32 | 119.36 | 119.26 | 119.3 | 31300.0 |
| 2005-05-23 08:30:00 | SPY | ETF | 119.31 | 119.33 | 119.24 | 119.26 | 72300.0 |
| 2005-05-23 09:00:00 | SPY | ETF | 119.24 | 119.24 | 119.18 | 119.2 | 102100.0 |
| 2005-05-23 09:30:00 | SPY | ETF | 119.21 | 119.53 | 119.19 | 119.51 | 6314300.0 |
| 2005-05-23 10:00:00 | SPY | ETF | 119.51 | 119.58 | 119.41 | 119.51 | 5463100.0 |
| 2005-05-23 10:30:00 | SPY | ETF | 119.52 | 119.67 | 119.28 | 119.35 | 6591100.0 |
| 2005-05-23 11:00:00 | SPY | ETF | 119.34 | 119.43 | 119.2 | 119.41 | 5114400.0 |
| 2005-05-23 11:30:00 | SPY | ETF | 119.41 | 119.52 | 119.3 | 119.51 | 1786800.0 |
| 2005-05-23 12:00:00 | SPY | ETF | 119.5 | 119.59 | 119.47 | 119.52 | 1999900.0 |
| 2005-05-23 12:30:00 | SPY | ETF | 119.52 | 119.69 | 119.44 | 119.53 | 1912400.0 |
| 2005-05-23 13:00:00 | SPY | ETF | 119.52 | 119.63 | 119.39 | 119.5 | 1483200.0 |
| 2005-05-23 13:30:00 | SPY | ETF | 119.49 | 119.6 | 119.39 | 119.54 | 1295200.0 |
| 2005-05-23 14:00:00 | SPY | ETF | 119.53 | 119.95 | 119.44 | 119.85 | 3676300.0 |
| 2005-05-23 14:30:00 | SPY | ETF | 119.84 | 120.04 | 119.79 | 119.97 | 3467600.0 |
| 2005-05-23 15:00:00 | SPY | ETF | 119.97 | 120.03 | 119.79 | 119.81 | 3310400.0 |
| 2005-05-23 15:30:00 | SPY | ETF | 119.79 | 119.98 | 119.6 | 119.65 | 6488200.0 |
| 2005-05-23 16:00:00 | SPY | ETF | 119.68 | 119.82 | 119.63 | 119.81 | 414500.0 |
| 2005-05-23 16:30:00 | SPY | ETF | 119.78 | 119.78 | 119.71 | 119.74 | 154200.0 |
| 2005-05-23 17:00:00 | SPY | ETF | 119.74 | 119.76 | 119.73 | 119.73 | 23900.0 |
| 2005-05-23 17:30:00 | SPY | ETF | 119.74 | 119.75 | 119.73 | 119.73 | 1300.0 |
| 2005-05-23 18:00:00 | SPY | ETF | 119.72 | 119.72 | 119.7 | 119.7 | 4700.0 |
| 2005-05-23 18:30:00 | SPY | ETF | 119.72 | 119.72 | 119.7 | 119.7 | 1000.0 |
| 2005-05-23 19:00:00 | SPY | ETF | 119.7 | 119.7 | 119.7 | 119.7 | 1600.0 |
| 2005-05-23 09:30:00 | QQQ | ETF | 37.66 | 37.83 | 37.64 | 37.81 | 11604100.0 |
| 2005-05-23 10:00:00 | QQQ | ETF | 37.81 | 37.84 | 37.77 | 37.8 | 5300000.0 |
| 2005-05-23 10:30:00 | QQQ | ETF | 37.8 | 37.88 | 37.66 | 37.67 | 9561200.0 |
| 2005-05-23 11:00:00 | QQQ | ETF | 37.67 | 37.73 | 37.6 | 37.71 | 5561000.0 |
| 2005-05-23 11:30:00 | QQQ | ETF | 37.71 | 37.77 | 37.68 | 37.76 | 3261500.0 |
| 2005-05-23 12:00:00 | QQQ | ETF | 37.76 | 37.79 | 37.74 | 37.76 | 3399700.0 |
| 2005-05-23 12:30:00 | QQQ | ETF | 37.76 | 37.85 | 37.73 | 37.76 | 6534200.0 |
| 2005-05-23 13:00:00 | QQQ | ETF | 37.76 | 37.84 | 37.74 | 37.78 | 2765900.0 |
| 2005-05-23 13:30:00 | QQQ | ETF | 37.78 | 37.84 | 37.76 | 37.82 | 2074900.0 |
| 2005-05-23 14:00:00 | QQQ | ETF | 37.82 | 37.93 | 37.79 | 37.9 | 6780700.0 |
| 2005-05-23 14:30:00 | QQQ | ETF | 37.9 | 37.99 | 37.86 | 37.94 | 7092100.0 |
| 2005-05-23 15:00:00 | QQQ | ETF | 37.95 | 37.96 | 37.87 | 37.87 | 8029100.0 |
| 2005-05-23 15:30:00 | QQQ | ETF | 37.88 | 37.95 | 37.8 | 37.84 | 16426200.0 |
| 2005-05-23 08:30:00 | IWM | ETF | 60.73 | 60.74 | 60.73 | 60.74 | 8400.0 |
| 2005-05-23 09:00:00 | IWM | ETF | 60.66 | 60.66 | 60.61 | 60.61 | 40600.0 |
| 2005-05-23 09:30:00 | IWM | ETF | 60.675 | 60.95 | 60.62 | 60.945 | 2603400.0 |
| 2005-05-23 10:00:00 | IWM | ETF | 60.95 | 60.99 | 60.875 | 60.905 | 2068800.0 |
| 2005-05-23 10:30:00 | IWM | ETF | 60.91 | 61.025 | 60.78 | 60.835 | 1585400.0 |
| 2005-05-23 11:00:00 | IWM | ETF | 60.835 | 60.875 | 60.66 | 60.82 | 1165800.0 |
| 2005-05-23 11:30:00 | IWM | ETF | 60.845 | 60.925 | 60.785 | 60.915 | 1561800.0 |
| 2005-05-23 12:00:00 | IWM | ETF | 60.915 | 60.95 | 60.83 | 60.87 | 666800.0 |
| 2005-05-23 12:30:00 | IWM | ETF | 60.95 | 60.995 | 60.84 | 60.9 | 930400.0 |
| 2005-05-23 13:00:00 | IWM | ETF | 60.9 | 60.98 | 60.835 | 60.895 | 1059800.0 |
| 2005-05-23 13:30:00 | IWM | ETF | 60.895 | 60.945 | 60.815 | 60.91 | 391200.0 |
| 2005-05-23 14:00:00 | IWM | ETF | 60.915 | 61.2 | 60.86 | 61.16 | 1217400.0 |
> showing 50 of 1,526 rows — these rows as CSV