PREVIEW / etf_30min / 2005-10-24
file: by_date/etf_30min/2005/2005-10-24.parquet size: 51 KB rows: 1,737
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-10-24 07:00:00 | SPY | ETF | 118.49 | 118.52 | 118.49 | 118.52 | 5000.0 |
| 2005-10-24 07:30:00 | SPY | ETF | 118.52 | 118.52 | 118.52 | 118.52 | 16000.0 |
| 2005-10-24 08:00:00 | SPY | ETF | 118.42 | 118.54 | 115.52 | 118.48 | 85300.0 |
| 2005-10-24 08:30:00 | SPY | ETF | 118.5 | 118.52 | 118.38 | 118.39 | 161100.0 |
| 2005-10-24 09:00:00 | SPY | ETF | 118.41 | 118.47 | 117.88 | 118.43 | 1316100.0 |
| 2005-10-24 09:30:00 | SPY | ETF | 118.44 | 119.01 | 118.41 | 118.93 | 13347800.0 |
| 2005-10-24 10:00:00 | SPY | ETF | 118.93 | 119.16 | 118.85 | 118.9 | 6250000.0 |
| 2005-10-24 10:30:00 | SPY | ETF | 118.91 | 119.18 | 118.51 | 118.67 | 4564600.0 |
| 2005-10-24 11:00:00 | SPY | ETF | 118.69 | 119.12 | 118.64 | 119.06 | 3795500.0 |
| 2005-10-24 11:30:00 | SPY | ETF | 119.05 | 119.27 | 119.03 | 119.09 | 3999800.0 |
| 2005-10-24 12:00:00 | SPY | ETF | 119.09 | 119.5 | 119.07 | 119.49 | 4674000.0 |
| 2005-10-24 12:30:00 | SPY | ETF | 119.48 | 119.55 | 119.33 | 119.39 | 3855000.0 |
| 2005-10-24 13:00:00 | SPY | ETF | 119.38 | 119.55 | 119.23 | 119.37 | 4239400.0 |
| 2005-10-24 13:30:00 | SPY | ETF | 119.37 | 119.57 | 119.31 | 119.51 | 2447000.0 |
| 2005-10-24 14:00:00 | SPY | ETF | 119.53 | 119.61 | 119.43 | 119.49 | 2250200.0 |
| 2005-10-24 14:30:00 | SPY | ETF | 119.5 | 119.57 | 119.33 | 119.4 | 3119200.0 |
| 2005-10-24 15:00:00 | SPY | ETF | 119.38 | 119.64 | 119.35 | 119.48 | 3317000.0 |
| 2005-10-24 15:30:00 | SPY | ETF | 119.48 | 120.06 | 119.48 | 120.03 | 11276900.0 |
| 2005-10-24 16:00:00 | SPY | ETF | 120.04 | 120.07 | 119.9 | 119.94 | 1132800.0 |
| 2005-10-24 16:30:00 | SPY | ETF | 119.93 | 119.93 | 119.03 | 119.9 | 953900.0 |
| 2005-10-24 17:00:00 | SPY | ETF | 119.9 | 119.92 | 119.89 | 119.89 | 48500.0 |
| 2005-10-24 17:30:00 | SPY | ETF | 119.87 | 119.91 | 119.87 | 119.91 | 12300.0 |
| 2005-10-24 18:00:00 | SPY | ETF | 119.87 | 119.92 | 119.6263 | 119.92 | 17700.0 |
| 2005-10-24 18:30:00 | SPY | ETF | 119.91 | 119.94 | 119.91 | 119.94 | 16400.0 |
| 2005-10-24 19:00:00 | SPY | ETF | 119.92 | 119.92 | 119.92 | 119.92 | 4000.0 |
| 2005-10-24 19:30:00 | SPY | ETF | 119.93 | 120.0 | 119.93 | 120.0 | 20700.0 |
| 2005-10-24 09:30:00 | QQQ | ETF | 38.72 | 38.76 | 36.67 | 38.72 | 12909700.0 |
| 2005-10-24 10:00:00 | QQQ | ETF | 38.71 | 38.81 | 38.69 | 38.69 | 7105300.0 |
| 2005-10-24 10:30:00 | QQQ | ETF | 38.69 | 38.78 | 38.47 | 38.54 | 10651200.0 |
| 2005-10-24 11:00:00 | QQQ | ETF | 38.54 | 38.7 | 38.53 | 38.67 | 4574700.0 |
| 2005-10-24 11:30:00 | QQQ | ETF | 38.67 | 38.79 | 38.67 | 38.75 | 11151500.0 |
| 2005-10-24 12:00:00 | QQQ | ETF | 38.75 | 38.91 | 38.73 | 38.91 | 5443200.0 |
| 2005-10-24 12:30:00 | QQQ | ETF | 38.91 | 38.97 | 38.87 | 38.94 | 8635400.0 |
| 2005-10-24 13:00:00 | QQQ | ETF | 38.94 | 38.97 | 38.86 | 38.93 | 4765900.0 |
| 2005-10-24 13:30:00 | QQQ | ETF | 38.93 | 38.97 | 38.85 | 38.93 | 4746400.0 |
| 2005-10-24 14:00:00 | QQQ | ETF | 38.92 | 38.96 | 38.88 | 38.88 | 3901700.0 |
| 2005-10-24 14:30:00 | QQQ | ETF | 38.89 | 38.94 | 38.82 | 38.84 | 5431300.0 |
| 2005-10-24 15:00:00 | QQQ | ETF | 38.84 | 38.95 | 38.84 | 38.93 | 3908100.0 |
| 2005-10-24 15:30:00 | QQQ | ETF | 38.93 | 39.16 | 38.93 | 39.15 | 11455700.0 |
| 2005-10-24 08:00:00 | IWM | ETF | 63.16 | 63.2 | 63.15 | 63.18 | 65300.0 |
| 2005-10-24 08:30:00 | IWM | ETF | 63.22 | 63.22 | 63.14 | 63.14 | 17800.0 |
| 2005-10-24 09:00:00 | IWM | ETF | 63.12 | 63.2 | 63.12 | 63.17 | 500700.0 |
| 2005-10-24 09:30:00 | IWM | ETF | 63.15 | 63.74 | 63.1 | 63.63 | 7502900.0 |
| 2005-10-24 10:00:00 | IWM | ETF | 63.61 | 63.85 | 63.55 | 63.55 | 2927900.0 |
| 2005-10-24 10:30:00 | IWM | ETF | 63.55 | 63.83 | 63.3 | 63.45 | 3125400.0 |
| 2005-10-24 11:00:00 | IWM | ETF | 63.45 | 63.8 | 63.4 | 63.77 | 3154600.0 |
| 2005-10-24 11:30:00 | IWM | ETF | 63.77 | 63.85 | 63.7 | 63.72 | 1218400.0 |
| 2005-10-24 12:00:00 | IWM | ETF | 63.72 | 63.96 | 63.67 | 63.95 | 1157100.0 |
| 2005-10-24 12:30:00 | IWM | ETF | 63.95 | 63.98 | 63.89 | 63.93 | 1600100.0 |
| 2005-10-24 13:00:00 | IWM | ETF | 63.93 | 64.05 | 63.82 | 63.89 | 1608000.0 |
> showing 50 of 1,737 rows — these rows as CSV