PREVIEW / etf_30min / 2005-06-09
file: by_date/etf_30min/2005/2005-06-09.parquet size: 44 KB rows: 1,524
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-09 07:00:00 | SPY | ETF | 119.68 | 119.68 | 119.68 | 119.68 | 100.0 |
| 2005-06-09 07:30:00 | SPY | ETF | 119.88 | 119.88 | 119.82 | 119.85 | 3500.0 |
| 2005-06-09 08:00:00 | SPY | ETF | 119.83 | 119.96 | 119.83 | 119.91 | 37500.0 |
| 2005-06-09 08:30:00 | SPY | ETF | 119.92 | 119.95 | 119.8 | 119.8 | 68000.0 |
| 2005-06-09 09:00:00 | SPY | ETF | 119.8 | 119.8 | 119.68 | 119.75 | 59900.0 |
| 2005-06-09 09:30:00 | SPY | ETF | 119.74 | 119.8 | 119.54 | 119.69 | 5596600.0 |
| 2005-06-09 10:00:00 | SPY | ETF | 119.71 | 120.0 | 119.5 | 119.63 | 11429500.0 |
| 2005-06-09 10:30:00 | SPY | ETF | 119.65 | 119.96 | 119.44 | 119.78 | 5126200.0 |
| 2005-06-09 11:00:00 | SPY | ETF | 119.75 | 119.91 | 119.62 | 119.67 | 3535300.0 |
| 2005-06-09 11:30:00 | SPY | ETF | 119.64 | 120.25 | 119.64 | 120.15 | 7049100.0 |
| 2005-06-09 12:00:00 | SPY | ETF | 120.16 | 120.58 | 120.15 | 120.52 | 3141900.0 |
| 2005-06-09 12:30:00 | SPY | ETF | 120.53 | 120.57 | 120.35 | 120.42 | 3542300.0 |
| 2005-06-09 13:00:00 | SPY | ETF | 120.42 | 120.46 | 120.07 | 120.17 | 2891400.0 |
| 2005-06-09 13:30:00 | SPY | ETF | 120.17 | 120.37 | 120.11 | 120.29 | 2068100.0 |
| 2005-06-09 14:00:00 | SPY | ETF | 120.28 | 120.35 | 120.05 | 120.11 | 1975100.0 |
| 2005-06-09 14:30:00 | SPY | ETF | 120.12 | 120.37 | 119.99 | 120.32 | 2653500.0 |
| 2005-06-09 15:00:00 | SPY | ETF | 120.32 | 120.51 | 120.26 | 120.28 | 2183400.0 |
| 2005-06-09 15:30:00 | SPY | ETF | 120.29 | 120.52 | 120.28 | 120.49 | 2955700.0 |
| 2005-06-09 16:00:00 | SPY | ETF | 120.49 | 120.5 | 120.4 | 120.42 | 939100.0 |
| 2005-06-09 16:30:00 | SPY | ETF | 120.43 | 120.43 | 120.31 | 120.4 | 589200.0 |
| 2005-06-09 17:00:00 | SPY | ETF | 120.4 | 120.45 | 120.4 | 120.45 | 202600.0 |
| 2005-06-09 17:30:00 | SPY | ETF | 120.46 | 120.47 | 120.43 | 120.47 | 1000.0 |
| 2005-06-09 18:00:00 | SPY | ETF | 120.45 | 120.48 | 120.42 | 120.42 | 4000.0 |
| 2005-06-09 18:30:00 | SPY | ETF | 120.45 | 120.45 | 120.45 | 120.45 | 300.0 |
| 2005-06-09 19:00:00 | SPY | ETF | 120.42 | 120.42 | 120.42 | 120.42 | 800.0 |
| 2005-06-09 19:30:00 | SPY | ETF | 120.42 | 120.42 | 120.4 | 120.42 | 3700.0 |
| 2005-06-09 09:30:00 | QQQ | ETF | 37.66 | 37.7 | 37.61 | 37.65 | 7775500.0 |
| 2005-06-09 10:00:00 | QQQ | ETF | 37.65 | 37.72 | 37.59 | 37.63 | 13319000.0 |
| 2005-06-09 10:30:00 | QQQ | ETF | 37.63 | 37.64 | 37.5 | 37.62 | 8932600.0 |
| 2005-06-09 11:00:00 | QQQ | ETF | 37.62 | 37.69 | 37.55 | 37.57 | 4748800.0 |
| 2005-06-09 11:30:00 | QQQ | ETF | 37.57 | 37.74 | 37.56 | 37.74 | 5832500.0 |
| 2005-06-09 12:00:00 | QQQ | ETF | 37.74 | 38.06 | 37.73 | 38.0 | 13792600.0 |
| 2005-06-09 12:30:00 | QQQ | ETF | 38.0 | 38.06 | 37.95 | 37.98 | 7686400.0 |
| 2005-06-09 13:00:00 | QQQ | ETF | 37.97 | 37.97 | 37.81 | 37.86 | 6459600.0 |
| 2005-06-09 13:30:00 | QQQ | ETF | 37.86 | 37.92 | 37.85 | 37.9 | 2805800.0 |
| 2005-06-09 14:00:00 | QQQ | ETF | 37.9 | 37.92 | 37.8 | 37.82 | 2854600.0 |
| 2005-06-09 14:30:00 | QQQ | ETF | 37.82 | 37.94 | 37.55 | 37.88 | 5496800.0 |
| 2005-06-09 15:00:00 | QQQ | ETF | 37.88 | 37.97 | 37.86 | 37.91 | 4070900.0 |
| 2005-06-09 15:30:00 | QQQ | ETF | 37.9 | 37.98 | 37.9 | 37.96 | 6084100.0 |
| 2005-06-09 08:30:00 | IWM | ETF | 61.77 | 61.77 | 61.72 | 61.72 | 26500.0 |
| 2005-06-09 09:00:00 | IWM | ETF | 61.7 | 61.7 | 61.56 | 61.61 | 58000.0 |
| 2005-06-09 09:30:00 | IWM | ETF | 61.67 | 61.68 | 61.41 | 61.49 | 1496400.0 |
| 2005-06-09 10:00:00 | IWM | ETF | 61.49 | 61.71 | 61.36 | 61.54 | 3321700.0 |
| 2005-06-09 10:30:00 | IWM | ETF | 61.53 | 61.64 | 61.4 | 61.62 | 804200.0 |
| 2005-06-09 11:00:00 | IWM | ETF | 61.62 | 61.68 | 61.55 | 61.55 | 1192400.0 |
| 2005-06-09 11:30:00 | IWM | ETF | 61.56 | 61.9 | 61.55 | 61.86 | 2329200.0 |
| 2005-06-09 12:00:00 | IWM | ETF | 61.87 | 62.13 | 61.87 | 62.11 | 2110300.0 |
| 2005-06-09 12:30:00 | IWM | ETF | 62.12 | 62.27 | 62.12 | 62.22 | 1960300.0 |
| 2005-06-09 13:00:00 | IWM | ETF | 62.22 | 62.23 | 61.99 | 62.03 | 913900.0 |
| 2005-06-09 13:30:00 | IWM | ETF | 62.03 | 62.2 | 62.01 | 62.15 | 608900.0 |
> showing 50 of 1,524 rows — these rows as CSV