PREVIEW / etf_30min / 2004-05-07
file: by_date/etf_30min/2004/2004-05-07.parquet size: 37 KB rows: 1,206
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-05-07 08:00:00 | SPY | ETF | 111.61 | 111.8 | 111.55 | 111.79 | 89700.0 |
| 2004-05-07 08:30:00 | SPY | ETF | 111.97 | 112.02 | 110.96 | 111.03 | 1253600.0 |
| 2004-05-07 09:00:00 | SPY | ETF | 111.03 | 111.37 | 111.0 | 111.22 | 400300.0 |
| 2004-05-07 09:30:00 | SPY | ETF | 111.22 | 112.23 | 111.18 | 111.61 | 8100600.0 |
| 2004-05-07 10:00:00 | SPY | ETF | 111.57 | 111.7 | 111.1 | 111.58 | 4823500.0 |
| 2004-05-07 10:30:00 | SPY | ETF | 111.6 | 111.86 | 111.39 | 111.6 | 3847700.0 |
| 2004-05-07 11:00:00 | SPY | ETF | 111.56 | 111.67 | 111.38 | 111.67 | 1846100.0 |
| 2004-05-07 11:30:00 | SPY | ETF | 111.67 | 111.7 | 111.33 | 111.47 | 1654200.0 |
| 2004-05-07 12:00:00 | SPY | ETF | 111.46 | 111.49 | 111.26 | 111.35 | 1016600.0 |
| 2004-05-07 12:30:00 | SPY | ETF | 111.36 | 111.63 | 111.28 | 111.51 | 1406900.0 |
| 2004-05-07 13:00:00 | SPY | ETF | 111.51 | 111.66 | 111.4 | 111.46 | 808600.0 |
| 2004-05-07 13:30:00 | SPY | ETF | 111.46 | 111.47 | 110.78 | 110.8 | 4158700.0 |
| 2004-05-07 14:00:00 | SPY | ETF | 110.93 | 111.05 | 110.38 | 110.64 | 8514700.0 |
| 2004-05-07 14:30:00 | SPY | ETF | 110.62 | 110.98 | 110.45 | 110.72 | 4267600.0 |
| 2004-05-07 15:00:00 | SPY | ETF | 110.73 | 110.85 | 110.31 | 110.47 | 3726800.0 |
| 2004-05-07 15:30:00 | SPY | ETF | 110.46 | 110.75 | 110.26 | 110.3 | 5886800.0 |
| 2004-05-07 16:00:00 | SPY | ETF | 110.29 | 111.8339 | 109.87 | 109.88 | 2433800.0 |
| 2004-05-07 16:30:00 | SPY | ETF | 109.88 | 109.92 | 109.82 | 109.84 | 144000.0 |
| 2004-05-07 17:00:00 | SPY | ETF | 109.86 | 109.98 | 109.84 | 109.96 | 38700.0 |
| 2004-05-07 17:30:00 | SPY | ETF | 109.96 | 109.98 | 109.95 | 109.98 | 9500.0 |
| 2004-05-07 18:00:00 | SPY | ETF | 109.96 | 110.08 | 109.96 | 110.08 | 2700.0 |
| 2004-05-07 18:30:00 | SPY | ETF | 110.09 | 110.11 | 110.05 | 110.11 | 1500.0 |
| 2004-05-07 19:00:00 | SPY | ETF | 110.04 | 110.04 | 109.95 | 109.97 | 1100.0 |
| 2004-05-07 19:30:00 | SPY | ETF | 109.88 | 109.97 | 109.88 | 109.97 | 500.0 |
| 2004-05-07 08:00:00 | QQQ | ETF | 35.17 | 35.25 | 35.14 | 35.18 | 391400.0 |
| 2004-05-07 08:30:00 | QQQ | ETF | 35.21 | 35.33 | 34.95 | 34.96 | 1559200.0 |
| 2004-05-07 09:00:00 | QQQ | ETF | 34.96 | 35.1 | 34.95 | 35.1 | 707000.0 |
| 2004-05-07 09:30:00 | QQQ | ETF | 35.09 | 35.64 | 35.08 | 35.37 | 23221400.0 |
| 2004-05-07 10:00:00 | QQQ | ETF | 35.37 | 35.45 | 35.14 | 35.442 | 15344300.0 |
| 2004-05-07 10:30:00 | QQQ | ETF | 35.44 | 35.59 | 35.38 | 35.5 | 10922600.0 |
| 2004-05-07 11:00:00 | QQQ | ETF | 35.5 | 35.56 | 35.41 | 35.56 | 5369300.0 |
| 2004-05-07 11:30:00 | QQQ | ETF | 35.56 | 35.58 | 35.45 | 35.52 | 3878800.0 |
| 2004-05-07 12:00:00 | QQQ | ETF | 35.51 | 35.52 | 35.41 | 35.45 | 4726900.0 |
| 2004-05-07 12:30:00 | QQQ | ETF | 35.44 | 35.59 | 35.42 | 35.53 | 4134500.0 |
| 2004-05-07 13:00:00 | QQQ | ETF | 35.53 | 35.6 | 35.5 | 35.55 | 2548900.0 |
| 2004-05-07 13:30:00 | QQQ | ETF | 35.55 | 35.55 | 35.26 | 35.31 | 7498100.0 |
| 2004-05-07 14:00:00 | QQQ | ETF | 35.31 | 35.35 | 35.14 | 35.262 | 11417600.0 |
| 2004-05-07 14:30:00 | QQQ | ETF | 35.26 | 35.41 | 35.14 | 35.25 | 9650000.0 |
| 2004-05-07 15:00:00 | QQQ | ETF | 35.25 | 35.32 | 35.04 | 35.1 | 11212600.0 |
| 2004-05-07 15:30:00 | QQQ | ETF | 35.085 | 35.23 | 34.96 | 34.98 | 14692800.0 |
| 2004-05-07 16:00:00 | QQQ | ETF | 34.99 | 35.05 | 34.91 | 34.96 | 4886400.0 |
| 2004-05-07 16:30:00 | QQQ | ETF | 34.96 | 35.01 | 34.95 | 34.98 | 277500.0 |
| 2004-05-07 17:00:00 | QQQ | ETF | 34.98 | 35.01 | 34.93 | 34.94 | 69200.0 |
| 2004-05-07 17:30:00 | QQQ | ETF | 34.95 | 34.99 | 34.94 | 34.94 | 35700.0 |
| 2004-05-07 18:00:00 | QQQ | ETF | 34.97 | 34.97 | 34.94 | 34.96 | 12900.0 |
| 2004-05-07 18:30:00 | QQQ | ETF | 34.95 | 34.95 | 34.94 | 34.95 | 3300.0 |
| 2004-05-07 19:00:00 | QQQ | ETF | 34.96 | 34.97 | 34.95 | 34.97 | 7700.0 |
| 2004-05-07 19:30:00 | QQQ | ETF | 34.98 | 35.0 | 34.98 | 35.0 | 1700.0 |
| 2004-05-07 08:00:00 | IWM | ETF | 55.885 | 55.895 | 55.885 | 55.895 | 400.0 |
| 2004-05-07 08:30:00 | IWM | ETF | 55.75 | 55.82 | 55.55 | 55.55 | 153600.0 |
> showing 50 of 1,206 rows — these rows as CSV