PREVIEW / etf_30min / 2005-08-25
file: by_date/etf_30min/2005/2005-08-25.parquet size: 43 KB rows: 1,571
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-25 07:00:00 | SPY | ETF | 121.37 | 121.42 | 121.37 | 121.4 | 68100.0 |
| 2005-08-25 07:30:00 | SPY | ETF | 121.36 | 121.36 | 121.27 | 121.32 | 84300.0 |
| 2005-08-25 08:00:00 | SPY | ETF | 121.32 | 121.41 | 121.28 | 121.33 | 559500.0 |
| 2005-08-25 08:30:00 | SPY | ETF | 121.34 | 122.33 | 121.33 | 121.44 | 409600.0 |
| 2005-08-25 09:00:00 | SPY | ETF | 121.44 | 122.32 | 121.32 | 121.36 | 258100.0 |
| 2005-08-25 09:30:00 | SPY | ETF | 121.35 | 121.49 | 121.21 | 121.27 | 4752600.0 |
| 2005-08-25 10:00:00 | SPY | ETF | 121.26 | 121.45 | 121.25 | 121.42 | 2999900.0 |
| 2005-08-25 10:30:00 | SPY | ETF | 121.41 | 121.58 | 121.4 | 121.5 | 3719300.0 |
| 2005-08-25 11:00:00 | SPY | ETF | 121.5 | 121.62 | 121.49 | 121.52 | 2777600.0 |
| 2005-08-25 11:30:00 | SPY | ETF | 121.55 | 121.57 | 121.36 | 121.48 | 2835600.0 |
| 2005-08-25 12:00:00 | SPY | ETF | 121.48 | 121.55 | 121.33 | 121.37 | 1325500.0 |
| 2005-08-25 12:30:00 | SPY | ETF | 121.38 | 121.49 | 121.28 | 121.4 | 2094800.0 |
| 2005-08-25 13:00:00 | SPY | ETF | 121.41 | 121.47 | 121.28 | 121.41 | 1599900.0 |
| 2005-08-25 13:30:00 | SPY | ETF | 121.4 | 121.48 | 121.32 | 121.37 | 1128800.0 |
| 2005-08-25 14:00:00 | SPY | ETF | 121.37 | 121.63 | 121.3 | 121.61 | 2311900.0 |
| 2005-08-25 14:30:00 | SPY | ETF | 121.61 | 121.66 | 121.5 | 121.66 | 2091600.0 |
| 2005-08-25 15:00:00 | SPY | ETF | 121.67 | 121.67 | 121.35 | 121.38 | 2278400.0 |
| 2005-08-25 15:30:00 | SPY | ETF | 121.39 | 121.59 | 121.33 | 121.53 | 2591800.0 |
| 2005-08-25 16:00:00 | SPY | ETF | 121.53 | 121.65 | 121.51 | 121.6 | 735600.0 |
| 2005-08-25 16:30:00 | SPY | ETF | 121.4468 | 121.57 | 121.4468 | 121.54 | 300600.0 |
| 2005-08-25 17:00:00 | SPY | ETF | 121.53 | 121.55 | 121.52 | 121.52 | 4500.0 |
| 2005-08-25 17:30:00 | SPY | ETF | 121.55 | 121.58 | 121.55 | 121.55 | 2900.0 |
| 2005-08-25 18:00:00 | SPY | ETF | 121.55 | 121.55 | 121.53 | 121.53 | 3500.0 |
| 2005-08-25 18:30:00 | SPY | ETF | 121.53 | 121.53 | 121.53 | 121.53 | 1400.0 |
| 2005-08-25 19:30:00 | SPY | ETF | 121.55 | 121.58 | 121.55 | 121.58 | 4000.0 |
| 2005-08-25 09:30:00 | QQQ | ETF | 38.56 | 38.62 | 38.49 | 38.54 | 7804400.0 |
| 2005-08-25 10:00:00 | QQQ | ETF | 38.54 | 38.62 | 38.52 | 38.6 | 4811600.0 |
| 2005-08-25 10:30:00 | QQQ | ETF | 38.61 | 38.67 | 38.6 | 38.64 | 5342000.0 |
| 2005-08-25 11:00:00 | QQQ | ETF | 38.64 | 38.69 | 38.64 | 38.64 | 3781800.0 |
| 2005-08-25 11:30:00 | QQQ | ETF | 38.65 | 38.65 | 38.56 | 38.6 | 2918300.0 |
| 2005-08-25 12:00:00 | QQQ | ETF | 38.59 | 38.62 | 38.55 | 38.56 | 2156900.0 |
| 2005-08-25 12:30:00 | QQQ | ETF | 38.56 | 38.61 | 38.5 | 38.57 | 2580700.0 |
| 2005-08-25 13:00:00 | QQQ | ETF | 38.57 | 38.6 | 38.54 | 38.58 | 2790600.0 |
| 2005-08-25 13:30:00 | QQQ | ETF | 38.58 | 38.6 | 38.55 | 38.56 | 1767800.0 |
| 2005-08-25 14:00:00 | QQQ | ETF | 38.55 | 38.67 | 38.53 | 38.66 | 2691400.0 |
| 2005-08-25 14:30:00 | QQQ | ETF | 38.66 | 38.67 | 38.6 | 38.65 | 2685400.0 |
| 2005-08-25 15:00:00 | QQQ | ETF | 38.65 | 38.65 | 38.55 | 38.57 | 3420600.0 |
| 2005-08-25 15:30:00 | QQQ | ETF | 38.57 | 38.62 | 38.56 | 38.59 | 3806000.0 |
| 2005-08-25 08:30:00 | IWM | ETF | 65.31 | 65.37 | 65.31 | 65.35 | 9900.0 |
| 2005-08-25 09:00:00 | IWM | ETF | 65.35 | 65.38 | 65.31 | 65.31 | 7300.0 |
| 2005-08-25 09:30:00 | IWM | ETF | 65.34 | 65.54 | 65.18 | 65.26 | 2322000.0 |
| 2005-08-25 10:00:00 | IWM | ETF | 65.25 | 65.47 | 65.22 | 65.45 | 1212600.0 |
| 2005-08-25 10:30:00 | IWM | ETF | 65.46 | 65.55 | 65.41 | 65.49 | 1295300.0 |
| 2005-08-25 11:00:00 | IWM | ETF | 65.5 | 65.68 | 65.49 | 65.6 | 1039600.0 |
| 2005-08-25 11:30:00 | IWM | ETF | 65.59 | 65.6 | 65.46 | 65.56 | 334400.0 |
| 2005-08-25 12:00:00 | IWM | ETF | 65.55 | 65.58 | 65.44 | 65.48 | 296700.0 |
| 2005-08-25 12:30:00 | IWM | ETF | 65.48 | 65.54 | 65.39 | 65.46 | 696100.0 |
| 2005-08-25 13:00:00 | IWM | ETF | 65.47 | 65.59 | 65.38 | 65.45 | 451300.0 |
| 2005-08-25 13:30:00 | IWM | ETF | 65.45 | 65.54 | 65.33 | 65.44 | 276300.0 |
| 2005-08-25 14:00:00 | IWM | ETF | 65.44 | 65.55 | 65.35 | 65.55 | 680400.0 |
> showing 50 of 1,571 rows — these rows as CSV