PREVIEW / etf_30min / 2004-11-19
file: by_date/etf_30min/2004/2004-11-19.parquet size: 40 KB rows: 1,351
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-19 08:00:00 | SPY | ETF | 118.65 | 118.65 | 118.61 | 118.61 | 5000.0 |
| 2004-11-19 08:30:00 | SPY | ETF | 118.6 | 118.61 | 118.53 | 118.59 | 17100.0 |
| 2004-11-19 09:00:00 | SPY | ETF | 118.59 | 118.69 | 118.49 | 118.67 | 204700.0 |
| 2004-11-19 09:30:00 | SPY | ETF | 118.7 | 118.72 | 118.13 | 118.23 | 7939200.0 |
| 2004-11-19 10:00:00 | SPY | ETF | 118.23 | 118.28 | 117.47 | 117.63 | 7818300.0 |
| 2004-11-19 10:30:00 | SPY | ETF | 117.62 | 117.76 | 117.43 | 117.61 | 3631500.0 |
| 2004-11-19 11:00:00 | SPY | ETF | 117.6 | 117.66 | 117.35 | 117.52 | 4678400.0 |
| 2004-11-19 11:30:00 | SPY | ETF | 117.52 | 117.61 | 117.44 | 117.45 | 2119600.0 |
| 2004-11-19 12:00:00 | SPY | ETF | 117.46 | 117.52 | 117.31 | 117.37 | 1913900.0 |
| 2004-11-19 12:30:00 | SPY | ETF | 117.38 | 117.55 | 117.36 | 117.48 | 1674800.0 |
| 2004-11-19 13:00:00 | SPY | ETF | 117.5 | 117.61 | 117.47 | 117.51 | 1901800.0 |
| 2004-11-19 13:30:00 | SPY | ETF | 117.5 | 117.53 | 117.42 | 117.43 | 1367400.0 |
| 2004-11-19 14:00:00 | SPY | ETF | 117.43 | 117.47 | 117.31 | 117.34 | 1203300.0 |
| 2004-11-19 14:30:00 | SPY | ETF | 117.35 | 117.55 | 117.32 | 117.37 | 2223200.0 |
| 2004-11-19 15:00:00 | SPY | ETF | 117.37 | 117.47 | 117.18 | 117.2 | 2987000.0 |
| 2004-11-19 15:30:00 | SPY | ETF | 117.2 | 117.35 | 117.14 | 117.32 | 4853600.0 |
| 2004-11-19 16:00:00 | SPY | ETF | 117.34 | 117.51 | 117.26 | 117.51 | 1949600.0 |
| 2004-11-19 16:30:00 | SPY | ETF | 117.49 | 117.49 | 117.32 | 117.42 | 153400.0 |
| 2004-11-19 17:00:00 | SPY | ETF | 117.42 | 117.42 | 117.38 | 117.38 | 1200.0 |
| 2004-11-19 17:30:00 | SPY | ETF | 117.43 | 117.43 | 117.42 | 117.42 | 900.0 |
| 2004-11-19 18:00:00 | SPY | ETF | 117.43 | 117.43 | 117.38 | 117.38 | 1800.0 |
| 2004-11-19 19:00:00 | SPY | ETF | 117.35 | 117.35 | 117.35 | 117.35 | 300.0 |
| 2004-11-19 08:00:00 | QQQ | ETF | 39.28 | 39.28 | 39.25 | 39.27 | 28800.0 |
| 2004-11-19 08:30:00 | QQQ | ETF | 39.27 | 39.27 | 39.22 | 39.26 | 123800.0 |
| 2004-11-19 09:00:00 | QQQ | ETF | 39.26 | 39.27 | 39.22 | 39.24 | 119100.0 |
| 2004-11-19 09:30:00 | QQQ | ETF | 39.24 | 39.29 | 39.02 | 39.107 | 14795700.0 |
| 2004-11-19 10:00:00 | QQQ | ETF | 39.106 | 39.11 | 38.9 | 38.95 | 14308300.0 |
| 2004-11-19 10:30:00 | QQQ | ETF | 38.95 | 39.0 | 38.86 | 38.882 | 10367800.0 |
| 2004-11-19 11:00:00 | QQQ | ETF | 38.882 | 38.89 | 38.7 | 38.815 | 12220900.0 |
| 2004-11-19 11:30:00 | QQQ | ETF | 38.82 | 38.84 | 38.77 | 38.791 | 5240900.0 |
| 2004-11-19 12:00:00 | QQQ | ETF | 38.8 | 38.8 | 38.7 | 38.72 | 4486100.0 |
| 2004-11-19 12:30:00 | QQQ | ETF | 38.73 | 38.785 | 38.71 | 38.73 | 5911700.0 |
| 2004-11-19 13:00:00 | QQQ | ETF | 38.738 | 38.81 | 38.71 | 38.73 | 4908200.0 |
| 2004-11-19 13:30:00 | QQQ | ETF | 38.7225 | 38.77 | 38.71 | 38.717 | 4211900.0 |
| 2004-11-19 14:00:00 | QQQ | ETF | 38.71 | 38.72 | 38.59 | 38.62 | 6401900.0 |
| 2004-11-19 14:30:00 | QQQ | ETF | 38.62 | 38.73 | 38.59 | 38.68 | 8036100.0 |
| 2004-11-19 15:00:00 | QQQ | ETF | 38.68 | 38.721 | 38.61 | 38.62 | 5945700.0 |
| 2004-11-19 15:30:00 | QQQ | ETF | 38.618 | 38.69 | 38.59 | 38.66 | 12193900.0 |
| 2004-11-19 16:00:00 | QQQ | ETF | 38.66 | 38.739 | 38.61 | 38.7 | 4625000.0 |
| 2004-11-19 16:30:00 | QQQ | ETF | 38.71 | 38.71 | 38.66 | 38.68 | 207900.0 |
| 2004-11-19 17:00:00 | QQQ | ETF | 38.66 | 38.68 | 38.65 | 38.65 | 21700.0 |
| 2004-11-19 17:30:00 | QQQ | ETF | 38.65 | 38.66 | 38.63 | 38.63 | 59400.0 |
| 2004-11-19 18:00:00 | QQQ | ETF | 38.64 | 38.65 | 38.63 | 38.63 | 37200.0 |
| 2004-11-19 18:30:00 | QQQ | ETF | 38.64 | 38.64 | 38.6 | 38.6 | 8000.0 |
| 2004-11-19 19:00:00 | QQQ | ETF | 38.62 | 38.63 | 38.62 | 38.63 | 2100.0 |
| 2004-11-19 19:30:00 | QQQ | ETF | 38.62 | 38.65 | 38.62 | 38.65 | 1400.0 |
| 2004-11-19 08:00:00 | IWM | ETF | 62.04 | 62.04 | 62.04 | 62.04 | 1000.0 |
| 2004-11-19 08:30:00 | IWM | ETF | 61.995 | 61.995 | 61.995 | 61.995 | 400.0 |
| 2004-11-19 09:00:00 | IWM | ETF | 61.895 | 61.94 | 61.895 | 61.92 | 14800.0 |
| 2004-11-19 09:30:00 | IWM | ETF | 61.94 | 61.975 | 61.555 | 61.63 | 1146600.0 |
> showing 50 of 1,351 rows — these rows as CSV