PREVIEW / etf_30min / 2004-07-20
file: by_date/etf_30min/2004/2004-07-20.parquet size: 36 KB rows: 1,178
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-20 08:00:00 | SPY | ETF | 110.42 | 110.54 | 110.42 | 110.5 | 28800.0 |
| 2004-07-20 08:30:00 | SPY | ETF | 110.48 | 110.5 | 110.45 | 110.5 | 8400.0 |
| 2004-07-20 09:00:00 | SPY | ETF | 110.53 | 110.56 | 110.48 | 110.48 | 35000.0 |
| 2004-07-20 09:30:00 | SPY | ETF | 110.53 | 110.64 | 110.38 | 110.52 | 4125400.0 |
| 2004-07-20 10:00:00 | SPY | ETF | 110.53 | 110.59 | 110.25 | 110.43 | 2188400.0 |
| 2004-07-20 10:30:00 | SPY | ETF | 110.44 | 110.75 | 110.41 | 110.74 | 3295500.0 |
| 2004-07-20 11:00:00 | SPY | ETF | 110.75 | 110.77 | 110.55 | 110.56 | 1828700.0 |
| 2004-07-20 11:30:00 | SPY | ETF | 110.56 | 110.72 | 110.52 | 110.65 | 1301500.0 |
| 2004-07-20 12:00:00 | SPY | ETF | 110.64 | 110.75 | 110.59 | 110.69 | 1113500.0 |
| 2004-07-20 12:30:00 | SPY | ETF | 110.7 | 110.88 | 110.69 | 110.77 | 3158100.0 |
| 2004-07-20 13:00:00 | SPY | ETF | 110.77 | 110.88 | 110.67 | 110.83 | 2237400.0 |
| 2004-07-20 13:30:00 | SPY | ETF | 110.84 | 110.95 | 110.79 | 110.89 | 1735600.0 |
| 2004-07-20 14:00:00 | SPY | ETF | 110.89 | 111.23 | 110.85 | 111.23 | 3663300.0 |
| 2004-07-20 14:30:00 | SPY | ETF | 111.22 | 111.31 | 110.75 | 110.88 | 9078100.0 |
| 2004-07-20 15:00:00 | SPY | ETF | 110.88 | 111.2 | 110.87 | 111.08 | 3640500.0 |
| 2004-07-20 15:30:00 | SPY | ETF | 111.06 | 111.25 | 110.97 | 111.24 | 2345900.0 |
| 2004-07-20 16:00:00 | SPY | ETF | 111.25 | 111.9 | 111.21 | 111.59 | 2333800.0 |
| 2004-07-20 16:30:00 | SPY | ETF | 111.65 | 111.75 | 111.54 | 111.69 | 259200.0 |
| 2004-07-20 17:00:00 | SPY | ETF | 111.69 | 111.7 | 111.6 | 111.7 | 223600.0 |
| 2004-07-20 17:30:00 | SPY | ETF | 111.7 | 111.9 | 111.67 | 111.8 | 302700.0 |
| 2004-07-20 18:00:00 | SPY | ETF | 111.8 | 111.88 | 111.5 | 111.8 | 307000.0 |
| 2004-07-20 18:30:00 | SPY | ETF | 111.9 | 111.9 | 111.85 | 111.85 | 1900.0 |
| 2004-07-20 19:00:00 | SPY | ETF | 111.85 | 111.85 | 111.81 | 111.81 | 4300.0 |
| 2004-07-20 19:30:00 | SPY | ETF | 111.84 | 111.85 | 111.83 | 111.84 | 2400.0 |
| 2004-07-20 08:00:00 | QQQ | ETF | 34.72 | 34.78 | 34.72 | 34.74 | 144800.0 |
| 2004-07-20 08:30:00 | QQQ | ETF | 34.75 | 34.78 | 34.73 | 34.76 | 203200.0 |
| 2004-07-20 09:00:00 | QQQ | ETF | 34.76 | 34.78 | 34.74 | 34.76 | 324600.0 |
| 2004-07-20 09:30:00 | QQQ | ETF | 34.75 | 34.89 | 34.71 | 34.85 | 14546500.0 |
| 2004-07-20 10:00:00 | QQQ | ETF | 34.86 | 34.88 | 34.75 | 34.851 | 4224300.0 |
| 2004-07-20 10:30:00 | QQQ | ETF | 34.85 | 34.95 | 34.832 | 34.94 | 7412200.0 |
| 2004-07-20 11:00:00 | QQQ | ETF | 34.94 | 34.97 | 34.866 | 34.88 | 4991600.0 |
| 2004-07-20 11:30:00 | QQQ | ETF | 34.88 | 34.98 | 34.84 | 34.94 | 4121500.0 |
| 2004-07-20 12:00:00 | QQQ | ETF | 34.95 | 35.0 | 34.89 | 34.98 | 4285000.0 |
| 2004-07-20 12:30:00 | QQQ | ETF | 34.99 | 35.07 | 34.98 | 35.02 | 6183500.0 |
| 2004-07-20 13:00:00 | QQQ | ETF | 35.024 | 35.07 | 34.98 | 35.06 | 4126900.0 |
| 2004-07-20 13:30:00 | QQQ | ETF | 35.05 | 35.11 | 35.04 | 35.08 | 4663100.0 |
| 2004-07-20 14:00:00 | QQQ | ETF | 35.08 | 35.15 | 35.07 | 35.14 | 6085700.0 |
| 2004-07-20 14:30:00 | QQQ | ETF | 35.14 | 35.2 | 35.01 | 35.06 | 13903500.0 |
| 2004-07-20 15:00:00 | QQQ | ETF | 35.06 | 35.18 | 35.03 | 35.17 | 9538300.0 |
| 2004-07-20 15:30:00 | QQQ | ETF | 35.17 | 35.29 | 35.143 | 35.264 | 10392700.0 |
| 2004-07-20 16:00:00 | QQQ | ETF | 35.27 | 35.58 | 35.17 | 35.48 | 12033500.0 |
| 2004-07-20 16:30:00 | QQQ | ETF | 35.48 | 35.5654 | 35.42 | 35.49 | 2372800.0 |
| 2004-07-20 17:00:00 | QQQ | ETF | 35.49 | 35.53 | 35.43 | 35.53 | 540400.0 |
| 2004-07-20 17:30:00 | QQQ | ETF | 35.53 | 35.73 | 35.53 | 35.68 | 1157600.0 |
| 2004-07-20 18:00:00 | QQQ | ETF | 35.63 | 35.67 | 35.42 | 35.63 | 2181200.0 |
| 2004-07-20 18:30:00 | QQQ | ETF | 35.64 | 35.68 | 35.64 | 35.65 | 55200.0 |
| 2004-07-20 19:00:00 | QQQ | ETF | 35.66 | 35.7 | 35.61 | 35.61 | 50300.0 |
| 2004-07-20 19:30:00 | QQQ | ETF | 35.61 | 35.72 | 35.61 | 35.65 | 46800.0 |
| 2004-07-20 09:30:00 | IWM | ETF | 55.335 | 55.585 | 55.22 | 55.49 | 1345600.0 |
| 2004-07-20 10:00:00 | IWM | ETF | 55.47 | 55.47 | 55.295 | 55.39 | 381200.0 |
> showing 50 of 1,178 rows — these rows as CSV