PREVIEW / etf_30min / 2005-08-29
file: by_date/etf_30min/2005/2005-08-29.parquet size: 47 KB rows: 1,619
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-29 06:30:00 | SPY | ETF | 120.2 | 120.2 | 120.17 | 120.17 | 1000.0 |
| 2005-08-29 07:00:00 | SPY | ETF | 120.2 | 120.21 | 120.12 | 120.14 | 173800.0 |
| 2005-08-29 07:30:00 | SPY | ETF | 120.15 | 120.17 | 120.1 | 120.14 | 69100.0 |
| 2005-08-29 08:00:00 | SPY | ETF | 120.14 | 120.58 | 120.1 | 120.4 | 510000.0 |
| 2005-08-29 08:30:00 | SPY | ETF | 119.9 | 120.47 | 119.6 | 120.4 | 1164300.0 |
| 2005-08-29 09:00:00 | SPY | ETF | 120.4 | 120.44 | 120.13 | 120.39 | 392300.0 |
| 2005-08-29 09:30:00 | SPY | ETF | 120.41 | 120.69 | 120.38 | 120.67 | 5904000.0 |
| 2005-08-29 10:00:00 | SPY | ETF | 120.68 | 121.16 | 120.55 | 120.96 | 7857400.0 |
| 2005-08-29 10:30:00 | SPY | ETF | 120.93 | 121.05 | 120.73 | 120.78 | 4955900.0 |
| 2005-08-29 11:00:00 | SPY | ETF | 120.78 | 120.95 | 120.73 | 120.85 | 1723600.0 |
| 2005-08-29 11:30:00 | SPY | ETF | 120.85 | 121.07 | 120.82 | 120.93 | 2154200.0 |
| 2005-08-29 12:00:00 | SPY | ETF | 120.95 | 121.03 | 120.84 | 120.99 | 1305500.0 |
| 2005-08-29 12:30:00 | SPY | ETF | 120.99 | 121.02 | 120.86 | 120.95 | 1749100.0 |
| 2005-08-29 13:00:00 | SPY | ETF | 120.97 | 121.4 | 120.95 | 121.29 | 7472800.0 |
| 2005-08-29 13:30:00 | SPY | ETF | 121.29 | 121.64 | 121.23 | 121.56 | 3221000.0 |
| 2005-08-29 14:00:00 | SPY | ETF | 121.56 | 121.59 | 121.38 | 121.48 | 2794900.0 |
| 2005-08-29 14:30:00 | SPY | ETF | 121.49 | 121.59 | 121.41 | 121.49 | 2014500.0 |
| 2005-08-29 15:00:00 | SPY | ETF | 121.48 | 121.78 | 121.45 | 121.71 | 5072100.0 |
| 2005-08-29 15:30:00 | SPY | ETF | 121.7 | 121.72 | 121.55 | 121.6 | 3622700.0 |
| 2005-08-29 16:00:00 | SPY | ETF | 121.59 | 128.6 | 121.44 | 121.65 | 2419500.0 |
| 2005-08-29 16:30:00 | SPY | ETF | 121.66 | 121.66 | 121.2559 | 121.65 | 352600.0 |
| 2005-08-29 17:00:00 | SPY | ETF | 121.65 | 121.66 | 121.65 | 121.66 | 2600.0 |
| 2005-08-29 17:30:00 | SPY | ETF | 121.66 | 121.67 | 121.66 | 121.67 | 700.0 |
| 2005-08-29 18:00:00 | SPY | ETF | 121.69 | 121.7 | 121.68 | 121.68 | 4200.0 |
| 2005-08-29 19:30:00 | SPY | ETF | 121.64 | 121.65 | 121.63 | 121.63 | 20600.0 |
| 2005-08-29 09:30:00 | QQQ | ETF | 38.26 | 38.43 | 38.26 | 38.42 | 9825300.0 |
| 2005-08-29 10:00:00 | QQQ | ETF | 38.42 | 38.59 | 38.39 | 38.55 | 9455300.0 |
| 2005-08-29 10:30:00 | QQQ | ETF | 38.55 | 38.6 | 38.45 | 38.48 | 5052400.0 |
| 2005-08-29 11:00:00 | QQQ | ETF | 38.49 | 38.55 | 38.47 | 38.49 | 2663700.0 |
| 2005-08-29 11:30:00 | QQQ | ETF | 38.5 | 38.55 | 38.49 | 38.51 | 2372200.0 |
| 2005-08-29 12:00:00 | QQQ | ETF | 38.51 | 38.58 | 38.47 | 38.56 | 2565000.0 |
| 2005-08-29 12:30:00 | QQQ | ETF | 38.56 | 38.57 | 38.5 | 38.55 | 1564400.0 |
| 2005-08-29 13:00:00 | QQQ | ETF | 38.54 | 38.74 | 38.54 | 38.68 | 7619400.0 |
| 2005-08-29 13:30:00 | QQQ | ETF | 38.68 | 38.84 | 38.66 | 38.83 | 7236400.0 |
| 2005-08-29 14:00:00 | QQQ | ETF | 38.83 | 38.84 | 38.71 | 38.75 | 4298500.0 |
| 2005-08-29 14:30:00 | QQQ | ETF | 38.75 | 38.79 | 38.71 | 38.76 | 3037600.0 |
| 2005-08-29 15:00:00 | QQQ | ETF | 38.76 | 38.85 | 38.73 | 38.8 | 4965900.0 |
| 2005-08-29 15:30:00 | QQQ | ETF | 38.79 | 38.82 | 38.74 | 38.74 | 6754400.0 |
| 2005-08-29 07:30:00 | IWM | ETF | 64.18 | 64.18 | 64.15 | 64.15 | 1000.0 |
| 2005-08-29 08:00:00 | IWM | ETF | 64.13 | 64.3 | 64.1 | 64.26 | 31700.0 |
| 2005-08-29 08:30:00 | IWM | ETF | 64.23 | 64.3 | 64.23 | 64.23 | 22400.0 |
| 2005-08-29 09:00:00 | IWM | ETF | 64.2 | 64.44 | 64.2 | 64.44 | 157800.0 |
| 2005-08-29 09:30:00 | IWM | ETF | 64.43 | 64.45 | 64.2 | 64.35 | 2942300.0 |
| 2005-08-29 10:00:00 | IWM | ETF | 64.33 | 64.6 | 64.24 | 64.43 | 2530500.0 |
| 2005-08-29 10:30:00 | IWM | ETF | 64.43 | 64.5 | 64.36 | 64.41 | 1077800.0 |
| 2005-08-29 11:00:00 | IWM | ETF | 64.39 | 64.53 | 64.36 | 64.46 | 1362100.0 |
| 2005-08-29 11:30:00 | IWM | ETF | 64.48 | 64.64 | 64.46 | 64.58 | 1552100.0 |
| 2005-08-29 12:00:00 | IWM | ETF | 64.58 | 64.71 | 64.56 | 64.71 | 794500.0 |
| 2005-08-29 12:30:00 | IWM | ETF | 64.69 | 64.7 | 64.6 | 64.66 | 202500.0 |
| 2005-08-29 13:00:00 | IWM | ETF | 64.66 | 65.06 | 64.66 | 64.92 | 2757500.0 |
> showing 50 of 1,619 rows — these rows as CSV