PREVIEW / etf_30min / 2001-08-24
file: by_date/etf_30min/2001/2001-08-24.parquet size: 15 KB rows: 357
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 |
|---|---|---|---|---|---|---|---|
| 2001-08-24 09:30:00 | SPY | ETF | 117.21 | 117.21 | 116.74 | 116.95 | 917700.0 |
| 2001-08-24 10:00:00 | SPY | ETF | 116.95 | 117.59 | 116.95 | 117.53 | 954700.0 |
| 2001-08-24 10:30:00 | SPY | ETF | 117.54 | 118.25 | 117.54 | 118.05 | 1076500.0 |
| 2001-08-24 11:00:00 | SPY | ETF | 118.05 | 118.72 | 118.05 | 118.62 | 1281900.0 |
| 2001-08-24 11:30:00 | SPY | ETF | 118.65 | 119.0 | 118.62 | 118.9 | 868400.0 |
| 2001-08-24 12:00:00 | SPY | ETF | 118.93 | 118.93 | 118.73 | 118.76 | 427100.0 |
| 2001-08-24 12:30:00 | SPY | ETF | 118.76 | 118.99 | 118.67 | 118.74 | 251400.0 |
| 2001-08-24 13:00:00 | SPY | ETF | 118.74 | 118.91 | 118.69 | 118.77 | 327900.0 |
| 2001-08-24 13:30:00 | SPY | ETF | 118.78 | 118.78 | 118.41 | 118.53 | 630000.0 |
| 2001-08-24 14:00:00 | SPY | ETF | 118.52 | 118.67 | 118.37 | 118.51 | 714300.0 |
| 2001-08-24 14:30:00 | SPY | ETF | 118.52 | 118.8 | 118.5 | 118.66 | 910800.0 |
| 2001-08-24 15:00:00 | SPY | ETF | 118.65 | 119.1 | 118.54 | 118.94 | 938800.0 |
| 2001-08-24 15:30:00 | SPY | ETF | 118.93 | 119.05 | 118.68 | 119.0 | 1119800.0 |
| 2001-08-24 16:00:00 | SPY | ETF | 118.97 | 119.13 | 118.83 | 119.0 | 969300.0 |
| 2001-08-24 16:30:00 | SPY | ETF | 119.0 | 119.0 | 119.0 | 119.0 | 1500.0 |
| 2001-08-24 17:30:00 | SPY | ETF | 119.15 | 119.15 | 119.15 | 119.15 | 500.0 |
| 2001-08-24 18:00:00 | SPY | ETF | 119.01 | 119.01 | 119.01 | 119.01 | 600.0 |
| 2001-08-24 09:30:00 | QQQ | ETF | 37.86 | 38.09 | 37.75 | 38.0 | 7032500.0 |
| 2001-08-24 10:00:00 | QQQ | ETF | 38.0 | 38.42 | 37.96 | 38.33 | 8078900.0 |
| 2001-08-24 10:30:00 | QQQ | ETF | 38.27 | 38.68 | 38.27 | 38.52 | 6859900.0 |
| 2001-08-24 11:00:00 | QQQ | ETF | 38.52 | 38.89 | 38.47 | 38.8 | 5550200.0 |
| 2001-08-24 11:30:00 | QQQ | ETF | 38.83 | 39.07 | 38.79 | 38.93 | 5265100.0 |
| 2001-08-24 12:00:00 | QQQ | ETF | 38.94 | 39.0 | 38.81 | 38.97 | 2351600.0 |
| 2001-08-24 12:30:00 | QQQ | ETF | 38.95 | 39.17 | 38.9 | 39.11 | 2248800.0 |
| 2001-08-24 13:00:00 | QQQ | ETF | 39.11 | 39.35 | 39.08 | 39.22 | 2620700.0 |
| 2001-08-24 13:30:00 | QQQ | ETF | 39.23 | 39.24 | 38.96 | 39.03 | 2795500.0 |
| 2001-08-24 14:00:00 | QQQ | ETF | 39.04 | 39.09 | 38.9 | 39.03 | 2435200.0 |
| 2001-08-24 14:30:00 | QQQ | ETF | 39.03 | 39.15 | 38.91 | 39.04 | 2548200.0 |
| 2001-08-24 15:00:00 | QQQ | ETF | 39.01 | 39.3 | 38.97 | 39.21 | 3050500.0 |
| 2001-08-24 15:30:00 | QQQ | ETF | 39.2 | 39.39 | 39.09 | 39.35 | 4491000.0 |
| 2001-08-24 16:00:00 | QQQ | ETF | 39.36 | 39.39 | 39.27 | 39.39 | 1166700.0 |
| 2001-08-24 16:30:00 | QQQ | ETF | 39.35 | 39.41 | 39.3 | 39.32 | 26200.0 |
| 2001-08-24 17:00:00 | QQQ | ETF | 39.35 | 39.39 | 39.28 | 39.32 | 10700.0 |
| 2001-08-24 17:30:00 | QQQ | ETF | 39.32 | 39.33 | 39.3 | 39.31 | 3500.0 |
| 2001-08-24 18:00:00 | QQQ | ETF | 39.33 | 39.35 | 39.28 | 39.28 | 3300.0 |
| 2001-08-24 09:30:00 | IWM | ETF | 47.5 | 47.5 | 47.425 | 47.425 | 5200.0 |
| 2001-08-24 10:00:00 | IWM | ETF | 47.545 | 47.6 | 47.5 | 47.52 | 4800.0 |
| 2001-08-24 10:30:00 | IWM | ETF | 47.6 | 47.695 | 47.5 | 47.5 | 5800.0 |
| 2001-08-24 11:00:00 | IWM | ETF | 47.75 | 47.75 | 47.675 | 47.7 | 67600.0 |
| 2001-08-24 11:30:00 | IWM | ETF | 47.725 | 47.76 | 47.72 | 47.755 | 856400.0 |
| 2001-08-24 12:00:00 | IWM | ETF | 47.75 | 47.75 | 47.645 | 47.65 | 396000.0 |
| 2001-08-24 12:30:00 | IWM | ETF | 47.63 | 47.735 | 47.63 | 47.72 | 357600.0 |
| 2001-08-24 13:00:00 | IWM | ETF | 47.69 | 47.725 | 47.69 | 47.725 | 113600.0 |
| 2001-08-24 13:30:00 | IWM | ETF | 47.725 | 47.725 | 47.625 | 47.675 | 183800.0 |
| 2001-08-24 14:00:00 | IWM | ETF | 47.6 | 47.6 | 47.59 | 47.59 | 1600.0 |
| 2001-08-24 14:30:00 | IWM | ETF | 47.58 | 47.675 | 47.58 | 47.675 | 100800.0 |
| 2001-08-24 15:00:00 | IWM | ETF | 47.675 | 47.875 | 47.675 | 47.875 | 119200.0 |
| 2001-08-24 15:30:00 | IWM | ETF | 47.83 | 47.965 | 47.82 | 47.85 | 28000.0 |
| 2001-08-24 16:00:00 | IWM | ETF | 47.85 | 48.05 | 47.85 | 48.05 | 99400.0 |
| 2001-08-24 09:30:00 | DIA | ETF | 102.75 | 102.75 | 102.38 | 102.5 | 103100.0 |
> showing 50 of 357 rows — these rows as CSV