PREVIEW / etf_30min / 2005-05-05
file: by_date/etf_30min/2005/2005-05-05.parquet size: 44 KB rows: 1,478
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-05-05 04:30:00 | SPY | ETF | 117.48 | 117.54 | 117.47 | 117.54 | 3000.0 |
| 2005-05-05 05:30:00 | SPY | ETF | 117.47 | 117.47 | 117.38 | 117.38 | 18000.0 |
| 2005-05-05 06:00:00 | SPY | ETF | 117.42 | 117.44 | 117.42 | 117.44 | 11000.0 |
| 2005-05-05 06:30:00 | SPY | ETF | 117.51 | 117.52 | 117.48 | 117.48 | 35100.0 |
| 2005-05-05 07:00:00 | SPY | ETF | 117.45 | 117.5 | 117.41 | 117.5 | 40900.0 |
| 2005-05-05 07:30:00 | SPY | ETF | 117.48 | 117.53 | 117.48 | 117.52 | 5400.0 |
| 2005-05-05 08:00:00 | SPY | ETF | 117.47 | 117.67 | 117.46 | 117.6 | 35900.0 |
| 2005-05-05 08:30:00 | SPY | ETF | 117.63 | 117.73 | 117.56 | 117.73 | 167400.0 |
| 2005-05-05 09:00:00 | SPY | ETF | 117.72 | 117.72 | 117.65 | 117.66 | 179500.0 |
| 2005-05-05 09:30:00 | SPY | ETF | 117.67 | 117.82 | 117.48 | 117.8 | 7968200.0 |
| 2005-05-05 10:00:00 | SPY | ETF | 117.79 | 118.0 | 117.7 | 117.76 | 7164500.0 |
| 2005-05-05 10:30:00 | SPY | ETF | 117.76 | 117.96 | 117.68 | 117.85 | 3293800.0 |
| 2005-05-05 11:00:00 | SPY | ETF | 117.84 | 117.98 | 117.68 | 117.72 | 3091600.0 |
| 2005-05-05 11:30:00 | SPY | ETF | 117.72 | 117.92 | 117.71 | 117.89 | 2225200.0 |
| 2005-05-05 12:00:00 | SPY | ETF | 117.89 | 117.97 | 117.8 | 117.91 | 1665500.0 |
| 2005-05-05 12:30:00 | SPY | ETF | 117.91 | 117.92 | 116.93 | 116.94 | 16651100.0 |
| 2005-05-05 13:00:00 | SPY | ETF | 116.94 | 117.95 | 116.74 | 117.06 | 18330200.0 |
| 2005-05-05 13:30:00 | SPY | ETF | 117.06 | 117.36 | 116.98 | 117.13 | 9107300.0 |
| 2005-05-05 14:00:00 | SPY | ETF | 117.14 | 117.3 | 117.03 | 117.05 | 4841700.0 |
| 2005-05-05 14:30:00 | SPY | ETF | 117.05 | 117.17 | 116.85 | 116.9 | 5414200.0 |
| 2005-05-05 15:00:00 | SPY | ETF | 116.9 | 117.37 | 116.87 | 117.1995 | 5099300.0 |
| 2005-05-05 15:30:00 | SPY | ETF | 117.19 | 117.63 | 117.17 | 117.36 | 7867700.0 |
| 2005-05-05 16:00:00 | SPY | ETF | 117.35 | 117.66 | 117.34 | 117.45 | 1531400.0 |
| 2005-05-05 16:30:00 | SPY | ETF | 117.44 | 117.51 | 117.4 | 117.47 | 291300.0 |
| 2005-05-05 17:00:00 | SPY | ETF | 117.48 | 117.52 | 117.45 | 117.45 | 106200.0 |
| 2005-05-05 17:30:00 | SPY | ETF | 117.46 | 117.48 | 117.43 | 117.48 | 4200.0 |
| 2005-05-05 18:00:00 | SPY | ETF | 117.44 | 117.44 | 117.4 | 117.44 | 12800.0 |
| 2005-05-05 19:30:00 | SPY | ETF | 117.44 | 117.44 | 117.44 | 117.44 | 500.0 |
| 2005-05-05 09:30:00 | QQQ | ETF | 35.75 | 35.81 | 35.66 | 35.79 | 10371400.0 |
| 2005-05-05 10:00:00 | QQQ | ETF | 35.79 | 35.92 | 35.75 | 35.77 | 8292600.0 |
| 2005-05-05 10:30:00 | QQQ | ETF | 35.78 | 35.87 | 35.73 | 35.8 | 3869600.0 |
| 2005-05-05 11:00:00 | QQQ | ETF | 35.79 | 35.86 | 35.74 | 35.76 | 3491400.0 |
| 2005-05-05 11:30:00 | QQQ | ETF | 35.76 | 35.84 | 35.76 | 35.83 | 1834300.0 |
| 2005-05-05 12:00:00 | QQQ | ETF | 35.82 | 35.92 | 35.75 | 35.9 | 3267800.0 |
| 2005-05-05 12:30:00 | QQQ | ETF | 35.91 | 35.91 | 35.65 | 35.65 | 7788700.0 |
| 2005-05-05 13:00:00 | QQQ | ETF | 35.65 | 35.68 | 35.53 | 35.63 | 10710300.0 |
| 2005-05-05 13:30:00 | QQQ | ETF | 35.63 | 35.74 | 35.6 | 35.66 | 5370400.0 |
| 2005-05-05 14:00:00 | QQQ | ETF | 35.66 | 35.72 | 35.62 | 35.65 | 3506000.0 |
| 2005-05-05 14:30:00 | QQQ | ETF | 35.65 | 35.69 | 35.58 | 35.58 | 5315300.0 |
| 2005-05-05 15:00:00 | QQQ | ETF | 35.58 | 35.71 | 35.56 | 35.67 | 4850000.0 |
| 2005-05-05 15:30:00 | QQQ | ETF | 35.67 | 35.8 | 35.66 | 35.72 | 6373000.0 |
| 2005-05-05 08:00:00 | IWM | ETF | 59.185 | 59.185 | 59.185 | 59.185 | 6000.0 |
| 2005-05-05 08:30:00 | IWM | ETF | 59.135 | 59.135 | 59.125 | 59.125 | 5000.0 |
| 2005-05-05 09:00:00 | IWM | ETF | 59.165 | 59.165 | 59.13 | 59.145 | 4800.0 |
| 2005-05-05 09:30:00 | IWM | ETF | 59.2 | 59.41 | 59.01 | 59.375 | 3476400.0 |
| 2005-05-05 10:00:00 | IWM | ETF | 59.375 | 59.55 | 59.35 | 59.405 | 3591600.0 |
| 2005-05-05 10:30:00 | IWM | ETF | 59.4 | 59.58 | 59.32 | 59.435 | 1907600.0 |
| 2005-05-05 11:00:00 | IWM | ETF | 59.43 | 59.575 | 59.38 | 59.425 | 1349400.0 |
| 2005-05-05 11:30:00 | IWM | ETF | 59.415 | 59.525 | 59.37 | 59.515 | 942400.0 |
| 2005-05-05 12:00:00 | IWM | ETF | 59.5204 | 59.55 | 59.445 | 59.52 | 448000.0 |
> showing 50 of 1,478 rows — these rows as CSV