PREVIEW / etf_30min / 2006-12-29
file: by_date/etf_30min/2006/2006-12-29.parquet size: 87 KB rows: 3,119
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-29 07:00:00 | SPY | ETF | 142.14 | 142.21 | 142.14 | 142.21 | 6500.0 |
| 2006-12-29 07:30:00 | SPY | ETF | 142.22 | 142.22 | 142.22 | 142.22 | 25000.0 |
| 2006-12-29 08:00:00 | SPY | ETF | 142.2 | 142.29 | 142.19 | 142.25 | 122100.0 |
| 2006-12-29 08:30:00 | SPY | ETF | 142.25 | 142.33 | 142.25 | 142.31 | 39200.0 |
| 2006-12-29 09:00:00 | SPY | ETF | 142.3 | 142.31 | 142.09 | 142.09 | 367000.0 |
| 2006-12-29 09:30:00 | SPY | ETF | 142.1 | 142.46 | 141.97 | 142.34 | 4586800.0 |
| 2006-12-29 10:00:00 | SPY | ETF | 142.34 | 142.54 | 142.32 | 142.38 | 2942500.0 |
| 2006-12-29 10:30:00 | SPY | ETF | 142.38 | 142.44 | 142.22 | 142.29 | 2870000.0 |
| 2006-12-29 11:00:00 | SPY | ETF | 142.29 | 142.31 | 142.15 | 142.19 | 3037800.0 |
| 2006-12-29 11:30:00 | SPY | ETF | 142.18 | 142.28 | 142.15 | 142.21 | 2450500.0 |
| 2006-12-29 12:00:00 | SPY | ETF | 142.21 | 142.3459 | 142.2 | 142.22 | 2139500.0 |
| 2006-12-29 12:30:00 | SPY | ETF | 142.23 | 142.23 | 142.07 | 142.14 | 1420900.0 |
| 2006-12-29 13:00:00 | SPY | ETF | 142.145 | 142.21 | 142.12 | 142.14 | 942700.0 |
| 2006-12-29 13:30:00 | SPY | ETF | 142.14 | 142.23 | 142.07 | 142.21 | 1670300.0 |
| 2006-12-29 14:00:00 | SPY | ETF | 142.18 | 142.22 | 142.05 | 142.06 | 1890400.0 |
| 2006-12-29 14:30:00 | SPY | ETF | 142.06 | 142.07 | 141.96 | 142.05 | 3102000.0 |
| 2006-12-29 15:00:00 | SPY | ETF | 142.05 | 142.1 | 141.43 | 141.56 | 4616200.0 |
| 2006-12-29 15:30:00 | SPY | ETF | 141.56 | 141.98 | 141.49 | 141.5 | 8857200.0 |
| 2006-12-29 16:00:00 | SPY | ETF | 141.48 | 141.78 | 141.41 | 141.64 | 2241600.0 |
| 2006-12-29 16:30:00 | SPY | ETF | 141.61 | 141.64 | 141.54 | 141.54 | 166600.0 |
| 2006-12-29 17:00:00 | SPY | ETF | 141.63 | 141.67 | 141.63 | 141.67 | 15800.0 |
| 2006-12-29 17:30:00 | SPY | ETF | 141.64 | 141.64 | 141.6 | 141.6 | 4900.0 |
| 2006-12-29 18:00:00 | SPY | ETF | 141.65 | 141.65 | 141.65 | 141.65 | 5100.0 |
| 2006-12-29 18:30:00 | SPY | ETF | 141.67 | 141.67 | 141.65 | 141.65 | 900.0 |
| 2006-12-29 19:30:00 | SPY | ETF | 141.6 | 141.67 | 141.6 | 141.67 | 1400.0 |
| 2006-12-29 09:30:00 | QQQ | ETF | 43.2 | 43.5 | 43.19 | 43.46 | 10032200.0 |
| 2006-12-29 10:00:00 | QQQ | ETF | 43.46 | 43.61 | 43.46 | 43.55 | 10599700.0 |
| 2006-12-29 10:30:00 | QQQ | ETF | 43.55 | 43.59 | 43.41 | 43.49 | 8328700.0 |
| 2006-12-29 11:00:00 | QQQ | ETF | 43.48 | 43.48 | 43.41 | 43.42 | 2204800.0 |
| 2006-12-29 11:30:00 | QQQ | ETF | 43.42 | 43.47 | 43.42 | 43.43 | 1334000.0 |
| 2006-12-29 12:00:00 | QQQ | ETF | 43.43 | 43.44 | 43.41 | 43.41 | 733300.0 |
| 2006-12-29 12:30:00 | QQQ | ETF | 43.41 | 43.41 | 43.33 | 43.38 | 4330900.0 |
| 2006-12-29 13:00:00 | QQQ | ETF | 43.38 | 43.41 | 43.36 | 43.36 | 1187100.0 |
| 2006-12-29 13:30:00 | QQQ | ETF | 43.36 | 43.39 | 43.31 | 43.37 | 2832700.0 |
| 2006-12-29 14:00:00 | QQQ | ETF | 43.37 | 43.38 | 43.28 | 43.28 | 3079900.0 |
| 2006-12-29 14:30:00 | QQQ | ETF | 43.28 | 43.3 | 43.22 | 43.25 | 3587400.0 |
| 2006-12-29 15:00:00 | QQQ | ETF | 43.25 | 43.3 | 43.12 | 43.15 | 9477700.0 |
| 2006-12-29 15:30:00 | QQQ | ETF | 43.16 | 43.23 | 43.13 | 43.14 | 13128300.0 |
| 2006-12-29 08:00:00 | IWM | ETF | 78.79 | 78.8 | 78.79 | 78.8 | 18800.0 |
| 2006-12-29 08:30:00 | IWM | ETF | 78.82 | 78.83 | 78.82 | 78.82 | 105600.0 |
| 2006-12-29 09:00:00 | IWM | ETF | 78.84 | 78.85 | 78.69 | 78.7 | 55900.0 |
| 2006-12-29 09:30:00 | IWM | ETF | 78.66 | 78.95 | 78.56 | 78.88 | 3380200.0 |
| 2006-12-29 10:00:00 | IWM | ETF | 78.88 | 78.99 | 78.81 | 78.92 | 1782400.0 |
| 2006-12-29 10:30:00 | IWM | ETF | 78.92 | 78.99 | 78.7 | 78.78 | 1634100.0 |
| 2006-12-29 11:00:00 | IWM | ETF | 78.78 | 78.8 | 78.7 | 78.72 | 1156800.0 |
| 2006-12-29 11:30:00 | IWM | ETF | 78.72 | 78.8 | 78.71 | 78.75 | 833800.0 |
| 2006-12-29 12:00:00 | IWM | ETF | 78.75 | 78.77 | 78.74 | 78.74 | 605700.0 |
| 2006-12-29 12:30:00 | IWM | ETF | 78.75 | 78.75 | 78.6 | 78.64 | 1254100.0 |
| 2006-12-29 13:00:00 | IWM | ETF | 78.63 | 78.74 | 78.6 | 78.61 | 817400.0 |
| 2006-12-29 13:30:00 | IWM | ETF | 78.62 | 78.62 | 78.5 | 78.56 | 699200.0 |
> showing 50 of 3,119 rows — these rows as CSV