PREVIEW / etf_30min / 2006-01-26
file: by_date/etf_30min/2006/2006-01-26.parquet size: 60 KB rows: 2,195
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 |
|---|---|---|---|---|---|---|---|
| 2006-01-26 04:00:00 | SPY | ETF | 127.29 | 127.29 | 127.29 | 127.29 | 10500.0 |
| 2006-01-26 04:30:00 | SPY | ETF | 127.39 | 127.46 | 127.39 | 127.46 | 10200.0 |
| 2006-01-26 06:00:00 | SPY | ETF | 127.4 | 127.4 | 127.31 | 127.31 | 102000.0 |
| 2006-01-26 06:30:00 | SPY | ETF | 127.31 | 127.31 | 127.26 | 127.31 | 79500.0 |
| 2006-01-26 07:00:00 | SPY | ETF | 127.3 | 127.39 | 127.3 | 127.39 | 45200.0 |
| 2006-01-26 07:30:00 | SPY | ETF | 127.39 | 127.48 | 127.39 | 127.44 | 305200.0 |
| 2006-01-26 08:00:00 | SPY | ETF | 127.4 | 127.49 | 127.29 | 127.35 | 2001600.0 |
| 2006-01-26 08:30:00 | SPY | ETF | 127.35 | 127.4 | 127.2 | 127.26 | 1064400.0 |
| 2006-01-26 09:00:00 | SPY | ETF | 127.29 | 127.35 | 127.26 | 127.28 | 846800.0 |
| 2006-01-26 09:30:00 | SPY | ETF | 127.28 | 127.31 | 126.99 | 127.14 | 7640700.0 |
| 2006-01-26 10:00:00 | SPY | ETF | 127.14 | 127.28 | 126.86 | 126.9 | 4810200.0 |
| 2006-01-26 10:30:00 | SPY | ETF | 126.9 | 127.15 | 126.76 | 127.12 | 5896700.0 |
| 2006-01-26 11:00:00 | SPY | ETF | 127.12 | 127.18 | 126.94 | 127.09 | 3272500.0 |
| 2006-01-26 11:30:00 | SPY | ETF | 127.12 | 127.54 | 127.09 | 127.46 | 7130300.0 |
| 2006-01-26 12:00:00 | SPY | ETF | 127.46 | 127.67 | 127.41 | 127.45 | 5042700.0 |
| 2006-01-26 12:30:00 | SPY | ETF | 127.44 | 127.47 | 127.16 | 127.18 | 3389300.0 |
| 2006-01-26 13:00:00 | SPY | ETF | 127.18 | 127.36 | 127.1 | 127.11 | 2127000.0 |
| 2006-01-26 13:30:00 | SPY | ETF | 127.11 | 127.23 | 126.98 | 127.16 | 2717900.0 |
| 2006-01-26 14:00:00 | SPY | ETF | 127.16 | 127.29 | 127.07 | 127.15 | 2705800.0 |
| 2006-01-26 14:30:00 | SPY | ETF | 127.14 | 127.52 | 127.09 | 127.4 | 4231400.0 |
| 2006-01-26 15:00:00 | SPY | ETF | 127.41 | 127.58 | 127.35 | 127.47 | 5291700.0 |
| 2006-01-26 15:30:00 | SPY | ETF | 127.48 | 127.52 | 127.23 | 127.4 | 4938100.0 |
| 2006-01-26 16:00:00 | SPY | ETF | 127.4 | 127.55 | 127.27 | 127.44 | 761900.0 |
| 2006-01-26 16:30:00 | SPY | ETF | 127.43 | 127.44 | 127.33 | 127.44 | 149200.0 |
| 2006-01-26 17:00:00 | SPY | ETF | 127.4 | 127.51 | 127.37 | 127.5 | 43300.0 |
| 2006-01-26 17:30:00 | SPY | ETF | 127.5 | 127.58 | 127.4 | 127.52 | 1838800.0 |
| 2006-01-26 18:00:00 | SPY | ETF | 127.52 | 127.58 | 127.52 | 127.56 | 62900.0 |
| 2006-01-26 18:30:00 | SPY | ETF | 127.56 | 127.6 | 127.56 | 127.6 | 8300.0 |
| 2006-01-26 19:00:00 | SPY | ETF | 127.62 | 127.65 | 127.62 | 127.63 | 4400.0 |
| 2006-01-26 19:30:00 | SPY | ETF | 127.62 | 127.62 | 127.62 | 127.62 | 1000.0 |
| 2006-01-26 09:30:00 | QQQ | ETF | 41.52 | 41.57 | 41.41 | 41.48 | 12390800.0 |
| 2006-01-26 10:00:00 | QQQ | ETF | 41.49 | 41.55 | 41.3 | 41.31 | 7355400.0 |
| 2006-01-26 10:30:00 | QQQ | ETF | 41.3 | 41.47 | 41.23 | 41.45 | 9091200.0 |
| 2006-01-26 11:00:00 | QQQ | ETF | 41.45 | 41.48 | 41.36 | 41.41 | 4699400.0 |
| 2006-01-26 11:30:00 | QQQ | ETF | 41.4 | 41.65 | 41.39 | 41.61 | 11770400.0 |
| 2006-01-26 12:00:00 | QQQ | ETF | 41.61 | 41.69 | 41.53 | 41.56 | 7506500.0 |
| 2006-01-26 12:30:00 | QQQ | ETF | 41.57 | 41.58 | 41.42 | 41.45 | 4829400.0 |
| 2006-01-26 13:00:00 | QQQ | ETF | 41.44 | 41.5 | 41.38 | 41.39 | 4230900.0 |
| 2006-01-26 13:30:00 | QQQ | ETF | 41.38 | 41.42 | 41.31 | 41.36 | 6487500.0 |
| 2006-01-26 14:00:00 | QQQ | ETF | 41.37 | 41.45 | 41.34 | 41.4 | 3683600.0 |
| 2006-01-26 14:30:00 | QQQ | ETF | 41.4 | 41.57 | 41.39 | 41.5 | 6076600.0 |
| 2006-01-26 15:00:00 | QQQ | ETF | 41.5 | 41.62 | 41.49 | 41.6 | 5178000.0 |
| 2006-01-26 15:30:00 | QQQ | ETF | 41.6 | 41.63 | 41.46 | 41.57 | 9129800.0 |
| 2006-01-26 07:00:00 | IWM | ETF | 71.64 | 71.66 | 71.64 | 71.66 | 13000.0 |
| 2006-01-26 07:30:00 | IWM | ETF | 71.69 | 71.78 | 71.69 | 71.78 | 19600.0 |
| 2006-01-26 08:00:00 | IWM | ETF | 71.76 | 71.78 | 71.65 | 71.7 | 23500.0 |
| 2006-01-26 08:30:00 | IWM | ETF | 71.65 | 71.67 | 71.58 | 71.6 | 21000.0 |
| 2006-01-26 09:00:00 | IWM | ETF | 71.62 | 71.66 | 71.58 | 71.6 | 46300.0 |
| 2006-01-26 09:30:00 | IWM | ETF | 71.62 | 71.73 | 71.51 | 71.6 | 3984600.0 |
| 2006-01-26 10:00:00 | IWM | ETF | 71.58 | 71.64 | 71.44 | 71.47 | 2644600.0 |
> showing 50 of 2,195 rows — these rows as CSV