PREVIEW / etf_30min / 2006-09-11
file: by_date/etf_30min/2006/2006-09-11.parquet size: 80 KB rows: 2,771
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-09-11 06:00:00 | SPY | ETF | 129.69 | 129.69 | 129.69 | 129.69 | 500.0 |
| 2006-09-11 06:30:00 | SPY | ETF | 129.76 | 129.76 | 129.67 | 129.67 | 300.0 |
| 2006-09-11 07:00:00 | SPY | ETF | 129.69 | 129.78 | 129.65 | 129.78 | 200100.0 |
| 2006-09-11 07:30:00 | SPY | ETF | 129.84 | 129.93 | 129.75 | 129.82 | 139600.0 |
| 2006-09-11 08:00:00 | SPY | ETF | 129.82 | 129.98 | 129.52 | 129.94 | 1092400.0 |
| 2006-09-11 08:30:00 | SPY | ETF | 129.95 | 130.0 | 129.9 | 129.9 | 258700.0 |
| 2006-09-11 09:00:00 | SPY | ETF | 129.9 | 129.9 | 129.8 | 129.84 | 322400.0 |
| 2006-09-11 09:30:00 | SPY | ETF | 129.86 | 130.0 | 129.7 | 129.84 | 5589300.0 |
| 2006-09-11 10:00:00 | SPY | ETF | 129.84 | 129.97 | 129.62 | 129.63 | 5852300.0 |
| 2006-09-11 10:30:00 | SPY | ETF | 129.63 | 129.67 | 129.48 | 129.61 | 6089900.0 |
| 2006-09-11 11:00:00 | SPY | ETF | 129.61 | 129.89 | 129.52 | 129.86 | 4783400.0 |
| 2006-09-11 11:30:00 | SPY | ETF | 129.86 | 129.89 | 129.68 | 129.77 | 2520700.0 |
| 2006-09-11 12:00:00 | SPY | ETF | 129.77 | 130.36 | 129.75 | 130.32 | 8411100.0 |
| 2006-09-11 12:30:00 | SPY | ETF | 130.32 | 130.35 | 130.17 | 130.29 | 4500900.0 |
| 2006-09-11 13:00:00 | SPY | ETF | 130.29 | 130.69 | 130.28 | 130.63 | 6526700.0 |
| 2006-09-11 13:30:00 | SPY | ETF | 130.63 | 130.68 | 130.46 | 130.47 | 4473400.0 |
| 2006-09-11 14:00:00 | SPY | ETF | 130.47 | 130.57 | 130.29 | 130.35 | 3129700.0 |
| 2006-09-11 14:30:00 | SPY | ETF | 130.34 | 130.49 | 130.29 | 130.45 | 2061100.0 |
| 2006-09-11 15:00:00 | SPY | ETF | 130.44 | 130.46 | 130.11 | 130.24 | 3190100.0 |
| 2006-09-11 15:30:00 | SPY | ETF | 130.24 | 130.4 | 130.19 | 130.37 | 5714000.0 |
| 2006-09-11 16:00:00 | SPY | ETF | 130.38 | 130.45 | 130.37 | 130.4 | 1785700.0 |
| 2006-09-11 16:30:00 | SPY | ETF | 130.43 | 130.43 | 130.32 | 130.39 | 316800.0 |
| 2006-09-11 17:00:00 | SPY | ETF | 130.39 | 130.39 | 130.34 | 130.34 | 115900.0 |
| 2006-09-11 18:00:00 | SPY | ETF | 130.32 | 130.32 | 130.31 | 130.31 | 2200.0 |
| 2006-09-11 18:30:00 | SPY | ETF | 130.36 | 130.36 | 130.36 | 130.36 | 800.0 |
| 2006-09-11 19:30:00 | SPY | ETF | 130.3 | 130.3 | 130.3 | 130.3 | 2000.0 |
| 2006-09-11 09:30:00 | QQQ | ETF | 38.41 | 38.55 | 38.36 | 38.51 | 19923200.0 |
| 2006-09-11 10:00:00 | QQQ | ETF | 38.51 | 38.57 | 38.4 | 38.41 | 19321600.0 |
| 2006-09-11 10:30:00 | QQQ | ETF | 38.4 | 38.42 | 38.32 | 38.39 | 9236900.0 |
| 2006-09-11 11:00:00 | QQQ | ETF | 38.4 | 38.57 | 38.35 | 38.54 | 8167000.0 |
| 2006-09-11 11:30:00 | QQQ | ETF | 38.55 | 38.57 | 38.46 | 38.5 | 5220700.0 |
| 2006-09-11 12:00:00 | QQQ | ETF | 38.5 | 38.85 | 38.5 | 38.84 | 14794500.0 |
| 2006-09-11 12:30:00 | QQQ | ETF | 38.84 | 38.87 | 38.76 | 38.83 | 8497400.0 |
| 2006-09-11 13:00:00 | QQQ | ETF | 38.83 | 39.08 | 38.82 | 39.06 | 10372000.0 |
| 2006-09-11 13:30:00 | QQQ | ETF | 39.06 | 39.15 | 39.01 | 39.04 | 8983400.0 |
| 2006-09-11 14:00:00 | QQQ | ETF | 39.03 | 39.08 | 38.93 | 38.95 | 4948800.0 |
| 2006-09-11 14:30:00 | QQQ | ETF | 38.95 | 39.05 | 38.9 | 39.03 | 7811200.0 |
| 2006-09-11 15:00:00 | QQQ | ETF | 39.03 | 39.04 | 38.83 | 38.93 | 7332900.0 |
| 2006-09-11 15:30:00 | QQQ | ETF | 38.94 | 39.02 | 38.89 | 38.95 | 8641900.0 |
| 2006-09-11 06:00:00 | IWM | ETF | 70.11 | 70.11 | 70.11 | 70.11 | 400.0 |
| 2006-09-11 08:00:00 | IWM | ETF | 70.15 | 70.29 | 70.15 | 70.28 | 44200.0 |
| 2006-09-11 08:30:00 | IWM | ETF | 70.2 | 70.36 | 70.2 | 70.25 | 915300.0 |
| 2006-09-11 09:00:00 | IWM | ETF | 70.22 | 70.25 | 70.13 | 70.14 | 426600.0 |
| 2006-09-11 09:30:00 | IWM | ETF | 70.13 | 70.34 | 69.9 | 70.046 | 3649400.0 |
| 2006-09-11 10:00:00 | IWM | ETF | 70.05 | 70.16 | 69.75 | 69.76 | 2421800.0 |
| 2006-09-11 10:30:00 | IWM | ETF | 69.75 | 69.9 | 69.65 | 69.87 | 5747000.0 |
| 2006-09-11 11:00:00 | IWM | ETF | 69.87 | 70.19 | 69.78 | 70.17 | 3995100.0 |
| 2006-09-11 11:30:00 | IWM | ETF | 70.17 | 70.26 | 70.0 | 70.06 | 2592500.0 |
| 2006-09-11 12:00:00 | IWM | ETF | 70.06 | 70.62 | 70.05 | 70.6 | 6827700.0 |
| 2006-09-11 12:30:00 | IWM | ETF | 70.6 | 70.61 | 70.4 | 70.5 | 2285400.0 |
> showing 50 of 2,771 rows — these rows as CSV