PREVIEW / etf_30min / 2005-06-21
file: by_date/etf_30min/2005/2005-06-21.parquet size: 41 KB rows: 1,519
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-06-21 07:00:00 | SPY | ETF | 121.37 | 121.38 | 121.35 | 121.35 | 24400.0 |
| 2005-06-21 07:30:00 | SPY | ETF | 121.32 | 121.32 | 121.32 | 121.32 | 1000.0 |
| 2005-06-21 08:00:00 | SPY | ETF | 121.37 | 121.4 | 121.37 | 121.4 | 15400.0 |
| 2005-06-21 08:30:00 | SPY | ETF | 121.4 | 121.41 | 121.4 | 121.41 | 5500.0 |
| 2005-06-21 09:00:00 | SPY | ETF | 121.44 | 121.52 | 121.43 | 121.49 | 47400.0 |
| 2005-06-21 09:30:00 | SPY | ETF | 121.5 | 121.64 | 121.14 | 121.2 | 5871700.0 |
| 2005-06-21 10:00:00 | SPY | ETF | 121.2 | 121.45 | 121.03 | 121.4 | 6691600.0 |
| 2005-06-21 10:30:00 | SPY | ETF | 121.4 | 121.65 | 121.38 | 121.47 | 2510400.0 |
| 2005-06-21 11:00:00 | SPY | ETF | 121.49 | 121.57 | 121.27 | 121.28 | 1640800.0 |
| 2005-06-21 11:30:00 | SPY | ETF | 121.28 | 121.42 | 121.23 | 121.34 | 937000.0 |
| 2005-06-21 12:00:00 | SPY | ETF | 121.35 | 121.55 | 121.34 | 121.42 | 1349700.0 |
| 2005-06-21 12:30:00 | SPY | ETF | 121.43 | 121.55 | 121.37 | 121.452 | 783800.0 |
| 2005-06-21 13:00:00 | SPY | ETF | 121.46 | 121.48 | 121.29 | 121.41 | 1883700.0 |
| 2005-06-21 13:30:00 | SPY | ETF | 121.4 | 121.6 | 121.39 | 121.48 | 1738200.0 |
| 2005-06-21 14:00:00 | SPY | ETF | 121.46 | 121.58 | 121.38 | 121.51 | 1828600.0 |
| 2005-06-21 14:30:00 | SPY | ETF | 121.49 | 121.61 | 121.41 | 121.5 | 2845600.0 |
| 2005-06-21 15:00:00 | SPY | ETF | 121.5 | 121.54 | 121.15 | 121.2 | 4969900.0 |
| 2005-06-21 15:30:00 | SPY | ETF | 121.22 | 121.42 | 121.2 | 121.3 | 3759400.0 |
| 2005-06-21 16:00:00 | SPY | ETF | 121.34 | 121.54 | 121.27 | 121.5 | 1120200.0 |
| 2005-06-21 16:30:00 | SPY | ETF | 121.5 | 121.55 | 121.48 | 121.48 | 82800.0 |
| 2005-06-21 17:00:00 | SPY | ETF | 121.51 | 121.51 | 121.47 | 121.48 | 21000.0 |
| 2005-06-21 17:30:00 | SPY | ETF | 121.48 | 121.49 | 121.48 | 121.49 | 500.0 |
| 2005-06-21 18:00:00 | SPY | ETF | 121.48 | 121.49 | 121.48 | 121.49 | 1000.0 |
| 2005-06-21 18:30:00 | SPY | ETF | 121.48 | 121.48 | 121.48 | 121.48 | 100.0 |
| 2005-06-21 19:00:00 | SPY | ETF | 121.47 | 121.47 | 121.45 | 121.45 | 1400.0 |
| 2005-06-21 09:30:00 | QQQ | ETF | 37.83 | 37.95 | 37.76 | 37.77 | 11531100.0 |
| 2005-06-21 10:00:00 | QQQ | ETF | 37.77 | 37.92 | 37.71 | 37.9 | 10213300.0 |
| 2005-06-21 10:30:00 | QQQ | ETF | 37.9 | 38.01 | 37.9 | 37.94 | 9847600.0 |
| 2005-06-21 11:00:00 | QQQ | ETF | 37.94 | 37.97 | 37.85 | 37.85 | 2736500.0 |
| 2005-06-21 11:30:00 | QQQ | ETF | 37.84 | 37.89 | 37.8 | 37.88 | 2263200.0 |
| 2005-06-21 12:00:00 | QQQ | ETF | 37.88 | 37.95 | 37.87 | 37.92 | 1730000.0 |
| 2005-06-21 12:30:00 | QQQ | ETF | 37.93 | 37.97 | 37.89 | 37.94 | 2278400.0 |
| 2005-06-21 13:00:00 | QQQ | ETF | 37.94 | 37.95 | 37.85 | 37.9 | 3492900.0 |
| 2005-06-21 13:30:00 | QQQ | ETF | 37.9 | 37.97 | 37.89 | 37.93 | 3301700.0 |
| 2005-06-21 14:00:00 | QQQ | ETF | 37.93 | 37.97 | 37.9 | 37.93 | 2853400.0 |
| 2005-06-21 14:30:00 | QQQ | ETF | 37.94 | 37.97 | 37.9 | 37.92 | 4025400.0 |
| 2005-06-21 15:00:00 | QQQ | ETF | 37.92 | 37.93 | 37.7 | 37.77 | 28689200.0 |
| 2005-06-21 15:30:00 | QQQ | ETF | 37.77 | 37.9 | 37.76 | 37.85 | 7078800.0 |
| 2005-06-21 09:00:00 | IWM | ETF | 63.82 | 63.87 | 63.77 | 63.83 | 6400.0 |
| 2005-06-21 09:30:00 | IWM | ETF | 63.85 | 63.99 | 63.6 | 63.65 | 1682500.0 |
| 2005-06-21 10:00:00 | IWM | ETF | 63.64 | 63.77 | 63.53 | 63.75 | 1169400.0 |
| 2005-06-21 10:30:00 | IWM | ETF | 63.75 | 63.92 | 63.75 | 63.86 | 1006100.0 |
| 2005-06-21 11:00:00 | IWM | ETF | 63.85 | 63.89 | 63.74 | 63.74 | 341300.0 |
| 2005-06-21 11:30:00 | IWM | ETF | 63.74 | 63.85 | 63.69 | 63.8 | 250200.0 |
| 2005-06-21 12:00:00 | IWM | ETF | 63.8 | 63.93 | 63.8 | 63.89 | 1583200.0 |
| 2005-06-21 12:30:00 | IWM | ETF | 63.88 | 63.97 | 63.86 | 63.93 | 568900.0 |
| 2005-06-21 13:00:00 | IWM | ETF | 63.92 | 63.95 | 63.72 | 63.77 | 1755700.0 |
| 2005-06-21 13:30:00 | IWM | ETF | 63.77 | 63.9 | 63.73 | 63.77 | 375100.0 |
| 2005-06-21 14:00:00 | IWM | ETF | 63.77 | 63.82 | 63.65 | 63.79 | 700300.0 |
| 2005-06-21 14:30:00 | IWM | ETF | 63.79 | 63.92 | 63.74 | 63.82 | 863600.0 |
> showing 50 of 1,519 rows — these rows as CSV