PREVIEW / etf_30min / 2004-05-21
file: by_date/etf_30min/2004/2004-05-21.parquet size: 34 KB rows: 1,113
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-05-21 09:00:00 | SPY | ETF | 110.05 | 110.13 | 109.87 | 109.98 | 135200.0 |
| 2004-05-21 09:30:00 | SPY | ETF | 109.97 | 110.11 | 109.81 | 109.86 | 5448600.0 |
| 2004-05-21 10:00:00 | SPY | ETF | 109.85 | 109.99 | 109.62 | 109.68 | 3142100.0 |
| 2004-05-21 10:30:00 | SPY | ETF | 109.69 | 110.2 | 109.64 | 110.2 | 4504600.0 |
| 2004-05-21 11:00:00 | SPY | ETF | 110.19 | 110.41 | 110.15 | 110.32 | 4245700.0 |
| 2004-05-21 11:30:00 | SPY | ETF | 110.32 | 110.55 | 110.25 | 110.32 | 4441100.0 |
| 2004-05-21 12:00:00 | SPY | ETF | 110.32 | 110.38 | 110.21 | 110.32 | 1935300.0 |
| 2004-05-21 12:30:00 | SPY | ETF | 110.3101 | 110.4 | 110.26 | 110.29 | 1041100.0 |
| 2004-05-21 13:00:00 | SPY | ETF | 110.3 | 110.35 | 110.12 | 110.2 | 2130000.0 |
| 2004-05-21 13:30:00 | SPY | ETF | 110.2 | 110.2 | 109.77 | 109.96 | 4972400.0 |
| 2004-05-21 14:00:00 | SPY | ETF | 109.97 | 109.99 | 109.72 | 109.91 | 1786300.0 |
| 2004-05-21 14:30:00 | SPY | ETF | 109.91 | 110.03 | 109.47 | 109.63 | 2571300.0 |
| 2004-05-21 15:00:00 | SPY | ETF | 109.63 | 109.84 | 109.47 | 109.74 | 2173200.0 |
| 2004-05-21 15:30:00 | SPY | ETF | 109.75 | 109.95 | 109.62 | 109.93 | 3582000.0 |
| 2004-05-21 16:00:00 | SPY | ETF | 109.94 | 109.98 | 109.69 | 109.7 | 2147900.0 |
| 2004-05-21 16:30:00 | SPY | ETF | 109.7 | 109.75 | 109.69 | 109.75 | 52200.0 |
| 2004-05-21 17:00:00 | SPY | ETF | 109.74 | 109.8 | 109.7 | 109.73 | 4300.0 |
| 2004-05-21 17:30:00 | SPY | ETF | 109.8 | 109.9 | 109.8 | 109.87 | 3200.0 |
| 2004-05-21 18:00:00 | SPY | ETF | 109.85 | 109.9 | 109.85 | 109.9 | 3000.0 |
| 2004-05-21 19:30:00 | SPY | ETF | 109.94 | 109.94 | 109.94 | 109.94 | 4400.0 |
| 2004-05-21 09:00:00 | QQQ | ETF | 35.05 | 35.1 | 34.98 | 35.02 | 1613900.0 |
| 2004-05-21 09:30:00 | QQQ | ETF | 35.01 | 35.061 | 34.877 | 34.92 | 15238800.0 |
| 2004-05-21 10:00:00 | QQQ | ETF | 34.919 | 34.98 | 34.78 | 34.78 | 12996600.0 |
| 2004-05-21 10:30:00 | QQQ | ETF | 34.784 | 35.03 | 34.78 | 34.96 | 12587000.0 |
| 2004-05-21 11:00:00 | QQQ | ETF | 34.96 | 35.031 | 34.95 | 35.029 | 11848900.0 |
| 2004-05-21 11:30:00 | QQQ | ETF | 35.029 | 35.17 | 35.0 | 35.07 | 8005400.0 |
| 2004-05-21 12:00:00 | QQQ | ETF | 35.069 | 35.09 | 35.01 | 35.05 | 5386500.0 |
| 2004-05-21 12:30:00 | QQQ | ETF | 35.05 | 35.09 | 35.03 | 35.04 | 1991600.0 |
| 2004-05-21 13:00:00 | QQQ | ETF | 35.04 | 35.05 | 34.94 | 34.98 | 2397500.0 |
| 2004-05-21 13:30:00 | QQQ | ETF | 34.974 | 34.977 | 34.85 | 34.92 | 5074000.0 |
| 2004-05-21 14:00:00 | QQQ | ETF | 34.92 | 34.93 | 34.809 | 34.858 | 5619100.0 |
| 2004-05-21 14:30:00 | QQQ | ETF | 34.858 | 34.91 | 34.74 | 34.78 | 6563500.0 |
| 2004-05-21 15:00:00 | QQQ | ETF | 34.776 | 34.89 | 34.738 | 34.86 | 6474900.0 |
| 2004-05-21 15:30:00 | QQQ | ETF | 34.86 | 35.01 | 34.82 | 35.0 | 7345200.0 |
| 2004-05-21 16:00:00 | QQQ | ETF | 35.008 | 35.04 | 34.95 | 35.0 | 2457100.0 |
| 2004-05-21 16:30:00 | QQQ | ETF | 35.0 | 35.03 | 34.99 | 34.99 | 179900.0 |
| 2004-05-21 17:00:00 | QQQ | ETF | 34.99 | 35.02 | 34.98 | 34.99 | 41200.0 |
| 2004-05-21 17:30:00 | QQQ | ETF | 34.99 | 35.04 | 34.98 | 35.04 | 114700.0 |
| 2004-05-21 18:00:00 | QQQ | ETF | 35.02 | 35.02 | 34.99 | 35.02 | 43000.0 |
| 2004-05-21 18:30:00 | QQQ | ETF | 35.03 | 35.05 | 35.02 | 35.02 | 4500.0 |
| 2004-05-21 19:00:00 | QQQ | ETF | 35.03 | 35.03 | 35.03 | 35.03 | 1000.0 |
| 2004-05-21 19:30:00 | QQQ | ETF | 35.02 | 35.03 | 35.0 | 35.03 | 6200.0 |
| 2004-05-21 09:00:00 | IWM | ETF | 54.2 | 54.23 | 54.06 | 54.07 | 6000.0 |
| 2004-05-21 09:30:00 | IWM | ETF | 54.075 | 54.3 | 54.03 | 54.165 | 855000.0 |
| 2004-05-21 10:00:00 | IWM | ETF | 54.165 | 54.2 | 53.93 | 53.95 | 1064000.0 |
| 2004-05-21 10:30:00 | IWM | ETF | 53.95 | 54.395 | 53.95 | 54.395 | 532600.0 |
| 2004-05-21 11:00:00 | IWM | ETF | 54.395 | 54.48 | 54.375 | 54.44 | 693400.0 |
| 2004-05-21 11:30:00 | IWM | ETF | 54.46 | 54.595 | 54.405 | 54.435 | 2311400.0 |
| 2004-05-21 12:00:00 | IWM | ETF | 54.46 | 54.475 | 54.375 | 54.455 | 575400.0 |
| 2004-05-21 12:30:00 | IWM | ETF | 54.44 | 54.465 | 54.38 | 54.39 | 296200.0 |
> showing 50 of 1,113 rows — these rows as CSV