PREVIEW / etf_30min / 2006-11-14
file: by_date/etf_30min/2006/2006-11-14.parquet size: 89 KB rows: 3,055
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-11-14 04:00:00 | SPY | ETF | 138.86 | 138.86 | 138.86 | 138.86 | 500.0 |
| 2006-11-14 06:00:00 | SPY | ETF | 138.7 | 138.7 | 138.7 | 138.7 | 10000.0 |
| 2006-11-14 06:30:00 | SPY | ETF | 138.66 | 138.66 | 138.66 | 138.66 | 10000.0 |
| 2006-11-14 07:00:00 | SPY | ETF | 138.7 | 138.75 | 138.7 | 138.75 | 11800.0 |
| 2006-11-14 07:30:00 | SPY | ETF | 138.75 | 138.75 | 138.65 | 138.65 | 6800.0 |
| 2006-11-14 08:00:00 | SPY | ETF | 138.67 | 138.93 | 138.65 | 138.9 | 1200000.0 |
| 2006-11-14 08:30:00 | SPY | ETF | 138.93 | 139.32 | 138.9 | 139.11 | 4747500.0 |
| 2006-11-14 09:00:00 | SPY | ETF | 139.12 | 139.23 | 138.96 | 138.98 | 2237300.0 |
| 2006-11-14 09:30:00 | SPY | ETF | 138.97 | 139.09 | 138.56 | 138.64 | 10630200.0 |
| 2006-11-14 10:00:00 | SPY | ETF | 138.64 | 138.96 | 138.17 | 138.19 | 8991300.0 |
| 2006-11-14 10:30:00 | SPY | ETF | 138.1901 | 138.37 | 138.12 | 138.33 | 6498400.0 |
| 2006-11-14 11:00:00 | SPY | ETF | 138.33 | 138.6292 | 138.21 | 138.41 | 5953100.0 |
| 2006-11-14 11:30:00 | SPY | ETF | 138.42 | 138.47 | 138.26 | 138.32 | 3650100.0 |
| 2006-11-14 12:00:00 | SPY | ETF | 138.34 | 138.36 | 138.22 | 138.32 | 2116900.0 |
| 2006-11-14 12:30:00 | SPY | ETF | 138.32 | 138.59 | 138.29 | 138.55 | 3851700.0 |
| 2006-11-14 13:00:00 | SPY | ETF | 138.55 | 138.74 | 138.55 | 138.69 | 3017400.0 |
| 2006-11-14 13:30:00 | SPY | ETF | 138.7 | 138.8 | 138.65 | 138.66 | 2576000.0 |
| 2006-11-14 14:00:00 | SPY | ETF | 138.67 | 138.85 | 138.6 | 138.79 | 3781500.0 |
| 2006-11-14 14:30:00 | SPY | ETF | 138.79 | 139.56 | 138.73 | 139.48 | 11152300.0 |
| 2006-11-14 15:00:00 | SPY | ETF | 139.48 | 139.74 | 139.42 | 139.45 | 10280600.0 |
| 2006-11-14 15:30:00 | SPY | ETF | 139.45 | 139.68 | 139.44 | 139.56 | 8929400.0 |
| 2006-11-14 16:00:00 | SPY | ETF | 139.53 | 139.68 | 139.5 | 139.59 | 1975700.0 |
| 2006-11-14 16:30:00 | SPY | ETF | 139.59 | 139.59 | 139.52 | 139.54 | 292500.0 |
| 2006-11-14 17:00:00 | SPY | ETF | 139.57 | 139.58 | 139.54 | 139.54 | 2900.0 |
| 2006-11-14 17:30:00 | SPY | ETF | 139.59 | 139.59 | 139.54 | 139.59 | 2300.0 |
| 2006-11-14 18:00:00 | SPY | ETF | 139.57 | 139.59 | 139.57 | 139.59 | 200.0 |
| 2006-11-14 18:30:00 | SPY | ETF | 139.59 | 139.59 | 139.59 | 139.59 | 300.0 |
| 2006-11-14 19:00:00 | SPY | ETF | 139.59 | 139.59 | 139.59 | 139.59 | 5700.0 |
| 2006-11-14 19:30:00 | SPY | ETF | 139.59 | 139.62 | 139.59 | 139.61 | 12000.0 |
| 2006-11-14 09:30:00 | QQQ | ETF | 43.5 | 43.57 | 42.43 | 43.44 | 18386200.0 |
| 2006-11-14 10:00:00 | QQQ | ETF | 43.43 | 43.52 | 43.26 | 43.27 | 12281000.0 |
| 2006-11-14 10:30:00 | QQQ | ETF | 43.27 | 43.37 | 43.24 | 43.35 | 6893400.0 |
| 2006-11-14 11:00:00 | QQQ | ETF | 43.35 | 43.4 | 43.29 | 43.38 | 4137700.0 |
| 2006-11-14 11:30:00 | QQQ | ETF | 43.37 | 43.41 | 43.34 | 43.38 | 4076500.0 |
| 2006-11-14 12:00:00 | QQQ | ETF | 43.38 | 43.39 | 43.33 | 43.36 | 1442800.0 |
| 2006-11-14 12:30:00 | QQQ | ETF | 43.36 | 43.56 | 43.35 | 43.55 | 6934800.0 |
| 2006-11-14 13:00:00 | QQQ | ETF | 43.54 | 43.62 | 43.5 | 43.59 | 5292300.0 |
| 2006-11-14 13:30:00 | QQQ | ETF | 43.58 | 43.6 | 43.5 | 43.5 | 3375300.0 |
| 2006-11-14 14:00:00 | QQQ | ETF | 43.5 | 43.6 | 43.49 | 43.59 | 3440800.0 |
| 2006-11-14 14:30:00 | QQQ | ETF | 43.59 | 43.81 | 43.55 | 43.78 | 11055900.0 |
| 2006-11-14 15:00:00 | QQQ | ETF | 43.78 | 43.9 | 43.78 | 43.82 | 8864600.0 |
| 2006-11-14 15:30:00 | QQQ | ETF | 43.82 | 43.97 | 43.82 | 43.93 | 12559700.0 |
| 2006-11-14 07:30:00 | IWM | ETF | 76.7 | 76.7 | 76.6 | 76.6 | 2100.0 |
| 2006-11-14 08:00:00 | IWM | ETF | 76.7 | 76.77 | 76.61 | 76.7 | 695300.0 |
| 2006-11-14 08:30:00 | IWM | ETF | 76.7 | 77.02 | 76.7 | 76.94 | 621600.0 |
| 2006-11-14 09:00:00 | IWM | ETF | 76.94 | 77.0 | 76.9 | 76.91 | 116300.0 |
| 2006-11-14 09:30:00 | IWM | ETF | 76.91 | 77.09 | 76.6 | 76.7 | 5069600.0 |
| 2006-11-14 10:00:00 | IWM | ETF | 76.7 | 76.82 | 76.43 | 76.44 | 4911200.0 |
| 2006-11-14 10:30:00 | IWM | ETF | 76.43 | 76.7 | 76.43 | 76.65 | 2783700.0 |
| 2006-11-14 11:00:00 | IWM | ETF | 76.64 | 76.73 | 76.53 | 76.67 | 2236500.0 |
> showing 50 of 3,055 rows — these rows as CSV