PREVIEW / etf_30min / 2004-07-07
file: by_date/etf_30min/2004/2004-07-07.parquet size: 35 KB rows: 1,184
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-07 08:00:00 | SPY | ETF | 112.06 | 112.06 | 112.06 | 112.06 | 200.0 |
| 2004-07-07 08:30:00 | SPY | ETF | 112.01 | 112.01 | 111.82 | 111.83 | 27400.0 |
| 2004-07-07 09:00:00 | SPY | ETF | 111.83 | 111.83 | 111.75 | 111.8 | 9600.0 |
| 2004-07-07 09:30:00 | SPY | ETF | 111.81 | 112.22 | 111.75 | 112.07 | 3984300.0 |
| 2004-07-07 10:00:00 | SPY | ETF | 112.08 | 112.37 | 112.06 | 112.19 | 2766900.0 |
| 2004-07-07 10:30:00 | SPY | ETF | 112.19 | 112.22 | 111.99 | 112.06 | 1904400.0 |
| 2004-07-07 11:00:00 | SPY | ETF | 112.06 | 112.17 | 111.91 | 111.94 | 1478900.0 |
| 2004-07-07 11:30:00 | SPY | ETF | 111.97 | 112.02 | 111.86 | 111.96 | 1823500.0 |
| 2004-07-07 12:00:00 | SPY | ETF | 111.96 | 112.07 | 111.89 | 111.94 | 1337400.0 |
| 2004-07-07 12:30:00 | SPY | ETF | 111.93 | 112.08 | 111.89 | 111.99 | 867700.0 |
| 2004-07-07 13:00:00 | SPY | ETF | 112.0 | 112.37 | 111.92 | 112.34 | 2332100.0 |
| 2004-07-07 13:30:00 | SPY | ETF | 112.35 | 112.37 | 112.22 | 112.32 | 1200700.0 |
| 2004-07-07 14:00:00 | SPY | ETF | 112.32 | 112.49 | 112.2 | 112.42 | 1409600.0 |
| 2004-07-07 14:30:00 | SPY | ETF | 112.47 | 112.57 | 112.36 | 112.45 | 2305900.0 |
| 2004-07-07 15:00:00 | SPY | ETF | 112.45 | 112.51 | 112.13 | 112.16 | 2062100.0 |
| 2004-07-07 15:30:00 | SPY | ETF | 112.17 | 112.26 | 112.07 | 112.14 | 2230800.0 |
| 2004-07-07 16:00:00 | SPY | ETF | 112.15 | 112.29 | 112.06 | 112.06 | 1177000.0 |
| 2004-07-07 16:30:00 | SPY | ETF | 112.08 | 112.1 | 111.5 | 111.58 | 1610700.0 |
| 2004-07-07 17:00:00 | SPY | ETF | 111.58 | 111.62 | 111.54 | 111.61 | 69200.0 |
| 2004-07-07 17:30:00 | SPY | ETF | 111.6 | 111.62 | 111.53 | 111.53 | 101500.0 |
| 2004-07-07 18:00:00 | SPY | ETF | 111.58 | 111.58 | 111.41 | 111.52 | 74900.0 |
| 2004-07-07 18:30:00 | SPY | ETF | 111.54 | 111.54 | 111.47 | 111.47 | 25800.0 |
| 2004-07-07 19:00:00 | SPY | ETF | 111.5 | 111.61 | 111.5 | 111.5 | 3200.0 |
| 2004-07-07 19:30:00 | SPY | ETF | 111.5 | 111.51 | 111.5 | 111.51 | 3000.0 |
| 2004-07-07 08:00:00 | QQQ | ETF | 36.14 | 36.14 | 36.07 | 36.07 | 36200.0 |
| 2004-07-07 08:30:00 | QQQ | ETF | 36.07 | 36.07 | 36.0 | 36.02 | 48000.0 |
| 2004-07-07 09:00:00 | QQQ | ETF | 36.01 | 36.01 | 35.92 | 35.94 | 217700.0 |
| 2004-07-07 09:30:00 | QQQ | ETF | 35.96 | 36.24 | 35.92 | 36.17 | 17146600.0 |
| 2004-07-07 10:00:00 | QQQ | ETF | 36.166 | 36.25 | 36.16 | 36.2 | 8022600.0 |
| 2004-07-07 10:30:00 | QQQ | ETF | 36.2 | 36.21 | 36.08 | 36.1 | 4244200.0 |
| 2004-07-07 11:00:00 | QQQ | ETF | 36.1 | 36.15 | 36.0 | 36.02 | 4945400.0 |
| 2004-07-07 11:30:00 | QQQ | ETF | 36.02 | 36.06 | 35.96 | 36.05 | 4167200.0 |
| 2004-07-07 12:00:00 | QQQ | ETF | 36.05 | 36.12 | 36.01 | 36.02 | 3411500.0 |
| 2004-07-07 12:30:00 | QQQ | ETF | 36.021 | 36.09 | 35.99 | 36.05 | 3657000.0 |
| 2004-07-07 13:00:00 | QQQ | ETF | 36.054 | 36.2 | 36.02 | 36.2 | 5511100.0 |
| 2004-07-07 13:30:00 | QQQ | ETF | 36.199 | 36.228 | 36.14 | 36.19 | 6323700.0 |
| 2004-07-07 14:00:00 | QQQ | ETF | 36.19 | 36.27 | 36.13 | 36.25 | 5222500.0 |
| 2004-07-07 14:30:00 | QQQ | ETF | 36.251 | 36.29 | 36.209 | 36.26 | 5678800.0 |
| 2004-07-07 15:00:00 | QQQ | ETF | 36.252 | 36.26 | 36.08 | 36.1 | 7613100.0 |
| 2004-07-07 15:30:00 | QQQ | ETF | 36.1 | 36.19 | 36.04 | 36.08 | 6456700.0 |
| 2004-07-07 16:00:00 | QQQ | ETF | 36.07 | 36.15 | 36.056 | 36.1 | 1685500.0 |
| 2004-07-07 16:30:00 | QQQ | ETF | 36.08 | 36.08 | 35.6 | 35.64 | 4371500.0 |
| 2004-07-07 17:00:00 | QQQ | ETF | 35.65 | 35.65 | 35.59 | 35.627 | 758100.0 |
| 2004-07-07 17:30:00 | QQQ | ETF | 35.625 | 35.69 | 35.625 | 35.68 | 292900.0 |
| 2004-07-07 18:00:00 | QQQ | ETF | 35.68 | 35.68 | 35.59 | 35.64 | 258300.0 |
| 2004-07-07 18:30:00 | QQQ | ETF | 35.63 | 35.64 | 35.63 | 35.64 | 4500.0 |
| 2004-07-07 19:00:00 | QQQ | ETF | 35.64 | 35.65 | 35.64 | 35.64 | 18900.0 |
| 2004-07-07 19:30:00 | QQQ | ETF | 35.63 | 35.67 | 35.63 | 35.67 | 15800.0 |
| 2004-07-07 08:30:00 | IWM | ETF | 57.16 | 57.16 | 57.16 | 57.16 | 1000.0 |
| 2004-07-07 09:00:00 | IWM | ETF | 57.05 | 57.05 | 57.005 | 57.005 | 2000.0 |
> showing 50 of 1,184 rows — these rows as CSV