PREVIEW / etf_30min / 2006-12-15
file: by_date/etf_30min/2006/2006-12-15.parquet size: 88 KB rows: 3,118
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-15 04:00:00 | SPY | ETF | 142.38 | 142.38 | 142.38 | 142.38 | 3100.0 |
| 2006-12-15 06:30:00 | SPY | ETF | 142.34 | 142.34 | 142.32 | 142.32 | 28000.0 |
| 2006-12-15 07:00:00 | SPY | ETF | 142.31 | 142.32 | 142.3 | 142.3 | 7000.0 |
| 2006-12-15 07:30:00 | SPY | ETF | 142.32 | 142.36 | 142.27 | 142.27 | 131700.0 |
| 2006-12-15 08:00:00 | SPY | ETF | 142.28 | 142.37 | 142.2 | 142.28 | 363000.0 |
| 2006-12-15 08:30:00 | SPY | ETF | 142.28 | 142.97 | 142.28 | 142.9 | 6083100.0 |
| 2006-12-15 09:00:00 | SPY | ETF | 142.9 | 142.93 | 142.65 | 142.65 | 1281800.0 |
| 2006-12-15 09:30:00 | SPY | ETF | 142.64 | 142.78 | 142.46 | 142.68 | 11862700.0 |
| 2006-12-15 10:00:00 | SPY | ETF | 142.68 | 142.71 | 142.54 | 142.66 | 4697300.0 |
| 2006-12-15 10:30:00 | SPY | ETF | 142.66 | 142.82 | 142.63 | 142.8 | 3038600.0 |
| 2006-12-15 11:00:00 | SPY | ETF | 142.8 | 142.89 | 142.65 | 142.65 | 5608100.0 |
| 2006-12-15 11:30:00 | SPY | ETF | 142.65 | 142.73 | 142.59 | 142.67 | 2251400.0 |
| 2006-12-15 12:00:00 | SPY | ETF | 142.68 | 142.69 | 142.34 | 142.46 | 4936500.0 |
| 2006-12-15 12:30:00 | SPY | ETF | 142.47 | 142.66 | 142.42 | 142.51 | 2253000.0 |
| 2006-12-15 13:00:00 | SPY | ETF | 142.51 | 142.65 | 142.43 | 142.47 | 2623500.0 |
| 2006-12-15 13:30:00 | SPY | ETF | 142.479 | 142.8 | 142.24 | 142.44 | 4417400.0 |
| 2006-12-15 14:00:00 | SPY | ETF | 142.43 | 142.58 | 142.35 | 142.56 | 4129700.0 |
| 2006-12-15 14:30:00 | SPY | ETF | 142.56 | 142.58 | 142.45 | 142.55 | 1347600.0 |
| 2006-12-15 15:00:00 | SPY | ETF | 142.55 | 142.59 | 142.43 | 142.44 | 3603600.0 |
| 2006-12-15 15:30:00 | SPY | ETF | 142.43 | 142.51 | 142.32 | 142.4 | 4861300.0 |
| 2006-12-15 16:00:00 | SPY | ETF | 142.4 | 142.45 | 142.24 | 142.25 | 814500.0 |
| 2006-12-15 16:30:00 | SPY | ETF | 142.25 | 142.34 | 142.2 | 142.31 | 154700.0 |
| 2006-12-15 17:00:00 | SPY | ETF | 142.27 | 142.3 | 142.27 | 142.27 | 25300.0 |
| 2006-12-15 17:30:00 | SPY | ETF | 142.5677 | 142.5677 | 142.32 | 142.32 | 1101100.0 |
| 2006-12-15 18:00:00 | SPY | ETF | 142.34 | 142.34 | 142.34 | 142.34 | 1300.0 |
| 2006-12-15 19:30:00 | SPY | ETF | 142.3 | 142.3 | 142.27 | 142.27 | 1400.0 |
| 2006-12-15 09:30:00 | QQQ | ETF | 44.67 | 44.76 | 44.49 | 44.64 | 22796500.0 |
| 2006-12-15 10:00:00 | QQQ | ETF | 44.63 | 44.65 | 44.56 | 44.62 | 5311000.0 |
| 2006-12-15 10:30:00 | QQQ | ETF | 44.62 | 44.68 | 44.57 | 44.61 | 4038200.0 |
| 2006-12-15 11:00:00 | QQQ | ETF | 44.62 | 44.66 | 44.54 | 44.56 | 3389800.0 |
| 2006-12-15 11:30:00 | QQQ | ETF | 44.56 | 44.66 | 44.54 | 44.62 | 4192800.0 |
| 2006-12-15 12:00:00 | QQQ | ETF | 44.61 | 44.63 | 44.4 | 44.46 | 7543800.0 |
| 2006-12-15 12:30:00 | QQQ | ETF | 44.46 | 44.55 | 44.45 | 44.47 | 2960000.0 |
| 2006-12-15 13:00:00 | QQQ | ETF | 44.47 | 44.5 | 44.42 | 44.44 | 4584000.0 |
| 2006-12-15 13:30:00 | QQQ | ETF | 44.44 | 44.6 | 44.35 | 44.45 | 5647700.0 |
| 2006-12-15 14:00:00 | QQQ | ETF | 44.46 | 44.51 | 44.4 | 44.46 | 4603100.0 |
| 2006-12-15 14:30:00 | QQQ | ETF | 44.47 | 44.49 | 44.4 | 44.48 | 3065700.0 |
| 2006-12-15 15:00:00 | QQQ | ETF | 44.49 | 44.52 | 44.44 | 44.45 | 4162500.0 |
| 2006-12-15 15:30:00 | QQQ | ETF | 44.46 | 44.47 | 44.38 | 44.43 | 6342700.0 |
| 2006-12-15 08:00:00 | IWM | ETF | 78.95 | 78.97 | 78.93 | 78.97 | 7100.0 |
| 2006-12-15 08:30:00 | IWM | ETF | 79.04 | 79.42 | 78.99 | 79.38 | 843100.0 |
| 2006-12-15 09:00:00 | IWM | ETF | 79.37 | 79.43 | 79.25 | 79.3 | 704800.0 |
| 2006-12-15 09:30:00 | IWM | ETF | 79.3 | 79.43 | 79.11 | 79.33 | 6124100.0 |
| 2006-12-15 10:00:00 | IWM | ETF | 79.34 | 79.35 | 79.2 | 79.31 | 3424500.0 |
| 2006-12-15 10:30:00 | IWM | ETF | 79.32 | 79.41 | 79.22 | 79.4 | 2394900.0 |
| 2006-12-15 11:00:00 | IWM | ETF | 79.4 | 79.5 | 79.2675 | 79.28 | 2741000.0 |
| 2006-12-15 11:30:00 | IWM | ETF | 79.28 | 79.37 | 79.25 | 79.3 | 3105900.0 |
| 2006-12-15 12:00:00 | IWM | ETF | 79.3 | 79.3 | 79.1 | 79.11 | 1378700.0 |
| 2006-12-15 12:30:00 | IWM | ETF | 79.09 | 79.22 | 79.05 | 79.09 | 1273200.0 |
| 2006-12-15 13:00:00 | IWM | ETF | 79.08 | 79.15 | 78.93 | 79.0175 | 4272400.0 |
> showing 50 of 3,118 rows — these rows as CSV