PREVIEW / etf_30min / 2006-06-16
file: by_date/etf_30min/2006/2006-06-16.parquet size: 68 KB rows: 2,455
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-06-16 04:30:00 | SPY | ETF | 125.42 | 125.42 | 125.42 | 125.42 | 100.0 |
| 2006-06-16 05:30:00 | SPY | ETF | 125.32 | 125.35 | 125.32 | 125.35 | 20100.0 |
| 2006-06-16 06:00:00 | SPY | ETF | 125.37 | 125.45 | 125.37 | 125.45 | 9300.0 |
| 2006-06-16 06:30:00 | SPY | ETF | 125.45 | 125.45 | 125.45 | 125.45 | 500.0 |
| 2006-06-16 07:00:00 | SPY | ETF | 125.47 | 125.47 | 125.4 | 125.4 | 76900.0 |
| 2006-06-16 07:30:00 | SPY | ETF | 125.35 | 125.39 | 125.31 | 125.39 | 128300.0 |
| 2006-06-16 08:00:00 | SPY | ETF | 125.39 | 126.12 | 125.31 | 125.35 | 4437600.0 |
| 2006-06-16 08:30:00 | SPY | ETF | 125.34 | 125.34 | 125.12 | 125.13 | 1866900.0 |
| 2006-06-16 09:00:00 | SPY | ETF | 125.14 | 126.048 | 125.07 | 125.17 | 1993700.0 |
| 2006-06-16 09:30:00 | SPY | ETF | 125.19 | 125.56 | 125.06 | 125.41 | 13549200.0 |
| 2006-06-16 10:00:00 | SPY | ETF | 125.4 | 125.42 | 124.9 | 124.94 | 8725000.0 |
| 2006-06-16 10:30:00 | SPY | ETF | 124.98 | 125.18 | 124.78 | 124.868 | 6454700.0 |
| 2006-06-16 11:00:00 | SPY | ETF | 124.88 | 125.48 | 124.57 | 124.63 | 5505400.0 |
| 2006-06-16 11:30:00 | SPY | ETF | 124.64 | 124.96 | 124.59 | 124.85 | 6041700.0 |
| 2006-06-16 12:00:00 | SPY | ETF | 124.85 | 125.14 | 124.7 | 124.76 | 4387200.0 |
| 2006-06-16 12:30:00 | SPY | ETF | 124.77 | 124.86 | 124.46 | 124.78 | 9059000.0 |
| 2006-06-16 13:00:00 | SPY | ETF | 124.78 | 124.93 | 124.69 | 124.83 | 2102800.0 |
| 2006-06-16 13:30:00 | SPY | ETF | 124.82 | 124.93 | 124.68 | 124.83 | 1622800.0 |
| 2006-06-16 14:00:00 | SPY | ETF | 124.83 | 125.15 | 124.71 | 124.9 | 3373600.0 |
| 2006-06-16 14:30:00 | SPY | ETF | 124.92 | 125.07 | 124.8 | 125.03 | 2459200.0 |
| 2006-06-16 15:00:00 | SPY | ETF | 125.03 | 125.33 | 125.0 | 125.29 | 6890800.0 |
| 2006-06-16 15:30:00 | SPY | ETF | 125.28 | 125.4 | 124.95 | 124.97 | 9784400.0 |
| 2006-06-16 16:00:00 | SPY | ETF | 124.99 | 125.03 | 124.65 | 124.85 | 1328600.0 |
| 2006-06-16 16:30:00 | SPY | ETF | 124.85 | 124.85 | 124.81 | 124.84 | 857600.0 |
| 2006-06-16 17:00:00 | SPY | ETF | 124.83 | 124.83 | 124.83 | 124.83 | 500.0 |
| 2006-06-16 17:30:00 | SPY | ETF | 124.353 | 124.85 | 124.353 | 124.85 | 1010000.0 |
| 2006-06-16 18:00:00 | SPY | ETF | 124.81 | 124.81 | 124.72 | 124.72 | 6000.0 |
| 2006-06-16 18:30:00 | SPY | ETF | 124.71 | 124.71 | 124.48 | 124.48 | 5900.0 |
| 2006-06-16 19:00:00 | SPY | ETF | 124.65 | 124.65 | 124.65 | 124.65 | 400.0 |
| 2006-06-16 19:30:00 | SPY | ETF | 124.73 | 124.8 | 124.73 | 124.8 | 1700.0 |
| 2006-06-16 09:30:00 | QQQ | ETF | 38.53 | 38.68 | 38.43 | 38.62 | 19629200.0 |
| 2006-06-16 10:00:00 | QQQ | ETF | 38.63 | 38.65 | 38.38 | 38.38 | 11334200.0 |
| 2006-06-16 10:30:00 | QQQ | ETF | 38.38 | 38.48 | 38.27 | 38.31 | 12998800.0 |
| 2006-06-16 11:00:00 | QQQ | ETF | 38.3 | 38.44 | 38.23 | 38.28 | 7724800.0 |
| 2006-06-16 11:30:00 | QQQ | ETF | 38.28 | 38.4 | 38.25 | 38.33 | 5750500.0 |
| 2006-06-16 12:00:00 | QQQ | ETF | 38.34 | 38.44 | 38.29 | 38.35 | 5259000.0 |
| 2006-06-16 12:30:00 | QQQ | ETF | 38.34 | 38.35 | 38.2 | 38.32 | 6863900.0 |
| 2006-06-16 13:00:00 | QQQ | ETF | 38.32 | 38.43 | 38.29 | 38.38 | 3959900.0 |
| 2006-06-16 13:30:00 | QQQ | ETF | 38.38 | 38.39 | 38.31 | 38.37 | 3546300.0 |
| 2006-06-16 14:00:00 | QQQ | ETF | 38.37 | 38.5 | 38.34 | 38.44 | 5674000.0 |
| 2006-06-16 14:30:00 | QQQ | ETF | 38.44 | 38.47 | 38.35 | 38.45 | 3195300.0 |
| 2006-06-16 15:00:00 | QQQ | ETF | 38.45 | 38.55 | 38.43 | 38.54 | 7980700.0 |
| 2006-06-16 15:30:00 | QQQ | ETF | 38.54 | 38.59 | 38.37 | 38.37 | 13234900.0 |
| 2006-06-16 07:30:00 | IWM | ETF | 69.65 | 69.65 | 69.65 | 69.65 | 500.0 |
| 2006-06-16 08:00:00 | IWM | ETF | 69.63 | 69.7 | 69.63 | 69.65 | 47800.0 |
| 2006-06-16 08:30:00 | IWM | ETF | 69.65 | 69.65 | 69.31 | 69.33 | 237600.0 |
| 2006-06-16 09:00:00 | IWM | ETF | 69.31 | 69.62 | 69.27 | 69.61 | 1109000.0 |
| 2006-06-16 09:30:00 | IWM | ETF | 69.6 | 69.7 | 69.25 | 69.61 | 9994500.0 |
| 2006-06-16 10:00:00 | IWM | ETF | 69.62 | 69.63 | 68.83 | 68.83 | 6774500.0 |
| 2006-06-16 10:30:00 | IWM | ETF | 68.83 | 69.12 | 68.57 | 68.66 | 7006000.0 |
> showing 50 of 2,455 rows — these rows as CSV