PREVIEW / etf_30min / 2002-09-23
file: by_date/etf_30min/2002/2002-09-23.parquet size: 20 KB rows: 585
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-09-23 09:30:00 | SPY | ETF | 83.65 | 83.97 | 83.5 | 83.8 | 4763900.0 |
| 2002-09-23 10:00:00 | SPY | ETF | 83.72 | 84.05 | 82.94 | 83.1 | 4470500.0 |
| 2002-09-23 10:30:00 | SPY | ETF | 83.1 | 83.5 | 82.69 | 82.93 | 5336700.0 |
| 2002-09-23 11:00:00 | SPY | ETF | 82.96 | 83.52 | 82.83 | 83.4 | 4122100.0 |
| 2002-09-23 11:30:00 | SPY | ETF | 83.41 | 83.41 | 83.0 | 83.1 | 2456400.0 |
| 2002-09-23 12:00:00 | SPY | ETF | 83.11 | 83.2 | 82.86 | 83.07 | 2017000.0 |
| 2002-09-23 12:30:00 | SPY | ETF | 83.07 | 83.58 | 82.87 | 83.5 | 2096600.0 |
| 2002-09-23 13:00:00 | SPY | ETF | 83.44 | 83.76 | 83.31 | 83.4 | 1849300.0 |
| 2002-09-23 13:30:00 | SPY | ETF | 83.4 | 83.57 | 83.14 | 83.53 | 2188000.0 |
| 2002-09-23 14:00:00 | SPY | ETF | 83.52 | 83.52 | 83.04 | 83.3 | 1963300.0 |
| 2002-09-23 14:30:00 | SPY | ETF | 83.31 | 83.47 | 82.97 | 83.06 | 2869800.0 |
| 2002-09-23 15:00:00 | SPY | ETF | 83.02 | 83.28 | 82.84 | 83.16 | 3379000.0 |
| 2002-09-23 15:30:00 | SPY | ETF | 83.17 | 84.06 | 83.11 | 83.59 | 5879200.0 |
| 2002-09-23 16:00:00 | SPY | ETF | 83.59 | 83.76 | 83.49 | 83.66 | 1655600.0 |
| 2002-09-23 09:30:00 | QQQ | ETF | 21.45 | 21.52 | 21.27 | 21.33 | 7845300.0 |
| 2002-09-23 10:00:00 | QQQ | ETF | 21.32 | 21.41 | 21.12 | 21.18 | 7361000.0 |
| 2002-09-23 10:30:00 | QQQ | ETF | 21.16 | 21.25 | 20.99 | 21.08 | 10774000.0 |
| 2002-09-23 11:00:00 | QQQ | ETF | 21.09 | 21.19 | 21.02 | 21.13 | 4240500.0 |
| 2002-09-23 11:30:00 | QQQ | ETF | 21.14 | 21.15 | 21.0 | 21.03 | 3389300.0 |
| 2002-09-23 12:00:00 | QQQ | ETF | 21.04 | 21.08 | 21.0 | 21.06 | 2445800.0 |
| 2002-09-23 12:30:00 | QQQ | ETF | 21.06 | 21.17 | 20.96 | 21.15 | 3609100.0 |
| 2002-09-23 13:00:00 | QQQ | ETF | 21.15 | 21.29 | 21.11 | 21.17 | 6786800.0 |
| 2002-09-23 13:30:00 | QQQ | ETF | 21.17 | 21.2 | 21.06 | 21.09 | 2743900.0 |
| 2002-09-23 14:00:00 | QQQ | ETF | 21.1 | 21.11 | 20.96 | 21.04 | 3739200.0 |
| 2002-09-23 14:30:00 | QQQ | ETF | 21.03 | 21.1 | 20.85 | 20.88 | 4534700.0 |
| 2002-09-23 15:00:00 | QQQ | ETF | 20.89 | 20.93 | 20.81 | 20.89 | 4712200.0 |
| 2002-09-23 15:30:00 | QQQ | ETF | 20.91 | 21.24 | 20.87 | 20.98 | 7594600.0 |
| 2002-09-23 16:00:00 | QQQ | ETF | 20.98 | 21.06 | 20.96 | 21.02 | 585800.0 |
| 2002-09-23 09:30:00 | IWM | ETF | 36.3 | 36.445 | 36.245 | 36.39 | 416400.0 |
| 2002-09-23 10:00:00 | IWM | ETF | 36.375 | 36.38 | 36.075 | 36.08 | 116800.0 |
| 2002-09-23 10:30:00 | IWM | ETF | 36.12 | 36.19 | 35.985 | 36.035 | 128800.0 |
| 2002-09-23 11:00:00 | IWM | ETF | 35.985 | 36.11 | 35.975 | 36.1 | 132600.0 |
| 2002-09-23 11:30:00 | IWM | ETF | 36.015 | 36.07 | 35.915 | 35.915 | 106600.0 |
| 2002-09-23 12:00:00 | IWM | ETF | 35.915 | 35.92 | 35.775 | 35.865 | 50200.0 |
| 2002-09-23 12:30:00 | IWM | ETF | 35.82 | 35.865 | 35.815 | 35.86 | 7600.0 |
| 2002-09-23 13:00:00 | IWM | ETF | 35.845 | 35.945 | 35.845 | 35.9 | 43400.0 |
| 2002-09-23 13:30:00 | IWM | ETF | 35.875 | 35.875 | 35.775 | 35.805 | 86800.0 |
| 2002-09-23 14:00:00 | IWM | ETF | 35.795 | 35.795 | 35.725 | 35.75 | 16000.0 |
| 2002-09-23 14:30:00 | IWM | ETF | 35.735 | 35.765 | 35.535 | 35.535 | 50000.0 |
| 2002-09-23 15:00:00 | IWM | ETF | 35.53 | 35.555 | 35.4 | 35.525 | 186600.0 |
| 2002-09-23 15:30:00 | IWM | ETF | 35.5 | 35.835 | 35.5 | 35.67 | 284600.0 |
| 2002-09-23 16:00:00 | IWM | ETF | 35.675 | 35.675 | 35.65 | 35.65 | 11600.0 |
| 2002-09-23 09:30:00 | DIA | ETF | 79.02 | 79.2 | 78.7 | 78.84 | 1068600.0 |
| 2002-09-23 10:00:00 | DIA | ETF | 78.84 | 79.15 | 78.0 | 78.3 | 1040100.0 |
| 2002-09-23 10:30:00 | DIA | ETF | 78.31 | 78.5 | 77.91 | 78.11 | 1011000.0 |
| 2002-09-23 11:00:00 | DIA | ETF | 78.1 | 78.66 | 78.03 | 78.47 | 885300.0 |
| 2002-09-23 11:30:00 | DIA | ETF | 78.48 | 78.6 | 78.18 | 78.28 | 624800.0 |
| 2002-09-23 12:00:00 | DIA | ETF | 78.28 | 78.33 | 78.0 | 78.18 | 314100.0 |
| 2002-09-23 12:30:00 | DIA | ETF | 78.17 | 78.61 | 78.02 | 78.6 | 450800.0 |
| 2002-09-23 13:00:00 | DIA | ETF | 78.55 | 78.9 | 78.46 | 78.53 | 585000.0 |
> showing 50 of 585 rows — these rows as CSV