PREVIEW / etf_30min / 2004-08-19
file: by_date/etf_30min/2004/2004-08-19.parquet size: 35 KB rows: 1,132
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-08-19 08:00:00 | SPY | ETF | 109.7 | 109.81 | 109.65 | 109.77 | 98100.0 |
| 2004-08-19 08:30:00 | SPY | ETF | 109.81 | 109.85 | 109.73 | 109.84 | 378100.0 |
| 2004-08-19 09:00:00 | SPY | ETF | 109.8 | 109.85 | 109.8 | 109.83 | 51700.0 |
| 2004-08-19 09:30:00 | SPY | ETF | 109.81 | 110.02 | 109.64 | 110.0 | 3624400.0 |
| 2004-08-19 10:00:00 | SPY | ETF | 110.01 | 110.01 | 109.57 | 109.57 | 4014000.0 |
| 2004-08-19 10:30:00 | SPY | ETF | 109.56 | 109.71 | 109.48 | 109.65 | 3772600.0 |
| 2004-08-19 11:00:00 | SPY | ETF | 109.64 | 109.89 | 109.61 | 109.89 | 2085600.0 |
| 2004-08-19 11:30:00 | SPY | ETF | 109.89 | 109.92 | 109.71 | 109.84 | 1641800.0 |
| 2004-08-19 12:00:00 | SPY | ETF | 109.84 | 109.9 | 109.72 | 109.85 | 1156300.0 |
| 2004-08-19 12:30:00 | SPY | ETF | 109.85 | 109.98 | 109.78 | 109.85 | 857400.0 |
| 2004-08-19 13:00:00 | SPY | ETF | 109.84 | 109.91 | 109.76 | 109.76 | 690600.0 |
| 2004-08-19 13:30:00 | SPY | ETF | 109.76 | 109.85 | 109.61 | 109.65 | 2003900.0 |
| 2004-08-19 14:00:00 | SPY | ETF | 109.65 | 109.66 | 109.26 | 109.32 | 3476300.0 |
| 2004-08-19 14:30:00 | SPY | ETF | 109.32 | 109.46 | 109.18 | 109.29 | 2785400.0 |
| 2004-08-19 15:00:00 | SPY | ETF | 109.29 | 109.61 | 109.19 | 109.58 | 3481900.0 |
| 2004-08-19 15:30:00 | SPY | ETF | 109.58 | 109.82 | 109.47 | 109.61 | 4668500.0 |
| 2004-08-19 16:00:00 | SPY | ETF | 109.6 | 109.89 | 109.58 | 109.75 | 3852200.0 |
| 2004-08-19 16:30:00 | SPY | ETF | 109.75 | 109.83 | 109.53 | 109.58 | 87000.0 |
| 2004-08-19 17:00:00 | SPY | ETF | 109.62 | 109.65 | 109.6 | 109.65 | 49200.0 |
| 2004-08-19 17:30:00 | SPY | ETF | 109.68 | 109.68 | 109.61 | 109.61 | 36900.0 |
| 2004-08-19 18:00:00 | SPY | ETF | 109.61 | 109.61 | 109.55 | 109.58 | 33100.0 |
| 2004-08-19 18:30:00 | SPY | ETF | 109.55 | 109.56 | 109.55 | 109.55 | 3600.0 |
| 2004-08-19 19:00:00 | SPY | ETF | 109.54 | 109.54 | 109.54 | 109.54 | 1000.0 |
| 2004-08-19 19:30:00 | SPY | ETF | 109.55 | 109.55 | 109.55 | 109.55 | 100.0 |
| 2004-08-19 08:00:00 | QQQ | ETF | 33.68 | 33.76 | 33.67 | 33.76 | 311400.0 |
| 2004-08-19 08:30:00 | QQQ | ETF | 33.75 | 33.76 | 33.68 | 33.75 | 239700.0 |
| 2004-08-19 09:00:00 | QQQ | ETF | 33.74 | 33.75 | 33.73 | 33.73 | 118700.0 |
| 2004-08-19 09:30:00 | QQQ | ETF | 33.73 | 33.85 | 33.6 | 33.809 | 13347900.0 |
| 2004-08-19 10:00:00 | QQQ | ETF | 33.809 | 33.81 | 33.63 | 33.642 | 9921700.0 |
| 2004-08-19 10:30:00 | QQQ | ETF | 33.64 | 33.7 | 33.55 | 33.67 | 8535400.0 |
| 2004-08-19 11:00:00 | QQQ | ETF | 33.67 | 33.78 | 33.639 | 33.77 | 6263500.0 |
| 2004-08-19 11:30:00 | QQQ | ETF | 33.76 | 33.826 | 33.66 | 33.72 | 6419200.0 |
| 2004-08-19 12:00:00 | QQQ | ETF | 33.71 | 33.777 | 33.672 | 33.73 | 5246000.0 |
| 2004-08-19 12:30:00 | QQQ | ETF | 33.74 | 33.8 | 33.72 | 33.73 | 6299200.0 |
| 2004-08-19 13:00:00 | QQQ | ETF | 33.74 | 33.76 | 33.68 | 33.7 | 1770000.0 |
| 2004-08-19 13:30:00 | QQQ | ETF | 33.699 | 33.72 | 33.63 | 33.63 | 5773900.0 |
| 2004-08-19 14:00:00 | QQQ | ETF | 33.64 | 33.65 | 33.47 | 33.51 | 9323300.0 |
| 2004-08-19 14:30:00 | QQQ | ETF | 33.509 | 33.551 | 33.42 | 33.51 | 7078200.0 |
| 2004-08-19 15:00:00 | QQQ | ETF | 33.51 | 33.63 | 33.44 | 33.61 | 6369700.0 |
| 2004-08-19 15:30:00 | QQQ | ETF | 33.61 | 33.75 | 33.55 | 33.63 | 10683000.0 |
| 2004-08-19 16:00:00 | QQQ | ETF | 33.63 | 33.703 | 33.62 | 33.69 | 2556700.0 |
| 2004-08-19 16:30:00 | QQQ | ETF | 33.681 | 33.681 | 33.643 | 33.65 | 322700.0 |
| 2004-08-19 17:00:00 | QQQ | ETF | 33.651 | 33.67 | 33.626 | 33.63 | 79700.0 |
| 2004-08-19 17:30:00 | QQQ | ETF | 33.63 | 33.65 | 33.6 | 33.62 | 2047600.0 |
| 2004-08-19 18:00:00 | QQQ | ETF | 33.62 | 33.62 | 33.6 | 33.6 | 31900.0 |
| 2004-08-19 19:00:00 | QQQ | ETF | 33.61 | 33.64 | 33.61 | 33.64 | 29000.0 |
| 2004-08-19 19:30:00 | QQQ | ETF | 33.62 | 33.65 | 33.61 | 33.63 | 13900.0 |
| 2004-08-19 08:00:00 | IWM | ETF | 53.87 | 53.88 | 53.825 | 53.88 | 62200.0 |
| 2004-08-19 08:30:00 | IWM | ETF | 53.88 | 53.88 | 53.8 | 53.8 | 4800.0 |
| 2004-08-19 09:00:00 | IWM | ETF | 53.865 | 53.865 | 53.805 | 53.82 | 4800.0 |
> showing 50 of 1,132 rows — these rows as CSV