PREVIEW / etf_30min / 2005-03-11
file: by_date/etf_30min/2005/2005-03-11.parquet size: 44 KB rows: 1,480
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-03-11 08:00:00 | SPY | ETF | 121.5 | 121.54 | 121.38 | 121.4 | 45500.0 |
| 2005-03-11 08:30:00 | SPY | ETF | 121.39 | 121.41 | 121.15 | 121.15 | 149200.0 |
| 2005-03-11 09:00:00 | SPY | ETF | 121.21 | 121.33 | 121.13 | 121.29 | 137600.0 |
| 2005-03-11 09:30:00 | SPY | ETF | 121.31 | 121.72 | 121.08 | 121.56 | 8206500.0 |
| 2005-03-11 10:00:00 | SPY | ETF | 121.57 | 121.62 | 121.07 | 121.18 | 4903900.0 |
| 2005-03-11 10:30:00 | SPY | ETF | 121.19 | 121.25 | 120.71 | 120.85 | 5248800.0 |
| 2005-03-11 11:00:00 | SPY | ETF | 120.84 | 121.03 | 120.74 | 120.91 | 3486600.0 |
| 2005-03-11 11:30:00 | SPY | ETF | 120.91 | 121.0 | 120.85 | 120.88 | 2606600.0 |
| 2005-03-11 12:00:00 | SPY | ETF | 120.87 | 120.98 | 120.74 | 120.96 | 1295900.0 |
| 2005-03-11 12:30:00 | SPY | ETF | 120.95 | 121.05 | 120.85 | 120.86 | 1078300.0 |
| 2005-03-11 13:00:00 | SPY | ETF | 120.86 | 121.0 | 120.82 | 120.86 | 1011400.0 |
| 2005-03-11 13:30:00 | SPY | ETF | 120.86 | 120.88 | 120.39 | 120.46 | 4839300.0 |
| 2005-03-11 14:00:00 | SPY | ETF | 120.47 | 120.73 | 120.42 | 120.62 | 3275100.0 |
| 2005-03-11 14:30:00 | SPY | ETF | 120.62 | 120.66 | 120.26 | 120.4 | 4204300.0 |
| 2005-03-11 15:00:00 | SPY | ETF | 120.4 | 120.4 | 120.16 | 120.31 | 4897900.0 |
| 2005-03-11 15:30:00 | SPY | ETF | 120.31 | 120.57 | 120.22 | 120.41 | 5852500.0 |
| 2005-03-11 16:00:00 | SPY | ETF | 120.44 | 120.45 | 120.33 | 120.36 | 716500.0 |
| 2005-03-11 16:30:00 | SPY | ETF | 120.36 | 120.39 | 120.34 | 120.34 | 3381500.0 |
| 2005-03-11 17:00:00 | SPY | ETF | 120.37 | 121.35 | 120.25 | 120.3892 | 568800.0 |
| 2005-03-11 17:30:00 | SPY | ETF | 120.26 | 120.27 | 120.24 | 120.25 | 2900.0 |
| 2005-03-11 18:00:00 | SPY | ETF | 120.34 | 120.34 | 120.25 | 120.25 | 2100.0 |
| 2005-03-11 19:00:00 | SPY | ETF | 120.34 | 120.34 | 120.34 | 120.34 | 100.0 |
| 2005-03-11 19:30:00 | SPY | ETF | 120.33 | 120.33 | 120.32 | 120.32 | 300.0 |
| 2005-03-11 09:30:00 | QQQ | ETF | 37.69 | 37.82 | 37.48 | 37.75 | 16394300.0 |
| 2005-03-11 10:00:00 | QQQ | ETF | 37.75 | 37.79 | 37.5 | 37.61 | 10067100.0 |
| 2005-03-11 10:30:00 | QQQ | ETF | 37.61 | 37.64 | 37.34 | 37.37 | 9105100.0 |
| 2005-03-11 11:00:00 | QQQ | ETF | 37.37 | 37.4 | 37.26 | 37.28 | 8745200.0 |
| 2005-03-11 11:30:00 | QQQ | ETF | 37.28 | 37.36 | 37.27 | 37.3 | 4241100.0 |
| 2005-03-11 12:00:00 | QQQ | ETF | 37.3 | 37.37 | 37.24 | 37.34 | 3426200.0 |
| 2005-03-11 12:30:00 | QQQ | ETF | 37.33 | 37.37 | 37.3 | 37.31 | 2190500.0 |
| 2005-03-11 13:00:00 | QQQ | ETF | 37.31 | 37.35 | 37.26 | 37.31 | 2537400.0 |
| 2005-03-11 13:30:00 | QQQ | ETF | 37.31 | 37.33 | 37.11 | 37.14 | 7985700.0 |
| 2005-03-11 14:00:00 | QQQ | ETF | 37.15 | 37.27 | 37.13 | 37.2 | 4191500.0 |
| 2005-03-11 14:30:00 | QQQ | ETF | 37.19 | 37.24 | 37.1 | 37.16 | 4196000.0 |
| 2005-03-11 15:00:00 | QQQ | ETF | 37.16 | 37.17 | 37.02 | 37.13 | 9180500.0 |
| 2005-03-11 15:30:00 | QQQ | ETF | 37.13 | 37.21 | 37.09 | 37.16 | 10512500.0 |
| 2005-03-11 08:30:00 | IWM | ETF | 62.695 | 62.695 | 62.695 | 62.695 | 2000.0 |
| 2005-03-11 09:00:00 | IWM | ETF | 62.645 | 62.725 | 62.605 | 62.725 | 8400.0 |
| 2005-03-11 09:30:00 | IWM | ETF | 62.75 | 63.05 | 62.55 | 62.965 | 2043800.0 |
| 2005-03-11 10:00:00 | IWM | ETF | 62.955 | 63.025 | 62.6 | 62.665 | 1191600.0 |
| 2005-03-11 10:30:00 | IWM | ETF | 62.665 | 62.725 | 62.385 | 62.455 | 1489400.0 |
| 2005-03-11 11:00:00 | IWM | ETF | 62.45 | 62.62 | 62.375 | 62.555 | 1223000.0 |
| 2005-03-11 11:30:00 | IWM | ETF | 62.56 | 62.635 | 62.475 | 62.545 | 871600.0 |
| 2005-03-11 12:00:00 | IWM | ETF | 62.535 | 62.64 | 62.43 | 62.605 | 553400.0 |
| 2005-03-11 12:30:00 | IWM | ETF | 62.6 | 62.75 | 62.59 | 62.605 | 421400.0 |
| 2005-03-11 13:00:00 | IWM | ETF | 62.615 | 62.7 | 62.575 | 62.625 | 295400.0 |
| 2005-03-11 13:30:00 | IWM | ETF | 62.63 | 62.66 | 62.28 | 62.345 | 1349000.0 |
| 2005-03-11 14:00:00 | IWM | ETF | 62.35 | 62.475 | 62.335 | 62.425 | 1488400.0 |
| 2005-03-11 14:30:00 | IWM | ETF | 62.43 | 62.48 | 62.32 | 62.34 | 809200.0 |
| 2005-03-11 15:00:00 | IWM | ETF | 62.335 | 62.42 | 62.205 | 62.305 | 1662400.0 |
> showing 50 of 1,480 rows — these rows as CSV