PREVIEW / etf_30min / 2004-06-23
file: by_date/etf_30min/2004/2004-06-23.parquet size: 36 KB rows: 1,190
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-23 08:00:00 | SPY | ETF | 113.68 | 113.73 | 113.67 | 113.67 | 5500.0 |
| 2004-06-23 08:30:00 | SPY | ETF | 113.66 | 113.68 | 113.63 | 113.67 | 16200.0 |
| 2004-06-23 09:00:00 | SPY | ETF | 113.64 | 113.64 | 113.6 | 113.6 | 6000.0 |
| 2004-06-23 09:30:00 | SPY | ETF | 113.61 | 113.8 | 113.58 | 113.65 | 3327300.0 |
| 2004-06-23 10:00:00 | SPY | ETF | 113.65 | 113.74 | 113.57 | 113.65 | 2202600.0 |
| 2004-06-23 10:30:00 | SPY | ETF | 113.65 | 113.7 | 113.43 | 113.48 | 2073200.0 |
| 2004-06-23 11:00:00 | SPY | ETF | 113.47 | 113.63 | 113.42 | 113.46 | 1286400.0 |
| 2004-06-23 11:30:00 | SPY | ETF | 113.47 | 113.84 | 113.45 | 113.77 | 1448900.0 |
| 2004-06-23 12:00:00 | SPY | ETF | 113.79 | 113.93 | 113.68 | 113.82 | 2032600.0 |
| 2004-06-23 12:30:00 | SPY | ETF | 113.82 | 113.86 | 113.71 | 113.77 | 1030000.0 |
| 2004-06-23 13:00:00 | SPY | ETF | 113.77 | 113.93 | 113.75 | 113.77 | 877300.0 |
| 2004-06-23 13:30:00 | SPY | ETF | 113.77 | 113.85 | 113.67 | 113.76 | 1770500.0 |
| 2004-06-23 14:00:00 | SPY | ETF | 113.77 | 114.0 | 113.66 | 113.88 | 1352700.0 |
| 2004-06-23 14:30:00 | SPY | ETF | 113.89 | 114.04 | 113.78 | 113.97 | 1741100.0 |
| 2004-06-23 15:00:00 | SPY | ETF | 113.99 | 114.47 | 113.97 | 114.44 | 3692900.0 |
| 2004-06-23 15:30:00 | SPY | ETF | 114.44 | 114.84 | 114.41 | 114.69 | 7865600.0 |
| 2004-06-23 16:00:00 | SPY | ETF | 114.7 | 114.81 | 114.64 | 114.74 | 1275400.0 |
| 2004-06-23 16:30:00 | SPY | ETF | 114.72 | 114.75 | 114.68 | 114.7 | 82100.0 |
| 2004-06-23 17:00:00 | SPY | ETF | 114.7 | 114.7 | 114.64 | 114.7 | 132700.0 |
| 2004-06-23 17:30:00 | SPY | ETF | 114.67 | 114.69 | 114.65 | 114.65 | 1500.0 |
| 2004-06-23 18:00:00 | SPY | ETF | 114.63 | 114.71 | 114.6 | 114.71 | 177400.0 |
| 2004-06-23 18:30:00 | SPY | ETF | 114.63 | 114.66 | 114.63 | 114.66 | 6300.0 |
| 2004-06-23 19:30:00 | SPY | ETF | 114.64 | 114.64 | 114.64 | 114.64 | 100.0 |
| 2004-06-23 08:00:00 | QQQ | ETF | 36.6 | 36.65 | 36.6 | 36.63 | 35800.0 |
| 2004-06-23 08:30:00 | QQQ | ETF | 36.64 | 36.65 | 36.6 | 36.6 | 39400.0 |
| 2004-06-23 09:00:00 | QQQ | ETF | 36.6 | 36.6 | 36.58 | 36.58 | 63900.0 |
| 2004-06-23 09:30:00 | QQQ | ETF | 36.57 | 36.69 | 36.544 | 36.55 | 10167700.0 |
| 2004-06-23 10:00:00 | QQQ | ETF | 36.55 | 36.68 | 36.511 | 36.641 | 6112700.0 |
| 2004-06-23 10:30:00 | QQQ | ETF | 36.65 | 36.67 | 36.51 | 36.55 | 4626100.0 |
| 2004-06-23 11:00:00 | QQQ | ETF | 36.55 | 36.65 | 36.53 | 36.563 | 4712400.0 |
| 2004-06-23 11:30:00 | QQQ | ETF | 36.56 | 36.79 | 36.55 | 36.763 | 6829900.0 |
| 2004-06-23 12:00:00 | QQQ | ETF | 36.762 | 36.87 | 36.73 | 36.81 | 6396600.0 |
| 2004-06-23 12:30:00 | QQQ | ETF | 36.81 | 36.83 | 36.74 | 36.81 | 4509700.0 |
| 2004-06-23 13:00:00 | QQQ | ETF | 36.79 | 36.87 | 36.76 | 36.76 | 4268100.0 |
| 2004-06-23 13:30:00 | QQQ | ETF | 36.76 | 36.84 | 36.71 | 36.77 | 3364200.0 |
| 2004-06-23 14:00:00 | QQQ | ETF | 36.76 | 36.87 | 36.72 | 36.8 | 4912700.0 |
| 2004-06-23 14:30:00 | QQQ | ETF | 36.808 | 36.92 | 36.76 | 36.888 | 6820100.0 |
| 2004-06-23 15:00:00 | QQQ | ETF | 36.889 | 37.04 | 36.88 | 37.01 | 11318300.0 |
| 2004-06-23 15:30:00 | QQQ | ETF | 37.0 | 37.19 | 37.0 | 37.09 | 14338900.0 |
| 2004-06-23 16:00:00 | QQQ | ETF | 37.097 | 37.14 | 37.078 | 37.131 | 2488600.0 |
| 2004-06-23 16:30:00 | QQQ | ETF | 37.12 | 37.14 | 37.1 | 37.1 | 891400.0 |
| 2004-06-23 17:00:00 | QQQ | ETF | 37.12 | 37.12 | 37.04 | 37.06 | 617000.0 |
| 2004-06-23 17:30:00 | QQQ | ETF | 37.06 | 37.13 | 37.0 | 37.079 | 871600.0 |
| 2004-06-23 18:00:00 | QQQ | ETF | 37.06 | 37.08 | 37.04 | 37.07 | 41400.0 |
| 2004-06-23 18:30:00 | QQQ | ETF | 37.06 | 37.06 | 37.04 | 37.04 | 12300.0 |
| 2004-06-23 19:00:00 | QQQ | ETF | 37.04 | 37.07 | 37.04 | 37.06 | 4000.0 |
| 2004-06-23 19:30:00 | QQQ | ETF | 37.05 | 37.07 | 37.05 | 37.06 | 4700.0 |
| 2004-06-23 09:00:00 | IWM | ETF | 57.015 | 57.02 | 57.005 | 57.02 | 21400.0 |
| 2004-06-23 09:30:00 | IWM | ETF | 56.985 | 57.25 | 56.985 | 57.13 | 824800.0 |
| 2004-06-23 10:00:00 | IWM | ETF | 57.105 | 57.27 | 57.035 | 57.225 | 443400.0 |
> showing 50 of 1,190 rows — these rows as CSV