PREVIEW / etf_30min / 2006-05-04
file: by_date/etf_30min/2006/2006-05-04.parquet size: 62 KB rows: 2,250
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-05-04 06:30:00 | SPY | ETF | 131.17 | 131.17 | 131.1 | 131.1 | 2800.0 |
| 2006-05-04 07:00:00 | SPY | ETF | 131.1 | 131.1 | 131.09 | 131.09 | 1200.0 |
| 2006-05-04 07:30:00 | SPY | ETF | 131.02 | 131.05 | 131.0 | 131.05 | 50200.0 |
| 2006-05-04 08:00:00 | SPY | ETF | 131.12 | 131.12 | 131.01 | 131.04 | 683500.0 |
| 2006-05-04 08:30:00 | SPY | ETF | 131.05 | 131.05 | 130.79 | 130.95 | 573000.0 |
| 2006-05-04 09:00:00 | SPY | ETF | 130.93 | 131.13 | 130.93 | 131.06 | 258600.0 |
| 2006-05-04 09:30:00 | SPY | ETF | 131.08 | 131.43 | 131.05 | 131.33 | 7678600.0 |
| 2006-05-04 10:00:00 | SPY | ETF | 131.34 | 131.62 | 131.32 | 131.47 | 5580700.0 |
| 2006-05-04 10:30:00 | SPY | ETF | 131.47 | 131.51 | 131.28 | 131.28 | 4469400.0 |
| 2006-05-04 11:00:00 | SPY | ETF | 131.29 | 131.52 | 131.28 | 131.44 | 2780600.0 |
| 2006-05-04 11:30:00 | SPY | ETF | 131.44 | 131.54 | 131.38 | 131.4 | 2587200.0 |
| 2006-05-04 12:00:00 | SPY | ETF | 131.4 | 131.42 | 131.12 | 131.15 | 2772000.0 |
| 2006-05-04 12:30:00 | SPY | ETF | 131.17 | 131.24 | 130.97 | 131.17 | 2317800.0 |
| 2006-05-04 13:00:00 | SPY | ETF | 131.17 | 131.27 | 131.15 | 131.24 | 1429100.0 |
| 2006-05-04 13:30:00 | SPY | ETF | 131.25 | 131.37 | 131.17 | 131.29 | 1282100.0 |
| 2006-05-04 14:00:00 | SPY | ETF | 131.31 | 131.48 | 131.28 | 131.4 | 1407300.0 |
| 2006-05-04 14:30:00 | SPY | ETF | 131.41 | 131.46 | 131.23 | 131.32 | 1712400.0 |
| 2006-05-04 15:00:00 | SPY | ETF | 131.32 | 131.42 | 131.26 | 131.36 | 2218500.0 |
| 2006-05-04 15:30:00 | SPY | ETF | 131.37 | 131.4 | 131.25 | 131.28 | 3551300.0 |
| 2006-05-04 16:00:00 | SPY | ETF | 131.29 | 131.36 | 131.27 | 131.32 | 717600.0 |
| 2006-05-04 16:30:00 | SPY | ETF | 131.32 | 131.35 | 131.29 | 131.34 | 15500.0 |
| 2006-05-04 17:00:00 | SPY | ETF | 131.34 | 131.34 | 131.31 | 131.31 | 2600.0 |
| 2006-05-04 17:30:00 | SPY | ETF | 131.33 | 131.33 | 131.33 | 131.33 | 400.0 |
| 2006-05-04 18:00:00 | SPY | ETF | 131.3 | 131.34 | 131.3 | 131.34 | 5200.0 |
| 2006-05-04 18:30:00 | SPY | ETF | 131.35 | 131.35 | 131.34 | 131.34 | 8500.0 |
| 2006-05-04 19:00:00 | SPY | ETF | 131.32 | 131.32 | 131.3 | 131.3 | 300.0 |
| 2006-05-04 19:30:00 | SPY | ETF | 131.31 | 131.31 | 131.31 | 131.31 | 1500.0 |
| 2006-05-04 09:30:00 | QQQ | ETF | 41.53 | 41.87 | 41.53 | 41.85 | 28992000.0 |
| 2006-05-04 10:00:00 | QQQ | ETF | 41.85 | 41.99 | 41.84 | 41.88 | 12097900.0 |
| 2006-05-04 10:30:00 | QQQ | ETF | 41.88 | 41.9 | 41.77 | 41.77 | 5858800.0 |
| 2006-05-04 11:00:00 | QQQ | ETF | 41.77 | 41.9 | 41.76 | 41.86 | 3379700.0 |
| 2006-05-04 11:30:00 | QQQ | ETF | 41.86 | 41.96 | 41.84 | 41.91 | 4153100.0 |
| 2006-05-04 12:00:00 | QQQ | ETF | 41.92 | 41.92 | 41.8 | 41.83 | 2991200.0 |
| 2006-05-04 12:30:00 | QQQ | ETF | 41.82 | 41.83 | 41.73 | 41.78 | 3981200.0 |
| 2006-05-04 13:00:00 | QQQ | ETF | 41.78 | 42.12 | 41.46 | 41.86 | 2829300.0 |
| 2006-05-04 13:30:00 | QQQ | ETF | 41.86 | 41.96 | 41.81 | 41.89 | 2794200.0 |
| 2006-05-04 14:00:00 | QQQ | ETF | 41.89 | 41.95 | 41.86 | 41.91 | 2139300.0 |
| 2006-05-04 14:30:00 | QQQ | ETF | 41.92 | 41.93 | 41.84 | 41.87 | 2982200.0 |
| 2006-05-04 15:00:00 | QQQ | ETF | 41.86 | 41.91 | 41.83 | 41.88 | 2017300.0 |
| 2006-05-04 15:30:00 | QQQ | ETF | 41.87 | 41.89 | 41.81 | 41.82 | 3926800.0 |
| 2006-05-04 08:00:00 | IWM | ETF | 76.3 | 76.32 | 76.17 | 76.17 | 210300.0 |
| 2006-05-04 08:30:00 | IWM | ETF | 76.15 | 76.21 | 76.06 | 76.13 | 815700.0 |
| 2006-05-04 09:00:00 | IWM | ETF | 76.18 | 76.3 | 76.14 | 76.27 | 262200.0 |
| 2006-05-04 09:30:00 | IWM | ETF | 76.25 | 76.6 | 76.25 | 76.46 | 4016500.0 |
| 2006-05-04 10:00:00 | IWM | ETF | 76.46 | 76.86 | 76.4 | 76.65 | 2973300.0 |
| 2006-05-04 10:30:00 | IWM | ETF | 76.67 | 76.76 | 76.54 | 76.58 | 2939400.0 |
| 2006-05-04 11:00:00 | IWM | ETF | 76.59 | 76.76 | 76.57 | 76.73 | 1696700.0 |
| 2006-05-04 11:30:00 | IWM | ETF | 76.73 | 76.82 | 76.64 | 76.71 | 1785100.0 |
| 2006-05-04 12:00:00 | IWM | ETF | 76.71 | 76.72 | 76.4 | 76.47 | 2129500.0 |
| 2006-05-04 12:30:00 | IWM | ETF | 76.46 | 76.55 | 76.35 | 76.5 | 1088600.0 |
> showing 50 of 2,250 rows — these rows as CSV