PREVIEW / etf_30min / 2005-10-13
file: by_date/etf_30min/2005/2005-10-13.parquet size: 50 KB rows: 1,733
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-13 04:00:00 | SPY | ETF | 117.87 | 117.87 | 117.84 | 117.84 | 1000.0 |
| 2005-10-13 05:30:00 | SPY | ETF | 117.71 | 117.71 | 117.71 | 117.71 | 500.0 |
| 2005-10-13 07:00:00 | SPY | ETF | 117.77 | 117.78 | 117.7 | 117.7 | 2400.0 |
| 2005-10-13 07:30:00 | SPY | ETF | 117.74 | 117.78 | 117.56 | 117.56 | 185900.0 |
| 2005-10-13 08:00:00 | SPY | ETF | 117.64 | 117.95 | 117.53 | 117.6 | 921300.0 |
| 2005-10-13 08:30:00 | SPY | ETF | 117.58 | 117.6 | 117.21 | 117.57 | 1680000.0 |
| 2005-10-13 09:00:00 | SPY | ETF | 117.57 | 117.76 | 117.4 | 117.46 | 2136600.0 |
| 2005-10-13 09:30:00 | SPY | ETF | 117.46 | 117.8 | 117.3 | 117.53 | 10980400.0 |
| 2005-10-13 10:00:00 | SPY | ETF | 117.52 | 117.77 | 117.41 | 117.71 | 7115300.0 |
| 2005-10-13 10:30:00 | SPY | ETF | 117.69 | 118.08 | 117.52 | 117.92 | 7018900.0 |
| 2005-10-13 11:00:00 | SPY | ETF | 117.92 | 118.02 | 117.61 | 117.73 | 4250100.0 |
| 2005-10-13 11:30:00 | SPY | ETF | 117.74 | 117.74 | 116.94 | 117.03 | 6687900.0 |
| 2005-10-13 12:00:00 | SPY | ETF | 117.02 | 117.91 | 116.88 | 117.02 | 6368700.0 |
| 2005-10-13 12:30:00 | SPY | ETF | 117.02 | 117.54 | 117.0 | 117.36 | 5921800.0 |
| 2005-10-13 13:00:00 | SPY | ETF | 117.36 | 117.36 | 117.03 | 117.12 | 3060000.0 |
| 2005-10-13 13:30:00 | SPY | ETF | 117.14 | 117.31 | 116.9 | 117.28 | 4096500.0 |
| 2005-10-13 14:00:00 | SPY | ETF | 117.28 | 117.91 | 117.27 | 117.56 | 12492000.0 |
| 2005-10-13 14:30:00 | SPY | ETF | 117.56 | 118.07 | 117.56 | 117.72 | 10548100.0 |
| 2005-10-13 15:00:00 | SPY | ETF | 117.72 | 117.98 | 117.6 | 117.77 | 5207000.0 |
| 2005-10-13 15:30:00 | SPY | ETF | 117.78 | 117.95 | 117.66 | 117.75 | 6740100.0 |
| 2005-10-13 16:00:00 | SPY | ETF | 117.8 | 117.85 | 117.05 | 117.5 | 1237900.0 |
| 2005-10-13 16:30:00 | SPY | ETF | 117.53 | 117.65 | 117.52 | 117.65 | 107500.0 |
| 2005-10-13 17:00:00 | SPY | ETF | 117.63 | 117.63 | 117.58 | 117.58 | 11800.0 |
| 2005-10-13 17:30:00 | SPY | ETF | 117.74 | 117.74 | 117.58 | 117.68 | 418400.0 |
| 2005-10-13 18:00:00 | SPY | ETF | 117.68 | 117.7 | 117.63 | 117.63 | 2900.0 |
| 2005-10-13 18:30:00 | SPY | ETF | 117.6 | 117.61 | 117.6 | 117.6 | 6100.0 |
| 2005-10-13 19:00:00 | SPY | ETF | 117.6 | 117.6 | 117.6 | 117.6 | 800.0 |
| 2005-10-13 19:30:00 | SPY | ETF | 117.6 | 117.6 | 117.6 | 117.6 | 100.0 |
| 2005-10-13 09:30:00 | QQQ | ETF | 37.47 | 37.6 | 37.41 | 37.54 | 17923400.0 |
| 2005-10-13 10:00:00 | QQQ | ETF | 37.54 | 37.63 | 37.45 | 37.62 | 12008300.0 |
| 2005-10-13 10:30:00 | QQQ | ETF | 37.62 | 37.64 | 37.48 | 37.58 | 11555100.0 |
| 2005-10-13 11:00:00 | QQQ | ETF | 37.59 | 37.63 | 37.53 | 37.61 | 5689900.0 |
| 2005-10-13 11:30:00 | QQQ | ETF | 37.6 | 37.6 | 37.39 | 37.4 | 7058900.0 |
| 2005-10-13 12:00:00 | QQQ | ETF | 37.4 | 37.49 | 37.33 | 37.37 | 11621800.0 |
| 2005-10-13 12:30:00 | QQQ | ETF | 37.36 | 37.6 | 37.36 | 37.56 | 8542100.0 |
| 2005-10-13 13:00:00 | QQQ | ETF | 37.56 | 37.56 | 37.47 | 37.53 | 2330600.0 |
| 2005-10-13 13:30:00 | QQQ | ETF | 37.53 | 37.59 | 37.43 | 37.57 | 4578600.0 |
| 2005-10-13 14:00:00 | QQQ | ETF | 37.57 | 37.76 | 37.56 | 37.69 | 11336300.0 |
| 2005-10-13 14:30:00 | QQQ | ETF | 37.68 | 37.89 | 37.68 | 37.76 | 12361700.0 |
| 2005-10-13 15:00:00 | QQQ | ETF | 37.76 | 37.87 | 37.74 | 37.83 | 7007700.0 |
| 2005-10-13 15:30:00 | QQQ | ETF | 37.83 | 37.91 | 37.78 | 37.78 | 11238700.0 |
| 2005-10-13 07:30:00 | IWM | ETF | 61.71 | 61.73 | 61.65 | 61.69 | 260900.0 |
| 2005-10-13 08:00:00 | IWM | ETF | 61.68 | 61.73 | 61.63 | 61.69 | 308900.0 |
| 2005-10-13 08:30:00 | IWM | ETF | 61.68 | 62.1 | 61.38 | 61.6 | 400300.0 |
| 2005-10-13 09:00:00 | IWM | ETF | 61.6 | 62.14 | 61.6 | 61.64 | 367700.0 |
| 2005-10-13 09:30:00 | IWM | ETF | 61.64 | 61.7985 | 61.21 | 61.64 | 7580500.0 |
| 2005-10-13 10:00:00 | IWM | ETF | 61.65 | 61.71 | 61.3 | 61.53 | 3100700.0 |
| 2005-10-13 10:30:00 | IWM | ETF | 61.53 | 61.8 | 61.32 | 61.7 | 2389100.0 |
| 2005-10-13 11:00:00 | IWM | ETF | 61.69 | 61.8 | 61.39 | 61.5188 | 1543400.0 |
| 2005-10-13 11:30:00 | IWM | ETF | 61.52 | 61.52 | 61.05 | 61.1 | 2270700.0 |
> showing 50 of 1,733 rows — these rows as CSV