PREVIEW / etf_30min / 2005-04-22
file: by_date/etf_30min/2005/2005-04-22.parquet size: 44 KB rows: 1,486
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-22 06:30:00 | SPY | ETF | 115.69 | 115.76 | 115.66 | 115.76 | 90000.0 |
| 2005-04-22 07:00:00 | SPY | ETF | 115.77 | 115.8 | 115.75 | 115.8 | 68200.0 |
| 2005-04-22 07:30:00 | SPY | ETF | 115.79 | 115.82 | 115.78 | 115.78 | 19400.0 |
| 2005-04-22 08:00:00 | SPY | ETF | 115.75 | 115.84 | 115.75 | 115.8 | 64600.0 |
| 2005-04-22 08:30:00 | SPY | ETF | 115.8 | 115.91 | 115.8 | 115.91 | 141500.0 |
| 2005-04-22 09:00:00 | SPY | ETF | 115.89 | 115.91 | 115.74 | 115.74 | 240300.0 |
| 2005-04-22 09:30:00 | SPY | ETF | 115.74 | 115.85 | 115.5 | 115.67 | 12171800.0 |
| 2005-04-22 10:00:00 | SPY | ETF | 115.67 | 116.5 | 115.6 | 115.75 | 6284800.0 |
| 2005-04-22 10:30:00 | SPY | ETF | 115.74 | 115.92 | 115.62 | 115.8 | 3906600.0 |
| 2005-04-22 11:00:00 | SPY | ETF | 115.77 | 115.99 | 115.74 | 115.83 | 2777600.0 |
| 2005-04-22 11:30:00 | SPY | ETF | 115.82 | 115.84 | 115.6 | 115.67 | 2616800.0 |
| 2005-04-22 12:00:00 | SPY | ETF | 115.67 | 115.73 | 115.45 | 115.66 | 3800200.0 |
| 2005-04-22 12:30:00 | SPY | ETF | 115.66 | 115.98 | 115.61 | 115.82 | 3361800.0 |
| 2005-04-22 13:00:00 | SPY | ETF | 115.8 | 115.95 | 115.65 | 115.76 | 1635000.0 |
| 2005-04-22 13:30:00 | SPY | ETF | 115.77 | 115.92 | 115.64 | 115.87 | 1868500.0 |
| 2005-04-22 14:00:00 | SPY | ETF | 115.89 | 115.89 | 115.46 | 115.65 | 2838200.0 |
| 2005-04-22 14:30:00 | SPY | ETF | 115.65 | 115.67 | 115.0 | 115.17 | 11902800.0 |
| 2005-04-22 15:00:00 | SPY | ETF | 115.19 | 115.32 | 114.35 | 114.38 | 14332100.0 |
| 2005-04-22 15:30:00 | SPY | ETF | 114.38 | 115.32 | 114.27 | 115.28 | 16058200.0 |
| 2005-04-22 16:00:00 | SPY | ETF | 115.31 | 115.61 | 115.23 | 115.52 | 1159000.0 |
| 2005-04-22 16:30:00 | SPY | ETF | 115.55 | 115.56 | 115.46 | 115.51 | 95900.0 |
| 2005-04-22 17:00:00 | SPY | ETF | 115.51 | 115.55 | 115.46 | 115.51 | 23500.0 |
| 2005-04-22 09:30:00 | QQQ | ETF | 35.45 | 35.46 | 35.31 | 35.36 | 14901700.0 |
| 2005-04-22 10:00:00 | QQQ | ETF | 35.36 | 35.43 | 35.26 | 35.35 | 12913900.0 |
| 2005-04-22 10:30:00 | QQQ | ETF | 35.35 | 35.4 | 35.28 | 35.33 | 8255300.0 |
| 2005-04-22 11:00:00 | QQQ | ETF | 35.32 | 35.39 | 35.29 | 35.33 | 6845200.0 |
| 2005-04-22 11:30:00 | QQQ | ETF | 35.33 | 35.34 | 35.24 | 35.29 | 5020500.0 |
| 2005-04-22 12:00:00 | QQQ | ETF | 35.29 | 35.29 | 35.17 | 35.23 | 6564100.0 |
| 2005-04-22 12:30:00 | QQQ | ETF | 35.24 | 35.31 | 35.21 | 35.24 | 4153000.0 |
| 2005-04-22 13:00:00 | QQQ | ETF | 35.24 | 35.31 | 35.2 | 35.22 | 2289700.0 |
| 2005-04-22 13:30:00 | QQQ | ETF | 35.22 | 35.35 | 35.22 | 35.35 | 4904000.0 |
| 2005-04-22 14:00:00 | QQQ | ETF | 35.34 | 35.39 | 35.17 | 35.23 | 6061000.0 |
| 2005-04-22 14:30:00 | QQQ | ETF | 35.22 | 35.22 | 35.03 | 35.08 | 8250000.0 |
| 2005-04-22 15:00:00 | QQQ | ETF | 35.08 | 35.12 | 34.83 | 34.83 | 11787700.0 |
| 2005-04-22 15:30:00 | QQQ | ETF | 34.84 | 35.09 | 34.82 | 35.09 | 18298600.0 |
| 2005-04-22 07:00:00 | IWM | ETF | 59.505 | 59.505 | 59.505 | 59.505 | 1000.0 |
| 2005-04-22 07:30:00 | IWM | ETF | 59.52 | 59.52 | 59.52 | 59.52 | 6800.0 |
| 2005-04-22 08:00:00 | IWM | ETF | 59.475 | 59.475 | 59.475 | 59.475 | 800.0 |
| 2005-04-22 09:00:00 | IWM | ETF | 59.49 | 59.49 | 59.48 | 59.48 | 1200.0 |
| 2005-04-22 09:30:00 | IWM | ETF | 59.465 | 59.56 | 59.08 | 59.15 | 3381800.0 |
| 2005-04-22 10:00:00 | IWM | ETF | 59.16 | 59.345 | 58.97 | 59.07 | 2055200.0 |
| 2005-04-22 10:30:00 | IWM | ETF | 59.06 | 59.195 | 58.83 | 58.885 | 883200.0 |
| 2005-04-22 11:00:00 | IWM | ETF | 58.885 | 59.075 | 58.885 | 59.01 | 1420200.0 |
| 2005-04-22 11:30:00 | IWM | ETF | 59.005 | 59.015 | 58.805 | 58.915 | 811200.0 |
| 2005-04-22 12:00:00 | IWM | ETF | 58.915 | 58.94 | 58.79 | 58.92 | 758400.0 |
| 2005-04-22 12:30:00 | IWM | ETF | 58.92 | 59.1 | 58.86 | 59.0 | 1387800.0 |
| 2005-04-22 13:00:00 | IWM | ETF | 59.0 | 59.03 | 58.94 | 58.98 | 217000.0 |
| 2005-04-22 13:30:00 | IWM | ETF | 58.975 | 59.055 | 58.925 | 58.975 | 973600.0 |
| 2005-04-22 14:00:00 | IWM | ETF | 58.96 | 58.985 | 58.66 | 58.805 | 972800.0 |
| 2005-04-22 14:30:00 | IWM | ETF | 58.805 | 58.805 | 58.375 | 58.55 | 2710400.0 |
> showing 50 of 1,486 rows — these rows as CSV