PREVIEW / etf_30min / 2005-12-14
file: by_date/etf_30min/2005/2005-12-14.parquet size: 56 KB rows: 2,051
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-14 04:00:00 | SPY | ETF | 127.05 | 127.05 | 127.03 | 127.03 | 900.0 |
| 2005-12-14 04:30:00 | SPY | ETF | 127.03 | 127.03 | 127.03 | 127.03 | 1000.0 |
| 2005-12-14 05:30:00 | SPY | ETF | 127.07 | 127.07 | 127.07 | 127.07 | 25000.0 |
| 2005-12-14 06:30:00 | SPY | ETF | 127.08 | 127.08 | 127.08 | 127.08 | 25000.0 |
| 2005-12-14 07:00:00 | SPY | ETF | 127.04 | 127.06 | 127.0 | 127.02 | 36400.0 |
| 2005-12-14 07:30:00 | SPY | ETF | 127.03 | 127.07 | 127.0 | 127.07 | 10400.0 |
| 2005-12-14 08:00:00 | SPY | ETF | 127.07 | 127.2 | 127.02 | 127.2 | 317800.0 |
| 2005-12-14 08:30:00 | SPY | ETF | 127.1 | 127.23 | 127.1 | 127.23 | 742200.0 |
| 2005-12-14 09:00:00 | SPY | ETF | 127.23 | 127.3 | 127.19 | 127.19 | 347900.0 |
| 2005-12-14 09:30:00 | SPY | ETF | 127.19 | 127.65 | 127.14 | 127.54 | 13280000.0 |
| 2005-12-14 10:00:00 | SPY | ETF | 127.53 | 127.59 | 127.37 | 127.55 | 3503400.0 |
| 2005-12-14 10:30:00 | SPY | ETF | 127.55 | 127.77 | 127.39 | 127.4 | 5623300.0 |
| 2005-12-14 11:00:00 | SPY | ETF | 127.4 | 127.44 | 127.21 | 127.35 | 5125500.0 |
| 2005-12-14 11:30:00 | SPY | ETF | 127.36 | 127.54 | 127.22 | 127.38 | 4174300.0 |
| 2005-12-14 12:00:00 | SPY | ETF | 127.37 | 127.49 | 127.33 | 127.37 | 1486600.0 |
| 2005-12-14 12:30:00 | SPY | ETF | 127.39 | 127.56 | 127.31 | 127.54 | 1543700.0 |
| 2005-12-14 13:00:00 | SPY | ETF | 127.53 | 127.7 | 127.48 | 127.67 | 2464000.0 |
| 2005-12-14 13:30:00 | SPY | ETF | 127.67 | 128.09 | 127.66 | 127.97 | 8146400.0 |
| 2005-12-14 14:00:00 | SPY | ETF | 127.98 | 128.07 | 127.93 | 127.9499 | 3122100.0 |
| 2005-12-14 14:30:00 | SPY | ETF | 127.93 | 127.96 | 127.69 | 127.8 | 4702800.0 |
| 2005-12-14 15:00:00 | SPY | ETF | 127.78 | 127.92 | 127.75 | 127.86 | 2290700.0 |
| 2005-12-14 15:30:00 | SPY | ETF | 127.84 | 127.88 | 127.71 | 127.76 | 3782900.0 |
| 2005-12-14 16:00:00 | SPY | ETF | 127.76 | 127.85 | 127.71 | 127.81 | 1423500.0 |
| 2005-12-14 16:30:00 | SPY | ETF | 127.8 | 127.95 | 127.8 | 127.94 | 62400.0 |
| 2005-12-14 17:00:00 | SPY | ETF | 127.94 | 127.95 | 127.9 | 127.9 | 107700.0 |
| 2005-12-14 17:30:00 | SPY | ETF | 127.87 | 127.87 | 127.83 | 127.83 | 1000.0 |
| 2005-12-14 18:00:00 | SPY | ETF | 127.82 | 127.83 | 127.81 | 127.81 | 2200.0 |
| 2005-12-14 18:30:00 | SPY | ETF | 127.81 | 127.81 | 127.81 | 127.81 | 500.0 |
| 2005-12-14 19:00:00 | SPY | ETF | 127.81 | 127.82 | 127.81 | 127.82 | 1500.0 |
| 2005-12-14 19:30:00 | SPY | ETF | 127.81 | 127.81 | 127.81 | 127.81 | 200.0 |
| 2005-12-14 09:30:00 | QQQ | ETF | 41.97 | 42.1 | 41.93 | 41.99 | 10274900.0 |
| 2005-12-14 10:00:00 | QQQ | ETF | 41.99 | 42.01 | 41.9 | 41.94 | 5161000.0 |
| 2005-12-14 10:30:00 | QQQ | ETF | 41.94 | 42.02 | 41.85 | 41.86 | 6104400.0 |
| 2005-12-14 11:00:00 | QQQ | ETF | 41.86 | 41.87 | 41.71 | 41.82 | 8127200.0 |
| 2005-12-14 11:30:00 | QQQ | ETF | 41.82 | 41.89 | 41.76 | 41.82 | 2969600.0 |
| 2005-12-14 12:00:00 | QQQ | ETF | 41.82 | 41.85 | 41.78 | 41.82 | 3765500.0 |
| 2005-12-14 12:30:00 | QQQ | ETF | 41.82 | 41.88 | 41.77 | 41.88 | 1964500.0 |
| 2005-12-14 13:00:00 | QQQ | ETF | 41.87 | 41.94 | 41.85 | 41.91 | 3150700.0 |
| 2005-12-14 13:30:00 | QQQ | ETF | 41.91 | 42.05 | 41.91 | 41.99 | 4491900.0 |
| 2005-12-14 14:00:00 | QQQ | ETF | 42.0 | 42.03 | 41.97 | 41.99 | 2375300.0 |
| 2005-12-14 14:30:00 | QQQ | ETF | 41.99 | 42.0 | 41.89 | 41.94 | 4112800.0 |
| 2005-12-14 15:00:00 | QQQ | ETF | 41.93 | 41.97 | 41.91 | 41.95 | 3195700.0 |
| 2005-12-14 15:30:00 | QQQ | ETF | 41.95 | 41.97 | 41.84 | 41.89 | 12060500.0 |
| 2005-12-14 08:00:00 | IWM | ETF | 68.72 | 68.78 | 68.64 | 68.78 | 29400.0 |
| 2005-12-14 08:30:00 | IWM | ETF | 68.76 | 68.8 | 68.73 | 68.8 | 63400.0 |
| 2005-12-14 09:00:00 | IWM | ETF | 68.8 | 68.86 | 68.74 | 68.74 | 236400.0 |
| 2005-12-14 09:30:00 | IWM | ETF | 68.76 | 68.98 | 68.71 | 68.9 | 2443500.0 |
| 2005-12-14 10:00:00 | IWM | ETF | 68.92 | 68.92 | 68.66 | 68.76 | 2442400.0 |
| 2005-12-14 10:30:00 | IWM | ETF | 68.76 | 68.96 | 68.67 | 68.67 | 2308300.0 |
| 2005-12-14 11:00:00 | IWM | ETF | 68.66 | 68.7 | 68.42 | 68.58 | 2150200.0 |
> showing 50 of 2,051 rows — these rows as CSV