PREVIEW / etf_30min / 2006-11-21
file: by_date/etf_30min/2006/2006-11-21.parquet size: 85 KB rows: 3,030
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-21 05:00:00 | SPY | ETF | 140.6 | 140.6 | 140.6 | 140.6 | 400.0 |
| 2006-11-21 07:00:00 | SPY | ETF | 140.64 | 140.67 | 140.63 | 140.65 | 156300.0 |
| 2006-11-21 07:30:00 | SPY | ETF | 140.65 | 140.65 | 140.6 | 140.64 | 86200.0 |
| 2006-11-21 08:00:00 | SPY | ETF | 140.64 | 140.7 | 140.58 | 140.6 | 107200.0 |
| 2006-11-21 08:30:00 | SPY | ETF | 140.59 | 140.64 | 140.56 | 140.61 | 1133200.0 |
| 2006-11-21 09:00:00 | SPY | ETF | 140.61 | 140.62 | 140.44 | 140.48 | 343700.0 |
| 2006-11-21 09:30:00 | SPY | ETF | 140.49 | 140.61 | 140.37 | 140.41 | 8444600.0 |
| 2006-11-21 10:00:00 | SPY | ETF | 140.4 | 140.63 | 140.4 | 140.47 | 5186700.0 |
| 2006-11-21 10:30:00 | SPY | ETF | 140.48 | 140.53 | 140.33 | 140.47 | 4915700.0 |
| 2006-11-21 11:00:00 | SPY | ETF | 140.48 | 140.48 | 140.29 | 140.4 | 5113900.0 |
| 2006-11-21 11:30:00 | SPY | ETF | 140.42 | 140.48 | 140.35 | 140.44 | 2098300.0 |
| 2006-11-21 12:00:00 | SPY | ETF | 140.44 | 140.58 | 140.42 | 140.56 | 3136500.0 |
| 2006-11-21 12:30:00 | SPY | ETF | 140.56 | 140.6 | 140.51 | 140.54 | 2167900.0 |
| 2006-11-21 13:00:00 | SPY | ETF | 140.52 | 140.59 | 140.41 | 140.46 | 2349700.0 |
| 2006-11-21 13:30:00 | SPY | ETF | 140.47 | 140.67 | 140.44 | 140.56 | 2209200.0 |
| 2006-11-21 14:00:00 | SPY | ETF | 140.57 | 140.58 | 140.44 | 140.48 | 2713900.0 |
| 2006-11-21 14:30:00 | SPY | ETF | 140.48 | 140.65 | 140.45 | 140.54 | 2985100.0 |
| 2006-11-21 15:00:00 | SPY | ETF | 140.54 | 140.6 | 140.48 | 140.52 | 1791300.0 |
| 2006-11-21 15:30:00 | SPY | ETF | 140.52 | 140.6 | 140.5 | 140.59 | 4148600.0 |
| 2006-11-21 16:00:00 | SPY | ETF | 140.59 | 140.67 | 140.52 | 140.67 | 882400.0 |
| 2006-11-21 16:30:00 | SPY | ETF | 140.65 | 140.67 | 140.4911 | 140.67 | 450700.0 |
| 2006-11-21 17:00:00 | SPY | ETF | 140.67 | 140.69 | 140.64 | 140.64 | 157600.0 |
| 2006-11-21 17:30:00 | SPY | ETF | 140.7 | 140.7 | 140.7 | 140.7 | 2000.0 |
| 2006-11-21 18:00:00 | SPY | ETF | 140.68 | 140.69 | 140.68 | 140.69 | 1600.0 |
| 2006-11-21 18:30:00 | SPY | ETF | 140.7 | 140.7 | 140.7 | 140.7 | 1000.0 |
| 2006-11-21 19:30:00 | SPY | ETF | 140.67 | 140.7 | 140.67 | 140.7 | 1500.0 |
| 2006-11-21 09:30:00 | QQQ | ETF | 44.42 | 44.48 | 44.36 | 44.38 | 8920800.0 |
| 2006-11-21 10:00:00 | QQQ | ETF | 44.38 | 45.4 | 44.37 | 44.41 | 5574600.0 |
| 2006-11-21 10:30:00 | QQQ | ETF | 44.41 | 44.44 | 44.26 | 44.33 | 8519700.0 |
| 2006-11-21 11:00:00 | QQQ | ETF | 44.33 | 44.38 | 44.25 | 44.33 | 5066700.0 |
| 2006-11-21 11:30:00 | QQQ | ETF | 44.33 | 44.39 | 44.32 | 44.38 | 2030200.0 |
| 2006-11-21 12:00:00 | QQQ | ETF | 44.38 | 44.45 | 44.35 | 44.43 | 4314800.0 |
| 2006-11-21 12:30:00 | QQQ | ETF | 44.43 | 44.47 | 44.41 | 44.44 | 1721300.0 |
| 2006-11-21 13:00:00 | QQQ | ETF | 44.44 | 44.49 | 44.4 | 44.43 | 2718400.0 |
| 2006-11-21 13:30:00 | QQQ | ETF | 44.43 | 44.51 | 44.42 | 44.46 | 2434100.0 |
| 2006-11-21 14:00:00 | QQQ | ETF | 44.46 | 44.46 | 44.35 | 44.39 | 5136000.0 |
| 2006-11-21 14:30:00 | QQQ | ETF | 44.39 | 44.42 | 44.37 | 44.41 | 1965500.0 |
| 2006-11-21 15:00:00 | QQQ | ETF | 44.41 | 44.44 | 44.37 | 44.4 | 3256900.0 |
| 2006-11-21 15:30:00 | QQQ | ETF | 44.4 | 44.48 | 44.38 | 44.46 | 7334100.0 |
| 2006-11-21 08:00:00 | IWM | ETF | 78.78 | 78.78 | 78.7 | 78.72 | 615300.0 |
| 2006-11-21 08:30:00 | IWM | ETF | 78.73 | 78.76 | 78.71 | 78.73 | 1191900.0 |
| 2006-11-21 09:00:00 | IWM | ETF | 78.73 | 78.75 | 78.67 | 78.67 | 51000.0 |
| 2006-11-21 09:30:00 | IWM | ETF | 78.69 | 78.8 | 78.42 | 78.45 | 3723700.0 |
| 2006-11-21 10:00:00 | IWM | ETF | 78.45 | 78.82 | 78.44 | 78.7 | 4691200.0 |
| 2006-11-21 10:30:00 | IWM | ETF | 78.7188 | 78.76 | 78.5 | 78.58 | 2052400.0 |
| 2006-11-21 11:00:00 | IWM | ETF | 78.57 | 78.6 | 78.31 | 78.43 | 2757000.0 |
| 2006-11-21 11:30:00 | IWM | ETF | 78.43 | 78.57 | 78.4 | 78.57 | 1015500.0 |
| 2006-11-21 12:00:00 | IWM | ETF | 78.58 | 78.8 | 78.57 | 78.79 | 4510300.0 |
| 2006-11-21 12:30:00 | IWM | ETF | 78.79 | 78.86 | 78.76 | 78.78 | 1485900.0 |
| 2006-11-21 13:00:00 | IWM | ETF | 78.79 | 78.86 | 78.73 | 78.76 | 1008400.0 |
> showing 50 of 3,030 rows — these rows as CSV