PREVIEW / etf_30min / 2006-12-21
file: by_date/etf_30min/2006/2006-12-21.parquet size: 91 KB rows: 3,122
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-21 06:00:00 | SPY | ETF | 142.37 | 142.37 | 142.37 | 142.37 | 1300.0 |
| 2006-12-21 08:00:00 | SPY | ETF | 142.34 | 142.39 | 142.32 | 142.39 | 561400.0 |
| 2006-12-21 08:30:00 | SPY | ETF | 142.26 | 142.5 | 141.95 | 142.27 | 547400.0 |
| 2006-12-21 09:00:00 | SPY | ETF | 142.29 | 142.29 | 142.2 | 142.25 | 604400.0 |
| 2006-12-21 09:30:00 | SPY | ETF | 142.27 | 142.43 | 142.17 | 142.26 | 6015200.0 |
| 2006-12-21 10:00:00 | SPY | ETF | 142.26 | 142.33 | 142.03 | 142.11 | 4295700.0 |
| 2006-12-21 10:30:00 | SPY | ETF | 142.11 | 142.26 | 141.95 | 141.96 | 3173300.0 |
| 2006-12-21 11:00:00 | SPY | ETF | 141.96 | 142.19 | 141.95 | 142.11 | 2107400.0 |
| 2006-12-21 11:30:00 | SPY | ETF | 142.1 | 142.17 | 142.0 | 142.03 | 1408500.0 |
| 2006-12-21 12:00:00 | SPY | ETF | 142.03 | 142.04 | 141.66 | 141.74 | 3990400.0 |
| 2006-12-21 12:30:00 | SPY | ETF | 141.74 | 141.94 | 141.46 | 141.57 | 4435100.0 |
| 2006-12-21 13:00:00 | SPY | ETF | 141.57 | 141.63 | 141.4 | 141.62 | 3326400.0 |
| 2006-12-21 13:30:00 | SPY | ETF | 141.62 | 141.71 | 141.38 | 141.41 | 3242500.0 |
| 2006-12-21 14:00:00 | SPY | ETF | 141.4 | 141.65 | 141.32 | 141.58 | 2695800.0 |
| 2006-12-21 14:30:00 | SPY | ETF | 141.58 | 141.7 | 141.44 | 141.57 | 2107400.0 |
| 2006-12-21 15:00:00 | SPY | ETF | 141.57 | 141.79 | 141.53 | 141.61 | 2860200.0 |
| 2006-12-21 15:30:00 | SPY | ETF | 141.6 | 141.68 | 141.58 | 141.63 | 3619100.0 |
| 2006-12-21 16:00:00 | SPY | ETF | 141.63 | 141.7 | 141.52 | 141.67 | 792000.0 |
| 2006-12-21 16:30:00 | SPY | ETF | 141.67 | 141.7 | 141.63 | 141.69 | 286900.0 |
| 2006-12-21 17:00:00 | SPY | ETF | 141.69 | 141.73 | 141.6 | 141.66 | 50400.0 |
| 2006-12-21 17:30:00 | SPY | ETF | 141.61 | 141.68 | 141.6 | 141.63 | 2600.0 |
| 2006-12-21 18:30:00 | SPY | ETF | 141.67 | 141.67 | 141.67 | 141.67 | 100.0 |
| 2006-12-21 19:30:00 | SPY | ETF | 141.68 | 141.68 | 141.68 | 141.68 | 300.0 |
| 2006-12-21 09:30:00 | QQQ | ETF | 43.75 | 43.78 | 43.62 | 43.65 | 18440700.0 |
| 2006-12-21 10:00:00 | QQQ | ETF | 43.66 | 43.73 | 43.61 | 43.66 | 6669000.0 |
| 2006-12-21 10:30:00 | QQQ | ETF | 43.66 | 43.78 | 43.65 | 43.67 | 5865800.0 |
| 2006-12-21 11:00:00 | QQQ | ETF | 43.67 | 43.79 | 43.66 | 43.74 | 4547200.0 |
| 2006-12-21 11:30:00 | QQQ | ETF | 43.75 | 43.78 | 43.69 | 43.7 | 2511200.0 |
| 2006-12-21 12:00:00 | QQQ | ETF | 43.69 | 43.7 | 43.5 | 43.53 | 8647100.0 |
| 2006-12-21 12:30:00 | QQQ | ETF | 43.52 | 43.53 | 43.3 | 43.38 | 12935200.0 |
| 2006-12-21 13:00:00 | QQQ | ETF | 43.38 | 43.43 | 43.28 | 43.43 | 6707200.0 |
| 2006-12-21 13:30:00 | QQQ | ETF | 43.43 | 43.46 | 43.28 | 43.29 | 5551400.0 |
| 2006-12-21 14:00:00 | QQQ | ETF | 43.29 | 43.4 | 43.21 | 43.36 | 7351400.0 |
| 2006-12-21 14:30:00 | QQQ | ETF | 43.37 | 43.45 | 43.33 | 43.4 | 5640800.0 |
| 2006-12-21 15:00:00 | QQQ | ETF | 43.4 | 43.49 | 43.39 | 43.42 | 5475200.0 |
| 2006-12-21 15:30:00 | QQQ | ETF | 43.41 | 43.47 | 43.37 | 43.38 | 6787100.0 |
| 2006-12-21 08:00:00 | IWM | ETF | 78.1 | 78.1 | 78.07 | 78.08 | 72500.0 |
| 2006-12-21 08:30:00 | IWM | ETF | 78.09 | 78.09 | 77.93 | 77.99 | 35900.0 |
| 2006-12-21 09:00:00 | IWM | ETF | 78.0 | 78.0 | 77.95 | 78.0 | 442600.0 |
| 2006-12-21 09:30:00 | IWM | ETF | 77.99 | 78.35 | 77.8 | 78.21 | 5901900.0 |
| 2006-12-21 10:00:00 | IWM | ETF | 78.2 | 78.3 | 78.09 | 78.17 | 3086000.0 |
| 2006-12-21 10:30:00 | IWM | ETF | 78.17 | 78.35 | 78.15 | 78.21 | 4175600.0 |
| 2006-12-21 11:00:00 | IWM | ETF | 78.21 | 78.35 | 78.21 | 78.27 | 3129100.0 |
| 2006-12-21 11:30:00 | IWM | ETF | 78.27 | 78.34 | 78.22 | 78.24 | 1367000.0 |
| 2006-12-21 12:00:00 | IWM | ETF | 78.24 | 78.24 | 77.98 | 78.02 | 4188700.0 |
| 2006-12-21 12:30:00 | IWM | ETF | 78.05 | 78.05 | 77.62 | 77.66 | 8005600.0 |
| 2006-12-21 13:00:00 | IWM | ETF | 77.65 | 77.65 | 77.45 | 77.59 | 3198500.0 |
| 2006-12-21 13:30:00 | IWM | ETF | 77.6 | 77.62 | 77.41 | 77.44 | 2624700.0 |
| 2006-12-21 14:00:00 | IWM | ETF | 77.45 | 77.59 | 77.31 | 77.53 | 5868400.0 |
| 2006-12-21 14:30:00 | IWM | ETF | 77.53 | 77.65 | 77.33 | 77.49 | 2266700.0 |
> showing 50 of 3,122 rows — these rows as CSV