PREVIEW / etf_30min / 2006-04-21
file: by_date/etf_30min/2006/2006-04-21.parquet size: 62 KB rows: 2,198
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-04-21 05:30:00 | SPY | ETF | 131.36 | 131.36 | 131.36 | 131.36 | 100.0 |
| 2006-04-21 07:00:00 | SPY | ETF | 131.33 | 131.33 | 131.33 | 131.33 | 100.0 |
| 2006-04-21 07:30:00 | SPY | ETF | 131.36 | 131.37 | 131.33 | 131.37 | 5800.0 |
| 2006-04-21 08:00:00 | SPY | ETF | 131.13 | 131.49 | 131.13 | 131.44 | 1275700.0 |
| 2006-04-21 08:30:00 | SPY | ETF | 131.43 | 131.56 | 131.43 | 131.52 | 209000.0 |
| 2006-04-21 09:00:00 | SPY | ETF | 131.54 | 131.74 | 131.46 | 131.74 | 581800.0 |
| 2006-04-21 09:30:00 | SPY | ETF | 131.73 | 131.79 | 131.41 | 131.49 | 6720000.0 |
| 2006-04-21 10:00:00 | SPY | ETF | 131.49 | 131.79 | 131.3 | 131.39 | 5696000.0 |
| 2006-04-21 10:30:00 | SPY | ETF | 131.39 | 131.58 | 131.3 | 131.44 | 3350100.0 |
| 2006-04-21 11:00:00 | SPY | ETF | 131.42 | 131.59 | 131.32 | 131.43 | 2291300.0 |
| 2006-04-21 11:30:00 | SPY | ETF | 131.43 | 131.55 | 131.29 | 131.43 | 3088600.0 |
| 2006-04-21 12:00:00 | SPY | ETF | 131.43 | 131.5 | 131.26 | 131.45 | 4005900.0 |
| 2006-04-21 12:30:00 | SPY | ETF | 131.4401 | 131.53 | 131.38 | 131.48 | 2600600.0 |
| 2006-04-21 13:00:00 | SPY | ETF | 131.4774 | 131.52 | 131.42 | 131.45 | 2135000.0 |
| 2006-04-21 13:30:00 | SPY | ETF | 131.45 | 131.54 | 131.36 | 131.39 | 3173700.0 |
| 2006-04-21 14:00:00 | SPY | ETF | 131.39 | 131.49 | 131.01 | 131.061 | 8821400.0 |
| 2006-04-21 14:30:00 | SPY | ETF | 131.062 | 131.07 | 130.71 | 130.81 | 8836600.0 |
| 2006-04-21 15:00:00 | SPY | ETF | 130.81 | 130.85 | 130.62 | 130.76 | 7569900.0 |
| 2006-04-21 15:30:00 | SPY | ETF | 130.75 | 131.2 | 130.73 | 131.1 | 8809200.0 |
| 2006-04-21 16:00:00 | SPY | ETF | 131.11 | 131.22 | 131.03 | 131.05 | 853500.0 |
| 2006-04-21 16:30:00 | SPY | ETF | 131.06 | 131.18 | 131.06 | 131.15 | 62400.0 |
| 2006-04-21 17:00:00 | SPY | ETF | 131.11 | 131.11 | 131.08 | 131.08 | 51100.0 |
| 2006-04-21 17:30:00 | SPY | ETF | 131.1 | 131.1 | 131.05 | 131.05 | 45400.0 |
| 2006-04-21 18:00:00 | SPY | ETF | 131.1 | 131.14 | 131.05 | 131.05 | 9100.0 |
| 2006-04-21 19:30:00 | SPY | ETF | 131.1 | 131.1 | 131.1 | 131.1 | 300.0 |
| 2006-04-21 09:30:00 | QQQ | ETF | 42.67 | 42.72 | 42.47 | 42.51 | 12577300.0 |
| 2006-04-21 10:00:00 | QQQ | ETF | 42.5 | 42.65 | 42.4 | 42.42 | 6887600.0 |
| 2006-04-21 10:30:00 | QQQ | ETF | 42.43 | 42.49 | 42.38 | 42.43 | 5375100.0 |
| 2006-04-21 11:00:00 | QQQ | ETF | 42.43 | 42.47 | 42.32 | 42.35 | 3980800.0 |
| 2006-04-21 11:30:00 | QQQ | ETF | 42.36 | 42.4 | 42.3 | 42.36 | 3959500.0 |
| 2006-04-21 12:00:00 | QQQ | ETF | 42.37 | 42.39 | 42.3 | 42.38 | 3763100.0 |
| 2006-04-21 12:30:00 | QQQ | ETF | 42.37 | 42.43 | 42.34 | 42.39 | 3485300.0 |
| 2006-04-21 13:00:00 | QQQ | ETF | 42.39 | 42.43 | 42.37 | 42.39 | 1798400.0 |
| 2006-04-21 13:30:00 | QQQ | ETF | 42.39 | 42.4 | 42.33 | 42.34 | 1494600.0 |
| 2006-04-21 14:00:00 | QQQ | ETF | 42.33 | 42.34 | 42.08 | 42.1 | 10676500.0 |
| 2006-04-21 14:30:00 | QQQ | ETF | 42.11 | 42.11 | 41.87 | 41.9 | 23358400.0 |
| 2006-04-21 15:00:00 | QQQ | ETF | 41.91 | 41.94 | 41.82 | 41.94 | 16253900.0 |
| 2006-04-21 15:30:00 | QQQ | ETF | 41.94 | 42.05 | 41.9 | 41.97 | 19359700.0 |
| 2006-04-21 08:00:00 | IWM | ETF | 76.98 | 77.08 | 76.85 | 77.08 | 139000.0 |
| 2006-04-21 08:30:00 | IWM | ETF | 77.08 | 77.24 | 77.02 | 77.08 | 125100.0 |
| 2006-04-21 09:00:00 | IWM | ETF | 77.08 | 77.29 | 77.02 | 77.29 | 477700.0 |
| 2006-04-21 09:30:00 | IWM | ETF | 77.27 | 77.35 | 76.95 | 76.98 | 3290800.0 |
| 2006-04-21 10:00:00 | IWM | ETF | 76.98 | 77.22 | 76.77 | 76.83 | 3976100.0 |
| 2006-04-21 10:30:00 | IWM | ETF | 76.82 | 77.05 | 76.74 | 77.04 | 2549300.0 |
| 2006-04-21 11:00:00 | IWM | ETF | 77.05 | 77.09 | 76.84 | 76.97 | 1746800.0 |
| 2006-04-21 11:30:00 | IWM | ETF | 76.9605 | 77.05 | 76.91 | 76.99 | 1961300.0 |
| 2006-04-21 12:00:00 | IWM | ETF | 77.0 | 77.08 | 76.93 | 77.04 | 938100.0 |
| 2006-04-21 12:30:00 | IWM | ETF | 77.04 | 77.11 | 77.01 | 77.03 | 602400.0 |
| 2006-04-21 13:00:00 | IWM | ETF | 77.03 | 77.1 | 77.02 | 77.07 | 920000.0 |
| 2006-04-21 13:30:00 | IWM | ETF | 77.08 | 77.19 | 77.05 | 77.07 | 1319700.0 |
> showing 50 of 2,198 rows — these rows as CSV