PREVIEW / etf_30min / 2005-01-26
file: by_date/etf_30min/2005/2005-01-26.parquet size: 41 KB rows: 1,413
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-26 08:00:00 | SPY | ETF | 117.33 | 117.39 | 117.29 | 117.32 | 78100.0 |
| 2005-01-26 08:30:00 | SPY | ETF | 117.32 | 117.35 | 117.3 | 117.3 | 43000.0 |
| 2005-01-26 09:00:00 | SPY | ETF | 117.32 | 117.34 | 117.28 | 117.31 | 224500.0 |
| 2005-01-26 09:30:00 | SPY | ETF | 117.32 | 117.4 | 117.22 | 117.33 | 5218000.0 |
| 2005-01-26 10:00:00 | SPY | ETF | 117.32 | 117.56 | 117.3 | 117.42 | 6133500.0 |
| 2005-01-26 10:30:00 | SPY | ETF | 117.42 | 117.51 | 117.23 | 117.46 | 6160400.0 |
| 2005-01-26 11:00:00 | SPY | ETF | 117.46 | 117.58 | 117.1 | 117.15 | 5461400.0 |
| 2005-01-26 11:30:00 | SPY | ETF | 117.15 | 117.27 | 117.06 | 117.17 | 4755000.0 |
| 2005-01-26 12:00:00 | SPY | ETF | 117.17 | 117.48 | 117.1 | 117.12 | 1806000.0 |
| 2005-01-26 12:30:00 | SPY | ETF | 117.12 | 117.27 | 117.04 | 117.08 | 2699600.0 |
| 2005-01-26 13:00:00 | SPY | ETF | 117.08 | 117.36 | 117.06 | 117.31 | 2161100.0 |
| 2005-01-26 13:30:00 | SPY | ETF | 117.31 | 117.48 | 117.22 | 117.42 | 3150800.0 |
| 2005-01-26 14:00:00 | SPY | ETF | 117.43 | 117.53 | 117.31 | 117.39 | 3442100.0 |
| 2005-01-26 14:30:00 | SPY | ETF | 117.4 | 117.43 | 117.34 | 117.41 | 3225700.0 |
| 2005-01-26 15:00:00 | SPY | ETF | 117.41 | 117.54 | 117.21 | 117.45 | 3131200.0 |
| 2005-01-26 15:30:00 | SPY | ETF | 117.46 | 117.6 | 117.38 | 117.41 | 5465900.0 |
| 2005-01-26 16:00:00 | SPY | ETF | 117.38 | 117.4 | 117.18 | 117.25 | 1436500.0 |
| 2005-01-26 16:30:00 | SPY | ETF | 117.23 | 117.41 | 117.16 | 117.22 | 249900.0 |
| 2005-01-26 17:00:00 | SPY | ETF | 117.2 | 117.22 | 117.12 | 117.15 | 220100.0 |
| 2005-01-26 17:30:00 | SPY | ETF | 117.18 | 117.21 | 117.18 | 117.21 | 7700.0 |
| 2005-01-26 18:00:00 | SPY | ETF | 117.18 | 117.24 | 117.18 | 117.24 | 11500.0 |
| 2005-01-26 18:30:00 | SPY | ETF | 117.25 | 117.27 | 117.22 | 117.22 | 3500.0 |
| 2005-01-26 19:00:00 | SPY | ETF | 117.18 | 117.18 | 117.18 | 117.18 | 1000.0 |
| 2005-01-26 19:30:00 | SPY | ETF | 117.18 | 117.18 | 117.17 | 117.18 | 2000.0 |
| 2005-01-26 09:30:00 | QQQ | ETF | 36.96 | 37.04 | 36.83 | 36.97 | 9609600.0 |
| 2005-01-26 10:00:00 | QQQ | ETF | 36.96 | 37.09 | 36.96 | 37.0 | 10310700.0 |
| 2005-01-26 10:30:00 | QQQ | ETF | 37.0 | 37.01 | 36.89 | 36.96 | 7130800.0 |
| 2005-01-26 11:00:00 | QQQ | ETF | 36.95 | 37.09 | 36.87 | 36.88 | 7712500.0 |
| 2005-01-26 11:30:00 | QQQ | ETF | 36.88 | 36.94 | 36.82 | 36.89 | 7478300.0 |
| 2005-01-26 12:00:00 | QQQ | ETF | 36.89 | 36.97 | 36.87 | 36.87 | 3661300.0 |
| 2005-01-26 12:30:00 | QQQ | ETF | 36.88 | 36.94 | 36.86 | 36.89 | 2171800.0 |
| 2005-01-26 13:00:00 | QQQ | ETF | 36.88 | 37.01 | 36.85 | 36.99 | 3885500.0 |
| 2005-01-26 13:30:00 | QQQ | ETF | 36.99 | 37.06 | 36.96 | 37.03 | 3828700.0 |
| 2005-01-26 14:00:00 | QQQ | ETF | 37.03 | 37.08 | 37.01 | 37.05 | 5688600.0 |
| 2005-01-26 14:30:00 | QQQ | ETF | 37.04 | 37.06 | 37.02 | 37.06 | 3750900.0 |
| 2005-01-26 15:00:00 | QQQ | ETF | 37.06 | 37.2 | 37.0 | 37.17 | 8617100.0 |
| 2005-01-26 15:30:00 | QQQ | ETF | 37.17 | 37.29 | 37.15 | 37.16 | 19537500.0 |
| 2005-01-26 09:00:00 | IWM | ETF | 60.725 | 60.725 | 60.675 | 60.715 | 600.0 |
| 2005-01-26 09:30:00 | IWM | ETF | 60.71 | 60.815 | 60.585 | 60.7 | 2040600.0 |
| 2005-01-26 10:00:00 | IWM | ETF | 60.7 | 60.955 | 60.7 | 60.815 | 1562400.0 |
| 2005-01-26 10:30:00 | IWM | ETF | 60.815 | 60.845 | 60.66 | 60.815 | 1718200.0 |
| 2005-01-26 11:00:00 | IWM | ETF | 60.8 | 60.915 | 60.635 | 60.655 | 711200.0 |
| 2005-01-26 11:30:00 | IWM | ETF | 60.63 | 60.73 | 60.56 | 60.66 | 1024600.0 |
| 2005-01-26 12:00:00 | IWM | ETF | 60.66 | 60.705 | 60.62 | 60.655 | 892600.0 |
| 2005-01-26 12:30:00 | IWM | ETF | 60.6505 | 60.775 | 60.64 | 60.68 | 299800.0 |
| 2005-01-26 13:00:00 | IWM | ETF | 60.68 | 60.825 | 60.675 | 60.77 | 693000.0 |
| 2005-01-26 13:30:00 | IWM | ETF | 60.78 | 61.105 | 60.75 | 61.085 | 1450000.0 |
| 2005-01-26 14:00:00 | IWM | ETF | 61.09 | 61.145 | 60.995 | 61.045 | 1040600.0 |
| 2005-01-26 14:30:00 | IWM | ETF | 61.045 | 61.12 | 61.02 | 61.1 | 878800.0 |
| 2005-01-26 15:00:00 | IWM | ETF | 61.105 | 61.25 | 60.925 | 61.19 | 1227600.0 |
> showing 50 of 1,413 rows — these rows as CSV