PREVIEW / etf_30min / 2006-10-23
file: by_date/etf_30min/2006/2006-10-23.parquet size: 85 KB rows: 3,029
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-10-23 07:00:00 | SPY | ETF | 136.77 | 136.77 | 136.77 | 136.77 | 300.0 |
| 2006-10-23 07:30:00 | SPY | ETF | 136.78 | 136.81 | 136.75 | 136.77 | 39200.0 |
| 2006-10-23 08:00:00 | SPY | ETF | 136.77 | 136.85 | 136.75 | 136.82 | 77100.0 |
| 2006-10-23 08:30:00 | SPY | ETF | 136.83 | 136.85 | 136.43 | 136.57 | 577400.0 |
| 2006-10-23 09:00:00 | SPY | ETF | 136.57 | 136.79 | 136.5 | 136.55 | 671700.0 |
| 2006-10-23 09:30:00 | SPY | ETF | 136.56 | 136.92 | 136.39 | 136.87 | 7771400.0 |
| 2006-10-23 10:00:00 | SPY | ETF | 136.88 | 137.55 | 136.85 | 137.53 | 8344000.0 |
| 2006-10-23 10:30:00 | SPY | ETF | 137.53 | 137.57 | 137.37 | 137.41 | 5393100.0 |
| 2006-10-23 11:00:00 | SPY | ETF | 137.42 | 137.75 | 137.42 | 137.53 | 6336500.0 |
| 2006-10-23 11:30:00 | SPY | ETF | 137.5 | 137.66 | 137.5 | 137.6 | 3999800.0 |
| 2006-10-23 12:00:00 | SPY | ETF | 137.59 | 137.8 | 137.58 | 137.73 | 2917000.0 |
| 2006-10-23 12:30:00 | SPY | ETF | 137.73 | 137.8 | 137.57 | 137.61 | 2276800.0 |
| 2006-10-23 13:00:00 | SPY | ETF | 137.61 | 137.72 | 137.51 | 137.7 | 2295600.0 |
| 2006-10-23 13:30:00 | SPY | ETF | 137.7 | 137.74 | 137.44 | 137.55 | 3518500.0 |
| 2006-10-23 14:00:00 | SPY | ETF | 137.56 | 137.57 | 137.26 | 137.34 | 4268000.0 |
| 2006-10-23 14:30:00 | SPY | ETF | 137.35 | 137.56 | 136.8983 | 137.54 | 3431000.0 |
| 2006-10-23 15:00:00 | SPY | ETF | 137.53 | 137.77 | 137.52 | 137.61 | 3917600.0 |
| 2006-10-23 15:30:00 | SPY | ETF | 137.6 | 137.75 | 137.56 | 137.68 | 3864100.0 |
| 2006-10-23 16:00:00 | SPY | ETF | 137.66 | 137.67 | 137.45 | 137.48 | 739800.0 |
| 2006-10-23 16:30:00 | SPY | ETF | 137.48 | 137.6479 | 137.27 | 137.4 | 259200.0 |
| 2006-10-23 17:00:00 | SPY | ETF | 137.4 | 137.4 | 137.35 | 137.37 | 17700.0 |
| 2006-10-23 17:30:00 | SPY | ETF | 137.37 | 137.43 | 137.37 | 137.43 | 107500.0 |
| 2006-10-23 18:00:00 | SPY | ETF | 137.4 | 137.4 | 137.32 | 137.32 | 14100.0 |
| 2006-10-23 19:00:00 | SPY | ETF | 137.33 | 137.34 | 137.3 | 137.3 | 1900.0 |
| 2006-10-23 19:30:00 | SPY | ETF | 137.31 | 137.31 | 137.3 | 137.3 | 1500.0 |
| 2006-10-23 09:30:00 | QQQ | ETF | 41.92 | 42.05 | 41.82 | 42.03 | 10719300.0 |
| 2006-10-23 10:00:00 | QQQ | ETF | 42.02 | 42.55 | 42.02 | 42.53 | 30266600.0 |
| 2006-10-23 10:30:00 | QQQ | ETF | 42.54 | 42.55 | 42.42 | 42.46 | 13215900.0 |
| 2006-10-23 11:00:00 | QQQ | ETF | 42.46 | 42.58 | 42.45 | 42.49 | 11073000.0 |
| 2006-10-23 11:30:00 | QQQ | ETF | 42.48 | 42.52 | 42.42 | 42.47 | 4696200.0 |
| 2006-10-23 12:00:00 | QQQ | ETF | 42.47 | 42.56 | 42.45 | 42.5 | 5408000.0 |
| 2006-10-23 12:30:00 | QQQ | ETF | 42.49 | 42.53 | 42.42 | 42.44 | 4007500.0 |
| 2006-10-23 13:00:00 | QQQ | ETF | 42.44 | 42.49 | 42.43 | 42.49 | 2765000.0 |
| 2006-10-23 13:30:00 | QQQ | ETF | 42.49 | 42.5 | 42.35 | 42.41 | 7047500.0 |
| 2006-10-23 14:00:00 | QQQ | ETF | 42.4 | 42.42 | 42.24 | 42.28 | 8506100.0 |
| 2006-10-23 14:30:00 | QQQ | ETF | 42.28 | 42.42 | 42.26 | 42.38 | 4784300.0 |
| 2006-10-23 15:00:00 | QQQ | ETF | 42.38 | 42.46 | 42.36 | 42.38 | 7381100.0 |
| 2006-10-23 15:30:00 | QQQ | ETF | 42.37 | 42.44 | 42.33 | 42.43 | 8502400.0 |
| 2006-10-23 08:00:00 | IWM | ETF | 76.0 | 76.25 | 75.6 | 75.63 | 11200.0 |
| 2006-10-23 08:30:00 | IWM | ETF | 75.61 | 75.62 | 75.26 | 75.36 | 18300.0 |
| 2006-10-23 09:00:00 | IWM | ETF | 75.36 | 75.4 | 75.31 | 75.34 | 131700.0 |
| 2006-10-23 09:30:00 | IWM | ETF | 75.35 | 75.75 | 75.09 | 75.71 | 3307100.0 |
| 2006-10-23 10:00:00 | IWM | ETF | 75.73 | 76.24 | 75.59 | 76.21 | 4813700.0 |
| 2006-10-23 10:30:00 | IWM | ETF | 76.22 | 76.25 | 75.99 | 76.04 | 4849100.0 |
| 2006-10-23 11:00:00 | IWM | ETF | 76.05 | 76.28 | 76.0 | 76.01 | 2970300.0 |
| 2006-10-23 11:30:00 | IWM | ETF | 76.01 | 76.08 | 75.89 | 75.98 | 1576000.0 |
| 2006-10-23 12:00:00 | IWM | ETF | 75.97 | 76.15 | 75.92 | 76.09 | 2129700.0 |
| 2006-10-23 12:30:00 | IWM | ETF | 76.09 | 76.18 | 75.9 | 75.9 | 1311300.0 |
| 2006-10-23 13:00:00 | IWM | ETF | 75.88 | 76.0 | 75.83 | 75.99 | 797800.0 |
| 2006-10-23 13:30:00 | IWM | ETF | 75.98 | 76.0 | 75.65 | 75.75 | 2044700.0 |
> showing 50 of 3,029 rows — these rows as CSV