PREVIEW / etf_30min / 2003-11-24
file: by_date/etf_30min/2003/2003-11-24.parquet size: 27 KB rows: 862
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-24 08:00:00 | SPY | ETF | 104.76 | 104.8 | 104.71 | 104.76 | 20900.0 |
| 2003-11-24 08:30:00 | SPY | ETF | 104.8 | 104.83 | 104.75 | 104.75 | 20100.0 |
| 2003-11-24 09:00:00 | SPY | ETF | 104.76 | 104.76 | 104.65 | 104.65 | 27000.0 |
| 2003-11-24 09:30:00 | SPY | ETF | 104.69 | 105.04 | 104.68 | 104.97 | 3904800.0 |
| 2003-11-24 10:00:00 | SPY | ETF | 104.97 | 105.43 | 104.92 | 105.38 | 3376300.0 |
| 2003-11-24 10:30:00 | SPY | ETF | 105.39 | 105.47 | 105.24 | 105.42 | 2224900.0 |
| 2003-11-24 11:00:00 | SPY | ETF | 105.41 | 105.54 | 105.28 | 105.3 | 2323000.0 |
| 2003-11-24 11:30:00 | SPY | ETF | 105.29 | 105.45 | 105.28 | 105.43 | 703400.0 |
| 2003-11-24 12:00:00 | SPY | ETF | 105.43 | 105.44 | 105.26 | 105.4 | 524300.0 |
| 2003-11-24 12:30:00 | SPY | ETF | 105.4 | 105.45 | 105.32 | 105.36 | 521100.0 |
| 2003-11-24 13:00:00 | SPY | ETF | 105.36 | 105.5 | 105.24 | 105.26 | 935300.0 |
| 2003-11-24 13:30:00 | SPY | ETF | 105.26 | 105.48 | 105.25 | 105.39 | 858400.0 |
| 2003-11-24 14:00:00 | SPY | ETF | 105.39 | 105.54 | 105.33 | 105.49 | 1056400.0 |
| 2003-11-24 14:30:00 | SPY | ETF | 105.49 | 105.56 | 105.4 | 105.48 | 1198700.0 |
| 2003-11-24 15:00:00 | SPY | ETF | 105.49 | 105.7 | 105.45 | 105.6 | 2212500.0 |
| 2003-11-24 15:30:00 | SPY | ETF | 105.61 | 105.77 | 105.56 | 105.73 | 3520200.0 |
| 2003-11-24 16:00:00 | SPY | ETF | 105.76 | 105.78 | 105.54 | 105.71 | 2369200.0 |
| 2003-11-24 16:30:00 | SPY | ETF | 105.61 | 105.62 | 105.56 | 105.59 | 98600.0 |
| 2003-11-24 17:00:00 | SPY | ETF | 105.59 | 105.6 | 105.57 | 105.6 | 14700.0 |
| 2003-11-24 17:30:00 | SPY | ETF | 105.63 | 105.64 | 105.6 | 105.6 | 55700.0 |
| 2003-11-24 18:00:00 | SPY | ETF | 105.6 | 105.63 | 105.6 | 105.63 | 2900.0 |
| 2003-11-24 18:30:00 | SPY | ETF | 105.67 | 105.67 | 105.6 | 105.6 | 1400.0 |
| 2003-11-24 19:00:00 | SPY | ETF | 105.67 | 105.67 | 105.67 | 105.67 | 4000.0 |
| 2003-11-24 19:30:00 | SPY | ETF | 105.65 | 105.65 | 105.65 | 105.65 | 2500.0 |
| 2003-11-24 08:00:00 | QQQ | ETF | 34.49 | 34.5 | 34.46 | 34.48 | 95900.0 |
| 2003-11-24 08:30:00 | QQQ | ETF | 34.48 | 34.51 | 34.48 | 34.5 | 80400.0 |
| 2003-11-24 09:00:00 | QQQ | ETF | 34.49 | 34.52 | 34.49 | 34.51 | 116400.0 |
| 2003-11-24 09:30:00 | QQQ | ETF | 34.52 | 34.66 | 34.47 | 34.585 | 11297300.0 |
| 2003-11-24 10:00:00 | QQQ | ETF | 34.57 | 34.82 | 34.56 | 34.79 | 8999800.0 |
| 2003-11-24 10:30:00 | QQQ | ETF | 34.782 | 34.87 | 34.71 | 34.87 | 7263100.0 |
| 2003-11-24 11:00:00 | QQQ | ETF | 34.87 | 34.941 | 34.81 | 34.846 | 8360000.0 |
| 2003-11-24 11:30:00 | QQQ | ETF | 34.84 | 34.9 | 34.83 | 34.89 | 2174300.0 |
| 2003-11-24 12:00:00 | QQQ | ETF | 34.89 | 34.921 | 34.8 | 34.89 | 2466200.0 |
| 2003-11-24 12:30:00 | QQQ | ETF | 34.89 | 34.89 | 34.82 | 34.87 | 982400.0 |
| 2003-11-24 13:00:00 | QQQ | ETF | 34.87 | 34.93 | 34.81 | 34.81 | 2548700.0 |
| 2003-11-24 13:30:00 | QQQ | ETF | 34.81 | 34.93 | 34.8 | 34.85 | 2779000.0 |
| 2003-11-24 14:00:00 | QQQ | ETF | 34.85 | 34.941 | 34.82 | 34.92 | 3296600.0 |
| 2003-11-24 14:30:00 | QQQ | ETF | 34.92 | 35.0 | 34.897 | 34.952 | 5410100.0 |
| 2003-11-24 15:00:00 | QQQ | ETF | 34.953 | 35.14 | 34.95 | 35.099 | 10458700.0 |
| 2003-11-24 15:30:00 | QQQ | ETF | 35.098 | 35.24 | 35.09 | 35.236 | 9709800.0 |
| 2003-11-24 16:00:00 | QQQ | ETF | 35.23 | 35.257 | 35.152 | 35.21 | 5090500.0 |
| 2003-11-24 16:30:00 | QQQ | ETF | 35.21 | 35.22 | 34.1554 | 35.18 | 1799000.0 |
| 2003-11-24 17:00:00 | QQQ | ETF | 35.19 | 35.2 | 35.15 | 35.2 | 95200.0 |
| 2003-11-24 17:30:00 | QQQ | ETF | 35.192 | 35.21 | 35.16 | 35.17 | 80900.0 |
| 2003-11-24 18:00:00 | QQQ | ETF | 35.18 | 35.23 | 35.18 | 35.22 | 33200.0 |
| 2003-11-24 18:30:00 | QQQ | ETF | 35.23 | 35.24 | 35.23 | 35.24 | 4100.0 |
| 2003-11-24 19:00:00 | QQQ | ETF | 35.23 | 35.24 | 35.23 | 35.24 | 9500.0 |
| 2003-11-24 19:30:00 | QQQ | ETF | 35.23 | 35.23 | 35.22 | 35.23 | 7300.0 |
| 2003-11-24 09:00:00 | IWM | ETF | 52.975 | 53.015 | 52.975 | 53.015 | 4200.0 |
| 2003-11-24 09:30:00 | IWM | ETF | 53.025 | 53.35 | 52.9 | 53.29 | 1434400.0 |
> showing 50 of 862 rows — these rows as CSV