PREVIEW / etf_30min / 2005-08-30
file: by_date/etf_30min/2005/2005-08-30.parquet size: 46 KB rows: 1,625
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-08-30 07:00:00 | SPY | ETF | 121.39 | 121.39 | 121.32 | 121.39 | 52700.0 |
| 2005-08-30 07:30:00 | SPY | ETF | 121.37 | 121.39 | 121.3 | 121.39 | 121800.0 |
| 2005-08-30 08:00:00 | SPY | ETF | 121.34 | 121.62 | 121.27 | 121.37 | 563600.0 |
| 2005-08-30 08:30:00 | SPY | ETF | 121.36 | 121.36 | 121.27 | 121.32 | 464100.0 |
| 2005-08-30 09:00:00 | SPY | ETF | 121.33 | 121.35 | 121.26 | 121.27 | 577100.0 |
| 2005-08-30 09:30:00 | SPY | ETF | 121.25 | 121.28 | 120.96 | 120.99 | 6531100.0 |
| 2005-08-30 10:00:00 | SPY | ETF | 121.0 | 121.3 | 120.87 | 120.92 | 6251900.0 |
| 2005-08-30 10:30:00 | SPY | ETF | 120.92 | 121.02 | 120.59 | 120.83 | 6443200.0 |
| 2005-08-30 11:00:00 | SPY | ETF | 120.84 | 120.85 | 120.5 | 120.79 | 4862100.0 |
| 2005-08-30 11:30:00 | SPY | ETF | 120.78 | 120.85 | 120.58 | 120.62 | 5046900.0 |
| 2005-08-30 12:00:00 | SPY | ETF | 120.64 | 121.04 | 120.57 | 120.93 | 6432800.0 |
| 2005-08-30 12:30:00 | SPY | ETF | 120.93 | 121.01 | 120.83 | 120.93 | 2709300.0 |
| 2005-08-30 13:00:00 | SPY | ETF | 120.93 | 120.93 | 120.7915 | 120.9 | 980700.0 |
| 2005-08-30 13:30:00 | SPY | ETF | 120.9 | 121.19 | 120.89 | 121.02 | 4116200.0 |
| 2005-08-30 14:00:00 | SPY | ETF | 121.02 | 121.05 | 120.6 | 120.71 | 5946100.0 |
| 2005-08-30 14:30:00 | SPY | ETF | 120.74 | 120.85 | 120.45 | 120.46 | 3585000.0 |
| 2005-08-30 15:00:00 | SPY | ETF | 120.47 | 120.81 | 120.39 | 120.66 | 6283000.0 |
| 2005-08-30 15:30:00 | SPY | ETF | 120.67 | 121.24 | 120.66 | 121.18 | 10489300.0 |
| 2005-08-30 16:00:00 | SPY | ETF | 121.2 | 121.23 | 121.05 | 121.08 | 876900.0 |
| 2005-08-30 16:30:00 | SPY | ETF | 121.07 | 121.11 | 121.03 | 121.07 | 365200.0 |
| 2005-08-30 17:00:00 | SPY | ETF | 121.09 | 121.09 | 120.93 | 120.96 | 158800.0 |
| 2005-08-30 17:30:00 | SPY | ETF | 121.0 | 121.02 | 120.96 | 120.96 | 4400.0 |
| 2005-08-30 18:00:00 | SPY | ETF | 120.94 | 120.95 | 120.83 | 120.86 | 17600.0 |
| 2005-08-30 18:30:00 | SPY | ETF | 120.85 | 120.88 | 120.83 | 120.85 | 138800.0 |
| 2005-08-30 19:00:00 | SPY | ETF | 120.85 | 120.89 | 120.85 | 120.89 | 3700.0 |
| 2005-08-30 19:30:00 | SPY | ETF | 120.88 | 120.89 | 120.88 | 120.89 | 3700.0 |
| 2005-08-30 09:30:00 | QQQ | ETF | 38.56 | 38.59 | 38.49 | 38.53 | 9855600.0 |
| 2005-08-30 10:00:00 | QQQ | ETF | 38.53 | 38.62 | 38.47 | 38.5 | 9190700.0 |
| 2005-08-30 10:30:00 | QQQ | ETF | 38.5 | 38.51 | 38.34 | 38.42 | 10439400.0 |
| 2005-08-30 11:00:00 | QQQ | ETF | 38.42 | 38.44 | 38.32 | 38.42 | 6786800.0 |
| 2005-08-30 11:30:00 | QQQ | ETF | 38.42 | 38.45 | 38.34 | 38.35 | 5524700.0 |
| 2005-08-30 12:00:00 | QQQ | ETF | 38.35 | 38.52 | 38.33 | 38.47 | 5701700.0 |
| 2005-08-30 12:30:00 | QQQ | ETF | 38.47 | 38.5 | 38.43 | 38.47 | 2772700.0 |
| 2005-08-30 13:00:00 | QQQ | ETF | 38.47 | 38.48 | 38.4 | 38.47 | 2536400.0 |
| 2005-08-30 13:30:00 | QQQ | ETF | 38.47 | 38.57 | 38.47 | 38.51 | 4319400.0 |
| 2005-08-30 14:00:00 | QQQ | ETF | 38.52 | 38.52 | 38.38 | 38.42 | 4702500.0 |
| 2005-08-30 14:30:00 | QQQ | ETF | 38.42 | 38.46 | 38.34 | 38.35 | 5809900.0 |
| 2005-08-30 15:00:00 | QQQ | ETF | 38.35 | 38.45 | 38.33 | 38.41 | 4676100.0 |
| 2005-08-30 15:30:00 | QQQ | ETF | 38.4 | 38.64 | 38.4 | 38.64 | 10543800.0 |
| 2005-08-30 07:30:00 | IWM | ETF | 65.23 | 65.23 | 65.18 | 65.18 | 2200.0 |
| 2005-08-30 08:00:00 | IWM | ETF | 65.22 | 65.22 | 65.2 | 65.2 | 100500.0 |
| 2005-08-30 08:30:00 | IWM | ETF | 65.2 | 65.2 | 65.14 | 65.18 | 12700.0 |
| 2005-08-30 09:00:00 | IWM | ETF | 65.14 | 65.15 | 65.09 | 65.09 | 42800.0 |
| 2005-08-30 09:30:00 | IWM | ETF | 65.12 | 65.2 | 64.83 | 65.03 | 2340000.0 |
| 2005-08-30 10:00:00 | IWM | ETF | 65.03 | 65.27 | 65.03 | 65.11 | 2314000.0 |
| 2005-08-30 10:30:00 | IWM | ETF | 65.1 | 65.19 | 64.85 | 65.04 | 2575800.0 |
| 2005-08-30 11:00:00 | IWM | ETF | 65.04 | 65.04 | 64.73 | 64.85 | 1743200.0 |
| 2005-08-30 11:30:00 | IWM | ETF | 64.85 | 64.93 | 64.77 | 64.92 | 918900.0 |
| 2005-08-30 12:00:00 | IWM | ETF | 64.91 | 65.13 | 64.88 | 65.03 | 1092200.0 |
| 2005-08-30 12:30:00 | IWM | ETF | 65.03 | 65.12 | 64.99 | 65.0 | 355600.0 |
> showing 50 of 1,625 rows — these rows as CSV