PREVIEW / etf_30min / 2004-07-16
file: by_date/etf_30min/2004/2004-07-16.parquet size: 35 KB rows: 1,141
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-16 08:00:00 | SPY | ETF | 111.2 | 111.2 | 111.09 | 111.1 | 42800.0 |
| 2004-07-16 08:30:00 | SPY | ETF | 111.17 | 111.42 | 111.14 | 111.4 | 779300.0 |
| 2004-07-16 09:00:00 | SPY | ETF | 111.42 | 111.6 | 111.39 | 111.58 | 52400.0 |
| 2004-07-16 09:30:00 | SPY | ETF | 111.57 | 111.67 | 111.32 | 111.45 | 6427500.0 |
| 2004-07-16 10:00:00 | SPY | ETF | 111.47 | 111.53 | 111.12 | 111.24 | 4205500.0 |
| 2004-07-16 10:30:00 | SPY | ETF | 111.23 | 111.24 | 110.85 | 110.93 | 3647700.0 |
| 2004-07-16 11:00:00 | SPY | ETF | 110.92 | 111.29 | 110.89 | 111.08 | 1893000.0 |
| 2004-07-16 11:30:00 | SPY | ETF | 111.09 | 111.16 | 111.01 | 111.11 | 1229700.0 |
| 2004-07-16 12:00:00 | SPY | ETF | 111.11 | 111.19 | 111.0 | 111.1 | 1805100.0 |
| 2004-07-16 12:30:00 | SPY | ETF | 111.11 | 111.2 | 111.02 | 111.15 | 1037400.0 |
| 2004-07-16 13:00:00 | SPY | ETF | 111.17 | 111.21 | 111.02 | 111.1 | 731900.0 |
| 2004-07-16 13:30:00 | SPY | ETF | 111.09 | 111.18 | 111.02 | 111.15 | 519200.0 |
| 2004-07-16 14:00:00 | SPY | ETF | 111.15 | 111.16 | 110.74 | 110.83 | 1776000.0 |
| 2004-07-16 14:30:00 | SPY | ETF | 110.81 | 110.94 | 110.58 | 110.62 | 2376400.0 |
| 2004-07-16 15:00:00 | SPY | ETF | 110.62 | 110.89 | 110.6 | 110.81 | 2206200.0 |
| 2004-07-16 15:30:00 | SPY | ETF | 110.8 | 110.83 | 110.44 | 110.53 | 5407200.0 |
| 2004-07-16 16:00:00 | SPY | ETF | 110.54 | 110.78 | 110.47 | 110.7 | 4087400.0 |
| 2004-07-16 16:30:00 | SPY | ETF | 110.71 | 110.76 | 110.71 | 110.76 | 49900.0 |
| 2004-07-16 17:00:00 | SPY | ETF | 110.75 | 110.9 | 110.75 | 110.89 | 39200.0 |
| 2004-07-16 17:30:00 | SPY | ETF | 110.77 | 110.77 | 110.77 | 110.77 | 200.0 |
| 2004-07-16 18:00:00 | SPY | ETF | 110.76 | 110.78 | 110.76 | 110.78 | 1500.0 |
| 2004-07-16 18:30:00 | SPY | ETF | 110.78 | 110.84 | 110.78 | 110.84 | 700.0 |
| 2004-07-16 19:30:00 | SPY | ETF | 110.82 | 110.82 | 110.82 | 110.82 | 100.0 |
| 2004-07-16 08:00:00 | QQQ | ETF | 35.32 | 35.33 | 35.28 | 35.32 | 100100.0 |
| 2004-07-16 08:30:00 | QQQ | ETF | 35.32 | 35.45 | 35.3 | 35.4 | 783200.0 |
| 2004-07-16 09:00:00 | QQQ | ETF | 35.4 | 35.43 | 35.38 | 35.41 | 174700.0 |
| 2004-07-16 09:30:00 | QQQ | ETF | 35.428 | 35.45 | 35.18 | 35.28 | 16228400.0 |
| 2004-07-16 10:00:00 | QQQ | ETF | 35.28 | 35.31 | 35.144 | 35.19 | 10640400.0 |
| 2004-07-16 10:30:00 | QQQ | ETF | 35.2 | 35.21 | 34.94 | 35.0 | 13929200.0 |
| 2004-07-16 11:00:00 | QQQ | ETF | 35.002 | 35.17 | 34.98 | 35.051 | 7192700.0 |
| 2004-07-16 11:30:00 | QQQ | ETF | 35.05 | 35.12 | 34.97 | 35.013 | 4946700.0 |
| 2004-07-16 12:00:00 | QQQ | ETF | 35.014 | 35.05 | 34.93 | 34.99 | 5170000.0 |
| 2004-07-16 12:30:00 | QQQ | ETF | 34.99 | 35.07 | 34.959 | 35.04 | 6504400.0 |
| 2004-07-16 13:00:00 | QQQ | ETF | 35.04 | 35.07 | 34.952 | 35.0 | 4081700.0 |
| 2004-07-16 13:30:00 | QQQ | ETF | 35.0 | 35.04 | 34.96 | 35.01 | 4027500.0 |
| 2004-07-16 14:00:00 | QQQ | ETF | 35.009 | 35.018 | 34.74 | 34.8 | 9882700.0 |
| 2004-07-16 14:30:00 | QQQ | ETF | 34.8 | 34.87 | 34.71 | 34.769 | 8971600.0 |
| 2004-07-16 15:00:00 | QQQ | ETF | 34.76 | 34.89 | 34.76 | 34.869 | 7962500.0 |
| 2004-07-16 15:30:00 | QQQ | ETF | 34.869 | 34.88 | 34.64 | 34.68 | 13416900.0 |
| 2004-07-16 16:00:00 | QQQ | ETF | 34.68 | 34.7 | 34.61 | 34.65 | 3509800.0 |
| 2004-07-16 16:30:00 | QQQ | ETF | 34.64 | 34.691 | 34.64 | 34.68 | 135600.0 |
| 2004-07-16 17:00:00 | QQQ | ETF | 34.67 | 34.69 | 34.65 | 34.68 | 41500.0 |
| 2004-07-16 17:30:00 | QQQ | ETF | 34.68 | 34.73 | 34.68 | 34.71 | 31100.0 |
| 2004-07-16 18:00:00 | QQQ | ETF | 34.71 | 34.76 | 34.69 | 34.7 | 41400.0 |
| 2004-07-16 18:30:00 | QQQ | ETF | 34.72 | 34.72 | 34.72 | 34.72 | 100.0 |
| 2004-07-16 19:00:00 | QQQ | ETF | 34.71 | 34.71 | 34.69 | 34.69 | 3900.0 |
| 2004-07-16 19:30:00 | QQQ | ETF | 34.7 | 34.71 | 34.69 | 34.71 | 900.0 |
| 2004-07-16 08:30:00 | IWM | ETF | 56.12 | 56.2 | 56.12 | 56.2 | 7000.0 |
| 2004-07-16 09:00:00 | IWM | ETF | 56.2 | 56.29 | 56.2 | 56.245 | 7800.0 |
| 2004-07-16 09:30:00 | IWM | ETF | 56.285 | 56.31 | 55.965 | 56.03 | 1368600.0 |
> showing 50 of 1,141 rows — these rows as CSV