PREVIEW / etf_30min / 2001-12-04
file: by_date/etf_30min/2001/2001-12-04.parquet size: 17 KB rows: 450
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-04 09:30:00 | SPY | ETF | 113.91 | 114.0 | 113.65 | 113.96 | 1488100.0 |
| 2001-12-04 10:00:00 | SPY | ETF | 113.94 | 114.17 | 113.66 | 113.69 | 1549300.0 |
| 2001-12-04 10:30:00 | SPY | ETF | 113.7 | 113.7 | 113.36 | 113.56 | 2067500.0 |
| 2001-12-04 11:00:00 | SPY | ETF | 113.55 | 113.8 | 113.35 | 113.76 | 1103100.0 |
| 2001-12-04 11:30:00 | SPY | ETF | 113.75 | 113.79 | 113.57 | 113.72 | 693000.0 |
| 2001-12-04 12:00:00 | SPY | ETF | 113.73 | 113.89 | 113.6 | 113.84 | 728100.0 |
| 2001-12-04 12:30:00 | SPY | ETF | 113.84 | 113.98 | 113.72 | 113.73 | 594000.0 |
| 2001-12-04 13:00:00 | SPY | ETF | 113.74 | 113.8 | 113.57 | 113.63 | 576500.0 |
| 2001-12-04 13:30:00 | SPY | ETF | 113.74 | 113.96 | 113.62 | 113.89 | 557100.0 |
| 2001-12-04 14:00:00 | SPY | ETF | 113.91 | 114.13 | 113.82 | 113.98 | 849100.0 |
| 2001-12-04 14:30:00 | SPY | ETF | 114.01 | 114.74 | 113.96 | 114.65 | 1774100.0 |
| 2001-12-04 15:00:00 | SPY | ETF | 114.65 | 114.81 | 114.46 | 114.52 | 1051900.0 |
| 2001-12-04 15:30:00 | SPY | ETF | 114.49 | 115.0 | 114.48 | 115.0 | 1688000.0 |
| 2001-12-04 16:00:00 | SPY | ETF | 114.99 | 115.3 | 114.94 | 115.2 | 2376900.0 |
| 2001-12-04 16:30:00 | SPY | ETF | 115.28 | 115.29 | 115.24 | 115.29 | 3300.0 |
| 2001-12-04 17:00:00 | SPY | ETF | 115.2 | 115.2 | 115.05 | 115.15 | 3400.0 |
| 2001-12-04 09:30:00 | QQQ | ETF | 39.34 | 39.6 | 39.24 | 39.52 | 10341400.0 |
| 2001-12-04 10:00:00 | QQQ | ETF | 39.52 | 39.76 | 39.46 | 39.46 | 8269300.0 |
| 2001-12-04 10:30:00 | QQQ | ETF | 39.46 | 39.62 | 39.32 | 39.5 | 4147000.0 |
| 2001-12-04 11:00:00 | QQQ | ETF | 39.53 | 39.7 | 39.4 | 39.63 | 3327600.0 |
| 2001-12-04 11:30:00 | QQQ | ETF | 39.63 | 39.64 | 39.4 | 39.5 | 3560300.0 |
| 2001-12-04 12:00:00 | QQQ | ETF | 39.51 | 39.65 | 39.43 | 39.61 | 1740700.0 |
| 2001-12-04 12:30:00 | QQQ | ETF | 39.61 | 39.72 | 39.47 | 39.5 | 2878600.0 |
| 2001-12-04 13:00:00 | QQQ | ETF | 39.5 | 39.62 | 39.44 | 39.46 | 2684300.0 |
| 2001-12-04 13:30:00 | QQQ | ETF | 39.45 | 39.74 | 39.45 | 39.72 | 3011100.0 |
| 2001-12-04 14:00:00 | QQQ | ETF | 39.69 | 40.0 | 39.66 | 39.95 | 7494500.0 |
| 2001-12-04 14:30:00 | QQQ | ETF | 39.95 | 40.35 | 39.9 | 40.3 | 9567800.0 |
| 2001-12-04 15:00:00 | QQQ | ETF | 40.32 | 40.47 | 40.23 | 40.3 | 7991500.0 |
| 2001-12-04 15:30:00 | QQQ | ETF | 40.29 | 40.68 | 40.26 | 40.65 | 9137900.0 |
| 2001-12-04 16:00:00 | QQQ | ETF | 40.65 | 40.85 | 39.59 | 40.8 | 4535700.0 |
| 2001-12-04 16:30:00 | QQQ | ETF | 40.8 | 40.83 | 40.7 | 40.8 | 108800.0 |
| 2001-12-04 17:00:00 | QQQ | ETF | 40.8 | 40.82 | 40.7 | 40.75 | 95100.0 |
| 2001-12-04 17:30:00 | QQQ | ETF | 40.75 | 40.8 | 40.74 | 40.77 | 13500.0 |
| 2001-12-04 18:00:00 | QQQ | ETF | 40.75 | 40.8 | 40.75 | 40.8 | 22900.0 |
| 2001-12-04 09:30:00 | IWM | ETF | 45.5 | 45.825 | 45.48 | 45.825 | 22800.0 |
| 2001-12-04 10:00:00 | IWM | ETF | 45.84 | 45.865 | 45.7 | 45.82 | 36600.0 |
| 2001-12-04 10:30:00 | IWM | ETF | 45.775 | 45.795 | 45.6 | 45.765 | 33800.0 |
| 2001-12-04 11:00:00 | IWM | ETF | 45.705 | 45.87 | 45.7 | 45.87 | 25000.0 |
| 2001-12-04 11:30:00 | IWM | ETF | 45.8 | 45.87 | 45.78 | 45.78 | 3200.0 |
| 2001-12-04 12:00:00 | IWM | ETF | 45.87 | 45.96 | 45.87 | 45.94 | 17400.0 |
| 2001-12-04 12:30:00 | IWM | ETF | 45.875 | 46.15 | 45.875 | 46.145 | 16800.0 |
| 2001-12-04 13:00:00 | IWM | ETF | 46.12 | 46.2 | 45.98 | 46.12 | 24600.0 |
| 2001-12-04 13:30:00 | IWM | ETF | 46.1 | 46.145 | 45.975 | 46.145 | 18400.0 |
| 2001-12-04 14:00:00 | IWM | ETF | 46.1 | 46.3 | 46.1 | 46.2 | 31000.0 |
| 2001-12-04 14:30:00 | IWM | ETF | 46.175 | 46.375 | 46.175 | 46.375 | 21600.0 |
| 2001-12-04 15:00:00 | IWM | ETF | 46.33 | 46.5 | 46.33 | 46.415 | 46000.0 |
| 2001-12-04 15:30:00 | IWM | ETF | 46.275 | 46.675 | 46.24 | 46.675 | 314200.0 |
| 2001-12-04 16:00:00 | IWM | ETF | 46.675 | 46.675 | 46.55 | 46.55 | 65200.0 |
| 2001-12-04 09:30:00 | DIA | ETF | 98.3 | 98.44 | 97.95 | 98.13 | 216600.0 |
| 2001-12-04 10:00:00 | DIA | ETF | 98.15 | 98.4 | 97.95 | 98.0 | 117000.0 |
> showing 50 of 450 rows — these rows as CSV