PREVIEW / etf_30min / 2006-02-14
file: by_date/etf_30min/2006/2006-02-14.parquet size: 61 KB rows: 2,137
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-02-14 07:00:00 | SPY | ETF | 126.68 | 126.75 | 126.68 | 126.73 | 15000.0 |
| 2006-02-14 07:30:00 | SPY | ETF | 126.7 | 126.73 | 126.7 | 126.7 | 31000.0 |
| 2006-02-14 08:00:00 | SPY | ETF | 126.73 | 126.82 | 126.68 | 126.73 | 263900.0 |
| 2006-02-14 08:30:00 | SPY | ETF | 126.75 | 126.85 | 126.61 | 126.66 | 1740600.0 |
| 2006-02-14 09:00:00 | SPY | ETF | 126.65 | 126.7 | 126.41 | 126.46 | 996200.0 |
| 2006-02-14 09:30:00 | SPY | ETF | 126.46 | 126.72 | 126.19 | 126.72 | 8850700.0 |
| 2006-02-14 10:00:00 | SPY | ETF | 126.66 | 126.84 | 126.5 | 126.57 | 4401200.0 |
| 2006-02-14 10:30:00 | SPY | ETF | 126.57 | 126.7 | 126.26 | 126.7 | 4412900.0 |
| 2006-02-14 11:00:00 | SPY | ETF | 126.7 | 127.16 | 126.63 | 127.04 | 7728100.0 |
| 2006-02-14 11:30:00 | SPY | ETF | 127.04 | 127.54 | 127.04 | 127.49 | 9929500.0 |
| 2006-02-14 12:00:00 | SPY | ETF | 127.49 | 127.55 | 127.2379 | 127.39 | 8787900.0 |
| 2006-02-14 12:30:00 | SPY | ETF | 127.39 | 127.46 | 127.27 | 127.32 | 3241900.0 |
| 2006-02-14 13:00:00 | SPY | ETF | 127.32 | 127.45 | 127.27 | 127.39 | 2996600.0 |
| 2006-02-14 13:30:00 | SPY | ETF | 127.38 | 127.55 | 127.35 | 127.45 | 3385800.0 |
| 2006-02-14 14:00:00 | SPY | ETF | 127.45 | 127.95 | 127.43 | 127.89 | 13395400.0 |
| 2006-02-14 14:30:00 | SPY | ETF | 127.89 | 128.03 | 127.71 | 127.83 | 7029500.0 |
| 2006-02-14 15:00:00 | SPY | ETF | 127.84 | 128.0 | 127.6 | 127.78 | 5433800.0 |
| 2006-02-14 15:30:00 | SPY | ETF | 127.78 | 127.85 | 127.53 | 127.71 | 5501900.0 |
| 2006-02-14 16:00:00 | SPY | ETF | 127.71 | 127.75 | 127.65 | 127.73 | 763400.0 |
| 2006-02-14 16:30:00 | SPY | ETF | 127.71 | 127.74 | 127.63 | 127.63 | 67100.0 |
| 2006-02-14 17:00:00 | SPY | ETF | 127.68 | 127.68 | 127.61 | 127.66 | 250300.0 |
| 2006-02-14 17:30:00 | SPY | ETF | 127.66 | 127.7 | 127.66 | 127.66 | 1200.0 |
| 2006-02-14 18:00:00 | SPY | ETF | 127.69 | 127.69 | 127.65 | 127.65 | 26900.0 |
| 2006-02-14 18:30:00 | SPY | ETF | 127.67 | 127.67 | 127.65 | 127.65 | 2100.0 |
| 2006-02-14 19:00:00 | SPY | ETF | 127.67 | 127.67 | 127.62 | 127.62 | 800.0 |
| 2006-02-14 09:30:00 | QQQ | ETF | 40.56 | 40.7 | 40.41 | 40.7 | 11074700.0 |
| 2006-02-14 10:00:00 | QQQ | ETF | 40.7 | 40.73 | 40.58 | 40.6 | 5806900.0 |
| 2006-02-14 10:30:00 | QQQ | ETF | 40.59 | 40.65 | 40.45 | 40.62 | 7641700.0 |
| 2006-02-14 11:00:00 | QQQ | ETF | 40.63 | 40.73 | 40.61 | 40.67 | 7804700.0 |
| 2006-02-14 11:30:00 | QQQ | ETF | 40.68 | 40.8 | 40.63 | 40.77 | 6170900.0 |
| 2006-02-14 12:00:00 | QQQ | ETF | 40.78 | 40.8 | 40.72 | 40.74 | 4703100.0 |
| 2006-02-14 12:30:00 | QQQ | ETF | 40.73 | 40.79 | 40.7 | 40.73 | 4285000.0 |
| 2006-02-14 13:00:00 | QQQ | ETF | 40.73 | 40.77 | 40.67 | 40.76 | 2229400.0 |
| 2006-02-14 13:30:00 | QQQ | ETF | 40.77 | 40.8 | 40.75 | 40.77 | 3679800.0 |
| 2006-02-14 14:00:00 | QQQ | ETF | 40.78 | 41.0 | 40.77 | 40.96 | 8680900.0 |
| 2006-02-14 14:30:00 | QQQ | ETF | 40.96 | 41.0 | 40.92 | 40.99 | 5482300.0 |
| 2006-02-14 15:00:00 | QQQ | ETF | 40.99 | 41.02 | 40.91 | 40.98 | 5421200.0 |
| 2006-02-14 15:30:00 | QQQ | ETF | 40.98 | 40.98 | 40.84 | 40.89 | 10544700.0 |
| 2006-02-14 07:30:00 | IWM | ETF | 70.92 | 70.92 | 70.92 | 70.92 | 300.0 |
| 2006-02-14 08:00:00 | IWM | ETF | 70.92 | 70.98 | 70.92 | 70.98 | 13100.0 |
| 2006-02-14 08:30:00 | IWM | ETF | 70.99 | 71.0 | 70.91 | 70.92 | 42100.0 |
| 2006-02-14 09:00:00 | IWM | ETF | 70.9 | 70.91 | 70.79 | 70.8 | 106700.0 |
| 2006-02-14 09:30:00 | IWM | ETF | 70.8 | 70.86 | 70.31 | 70.63 | 6661100.0 |
| 2006-02-14 10:00:00 | IWM | ETF | 70.63 | 70.74 | 70.52 | 70.65 | 5491900.0 |
| 2006-02-14 10:30:00 | IWM | ETF | 70.66 | 70.85 | 70.44 | 70.82 | 2571500.0 |
| 2006-02-14 11:00:00 | IWM | ETF | 70.82 | 71.23 | 70.77 | 71.15 | 4996400.0 |
| 2006-02-14 11:30:00 | IWM | ETF | 71.16 | 71.5 | 71.1 | 71.44 | 4084200.0 |
| 2006-02-14 12:00:00 | IWM | ETF | 71.44 | 71.49 | 71.37 | 71.44 | 2727600.0 |
| 2006-02-14 12:30:00 | IWM | ETF | 71.44 | 71.46 | 71.37 | 71.37 | 2145700.0 |
| 2006-02-14 13:00:00 | IWM | ETF | 71.37 | 71.49 | 71.32 | 71.44 | 964300.0 |
> showing 50 of 2,137 rows — these rows as CSV