PREVIEW / etf_30min / 2006-12-08
file: by_date/etf_30min/2006/2006-12-08.parquet size: 86 KB rows: 2,996
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-08 07:00:00 | SPY | ETF | 141.19 | 141.23 | 141.19 | 141.23 | 8300.0 |
| 2006-12-08 07:30:00 | SPY | ETF | 141.23 | 141.33 | 141.21 | 141.33 | 476400.0 |
| 2006-12-08 08:00:00 | SPY | ETF | 141.32 | 141.38 | 141.22 | 141.3 | 1074500.0 |
| 2006-12-08 08:30:00 | SPY | ETF | 141.32 | 141.69 | 141.32 | 141.41 | 3719000.0 |
| 2006-12-08 09:00:00 | SPY | ETF | 141.41 | 141.85 | 140.85 | 141.14 | 2371900.0 |
| 2006-12-08 09:30:00 | SPY | ETF | 141.13 | 141.55 | 141.01 | 141.25 | 9663700.0 |
| 2006-12-08 10:00:00 | SPY | ETF | 141.25 | 141.53 | 140.78 | 141.01 | 10569200.0 |
| 2006-12-08 10:30:00 | SPY | ETF | 141.01 | 141.36 | 140.94 | 141.24 | 5751500.0 |
| 2006-12-08 11:00:00 | SPY | ETF | 141.24 | 141.76 | 141.22 | 141.72 | 8145500.0 |
| 2006-12-08 11:30:00 | SPY | ETF | 141.72 | 141.9 | 141.52 | 141.55 | 5562700.0 |
| 2006-12-08 12:00:00 | SPY | ETF | 141.56 | 141.71 | 141.47 | 141.6 | 3621400.0 |
| 2006-12-08 12:30:00 | SPY | ETF | 141.59 | 141.63 | 141.35 | 141.6 | 5529900.0 |
| 2006-12-08 13:00:00 | SPY | ETF | 141.6 | 141.6 | 141.41 | 141.455 | 3007700.0 |
| 2006-12-08 13:30:00 | SPY | ETF | 141.46 | 141.53 | 141.35 | 141.41 | 1971900.0 |
| 2006-12-08 14:00:00 | SPY | ETF | 141.4 | 141.54 | 141.29 | 141.36 | 1777800.0 |
| 2006-12-08 14:30:00 | SPY | ETF | 141.36 | 141.68 | 141.31 | 141.58 | 3080100.0 |
| 2006-12-08 15:00:00 | SPY | ETF | 141.59 | 141.65 | 141.5 | 141.56 | 1422600.0 |
| 2006-12-08 15:30:00 | SPY | ETF | 141.56 | 141.63 | 141.3 | 141.41 | 3882300.0 |
| 2006-12-08 16:00:00 | SPY | ETF | 141.39 | 141.44 | 141.33 | 141.39 | 1184700.0 |
| 2006-12-08 16:30:00 | SPY | ETF | 141.38 | 141.45 | 141.35 | 141.36 | 61900.0 |
| 2006-12-08 17:00:00 | SPY | ETF | 141.36 | 141.36 | 140.8474 | 141.32 | 2856100.0 |
| 2006-12-08 17:30:00 | SPY | ETF | 141.33 | 141.36 | 141.32 | 141.36 | 519200.0 |
| 2006-12-08 18:00:00 | SPY | ETF | 141.36 | 141.36 | 141.36 | 141.36 | 2400.0 |
| 2006-12-08 19:30:00 | SPY | ETF | 141.42 | 141.42 | 141.42 | 141.42 | 900.0 |
| 2006-12-08 09:30:00 | QQQ | ETF | 43.57 | 43.83 | 43.53 | 43.66 | 19324900.0 |
| 2006-12-08 10:00:00 | QQQ | ETF | 43.66 | 43.67 | 43.47 | 43.65 | 16094100.0 |
| 2006-12-08 10:30:00 | QQQ | ETF | 43.66 | 43.77 | 43.59 | 43.73 | 6751900.0 |
| 2006-12-08 11:00:00 | QQQ | ETF | 43.73 | 44.17 | 43.73 | 44.13 | 15597400.0 |
| 2006-12-08 11:30:00 | QQQ | ETF | 44.13 | 44.26 | 44.1 | 44.12 | 15746500.0 |
| 2006-12-08 12:00:00 | QQQ | ETF | 44.12 | 44.22 | 44.09 | 44.13 | 4604700.0 |
| 2006-12-08 12:30:00 | QQQ | ETF | 44.13 | 44.15 | 44.05 | 44.13 | 4412500.0 |
| 2006-12-08 13:00:00 | QQQ | ETF | 44.14 | 44.14 | 44.07 | 44.07 | 4100300.0 |
| 2006-12-08 13:30:00 | QQQ | ETF | 44.07 | 44.08 | 43.98 | 44.01 | 3690700.0 |
| 2006-12-08 14:00:00 | QQQ | ETF | 44.01 | 44.08 | 43.96 | 43.99 | 3723000.0 |
| 2006-12-08 14:30:00 | QQQ | ETF | 44.0 | 44.13 | 43.96 | 44.09 | 3446500.0 |
| 2006-12-08 15:00:00 | QQQ | ETF | 44.1 | 44.1 | 43.97 | 44.0 | 4313300.0 |
| 2006-12-08 15:30:00 | QQQ | ETF | 44.0 | 44.02 | 43.84 | 43.9 | 11009300.0 |
| 2006-12-08 07:30:00 | IWM | ETF | 78.74 | 78.74 | 78.74 | 78.74 | 5000.0 |
| 2006-12-08 08:00:00 | IWM | ETF | 78.8 | 78.82 | 78.71 | 78.82 | 690900.0 |
| 2006-12-08 08:30:00 | IWM | ETF | 78.82 | 79.1 | 78.82 | 78.9 | 1158600.0 |
| 2006-12-08 09:00:00 | IWM | ETF | 78.89 | 78.91 | 78.47 | 78.59 | 781100.0 |
| 2006-12-08 09:30:00 | IWM | ETF | 78.62 | 79.0 | 78.41 | 78.6 | 5123800.0 |
| 2006-12-08 10:00:00 | IWM | ETF | 78.58 | 78.75 | 78.16 | 78.56 | 9572800.0 |
| 2006-12-08 10:30:00 | IWM | ETF | 78.58 | 78.83 | 78.49 | 78.68 | 2988400.0 |
| 2006-12-08 11:00:00 | IWM | ETF | 78.69 | 79.21 | 78.69 | 79.1 | 4061200.0 |
| 2006-12-08 11:30:00 | IWM | ETF | 79.11 | 79.34 | 79.07 | 79.08 | 3866300.0 |
| 2006-12-08 12:00:00 | IWM | ETF | 79.08 | 79.17 | 79.0 | 79.12 | 1075600.0 |
| 2006-12-08 12:30:00 | IWM | ETF | 79.12 | 79.12 | 78.86 | 79.0 | 1932700.0 |
| 2006-12-08 13:00:00 | IWM | ETF | 78.99 | 79.1 | 78.93 | 78.97 | 1238400.0 |
| 2006-12-08 13:30:00 | IWM | ETF | 78.97 | 79.02 | 78.79 | 78.85 | 2422100.0 |
> showing 50 of 2,996 rows — these rows as CSV