PREVIEW / etf_30min / 2004-01-27
file: by_date/etf_30min/2004/2004-01-27.parquet size: 35 KB rows: 1,151
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-01-27 08:00:00 | SPY | ETF | 115.73 | 115.73 | 115.7 | 115.72 | 1600.0 |
| 2004-01-27 08:30:00 | SPY | ETF | 115.72 | 115.75 | 115.7 | 115.73 | 4300.0 |
| 2004-01-27 09:00:00 | SPY | ETF | 115.73 | 115.78 | 115.73 | 115.75 | 5000.0 |
| 2004-01-27 09:30:00 | SPY | ETF | 115.75 | 115.85 | 115.59 | 115.74 | 2262600.0 |
| 2004-01-27 10:00:00 | SPY | ETF | 115.73 | 115.85 | 115.55 | 115.74 | 3321500.0 |
| 2004-01-27 10:30:00 | SPY | ETF | 115.73 | 115.81 | 115.56 | 115.61 | 1759300.0 |
| 2004-01-27 11:00:00 | SPY | ETF | 115.58 | 115.67 | 115.31 | 115.36 | 2105400.0 |
| 2004-01-27 11:30:00 | SPY | ETF | 115.36 | 115.51 | 115.31 | 115.36 | 1544700.0 |
| 2004-01-27 12:00:00 | SPY | ETF | 115.25 | 115.27 | 115.06 | 115.13 | 1803100.0 |
| 2004-01-27 12:30:00 | SPY | ETF | 115.14 | 115.25 | 115.06 | 115.13 | 1793300.0 |
| 2004-01-27 13:00:00 | SPY | ETF | 115.15 | 115.19 | 114.75 | 114.85 | 1770500.0 |
| 2004-01-27 13:30:00 | SPY | ETF | 114.83 | 115.07 | 114.82 | 115.06 | 2363000.0 |
| 2004-01-27 14:00:00 | SPY | ETF | 115.04 | 115.07 | 114.79 | 114.98 | 1218700.0 |
| 2004-01-27 14:30:00 | SPY | ETF | 114.98 | 115.16 | 114.95 | 114.97 | 1843300.0 |
| 2004-01-27 15:00:00 | SPY | ETF | 114.97 | 115.1 | 114.77 | 114.9 | 2783800.0 |
| 2004-01-27 15:30:00 | SPY | ETF | 114.9 | 114.98 | 114.7 | 114.7 | 2460900.0 |
| 2004-01-27 16:00:00 | SPY | ETF | 114.73 | 114.77 | 114.61 | 114.66 | 2246900.0 |
| 2004-01-27 16:30:00 | SPY | ETF | 114.66 | 114.69 | 114.61 | 114.62 | 233100.0 |
| 2004-01-27 17:00:00 | SPY | ETF | 114.61 | 114.72 | 114.61 | 114.69 | 35000.0 |
| 2004-01-27 17:30:00 | SPY | ETF | 114.7 | 114.83 | 114.68 | 114.68 | 15600.0 |
| 2004-01-27 18:00:00 | SPY | ETF | 114.7 | 114.7 | 114.6 | 114.62 | 13700.0 |
| 2004-01-27 18:30:00 | SPY | ETF | 114.66 | 114.67 | 114.66 | 114.67 | 12500.0 |
| 2004-01-27 19:00:00 | SPY | ETF | 114.69 | 114.7 | 114.69 | 114.7 | 7800.0 |
| 2004-01-27 08:00:00 | QQQ | ETF | 38.57 | 38.57 | 38.52 | 38.54 | 25600.0 |
| 2004-01-27 08:30:00 | QQQ | ETF | 38.53 | 38.55 | 38.53 | 38.53 | 10500.0 |
| 2004-01-27 09:00:00 | QQQ | ETF | 38.53 | 38.54 | 38.51 | 38.51 | 83900.0 |
| 2004-01-27 09:30:00 | QQQ | ETF | 38.51 | 38.59 | 38.44 | 38.519 | 7630800.0 |
| 2004-01-27 10:00:00 | QQQ | ETF | 38.531 | 38.63 | 38.41 | 38.49 | 10133600.0 |
| 2004-01-27 10:30:00 | QQQ | ETF | 38.49 | 38.53 | 38.35 | 38.35 | 6529700.0 |
| 2004-01-27 11:00:00 | QQQ | ETF | 38.352 | 38.39 | 38.13 | 38.15 | 6669400.0 |
| 2004-01-27 11:30:00 | QQQ | ETF | 38.15 | 38.25 | 38.12 | 38.15 | 5638700.0 |
| 2004-01-27 12:00:00 | QQQ | ETF | 38.1 | 38.11 | 37.87 | 37.9 | 9869600.0 |
| 2004-01-27 12:30:00 | QQQ | ETF | 37.9 | 38.04 | 37.89 | 37.99 | 4040600.0 |
| 2004-01-27 13:00:00 | QQQ | ETF | 37.99 | 38.01 | 37.83 | 37.886 | 4247000.0 |
| 2004-01-27 13:30:00 | QQQ | ETF | 37.888 | 38.01 | 37.86 | 38.0 | 4492400.0 |
| 2004-01-27 14:00:00 | QQQ | ETF | 38.005 | 38.02 | 37.85 | 37.95 | 5083000.0 |
| 2004-01-27 14:30:00 | QQQ | ETF | 37.961 | 38.04 | 37.89 | 37.9 | 4369000.0 |
| 2004-01-27 15:00:00 | QQQ | ETF | 37.906 | 37.97 | 37.8 | 37.9 | 5268600.0 |
| 2004-01-27 15:30:00 | QQQ | ETF | 37.904 | 37.92 | 37.76 | 37.79 | 8538000.0 |
| 2004-01-27 16:00:00 | QQQ | ETF | 37.79 | 37.86 | 37.7 | 37.738 | 5297900.0 |
| 2004-01-27 16:30:00 | QQQ | ETF | 37.721 | 37.77 | 37.69 | 37.73 | 1026500.0 |
| 2004-01-27 17:00:00 | QQQ | ETF | 37.729 | 37.83 | 37.72 | 37.8 | 2102500.0 |
| 2004-01-27 17:30:00 | QQQ | ETF | 37.79 | 37.81 | 37.74 | 37.74 | 118700.0 |
| 2004-01-27 18:00:00 | QQQ | ETF | 37.75 | 37.78 | 37.73 | 37.75 | 44000.0 |
| 2004-01-27 18:30:00 | QQQ | ETF | 37.78 | 37.78 | 37.77 | 37.77 | 8400.0 |
| 2004-01-27 19:00:00 | QQQ | ETF | 37.77 | 37.81 | 37.77 | 37.81 | 15500.0 |
| 2004-01-27 19:30:00 | QQQ | ETF | 37.79 | 37.81 | 37.78 | 37.79 | 7100.0 |
| 2004-01-27 09:30:00 | IWM | ETF | 59.91 | 59.95 | 59.625 | 59.805 | 466200.0 |
| 2004-01-27 10:00:00 | IWM | ETF | 59.775 | 59.875 | 59.645 | 59.755 | 530800.0 |
| 2004-01-27 10:30:00 | IWM | ETF | 59.785 | 59.825 | 59.675 | 59.695 | 119800.0 |
> showing 50 of 1,151 rows — these rows as CSV