PREVIEW / etf_30min / 2004-11-12
file: by_date/etf_30min/2004/2004-11-12.parquet size: 41 KB rows: 1,355
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-11-12 08:00:00 | SPY | ETF | 117.89 | 117.93 | 117.86 | 117.93 | 14600.0 |
| 2004-11-12 08:30:00 | SPY | ETF | 117.99 | 118.05 | 117.95 | 118.02 | 104900.0 |
| 2004-11-12 09:00:00 | SPY | ETF | 117.99 | 118.0 | 117.93 | 117.96 | 48700.0 |
| 2004-11-12 09:30:00 | SPY | ETF | 117.97 | 118.04 | 117.68 | 117.85 | 8050400.0 |
| 2004-11-12 10:00:00 | SPY | ETF | 117.84 | 118.04 | 117.75 | 117.99 | 5333700.0 |
| 2004-11-12 10:30:00 | SPY | ETF | 118.01 | 118.11 | 117.9 | 117.93 | 3180900.0 |
| 2004-11-12 11:00:00 | SPY | ETF | 117.93 | 118.19 | 117.85 | 118.07 | 3613500.0 |
| 2004-11-12 11:30:00 | SPY | ETF | 118.07 | 118.18 | 117.93 | 117.98 | 2087900.0 |
| 2004-11-12 12:00:00 | SPY | ETF | 117.98 | 118.32 | 117.96 | 118.29 | 2538600.0 |
| 2004-11-12 12:30:00 | SPY | ETF | 118.29 | 118.35 | 118.22 | 118.26 | 2242500.0 |
| 2004-11-12 13:00:00 | SPY | ETF | 118.26 | 118.38 | 118.26 | 118.32 | 1326800.0 |
| 2004-11-12 13:30:00 | SPY | ETF | 118.32 | 118.35 | 118.2 | 118.27 | 1867900.0 |
| 2004-11-12 14:00:00 | SPY | ETF | 118.27 | 118.53 | 118.25 | 118.48 | 4006300.0 |
| 2004-11-12 14:30:00 | SPY | ETF | 118.48 | 118.83 | 118.46 | 118.64 | 5203000.0 |
| 2004-11-12 15:00:00 | SPY | ETF | 118.66 | 118.86 | 118.63 | 118.79 | 3314700.0 |
| 2004-11-12 15:30:00 | SPY | ETF | 118.79 | 118.97 | 118.72 | 118.91 | 7179100.0 |
| 2004-11-12 16:00:00 | SPY | ETF | 118.95 | 119.0 | 118.71 | 118.75 | 3213900.0 |
| 2004-11-12 16:30:00 | SPY | ETF | 118.75 | 118.92 | 118.7 | 118.8 | 148400.0 |
| 2004-11-12 17:00:00 | SPY | ETF | 118.8 | 118.95 | 118.78 | 118.8 | 46200.0 |
| 2004-11-12 17:30:00 | SPY | ETF | 118.8 | 118.8 | 118.72 | 118.8 | 8700.0 |
| 2004-11-12 18:00:00 | SPY | ETF | 118.78 | 118.79 | 118.78 | 118.79 | 3900.0 |
| 2004-11-12 18:30:00 | SPY | ETF | 118.78 | 118.78 | 118.78 | 118.78 | 500.0 |
| 2004-11-12 19:00:00 | SPY | ETF | 118.78 | 118.78 | 118.78 | 118.78 | 400.0 |
| 2004-11-12 19:30:00 | SPY | ETF | 118.79 | 118.79 | 118.78 | 118.78 | 1300.0 |
| 2004-11-12 08:00:00 | QQQ | ETF | 38.38 | 38.38 | 38.26 | 38.35 | 48200.0 |
| 2004-11-12 08:30:00 | QQQ | ETF | 38.35 | 38.42 | 38.35 | 38.37 | 332200.0 |
| 2004-11-12 09:00:00 | QQQ | ETF | 38.37 | 38.39 | 38.34 | 38.36 | 316800.0 |
| 2004-11-12 09:30:00 | QQQ | ETF | 38.34 | 38.4 | 38.17 | 38.24 | 15479900.0 |
| 2004-11-12 10:00:00 | QQQ | ETF | 38.25 | 38.42 | 38.22 | 38.38 | 9629200.0 |
| 2004-11-12 10:30:00 | QQQ | ETF | 38.37 | 38.49 | 38.36 | 38.37 | 11798200.0 |
| 2004-11-12 11:00:00 | QQQ | ETF | 38.38 | 38.508 | 38.34 | 38.44 | 5580200.0 |
| 2004-11-12 11:30:00 | QQQ | ETF | 38.44 | 38.47 | 38.32 | 38.335 | 5468400.0 |
| 2004-11-12 12:00:00 | QQQ | ETF | 38.335 | 38.46 | 38.31 | 38.43 | 5248600.0 |
| 2004-11-12 12:30:00 | QQQ | ETF | 38.42 | 38.46 | 38.4 | 38.402 | 2518200.0 |
| 2004-11-12 13:00:00 | QQQ | ETF | 38.409 | 38.47 | 38.4 | 38.44 | 2604500.0 |
| 2004-11-12 13:30:00 | QQQ | ETF | 38.44 | 38.46 | 38.388 | 38.42 | 2352600.0 |
| 2004-11-12 14:00:00 | QQQ | ETF | 38.42 | 38.553 | 38.41 | 38.52 | 8249200.0 |
| 2004-11-12 14:30:00 | QQQ | ETF | 38.52 | 38.62 | 38.5 | 38.53 | 8023600.0 |
| 2004-11-12 15:00:00 | QQQ | ETF | 38.53 | 38.62 | 38.51 | 38.592 | 6699800.0 |
| 2004-11-12 15:30:00 | QQQ | ETF | 38.593 | 38.68 | 38.54 | 38.66 | 12471700.0 |
| 2004-11-12 16:00:00 | QQQ | ETF | 38.66 | 38.68 | 38.4712 | 38.65 | 3554400.0 |
| 2004-11-12 16:30:00 | QQQ | ETF | 38.63 | 38.7 | 38.63 | 38.7 | 143200.0 |
| 2004-11-12 17:00:00 | QQQ | ETF | 38.68 | 38.7 | 38.65 | 38.68 | 93400.0 |
| 2004-11-12 17:30:00 | QQQ | ETF | 38.68 | 38.69 | 38.5233 | 38.68 | 186400.0 |
| 2004-11-12 18:00:00 | QQQ | ETF | 38.68 | 38.69 | 38.68 | 38.68 | 3800.0 |
| 2004-11-12 18:30:00 | QQQ | ETF | 38.69 | 38.69 | 38.69 | 38.69 | 1800.0 |
| 2004-11-12 19:00:00 | QQQ | ETF | 38.69 | 38.69 | 38.69 | 38.69 | 2600.0 |
| 2004-11-12 19:30:00 | QQQ | ETF | 38.7 | 38.7 | 38.69 | 38.7 | 4600.0 |
| 2004-11-12 09:30:00 | IWM | ETF | 61.36 | 61.475 | 61.175 | 61.225 | 1447400.0 |
| 2004-11-12 10:00:00 | IWM | ETF | 61.22 | 61.375 | 61.205 | 61.315 | 693600.0 |
> showing 50 of 1,355 rows — these rows as CSV