PREVIEW / etf_30min / 2005-04-01
file: by_date/etf_30min/2005/2005-04-01.parquet size: 45 KB rows: 1,510
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-04-01 08:00:00 | SPY | ETF | 118.4 | 118.57 | 118.39 | 118.48 | 227900.0 |
| 2005-04-01 08:30:00 | SPY | ETF | 118.45 | 118.82 | 118.03 | 118.7 | 1669800.0 |
| 2005-04-01 09:00:00 | SPY | ETF | 118.7 | 118.74 | 118.53 | 118.63 | 406500.0 |
| 2005-04-01 09:30:00 | SPY | ETF | 118.63 | 118.99 | 118.52 | 118.8 | 9719500.0 |
| 2005-04-01 10:00:00 | SPY | ETF | 118.8 | 118.88 | 117.99 | 118.08 | 12467100.0 |
| 2005-04-01 10:30:00 | SPY | ETF | 118.1 | 118.81 | 117.67 | 117.76 | 13644900.0 |
| 2005-04-01 11:00:00 | SPY | ETF | 117.75 | 117.97 | 117.63 | 117.96 | 7742600.0 |
| 2005-04-01 11:30:00 | SPY | ETF | 117.96 | 118.05 | 117.82 | 117.92 | 4414900.0 |
| 2005-04-01 12:00:00 | SPY | ETF | 117.92 | 117.97 | 117.39 | 117.43 | 5105100.0 |
| 2005-04-01 12:30:00 | SPY | ETF | 117.41 | 117.59 | 117.21 | 117.21 | 3929100.0 |
| 2005-04-01 13:00:00 | SPY | ETF | 117.21 | 117.45 | 117.16 | 117.36 | 8295000.0 |
| 2005-04-01 13:30:00 | SPY | ETF | 117.36 | 117.42 | 116.95 | 117.05 | 4396700.0 |
| 2005-04-01 14:00:00 | SPY | ETF | 117.06 | 117.65 | 116.92 | 117.01 | 2865300.0 |
| 2005-04-01 14:30:00 | SPY | ETF | 117.02 | 117.24 | 116.91 | 117.01 | 4203600.0 |
| 2005-04-01 15:00:00 | SPY | ETF | 116.98 | 117.3 | 116.94 | 117.1 | 2877100.0 |
| 2005-04-01 15:30:00 | SPY | ETF | 117.1 | 117.47 | 117.02 | 117.24 | 7805100.0 |
| 2005-04-01 16:00:00 | SPY | ETF | 117.24 | 118.0 | 117.2 | 117.32 | 825800.0 |
| 2005-04-01 16:30:00 | SPY | ETF | 117.31 | 117.38 | 117.29 | 117.3 | 2029700.0 |
| 2005-04-01 17:00:00 | SPY | ETF | 117.31 | 117.35 | 117.31 | 117.31 | 3000.0 |
| 2005-04-01 17:30:00 | SPY | ETF | 117.31 | 117.31 | 117.27 | 117.27 | 4100.0 |
| 2005-04-01 18:00:00 | SPY | ETF | 117.3 | 117.37 | 117.3 | 117.3 | 7900.0 |
| 2005-04-01 18:30:00 | SPY | ETF | 117.35 | 117.35 | 117.35 | 117.35 | 100.0 |
| 2005-04-01 19:00:00 | SPY | ETF | 117.35 | 117.35 | 117.33 | 117.33 | 1700.0 |
| 2005-04-01 19:30:00 | SPY | ETF | 117.33 | 117.33 | 117.33 | 117.33 | 200.0 |
| 2005-04-01 09:30:00 | QQQ | ETF | 36.82 | 36.88 | 36.74 | 36.81 | 12150400.0 |
| 2005-04-01 10:00:00 | QQQ | ETF | 36.8 | 36.85 | 36.35 | 36.41 | 22859000.0 |
| 2005-04-01 10:30:00 | QQQ | ETF | 36.4 | 36.47 | 36.22 | 36.25 | 20082200.0 |
| 2005-04-01 11:00:00 | QQQ | ETF | 36.25 | 36.39 | 36.21 | 36.38 | 9635000.0 |
| 2005-04-01 11:30:00 | QQQ | ETF | 36.39 | 36.43 | 36.32 | 36.37 | 5549500.0 |
| 2005-04-01 12:00:00 | QQQ | ETF | 36.37 | 36.39 | 36.27 | 36.28 | 4552600.0 |
| 2005-04-01 12:30:00 | QQQ | ETF | 36.28 | 36.4 | 36.23 | 36.24 | 8984100.0 |
| 2005-04-01 13:00:00 | QQQ | ETF | 36.24 | 36.37 | 36.21 | 36.3 | 5687100.0 |
| 2005-04-01 13:30:00 | QQQ | ETF | 36.3 | 36.3 | 36.13 | 36.19 | 10240100.0 |
| 2005-04-01 14:00:00 | QQQ | ETF | 36.2 | 36.27 | 36.16 | 36.19 | 5333300.0 |
| 2005-04-01 14:30:00 | QQQ | ETF | 36.2 | 36.28 | 36.16 | 36.19 | 8809300.0 |
| 2005-04-01 15:00:00 | QQQ | ETF | 36.18 | 36.3 | 36.16 | 36.19 | 6447500.0 |
| 2005-04-01 15:30:00 | QQQ | ETF | 36.19 | 36.29 | 36.18 | 36.18 | 10826700.0 |
| 2005-04-01 08:00:00 | IWM | ETF | 61.26 | 61.27 | 61.26 | 61.27 | 8000.0 |
| 2005-04-01 08:30:00 | IWM | ETF | 61.105 | 61.51 | 61.105 | 61.42 | 99200.0 |
| 2005-04-01 09:00:00 | IWM | ETF | 61.44 | 61.475 | 61.3 | 61.345 | 50400.0 |
| 2005-04-01 09:30:00 | IWM | ETF | 61.365 | 61.72 | 61.325 | 61.61 | 3208400.0 |
| 2005-04-01 10:00:00 | IWM | ETF | 61.61 | 61.675 | 60.775 | 60.85 | 5296600.0 |
| 2005-04-01 10:30:00 | IWM | ETF | 60.845 | 61.495 | 60.58 | 60.595 | 3281000.0 |
| 2005-04-01 11:00:00 | IWM | ETF | 60.585 | 60.705 | 60.48 | 60.695 | 1584400.0 |
| 2005-04-01 11:30:00 | IWM | ETF | 60.7 | 60.845 | 60.695 | 60.745 | 1084600.0 |
| 2005-04-01 12:00:00 | IWM | ETF | 60.745 | 60.75 | 60.49 | 60.5 | 1216600.0 |
| 2005-04-01 12:30:00 | IWM | ETF | 60.49 | 60.61 | 60.45 | 60.47 | 697600.0 |
| 2005-04-01 13:00:00 | IWM | ETF | 60.47 | 60.6 | 60.455 | 60.525 | 1134800.0 |
| 2005-04-01 13:30:00 | IWM | ETF | 60.515 | 60.57 | 60.41 | 60.475 | 1144200.0 |
| 2005-04-01 14:00:00 | IWM | ETF | 60.46 | 60.61 | 60.445 | 60.525 | 1175200.0 |
> showing 50 of 1,510 rows — these rows as CSV