PREVIEW / etf_30min / 2002-02-19
file: by_date/etf_30min/2002/2002-02-19.parquet size: 18 KB rows: 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 |
|---|---|---|---|---|---|---|---|
| 2002-02-19 09:30:00 | SPY | ETF | 110.23 | 110.29 | 109.88 | 110.13 | 1970200.0 |
| 2002-02-19 10:00:00 | SPY | ETF | 110.08 | 110.29 | 109.47 | 109.6 | 2116000.0 |
| 2002-02-19 10:30:00 | SPY | ETF | 109.63 | 109.71 | 109.28 | 109.52 | 1148800.0 |
| 2002-02-19 11:00:00 | SPY | ETF | 109.52 | 109.66 | 109.23 | 109.52 | 866200.0 |
| 2002-02-19 11:30:00 | SPY | ETF | 109.53 | 109.69 | 109.27 | 109.66 | 492400.0 |
| 2002-02-19 12:00:00 | SPY | ETF | 109.7 | 109.79 | 109.34 | 109.43 | 906800.0 |
| 2002-02-19 12:30:00 | SPY | ETF | 109.49 | 109.64 | 109.2 | 109.25 | 532500.0 |
| 2002-02-19 13:00:00 | SPY | ETF | 109.21 | 109.5 | 109.2 | 109.45 | 1156200.0 |
| 2002-02-19 13:30:00 | SPY | ETF | 109.45 | 109.58 | 109.2 | 109.33 | 497500.0 |
| 2002-02-19 14:00:00 | SPY | ETF | 109.33 | 109.49 | 109.08 | 109.09 | 561400.0 |
| 2002-02-19 14:30:00 | SPY | ETF | 109.14 | 109.6 | 109.1 | 109.43 | 587300.0 |
| 2002-02-19 15:00:00 | SPY | ETF | 109.4 | 109.43 | 108.83 | 108.91 | 1418000.0 |
| 2002-02-19 15:30:00 | SPY | ETF | 108.88 | 108.97 | 108.61 | 108.74 | 1505500.0 |
| 2002-02-19 16:00:00 | SPY | ETF | 108.74 | 108.83 | 108.67 | 108.73 | 1542900.0 |
| 2002-02-19 16:30:00 | SPY | ETF | 108.8 | 108.8 | 108.8 | 108.8 | 100.0 |
| 2002-02-19 17:00:00 | SPY | ETF | 108.85 | 108.88 | 108.76 | 108.88 | 3700.0 |
| 2002-02-19 17:30:00 | SPY | ETF | 108.8 | 108.8 | 108.8 | 108.8 | 100.0 |
| 2002-02-19 18:00:00 | SPY | ETF | 108.8 | 108.8 | 108.8 | 108.8 | 200.0 |
| 2002-02-19 09:30:00 | QQQ | ETF | 35.37 | 35.42 | 35.18 | 35.31 | 9140100.0 |
| 2002-02-19 10:00:00 | QQQ | ETF | 35.31 | 35.46 | 35.07 | 35.17 | 5259500.0 |
| 2002-02-19 10:30:00 | QQQ | ETF | 35.17 | 35.23 | 34.94 | 35.1 | 6336500.0 |
| 2002-02-19 11:00:00 | QQQ | ETF | 35.09 | 35.11 | 34.86 | 35.03 | 5582800.0 |
| 2002-02-19 11:30:00 | QQQ | ETF | 35.01 | 35.12 | 34.91 | 35.08 | 4061100.0 |
| 2002-02-19 12:00:00 | QQQ | ETF | 35.07 | 35.12 | 34.85 | 34.91 | 4178700.0 |
| 2002-02-19 12:30:00 | QQQ | ETF | 34.91 | 34.97 | 34.69 | 34.72 | 3533000.0 |
| 2002-02-19 13:00:00 | QQQ | ETF | 34.74 | 34.87 | 34.65 | 34.8 | 3721000.0 |
| 2002-02-19 13:30:00 | QQQ | ETF | 34.8 | 34.91 | 34.69 | 34.73 | 2849700.0 |
| 2002-02-19 14:00:00 | QQQ | ETF | 34.74 | 34.79 | 34.6 | 34.62 | 2614300.0 |
| 2002-02-19 14:30:00 | QQQ | ETF | 34.63 | 34.85 | 34.58 | 34.77 | 4049200.0 |
| 2002-02-19 15:00:00 | QQQ | ETF | 34.77 | 34.85 | 34.4 | 34.46 | 6881000.0 |
| 2002-02-19 15:30:00 | QQQ | ETF | 34.48 | 34.56 | 34.32 | 34.56 | 8386500.0 |
| 2002-02-19 16:00:00 | QQQ | ETF | 34.56 | 34.89 | 34.47 | 34.61 | 3944700.0 |
| 2002-02-19 16:30:00 | QQQ | ETF | 34.62 | 34.65 | 34.62 | 34.62 | 56500.0 |
| 2002-02-19 17:00:00 | QQQ | ETF | 34.63 | 34.65 | 34.61 | 34.63 | 17400.0 |
| 2002-02-19 17:30:00 | QQQ | ETF | 34.63 | 34.65 | 34.61 | 34.65 | 11900.0 |
| 2002-02-19 18:00:00 | QQQ | ETF | 34.67 | 34.7 | 34.61 | 34.63 | 31700.0 |
| 2002-02-19 09:30:00 | IWM | ETF | 46.25 | 46.4 | 46.2 | 46.345 | 165800.0 |
| 2002-02-19 10:00:00 | IWM | ETF | 46.3 | 46.35 | 46.12 | 46.205 | 45200.0 |
| 2002-02-19 10:30:00 | IWM | ETF | 46.205 | 46.205 | 45.98 | 46.105 | 84600.0 |
| 2002-02-19 11:00:00 | IWM | ETF | 46.0 | 46.105 | 45.93 | 46.05 | 72800.0 |
| 2002-02-19 11:30:00 | IWM | ETF | 46.0 | 46.07 | 45.93 | 46.06 | 50400.0 |
| 2002-02-19 12:00:00 | IWM | ETF | 46.085 | 46.095 | 46.0 | 46.025 | 32400.0 |
| 2002-02-19 12:30:00 | IWM | ETF | 45.98 | 46.025 | 45.9 | 45.945 | 47800.0 |
| 2002-02-19 13:00:00 | IWM | ETF | 45.89 | 45.975 | 45.84 | 45.93 | 29800.0 |
| 2002-02-19 13:30:00 | IWM | ETF | 45.97 | 46.045 | 45.97 | 46.025 | 17200.0 |
| 2002-02-19 14:00:00 | IWM | ETF | 45.95 | 45.975 | 45.9 | 45.9 | 13000.0 |
| 2002-02-19 14:30:00 | IWM | ETF | 45.965 | 46.0 | 45.9 | 46.0 | 9800.0 |
| 2002-02-19 15:00:00 | IWM | ETF | 46.0 | 46.0 | 45.625 | 45.69 | 56600.0 |
| 2002-02-19 15:30:00 | IWM | ETF | 45.71 | 45.775 | 45.64 | 45.765 | 179400.0 |
| 2002-02-19 16:00:00 | IWM | ETF | 45.625 | 45.775 | 45.625 | 45.775 | 65600.0 |
> showing 50 of 486 rows — these rows as CSV