PREVIEW / etf_30min / 2005-03-03
file: by_date/etf_30min/2005/2005-03-03.parquet size: 43 KB rows: 1,465
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-03 08:00:00 | SPY | ETF | 121.51 | 121.52 | 121.48 | 121.48 | 30400.0 |
| 2005-03-03 08:30:00 | SPY | ETF | 121.48 | 121.7 | 121.48 | 121.66 | 308500.0 |
| 2005-03-03 09:00:00 | SPY | ETF | 121.65 | 121.71 | 121.63 | 121.66 | 184800.0 |
| 2005-03-03 09:30:00 | SPY | ETF | 121.66 | 121.78 | 121.58 | 121.69 | 5177700.0 |
| 2005-03-03 10:00:00 | SPY | ETF | 121.7 | 121.9 | 121.44 | 121.47 | 5949500.0 |
| 2005-03-03 10:30:00 | SPY | ETF | 121.47 | 121.6 | 121.34 | 121.56 | 4506200.0 |
| 2005-03-03 11:00:00 | SPY | ETF | 121.57 | 121.57 | 121.27 | 121.33 | 3443100.0 |
| 2005-03-03 11:30:00 | SPY | ETF | 121.33 | 121.41 | 120.79 | 120.88 | 7118300.0 |
| 2005-03-03 12:00:00 | SPY | ETF | 120.86 | 121.1 | 120.79 | 120.8 | 6413300.0 |
| 2005-03-03 12:30:00 | SPY | ETF | 120.8 | 121.0 | 120.7 | 120.98 | 4083600.0 |
| 2005-03-03 13:00:00 | SPY | ETF | 120.99 | 121.39 | 120.99 | 121.15 | 4769200.0 |
| 2005-03-03 13:30:00 | SPY | ETF | 121.15 | 121.36 | 120.8 | 121.26 | 1242000.0 |
| 2005-03-03 14:00:00 | SPY | ETF | 121.25 | 121.57 | 121.25 | 121.54 | 4337200.0 |
| 2005-03-03 14:30:00 | SPY | ETF | 121.53 | 121.58 | 121.35 | 121.44 | 2351500.0 |
| 2005-03-03 15:00:00 | SPY | ETF | 121.45 | 121.54 | 121.36 | 121.52 | 2762800.0 |
| 2005-03-03 15:30:00 | SPY | ETF | 121.52 | 121.54 | 121.32 | 121.34 | 5988200.0 |
| 2005-03-03 16:00:00 | SPY | ETF | 121.32 | 121.36 | 120.89 | 121.24 | 794800.0 |
| 2005-03-03 16:30:00 | SPY | ETF | 121.24 | 121.26 | 121.19 | 121.22 | 243100.0 |
| 2005-03-03 17:00:00 | SPY | ETF | 121.22 | 121.25 | 121.2 | 121.22 | 25100.0 |
| 2005-03-03 17:30:00 | SPY | ETF | 121.22 | 121.23 | 121.22 | 121.23 | 500100.0 |
| 2005-03-03 18:00:00 | SPY | ETF | 121.25 | 121.25 | 121.25 | 121.25 | 100.0 |
| 2005-03-03 18:30:00 | SPY | ETF | 121.29 | 121.29 | 121.27 | 121.28 | 4000.0 |
| 2005-03-03 19:00:00 | SPY | ETF | 121.28 | 121.28 | 121.28 | 121.28 | 1900.0 |
| 2005-03-03 19:30:00 | SPY | ETF | 121.28 | 121.28 | 121.27 | 121.27 | 900.0 |
| 2005-03-03 09:30:00 | QQQ | ETF | 37.7 | 37.73 | 37.58 | 37.6 | 9656200.0 |
| 2005-03-03 10:00:00 | QQQ | ETF | 37.6 | 37.69 | 37.45 | 37.46 | 9544100.0 |
| 2005-03-03 10:30:00 | QQQ | ETF | 37.47 | 37.51 | 37.36 | 37.49 | 7287200.0 |
| 2005-03-03 11:00:00 | QQQ | ETF | 37.49 | 37.49 | 37.3 | 37.32 | 6453000.0 |
| 2005-03-03 11:30:00 | QQQ | ETF | 37.32 | 37.33 | 37.09 | 37.12 | 11532500.0 |
| 2005-03-03 12:00:00 | QQQ | ETF | 37.12 | 37.2 | 37.05 | 37.07 | 6820400.0 |
| 2005-03-03 12:30:00 | QQQ | ETF | 37.06 | 37.18 | 37.02 | 37.16 | 4916100.0 |
| 2005-03-03 13:00:00 | QQQ | ETF | 37.17 | 38.2 | 37.16 | 37.22 | 5659600.0 |
| 2005-03-03 13:30:00 | QQQ | ETF | 37.22 | 37.28 | 37.17 | 37.26 | 2297000.0 |
| 2005-03-03 14:00:00 | QQQ | ETF | 37.26 | 37.4 | 37.24 | 37.38 | 6707800.0 |
| 2005-03-03 14:30:00 | QQQ | ETF | 37.38 | 37.41 | 37.27 | 37.33 | 4192900.0 |
| 2005-03-03 15:00:00 | QQQ | ETF | 37.34 | 37.37 | 37.29 | 37.36 | 3418200.0 |
| 2005-03-03 15:30:00 | QQQ | ETF | 37.35 | 37.36 | 37.27 | 37.29 | 5237700.0 |
| 2005-03-03 08:30:00 | IWM | ETF | 63.785 | 63.82 | 63.785 | 63.81 | 4400.0 |
| 2005-03-03 09:00:00 | IWM | ETF | 63.81 | 63.81 | 63.78 | 63.78 | 6800.0 |
| 2005-03-03 09:30:00 | IWM | ETF | 63.8 | 63.93 | 63.71 | 63.79 | 1245800.0 |
| 2005-03-03 10:00:00 | IWM | ETF | 63.795 | 63.97 | 63.58 | 63.61 | 1957600.0 |
| 2005-03-03 10:30:00 | IWM | ETF | 63.6055 | 63.765 | 63.53 | 63.71 | 864600.0 |
| 2005-03-03 11:00:00 | IWM | ETF | 63.7 | 63.705 | 63.56 | 63.61 | 1239200.0 |
| 2005-03-03 11:30:00 | IWM | ETF | 63.59 | 63.605 | 63.175 | 63.215 | 2187600.0 |
| 2005-03-03 12:00:00 | IWM | ETF | 63.2 | 63.305 | 63.14 | 63.195 | 1301800.0 |
| 2005-03-03 12:30:00 | IWM | ETF | 63.195 | 63.355 | 63.14 | 63.355 | 471800.0 |
| 2005-03-03 13:00:00 | IWM | ETF | 63.36 | 63.515 | 63.34 | 63.38 | 1046600.0 |
| 2005-03-03 13:30:00 | IWM | ETF | 63.38 | 63.57 | 63.365 | 63.49 | 1106600.0 |
| 2005-03-03 14:00:00 | IWM | ETF | 63.49 | 63.89 | 63.48 | 63.835 | 2266200.0 |
| 2005-03-03 14:30:00 | IWM | ETF | 63.825 | 63.89 | 63.73 | 63.785 | 1375400.0 |
> showing 50 of 1,465 rows — these rows as CSV