PREVIEW / etf_30min / 2004-07-22
file: by_date/etf_30min/2004/2004-07-22.parquet size: 37 KB rows: 1,199
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-07-22 08:00:00 | SPY | ETF | 109.6 | 109.73 | 109.57 | 109.71 | 15100.0 |
| 2004-07-22 08:30:00 | SPY | ETF | 109.73 | 109.76 | 109.38 | 109.39 | 95300.0 |
| 2004-07-22 09:00:00 | SPY | ETF | 109.34 | 109.4 | 109.15 | 109.4 | 228700.0 |
| 2004-07-22 09:30:00 | SPY | ETF | 109.36 | 109.83 | 109.26 | 109.45 | 8982400.0 |
| 2004-07-22 10:00:00 | SPY | ETF | 109.45 | 109.66 | 109.18 | 109.36 | 7809100.0 |
| 2004-07-22 10:30:00 | SPY | ETF | 109.38 | 109.61 | 109.26 | 109.31 | 3627200.0 |
| 2004-07-22 11:00:00 | SPY | ETF | 109.33 | 109.43 | 108.93 | 109.04 | 6518000.0 |
| 2004-07-22 11:30:00 | SPY | ETF | 109.02 | 109.15 | 108.77 | 109.0 | 3784500.0 |
| 2004-07-22 12:00:00 | SPY | ETF | 109.0 | 109.6 | 108.95 | 109.49 | 4188400.0 |
| 2004-07-22 12:30:00 | SPY | ETF | 109.45 | 109.78 | 109.4 | 109.58 | 4376300.0 |
| 2004-07-22 13:00:00 | SPY | ETF | 109.59 | 109.68 | 109.28 | 109.32 | 1680700.0 |
| 2004-07-22 13:30:00 | SPY | ETF | 109.31 | 109.66 | 109.28 | 109.59 | 2044300.0 |
| 2004-07-22 14:00:00 | SPY | ETF | 109.59 | 110.13 | 109.55 | 109.91 | 7553600.0 |
| 2004-07-22 14:30:00 | SPY | ETF | 109.91 | 110.26 | 109.9 | 110.07 | 3404300.0 |
| 2004-07-22 15:00:00 | SPY | ETF | 110.09 | 110.34 | 109.92 | 110.22 | 3807300.0 |
| 2004-07-22 15:30:00 | SPY | ETF | 110.22 | 110.39 | 109.92 | 109.99 | 5876100.0 |
| 2004-07-22 16:00:00 | SPY | ETF | 110.01 | 110.08 | 109.47 | 109.5 | 2399200.0 |
| 2004-07-22 16:30:00 | SPY | ETF | 109.5 | 110.0 | 109.39 | 109.5 | 1044100.0 |
| 2004-07-22 17:00:00 | SPY | ETF | 109.5 | 109.74 | 109.5 | 109.74 | 431900.0 |
| 2004-07-22 17:30:00 | SPY | ETF | 109.75 | 109.8 | 109.7 | 109.75 | 59700.0 |
| 2004-07-22 18:00:00 | SPY | ETF | 109.75 | 109.8 | 109.72 | 109.72 | 121800.0 |
| 2004-07-22 19:00:00 | SPY | ETF | 109.75 | 109.75 | 109.74 | 109.74 | 500.0 |
| 2004-07-22 19:30:00 | SPY | ETF | 109.74 | 109.74 | 109.74 | 109.74 | 6500.0 |
| 2004-07-22 08:00:00 | QQQ | ETF | 34.47 | 34.52 | 34.39 | 34.52 | 81600.0 |
| 2004-07-22 08:30:00 | QQQ | ETF | 34.5 | 34.54 | 34.39 | 34.39 | 335800.0 |
| 2004-07-22 09:00:00 | QQQ | ETF | 34.39 | 34.46 | 34.32 | 34.46 | 410100.0 |
| 2004-07-22 09:30:00 | QQQ | ETF | 34.48 | 34.7 | 34.399 | 34.53 | 18636200.0 |
| 2004-07-22 10:00:00 | QQQ | ETF | 34.53 | 34.64 | 34.42 | 34.52 | 11965800.0 |
| 2004-07-22 10:30:00 | QQQ | ETF | 34.506 | 34.61 | 34.46 | 34.5 | 5825000.0 |
| 2004-07-22 11:00:00 | QQQ | ETF | 34.5 | 34.52 | 34.28 | 34.362 | 11064200.0 |
| 2004-07-22 11:30:00 | QQQ | ETF | 34.36 | 34.44 | 34.25 | 34.382 | 6622200.0 |
| 2004-07-22 12:00:00 | QQQ | ETF | 34.38 | 34.65 | 34.36 | 34.58 | 8529400.0 |
| 2004-07-22 12:30:00 | QQQ | ETF | 34.58 | 34.72 | 34.55 | 34.61 | 7221500.0 |
| 2004-07-22 13:00:00 | QQQ | ETF | 34.604 | 34.65 | 34.45 | 34.48 | 4274000.0 |
| 2004-07-22 13:30:00 | QQQ | ETF | 34.472 | 34.65 | 34.448 | 34.6 | 4569600.0 |
| 2004-07-22 14:00:00 | QQQ | ETF | 34.6 | 34.88 | 34.59 | 34.84 | 10902900.0 |
| 2004-07-22 14:30:00 | QQQ | ETF | 34.84 | 34.99 | 34.83 | 34.92 | 8390600.0 |
| 2004-07-22 15:00:00 | QQQ | ETF | 34.91 | 35.04 | 34.83 | 34.99 | 7294300.0 |
| 2004-07-22 15:30:00 | QQQ | ETF | 34.99 | 35.1 | 34.88 | 34.96 | 12854000.0 |
| 2004-07-22 16:00:00 | QQQ | ETF | 34.97 | 35.03 | 34.57 | 34.65 | 3521600.0 |
| 2004-07-22 16:30:00 | QQQ | ETF | 34.65 | 34.69 | 34.48 | 34.543 | 4180500.0 |
| 2004-07-22 17:00:00 | QQQ | ETF | 34.54 | 34.7 | 34.52 | 34.7 | 1625300.0 |
| 2004-07-22 17:30:00 | QQQ | ETF | 34.69 | 34.81 | 34.65 | 34.75 | 702400.0 |
| 2004-07-22 18:00:00 | QQQ | ETF | 34.75 | 34.75 | 34.7 | 34.71 | 217000.0 |
| 2004-07-22 18:30:00 | QQQ | ETF | 34.73 | 34.73 | 34.71 | 34.72 | 3100.0 |
| 2004-07-22 19:00:00 | QQQ | ETF | 34.71 | 34.71 | 34.71 | 34.71 | 200.0 |
| 2004-07-22 19:30:00 | QQQ | ETF | 34.76 | 34.79 | 34.7 | 34.7 | 3000.0 |
| 2004-07-22 08:00:00 | IWM | ETF | 54.605 | 54.65 | 54.585 | 54.65 | 61800.0 |
| 2004-07-22 08:30:00 | IWM | ETF | 54.68 | 54.68 | 54.48 | 54.515 | 14000.0 |
| 2004-07-22 09:00:00 | IWM | ETF | 54.435 | 54.51 | 54.4 | 54.5 | 73400.0 |
> showing 50 of 1,199 rows — these rows as CSV