PREVIEW / etf_30min / 2006-12-05
file: by_date/etf_30min/2006/2006-12-05.parquet size: 88 KB rows: 3,091
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-12-05 07:00:00 | SPY | ETF | 141.32 | 141.37 | 141.24 | 141.24 | 39800.0 |
| 2006-12-05 07:30:00 | SPY | ETF | 141.24 | 141.32 | 141.24 | 141.32 | 23800.0 |
| 2006-12-05 08:00:00 | SPY | ETF | 141.3 | 141.4 | 141.23 | 141.32 | 343100.0 |
| 2006-12-05 08:30:00 | SPY | ETF | 141.38 | 141.74 | 141.34 | 141.57 | 932200.0 |
| 2006-12-05 09:00:00 | SPY | ETF | 141.58 | 141.63 | 141.51 | 141.57 | 507000.0 |
| 2006-12-05 09:30:00 | SPY | ETF | 141.56 | 141.6 | 141.26 | 141.46 | 6072100.0 |
| 2006-12-05 10:00:00 | SPY | ETF | 141.45 | 141.96 | 141.45 | 141.64 | 12965000.0 |
| 2006-12-05 10:30:00 | SPY | ETF | 141.64 | 141.71 | 141.52 | 141.7 | 5558000.0 |
| 2006-12-05 11:00:00 | SPY | ETF | 141.71 | 141.75 | 141.56 | 141.74 | 4773900.0 |
| 2006-12-05 11:30:00 | SPY | ETF | 141.74 | 141.86 | 141.59 | 141.6 | 5114900.0 |
| 2006-12-05 12:00:00 | SPY | ETF | 141.62 | 141.66 | 141.48 | 141.65 | 3819200.0 |
| 2006-12-05 12:30:00 | SPY | ETF | 141.65 | 141.78 | 141.54 | 141.74 | 4749500.0 |
| 2006-12-05 13:00:00 | SPY | ETF | 141.74 | 141.82 | 141.59 | 141.72 | 1573100.0 |
| 2006-12-05 13:30:00 | SPY | ETF | 141.72 | 141.82 | 141.64 | 141.73 | 1832100.0 |
| 2006-12-05 14:00:00 | SPY | ETF | 141.72 | 141.92 | 141.65 | 141.83 | 3795000.0 |
| 2006-12-05 14:30:00 | SPY | ETF | 141.83 | 141.95 | 141.79 | 141.81 | 5281800.0 |
| 2006-12-05 15:00:00 | SPY | ETF | 141.82 | 141.89 | 141.67 | 141.76 | 4851000.0 |
| 2006-12-05 15:30:00 | SPY | ETF | 141.79 | 141.9 | 141.68 | 141.89 | 3816700.0 |
| 2006-12-05 16:00:00 | SPY | ETF | 141.9 | 141.94 | 141.84 | 141.9 | 3044100.0 |
| 2006-12-05 16:30:00 | SPY | ETF | 141.87 | 141.93 | 141.87 | 141.87 | 869700.0 |
| 2006-12-05 17:00:00 | SPY | ETF | 141.88 | 141.95 | 141.88 | 141.95 | 42400.0 |
| 2006-12-05 17:30:00 | SPY | ETF | 141.94 | 141.94 | 141.92 | 141.92 | 2800.0 |
| 2006-12-05 18:00:00 | SPY | ETF | 141.94 | 141.96 | 141.91 | 141.91 | 4400.0 |
| 2006-12-05 18:30:00 | SPY | ETF | 141.92 | 141.98 | 141.92 | 141.98 | 2000.0 |
| 2006-12-05 19:00:00 | SPY | ETF | 141.94 | 141.94 | 141.89 | 141.9 | 2200.0 |
| 2006-12-05 19:30:00 | SPY | ETF | 141.9 | 141.9 | 141.9 | 141.9 | 600.0 |
| 2006-12-05 09:30:00 | QQQ | ETF | 44.4 | 44.42 | 44.19 | 44.3 | 13445400.0 |
| 2006-12-05 10:00:00 | QQQ | ETF | 44.3 | 44.55 | 44.3 | 44.45 | 19713300.0 |
| 2006-12-05 10:30:00 | QQQ | ETF | 44.44 | 44.47 | 44.38 | 44.46 | 5337500.0 |
| 2006-12-05 11:00:00 | QQQ | ETF | 44.45 | 44.47 | 44.4 | 44.46 | 3306300.0 |
| 2006-12-05 11:30:00 | QQQ | ETF | 44.46 | 44.97 | 44.38 | 44.39 | 4632900.0 |
| 2006-12-05 12:00:00 | QQQ | ETF | 44.39 | 44.4 | 44.33 | 44.38 | 3552800.0 |
| 2006-12-05 12:30:00 | QQQ | ETF | 44.37 | 44.42 | 44.3 | 44.38 | 4093800.0 |
| 2006-12-05 13:00:00 | QQQ | ETF | 44.39 | 44.43 | 44.31 | 44.37 | 2754800.0 |
| 2006-12-05 13:30:00 | QQQ | ETF | 44.37 | 44.42 | 44.33 | 44.39 | 2620700.0 |
| 2006-12-05 14:00:00 | QQQ | ETF | 44.38 | 44.47 | 44.34 | 44.44 | 5147100.0 |
| 2006-12-05 14:30:00 | QQQ | ETF | 44.43 | 44.49 | 44.38 | 44.4 | 3641700.0 |
| 2006-12-05 15:00:00 | QQQ | ETF | 44.39 | 44.43 | 44.33 | 44.38 | 4830600.0 |
| 2006-12-05 15:30:00 | QQQ | ETF | 44.38 | 44.47 | 44.32 | 44.41 | 5285100.0 |
| 2006-12-05 07:30:00 | IWM | ETF | 79.25 | 79.25 | 79.25 | 79.25 | 100.0 |
| 2006-12-05 08:00:00 | IWM | ETF | 79.3 | 79.37 | 79.3 | 79.37 | 19900.0 |
| 2006-12-05 08:30:00 | IWM | ETF | 79.37 | 79.65 | 79.37 | 79.47 | 345100.0 |
| 2006-12-05 09:00:00 | IWM | ETF | 79.48 | 79.53 | 79.4 | 79.4 | 59600.0 |
| 2006-12-05 09:30:00 | IWM | ETF | 79.4 | 79.48 | 79.07 | 79.2306 | 4637700.0 |
| 2006-12-05 10:00:00 | IWM | ETF | 79.24 | 79.76 | 79.23 | 79.53 | 8622000.0 |
| 2006-12-05 10:30:00 | IWM | ETF | 79.53 | 79.62 | 79.43 | 79.5 | 2491900.0 |
| 2006-12-05 11:00:00 | IWM | ETF | 79.5 | 79.55 | 79.31 | 79.52 | 2678300.0 |
| 2006-12-05 11:30:00 | IWM | ETF | 79.52 | 79.6 | 79.28 | 79.32 | 2931600.0 |
| 2006-12-05 12:00:00 | IWM | ETF | 79.33 | 79.33 | 79.2 | 79.31 | 1372000.0 |
| 2006-12-05 12:30:00 | IWM | ETF | 79.3 | 79.4 | 79.14 | 79.37 | 1700100.0 |
> showing 50 of 3,091 rows — these rows as CSV