PREVIEW / etf_30min / 2004-10-18
file: by_date/etf_30min/2004/2004-10-18.parquet size: 37 KB rows: 1,229
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-10-18 08:00:00 | SPY | ETF | 110.89 | 110.93 | 110.89 | 110.93 | 13000.0 |
| 2004-10-18 08:30:00 | SPY | ETF | 110.91 | 110.91 | 110.82 | 110.88 | 69800.0 |
| 2004-10-18 09:00:00 | SPY | ETF | 110.89 | 110.9 | 110.81 | 110.9 | 82100.0 |
| 2004-10-18 09:30:00 | SPY | ETF | 110.89 | 111.15 | 110.89 | 111.15 | 3851500.0 |
| 2004-10-18 10:00:00 | SPY | ETF | 111.16 | 111.25 | 111.0 | 111.05 | 3342000.0 |
| 2004-10-18 10:30:00 | SPY | ETF | 111.06 | 111.19 | 110.75 | 110.77 | 3335800.0 |
| 2004-10-18 11:00:00 | SPY | ETF | 110.78 | 111.01 | 110.7 | 110.96 | 2045800.0 |
| 2004-10-18 11:30:00 | SPY | ETF | 110.96 | 111.21 | 110.95 | 111.15 | 1800800.0 |
| 2004-10-18 12:00:00 | SPY | ETF | 111.14 | 111.8 | 111.14 | 111.71 | 6035000.0 |
| 2004-10-18 12:30:00 | SPY | ETF | 111.71 | 111.8 | 111.57 | 111.59 | 2793700.0 |
| 2004-10-18 13:00:00 | SPY | ETF | 111.58 | 111.83 | 111.58 | 111.82 | 1187900.0 |
| 2004-10-18 13:30:00 | SPY | ETF | 111.82 | 111.86 | 111.41 | 111.54 | 2436200.0 |
| 2004-10-18 14:00:00 | SPY | ETF | 111.54 | 111.59 | 111.43 | 111.56 | 1389700.0 |
| 2004-10-18 14:30:00 | SPY | ETF | 111.54 | 111.81 | 111.41 | 111.74 | 1552400.0 |
| 2004-10-18 15:00:00 | SPY | ETF | 111.75 | 111.86 | 111.53 | 111.8 | 2081700.0 |
| 2004-10-18 15:30:00 | SPY | ETF | 111.82 | 111.86 | 111.6 | 111.8 | 2440500.0 |
| 2004-10-18 16:00:00 | SPY | ETF | 111.8 | 111.9 | 111.4 | 111.75 | 1607500.0 |
| 2004-10-18 16:30:00 | SPY | ETF | 111.75 | 111.9 | 111.69 | 111.87 | 255400.0 |
| 2004-10-18 17:00:00 | SPY | ETF | 111.87 | 111.92 | 111.83 | 111.87 | 244800.0 |
| 2004-10-18 17:30:00 | SPY | ETF | 111.93 | 111.95 | 111.92 | 111.92 | 5700.0 |
| 2004-10-18 18:00:00 | SPY | ETF | 111.92 | 111.92 | 111.83 | 111.83 | 151200.0 |
| 2004-10-18 18:30:00 | SPY | ETF | 111.86 | 111.86 | 111.86 | 111.86 | 500.0 |
| 2004-10-18 19:00:00 | SPY | ETF | 111.86 | 111.86 | 111.86 | 111.86 | 6200.0 |
| 2004-10-18 19:30:00 | SPY | ETF | 111.92 | 111.92 | 111.86 | 111.9 | 700.0 |
| 2004-10-18 08:00:00 | QQQ | ETF | 35.5 | 35.54 | 35.48 | 35.5 | 54200.0 |
| 2004-10-18 08:30:00 | QQQ | ETF | 35.51 | 35.51 | 35.45 | 35.49 | 70700.0 |
| 2004-10-18 09:00:00 | QQQ | ETF | 35.49 | 35.51 | 35.46 | 35.5 | 330400.0 |
| 2004-10-18 09:30:00 | QQQ | ETF | 35.51 | 35.622 | 35.45 | 35.62 | 12285500.0 |
| 2004-10-18 10:00:00 | QQQ | ETF | 35.618 | 35.7 | 35.51 | 35.555 | 9980700.0 |
| 2004-10-18 10:30:00 | QQQ | ETF | 35.56 | 35.64 | 35.43 | 35.49 | 6133400.0 |
| 2004-10-18 11:00:00 | QQQ | ETF | 35.48 | 35.59 | 35.41 | 35.575 | 5508400.0 |
| 2004-10-18 11:30:00 | QQQ | ETF | 35.58 | 35.747 | 35.57 | 35.73 | 6520800.0 |
| 2004-10-18 12:00:00 | QQQ | ETF | 35.734 | 36.07 | 35.71 | 36.02 | 11606600.0 |
| 2004-10-18 12:30:00 | QQQ | ETF | 36.032 | 36.1 | 35.97 | 35.99 | 7869400.0 |
| 2004-10-18 13:00:00 | QQQ | ETF | 35.983 | 36.1 | 35.97 | 36.094 | 5589200.0 |
| 2004-10-18 13:30:00 | QQQ | ETF | 36.094 | 36.11 | 35.908 | 35.97 | 8466000.0 |
| 2004-10-18 14:00:00 | QQQ | ETF | 35.97 | 36.02 | 35.91 | 35.99 | 3100100.0 |
| 2004-10-18 14:30:00 | QQQ | ETF | 36.0 | 36.16 | 35.94 | 36.12 | 9258300.0 |
| 2004-10-18 15:00:00 | QQQ | ETF | 36.12 | 36.16 | 36.01 | 36.15 | 5617700.0 |
| 2004-10-18 15:30:00 | QQQ | ETF | 36.16 | 36.2 | 36.06 | 36.188 | 8112400.0 |
| 2004-10-18 16:00:00 | QQQ | ETF | 36.18 | 36.25 | 36.12 | 36.17 | 4949500.0 |
| 2004-10-18 16:30:00 | QQQ | ETF | 36.178 | 36.29 | 36.14 | 36.29 | 1594000.0 |
| 2004-10-18 17:00:00 | QQQ | ETF | 36.29 | 36.378 | 36.26 | 36.36 | 634000.0 |
| 2004-10-18 17:30:00 | QQQ | ETF | 36.36 | 36.39 | 36.351 | 36.37 | 95700.0 |
| 2004-10-18 18:00:00 | QQQ | ETF | 36.37 | 36.38 | 36.33 | 36.33 | 98800.0 |
| 2004-10-18 18:30:00 | QQQ | ETF | 36.34 | 36.37 | 36.34 | 36.34 | 20600.0 |
| 2004-10-18 19:00:00 | QQQ | ETF | 36.35 | 36.35 | 36.34 | 36.34 | 15200.0 |
| 2004-10-18 19:30:00 | QQQ | ETF | 36.34 | 36.35 | 36.34 | 36.35 | 6800.0 |
| 2004-10-18 08:30:00 | IWM | ETF | 56.64 | 56.64 | 56.6 | 56.6 | 3000.0 |
| 2004-10-18 09:00:00 | IWM | ETF | 56.645 | 56.665 | 56.645 | 56.665 | 12600.0 |
> showing 50 of 1,229 rows — these rows as CSV