PREVIEW / etf_30min / 2002-08-15
file: by_date/etf_30min/2002/2002-08-15.parquet size: 20 KB rows: 557
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 |
|---|---|---|---|---|---|---|---|
| 2002-08-15 09:30:00 | SPY | ETF | 92.84 | 93.3 | 92.54 | 92.65 | 5191700.0 |
| 2002-08-15 10:00:00 | SPY | ETF | 92.67 | 93.85 | 92.2 | 93.56 | 4604500.0 |
| 2002-08-15 10:30:00 | SPY | ETF | 93.6 | 93.7 | 92.81 | 93.55 | 3869400.0 |
| 2002-08-15 11:00:00 | SPY | ETF | 93.53 | 93.7 | 92.99 | 93.17 | 1524300.0 |
| 2002-08-15 11:30:00 | SPY | ETF | 93.16 | 93.8 | 93.06 | 93.66 | 2540200.0 |
| 2002-08-15 12:00:00 | SPY | ETF | 93.67 | 93.99 | 92.65 | 93.04 | 6341300.0 |
| 2002-08-15 12:30:00 | SPY | ETF | 93.0 | 93.42 | 92.69 | 92.87 | 2135500.0 |
| 2002-08-15 13:00:00 | SPY | ETF | 92.87 | 93.0 | 92.4 | 92.92 | 2427400.0 |
| 2002-08-15 13:30:00 | SPY | ETF | 92.95 | 93.07 | 92.5 | 92.95 | 1827600.0 |
| 2002-08-15 14:00:00 | SPY | ETF | 92.94 | 93.56 | 92.73 | 93.15 | 3797100.0 |
| 2002-08-15 14:30:00 | SPY | ETF | 93.15 | 93.32 | 92.55 | 92.72 | 2690500.0 |
| 2002-08-15 15:00:00 | SPY | ETF | 92.71 | 93.26 | 92.62 | 93.26 | 1868900.0 |
| 2002-08-15 15:30:00 | SPY | ETF | 93.25 | 93.57 | 93.0 | 93.4 | 3026600.0 |
| 2002-08-15 16:00:00 | SPY | ETF | 93.41 | 93.6 | 93.32 | 93.5 | 1051300.0 |
| 2002-08-15 09:30:00 | QQQ | ETF | 24.24 | 24.42 | 23.95 | 24.0 | 16185700.0 |
| 2002-08-15 10:00:00 | QQQ | ETF | 23.94 | 24.5 | 23.84 | 24.39 | 12921000.0 |
| 2002-08-15 10:30:00 | QQQ | ETF | 24.39 | 24.45 | 24.18 | 24.45 | 9608500.0 |
| 2002-08-15 11:00:00 | QQQ | ETF | 24.45 | 24.53 | 24.26 | 24.29 | 6762700.0 |
| 2002-08-15 11:30:00 | QQQ | ETF | 24.29 | 24.53 | 24.26 | 24.46 | 5932400.0 |
| 2002-08-15 12:00:00 | QQQ | ETF | 24.45 | 24.55 | 24.12 | 24.22 | 11108100.0 |
| 2002-08-15 12:30:00 | QQQ | ETF | 24.2 | 24.34 | 24.0 | 24.01 | 5956300.0 |
| 2002-08-15 13:00:00 | QQQ | ETF | 24.03 | 24.04 | 23.72 | 23.94 | 9052900.0 |
| 2002-08-15 13:30:00 | QQQ | ETF | 23.94 | 24.1 | 23.83 | 24.1 | 5335200.0 |
| 2002-08-15 14:00:00 | QQQ | ETF | 24.1 | 24.45 | 24.04 | 24.3 | 11452700.0 |
| 2002-08-15 14:30:00 | QQQ | ETF | 24.31 | 24.41 | 24.11 | 24.17 | 5106900.0 |
| 2002-08-15 15:00:00 | QQQ | ETF | 24.16 | 24.35 | 24.11 | 24.32 | 6064700.0 |
| 2002-08-15 15:30:00 | QQQ | ETF | 24.32 | 24.45 | 24.19 | 24.37 | 6839900.0 |
| 2002-08-15 16:00:00 | QQQ | ETF | 24.33 | 24.53 | 24.3 | 24.53 | 1268900.0 |
| 2002-08-15 09:30:00 | IWM | ETF | 39.15 | 39.15 | 38.775 | 38.845 | 431000.0 |
| 2002-08-15 10:00:00 | IWM | ETF | 38.8 | 39.25 | 38.7 | 39.195 | 381400.0 |
| 2002-08-15 10:30:00 | IWM | ETF | 39.12 | 39.15 | 38.95 | 39.14 | 152800.0 |
| 2002-08-15 11:00:00 | IWM | ETF | 39.13 | 39.165 | 38.93 | 38.94 | 176800.0 |
| 2002-08-15 11:30:00 | IWM | ETF | 38.895 | 39.11 | 38.895 | 39.01 | 149200.0 |
| 2002-08-15 12:00:00 | IWM | ETF | 39.115 | 39.125 | 38.825 | 38.93 | 1268800.0 |
| 2002-08-15 12:30:00 | IWM | ETF | 38.945 | 38.97 | 38.775 | 38.8 | 39000.0 |
| 2002-08-15 13:00:00 | IWM | ETF | 38.8 | 38.8 | 38.695 | 38.755 | 49000.0 |
| 2002-08-15 13:30:00 | IWM | ETF | 38.81 | 38.84 | 38.725 | 38.8 | 144600.0 |
| 2002-08-15 14:00:00 | IWM | ETF | 38.8 | 39.095 | 38.785 | 39.0 | 116000.0 |
| 2002-08-15 14:30:00 | IWM | ETF | 38.97 | 39.095 | 38.9 | 38.915 | 152600.0 |
| 2002-08-15 15:00:00 | IWM | ETF | 38.915 | 39.0 | 38.87 | 39.0 | 40200.0 |
| 2002-08-15 15:30:00 | IWM | ETF | 39.025 | 39.135 | 38.9 | 38.975 | 272800.0 |
| 2002-08-15 16:00:00 | IWM | ETF | 38.825 | 38.88 | 38.825 | 38.88 | 2400.0 |
| 2002-08-15 09:30:00 | DIA | ETF | 88.05 | 88.2 | 87.34 | 87.36 | 1663100.0 |
| 2002-08-15 10:00:00 | DIA | ETF | 87.36 | 88.67 | 87.03 | 88.45 | 1870000.0 |
| 2002-08-15 10:30:00 | DIA | ETF | 88.5 | 88.58 | 87.72 | 88.51 | 1276600.0 |
| 2002-08-15 11:00:00 | DIA | ETF | 88.44 | 88.65 | 87.97 | 88.1 | 586700.0 |
| 2002-08-15 11:30:00 | DIA | ETF | 88.08 | 88.78 | 88.05 | 88.54 | 862500.0 |
| 2002-08-15 12:00:00 | DIA | ETF | 88.52 | 88.88 | 87.59 | 87.95 | 1963500.0 |
| 2002-08-15 12:30:00 | DIA | ETF | 87.95 | 88.29 | 87.5 | 87.65 | 630700.0 |
| 2002-08-15 13:00:00 | DIA | ETF | 87.61 | 87.85 | 87.22 | 87.82 | 1080600.0 |
> showing 50 of 557 rows — these rows as CSV