PREVIEW / etf_30min / 2005-05-24
file: by_date/etf_30min/2005/2005-05-24.parquet size: 42 KB rows: 1,503
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-24 06:30:00 | SPY | ETF | 119.54 | 119.54 | 119.54 | 119.54 | 500.0 |
| 2005-05-24 07:00:00 | SPY | ETF | 119.51 | 119.52 | 119.44 | 119.44 | 8200.0 |
| 2005-05-24 07:30:00 | SPY | ETF | 119.49 | 119.49 | 119.41 | 119.44 | 4200.0 |
| 2005-05-24 08:00:00 | SPY | ETF | 119.44 | 119.49 | 119.39 | 119.49 | 85300.0 |
| 2005-05-24 08:30:00 | SPY | ETF | 119.46 | 119.46 | 119.44 | 119.44 | 47300.0 |
| 2005-05-24 09:00:00 | SPY | ETF | 119.44 | 119.46 | 119.44 | 119.44 | 26800.0 |
| 2005-05-24 09:30:00 | SPY | ETF | 119.44 | 119.54 | 119.27 | 119.48 | 5977200.0 |
| 2005-05-24 10:00:00 | SPY | ETF | 119.48 | 119.54 | 119.2 | 119.38 | 4198200.0 |
| 2005-05-24 10:30:00 | SPY | ETF | 119.38 | 119.5 | 119.25 | 119.4 | 2821000.0 |
| 2005-05-24 11:00:00 | SPY | ETF | 119.4 | 119.67 | 119.31 | 119.45 | 4837000.0 |
| 2005-05-24 11:30:00 | SPY | ETF | 119.45 | 119.5 | 119.2 | 119.27 | 4360700.0 |
| 2005-05-24 12:00:00 | SPY | ETF | 119.27 | 119.49 | 119.25 | 119.27 | 3424800.0 |
| 2005-05-24 12:30:00 | SPY | ETF | 119.26 | 119.44 | 119.23 | 119.39 | 1215100.0 |
| 2005-05-24 13:00:00 | SPY | ETF | 119.41 | 119.46 | 119.29 | 119.34 | 945800.0 |
| 2005-05-24 13:30:00 | SPY | ETF | 119.34 | 119.43 | 119.29 | 119.41 | 1424700.0 |
| 2005-05-24 14:00:00 | SPY | ETF | 119.41 | 119.6 | 119.27 | 119.47 | 6046200.0 |
| 2005-05-24 14:30:00 | SPY | ETF | 119.46 | 119.52 | 119.23 | 119.42 | 3319600.0 |
| 2005-05-24 15:00:00 | SPY | ETF | 119.45 | 119.77 | 119.33 | 119.72 | 4639400.0 |
| 2005-05-24 15:30:00 | SPY | ETF | 119.73 | 119.83 | 119.58 | 119.65 | 4747000.0 |
| 2005-05-24 16:00:00 | SPY | ETF | 119.6 | 119.62 | 119.51 | 119.54 | 917200.0 |
| 2005-05-24 16:30:00 | SPY | ETF | 119.53 | 119.61 | 119.44 | 119.49 | 182600.0 |
| 2005-05-24 17:00:00 | SPY | ETF | 119.49 | 119.5 | 119.45 | 119.45 | 76400.0 |
| 2005-05-24 17:30:00 | SPY | ETF | 119.45 | 119.45 | 119.45 | 119.45 | 1300.0 |
| 2005-05-24 18:00:00 | SPY | ETF | 119.45 | 119.45 | 119.41 | 119.45 | 7200.0 |
| 2005-05-24 18:30:00 | SPY | ETF | 119.42 | 119.45 | 119.42 | 119.44 | 3300.0 |
| 2005-05-24 19:00:00 | SPY | ETF | 119.41 | 119.41 | 119.4 | 119.4 | 1100.0 |
| 2005-05-24 19:30:00 | SPY | ETF | 119.44 | 119.44 | 119.44 | 119.44 | 500.0 |
| 2005-05-24 09:30:00 | QQQ | ETF | 37.76 | 37.85 | 37.71 | 37.82 | 10938200.0 |
| 2005-05-24 10:00:00 | QQQ | ETF | 37.83 | 37.87 | 37.7 | 37.84 | 10499100.0 |
| 2005-05-24 10:30:00 | QQQ | ETF | 37.83 | 37.9 | 37.77 | 37.81 | 10113400.0 |
| 2005-05-24 11:00:00 | QQQ | ETF | 37.81 | 37.92 | 37.78 | 37.84 | 7709500.0 |
| 2005-05-24 11:30:00 | QQQ | ETF | 37.83 | 37.86 | 37.78 | 37.82 | 5093400.0 |
| 2005-05-24 12:00:00 | QQQ | ETF | 37.83 | 37.92 | 37.82 | 37.82 | 3455700.0 |
| 2005-05-24 12:30:00 | QQQ | ETF | 37.82 | 37.89 | 37.8 | 37.88 | 3405200.0 |
| 2005-05-24 13:00:00 | QQQ | ETF | 37.87 | 37.91 | 37.82 | 37.82 | 2872800.0 |
| 2005-05-24 13:30:00 | QQQ | ETF | 37.83 | 37.89 | 37.81 | 37.86 | 1852400.0 |
| 2005-05-24 14:00:00 | QQQ | ETF | 37.87 | 37.94 | 37.83 | 37.86 | 8643400.0 |
| 2005-05-24 14:30:00 | QQQ | ETF | 37.85 | 37.89 | 37.78 | 37.84 | 5980700.0 |
| 2005-05-24 15:00:00 | QQQ | ETF | 37.84 | 37.99 | 37.78 | 37.97 | 10196700.0 |
| 2005-05-24 15:30:00 | QQQ | ETF | 37.97 | 38.0 | 37.94 | 37.98 | 9057700.0 |
| 2005-05-24 08:00:00 | IWM | ETF | 60.8 | 60.8 | 60.8 | 60.8 | 1000.0 |
| 2005-05-24 08:30:00 | IWM | ETF | 60.8 | 60.8 | 60.8 | 60.8 | 1800.0 |
| 2005-05-24 09:00:00 | IWM | ETF | 60.76 | 60.775 | 60.75 | 60.775 | 14200.0 |
| 2005-05-24 09:30:00 | IWM | ETF | 60.78 | 60.895 | 60.655 | 60.88 | 1932400.0 |
| 2005-05-24 10:00:00 | IWM | ETF | 60.89 | 60.92 | 60.63 | 60.825 | 2171400.0 |
| 2005-05-24 10:30:00 | IWM | ETF | 60.835 | 60.92 | 60.735 | 60.82 | 2438600.0 |
| 2005-05-24 11:00:00 | IWM | ETF | 60.82 | 60.99 | 60.785 | 60.915 | 1518400.0 |
| 2005-05-24 11:30:00 | IWM | ETF | 60.91 | 60.935 | 60.75 | 60.845 | 2606200.0 |
| 2005-05-24 12:00:00 | IWM | ETF | 60.855 | 60.92 | 60.81 | 60.82 | 1206200.0 |
| 2005-05-24 12:30:00 | IWM | ETF | 60.82 | 60.895 | 60.77 | 60.885 | 904400.0 |
> showing 50 of 1,503 rows — these rows as CSV