PREVIEW / etf_30min / 2001-04-02
file: by_date/etf_30min/2001/2001-04-02.parquet size: 15 KB rows: 349
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-04-02 09:30:00 | SPY | ETF | 116.3 | 116.6 | 115.99 | 116.58 | 1077800.0 |
| 2001-04-02 10:00:00 | SPY | ETF | 116.48 | 116.95 | 116.16 | 116.72 | 1286900.0 |
| 2001-04-02 10:30:00 | SPY | ETF | 116.77 | 116.88 | 116.1 | 116.59 | 387800.0 |
| 2001-04-02 11:00:00 | SPY | ETF | 116.59 | 116.84 | 116.4 | 116.74 | 448600.0 |
| 2001-04-02 11:30:00 | SPY | ETF | 116.74 | 117.38 | 116.73 | 117.02 | 966800.0 |
| 2001-04-02 12:00:00 | SPY | ETF | 116.95 | 117.05 | 115.7 | 115.71 | 487200.0 |
| 2001-04-02 12:30:00 | SPY | ETF | 115.78 | 115.89 | 115.28 | 115.69 | 690200.0 |
| 2001-04-02 13:00:00 | SPY | ETF | 115.69 | 115.7 | 114.63 | 114.8 | 472300.0 |
| 2001-04-02 13:30:00 | SPY | ETF | 114.77 | 115.18 | 114.28 | 114.58 | 946500.0 |
| 2001-04-02 14:00:00 | SPY | ETF | 114.55 | 114.81 | 113.96 | 114.09 | 801200.0 |
| 2001-04-02 14:30:00 | SPY | ETF | 114.13 | 114.75 | 113.96 | 114.25 | 569100.0 |
| 2001-04-02 15:00:00 | SPY | ETF | 114.21 | 114.66 | 113.8 | 114.08 | 608000.0 |
| 2001-04-02 15:30:00 | SPY | ETF | 114.18 | 114.9 | 114.03 | 114.54 | 960100.0 |
| 2001-04-02 16:00:00 | SPY | ETF | 114.6 | 115.5 | 114.1 | 114.25 | 717800.0 |
| 2001-04-02 16:30:00 | SPY | ETF | 113.95 | 114.58 | 113.75 | 114.4 | 3800.0 |
| 2001-04-02 17:00:00 | SPY | ETF | 114.4 | 114.4 | 114.4 | 114.4 | 1100.0 |
| 2001-04-02 17:30:00 | SPY | ETF | 114.3 | 114.3 | 114.3 | 114.3 | 500.0 |
| 2001-04-02 09:30:00 | QQQ | ETF | 39.17 | 39.85 | 39.03 | 39.49 | 5451800.0 |
| 2001-04-02 10:00:00 | QQQ | ETF | 39.5 | 39.78 | 38.91 | 39.01 | 5387400.0 |
| 2001-04-02 10:30:00 | QQQ | ETF | 39.1 | 39.24 | 38.55 | 38.84 | 6909600.0 |
| 2001-04-02 11:00:00 | QQQ | ETF | 38.8 | 39.25 | 38.78 | 39.16 | 2528800.0 |
| 2001-04-02 11:30:00 | QQQ | ETF | 39.15 | 39.39 | 38.86 | 39.0 | 4376200.0 |
| 2001-04-02 12:00:00 | QQQ | ETF | 39.0 | 39.11 | 38.34 | 38.35 | 5749600.0 |
| 2001-04-02 12:30:00 | QQQ | ETF | 38.35 | 38.58 | 38.2 | 38.43 | 3380900.0 |
| 2001-04-02 13:00:00 | QQQ | ETF | 38.47 | 38.5 | 37.95 | 38.0 | 4004700.0 |
| 2001-04-02 13:30:00 | QQQ | ETF | 37.95 | 38.25 | 37.63 | 37.78 | 5683800.0 |
| 2001-04-02 14:00:00 | QQQ | ETF | 37.75 | 37.86 | 37.35 | 37.43 | 4163600.0 |
| 2001-04-02 14:30:00 | QQQ | ETF | 37.43 | 37.87 | 37.35 | 37.53 | 4091600.0 |
| 2001-04-02 15:00:00 | QQQ | ETF | 37.57 | 37.81 | 37.34 | 37.45 | 6376900.0 |
| 2001-04-02 15:30:00 | QQQ | ETF | 37.47 | 37.98 | 37.4 | 37.75 | 7814800.0 |
| 2001-04-02 16:00:00 | QQQ | ETF | 37.72 | 39.5 | 37.3 | 39.5 | 2470800.0 |
| 2001-04-02 16:30:00 | QQQ | ETF | 37.38 | 37.6 | 37.35 | 37.51 | 63100.0 |
| 2001-04-02 17:00:00 | QQQ | ETF | 37.48 | 37.56 | 37.39 | 37.5 | 65500.0 |
| 2001-04-02 17:30:00 | QQQ | ETF | 37.45 | 37.6 | 37.4 | 37.6 | 31500.0 |
| 2001-04-02 18:00:00 | QQQ | ETF | 37.6 | 37.6 | 37.4 | 37.4 | 19100.0 |
| 2001-04-02 09:30:00 | IWM | ETF | 44.775 | 45.0 | 44.75 | 44.825 | 60600.0 |
| 2001-04-02 10:00:00 | IWM | ETF | 44.86 | 44.86 | 44.575 | 44.8 | 9200.0 |
| 2001-04-02 10:30:00 | IWM | ETF | 44.6 | 44.6 | 44.45 | 44.45 | 4400.0 |
| 2001-04-02 11:00:00 | IWM | ETF | 44.54 | 44.7 | 44.54 | 44.585 | 20800.0 |
| 2001-04-02 11:30:00 | IWM | ETF | 44.75 | 44.75 | 44.675 | 44.75 | 14000.0 |
| 2001-04-02 12:00:00 | IWM | ETF | 44.725 | 44.725 | 44.425 | 44.425 | 10000.0 |
| 2001-04-02 12:30:00 | IWM | ETF | 44.5 | 44.5 | 44.225 | 44.255 | 31600.0 |
| 2001-04-02 13:00:00 | IWM | ETF | 44.05 | 44.05 | 44.05 | 44.05 | 48200.0 |
| 2001-04-02 13:30:00 | IWM | ETF | 44.02 | 44.2 | 43.8 | 43.875 | 20800.0 |
| 2001-04-02 14:00:00 | IWM | ETF | 44.0 | 44.05 | 43.775 | 43.8 | 35800.0 |
| 2001-04-02 14:30:00 | IWM | ETF | 43.85 | 44.0 | 43.85 | 44.0 | 4600.0 |
| 2001-04-02 15:00:00 | IWM | ETF | 43.725 | 44.025 | 43.725 | 44.025 | 9200.0 |
| 2001-04-02 15:30:00 | IWM | ETF | 43.925 | 43.925 | 43.675 | 43.75 | 69200.0 |
| 2001-04-02 16:00:00 | IWM | ETF | 43.75 | 43.75 | 43.75 | 43.75 | 1800.0 |
| 2001-04-02 09:30:00 | DIA | ETF | 98.4 | 99.3 | 98.4 | 99.3 | 425300.0 |
> showing 50 of 349 rows — these rows as CSV