PREVIEW / etf_30min / 2006-09-28
file: by_date/etf_30min/2006/2006-09-28.parquet size: 80 KB rows: 2,824
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-09-28 04:30:00 | SPY | ETF | 133.79 | 133.79 | 133.79 | 133.79 | 200.0 |
| 2006-09-28 06:30:00 | SPY | ETF | 133.89 | 133.89 | 133.89 | 133.89 | 300.0 |
| 2006-09-28 07:00:00 | SPY | ETF | 133.89 | 133.92 | 133.89 | 133.91 | 900.0 |
| 2006-09-28 07:30:00 | SPY | ETF | 133.86 | 133.88 | 133.83 | 133.87 | 23200.0 |
| 2006-09-28 08:00:00 | SPY | ETF | 133.85 | 133.87 | 133.81 | 133.86 | 337600.0 |
| 2006-09-28 08:30:00 | SPY | ETF | 133.83 | 133.85 | 133.52 | 133.75 | 578400.0 |
| 2006-09-28 09:00:00 | SPY | ETF | 133.76 | 133.81 | 133.72 | 133.77 | 131400.0 |
| 2006-09-28 09:30:00 | SPY | ETF | 133.74 | 133.97 | 133.5 | 133.57 | 8067900.0 |
| 2006-09-28 10:00:00 | SPY | ETF | 133.58 | 133.78 | 133.49 | 133.65 | 3190700.0 |
| 2006-09-28 10:30:00 | SPY | ETF | 133.67 | 133.94 | 133.4 | 133.51 | 7428600.0 |
| 2006-09-28 11:00:00 | SPY | ETF | 133.5 | 133.95 | 133.45 | 133.63 | 5062800.0 |
| 2006-09-28 11:30:00 | SPY | ETF | 133.62 | 133.67 | 133.45 | 133.49 | 3181600.0 |
| 2006-09-28 12:00:00 | SPY | ETF | 133.48 | 133.49 | 133.28 | 133.41 | 7589900.0 |
| 2006-09-28 12:30:00 | SPY | ETF | 133.4 | 133.53 | 133.37 | 133.47 | 1690200.0 |
| 2006-09-28 13:00:00 | SPY | ETF | 133.48 | 133.77 | 133.45 | 133.67 | 3055100.0 |
| 2006-09-28 13:30:00 | SPY | ETF | 133.67 | 133.8 | 133.61 | 133.75 | 2139400.0 |
| 2006-09-28 14:00:00 | SPY | ETF | 133.73 | 133.85 | 133.69 | 133.79 | 3779900.0 |
| 2006-09-28 14:30:00 | SPY | ETF | 133.78 | 133.93 | 133.69 | 133.83 | 2453400.0 |
| 2006-09-28 15:00:00 | SPY | ETF | 133.82 | 133.85 | 133.66 | 133.74 | 1855700.0 |
| 2006-09-28 15:30:00 | SPY | ETF | 133.75 | 133.99 | 133.75 | 133.78 | 5970200.0 |
| 2006-09-28 16:00:00 | SPY | ETF | 133.77 | 133.85 | 133.69 | 133.74 | 642900.0 |
| 2006-09-28 16:30:00 | SPY | ETF | 133.73 | 133.75 | 133.66 | 133.69 | 79300.0 |
| 2006-09-28 17:00:00 | SPY | ETF | 133.67 | 133.74 | 133.65 | 133.72 | 55100.0 |
| 2006-09-28 17:30:00 | SPY | ETF | 133.74 | 133.75 | 133.67 | 133.73 | 7200.0 |
| 2006-09-28 18:00:00 | SPY | ETF | 133.72 | 133.72 | 133.71 | 133.71 | 3100.0 |
| 2006-09-28 19:30:00 | SPY | ETF | 133.75 | 133.75 | 133.7 | 133.7 | 2000.0 |
| 2006-09-28 09:30:00 | QQQ | ETF | 40.77 | 40.89 | 40.63 | 40.74 | 13370300.0 |
| 2006-09-28 10:00:00 | QQQ | ETF | 40.74 | 40.8 | 40.67 | 40.71 | 8436500.0 |
| 2006-09-28 10:30:00 | QQQ | ETF | 40.71 | 40.74 | 40.54 | 40.62 | 8438700.0 |
| 2006-09-28 11:00:00 | QQQ | ETF | 40.63 | 40.73 | 40.6 | 40.71 | 5373400.0 |
| 2006-09-28 11:30:00 | QQQ | ETF | 40.71 | 40.72 | 40.51 | 40.53 | 6838900.0 |
| 2006-09-28 12:00:00 | QQQ | ETF | 40.52 | 40.55 | 40.43 | 40.54 | 6929500.0 |
| 2006-09-28 12:30:00 | QQQ | ETF | 40.54 | 40.62 | 40.52 | 40.59 | 3149100.0 |
| 2006-09-28 13:00:00 | QQQ | ETF | 40.6 | 40.76 | 40.57 | 40.7 | 4999400.0 |
| 2006-09-28 13:30:00 | QQQ | ETF | 40.7 | 40.75 | 40.62 | 40.72 | 3365000.0 |
| 2006-09-28 14:00:00 | QQQ | ETF | 40.71 | 40.76 | 40.68 | 40.72 | 3094600.0 |
| 2006-09-28 14:30:00 | QQQ | ETF | 40.73 | 40.8 | 40.67 | 40.74 | 4147400.0 |
| 2006-09-28 15:00:00 | QQQ | ETF | 40.73 | 40.78 | 40.68 | 40.73 | 3187900.0 |
| 2006-09-28 15:30:00 | QQQ | ETF | 40.73 | 40.85 | 40.73 | 40.83 | 7017200.0 |
| 2006-09-28 07:30:00 | IWM | ETF | 73.0 | 73.0 | 73.0 | 73.0 | 1400.0 |
| 2006-09-28 08:00:00 | IWM | ETF | 73.03 | 73.15 | 72.92 | 73.15 | 780300.0 |
| 2006-09-28 08:30:00 | IWM | ETF | 73.1 | 73.15 | 72.93 | 72.99 | 639800.0 |
| 2006-09-28 09:00:00 | IWM | ETF | 72.99 | 73.04 | 72.96 | 72.97 | 50800.0 |
| 2006-09-28 09:30:00 | IWM | ETF | 72.98 | 73.28 | 72.74 | 72.86 | 4852300.0 |
| 2006-09-28 10:00:00 | IWM | ETF | 72.86 | 73.03 | 72.74 | 72.75 | 2795400.0 |
| 2006-09-28 10:30:00 | IWM | ETF | 72.78 | 72.86 | 72.49 | 72.61 | 2720000.0 |
| 2006-09-28 11:00:00 | IWM | ETF | 72.61 | 72.73 | 72.56 | 72.65 | 2614100.0 |
| 2006-09-28 11:30:00 | IWM | ETF | 72.65 | 72.71 | 72.43 | 72.45 | 1948000.0 |
| 2006-09-28 12:00:00 | IWM | ETF | 72.43 | 72.44 | 72.25 | 72.33 | 1531300.0 |
| 2006-09-28 12:30:00 | IWM | ETF | 72.33 | 72.45 | 72.26 | 72.34 | 750300.0 |
> showing 50 of 2,824 rows — these rows as CSV