PREVIEW / etf_30min / 2004-09-28
file: by_date/etf_30min/2004/2004-09-28.parquet size: 35 KB rows: 1,132
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-09-28 08:00:00 | SPY | ETF | 111.0 | 111.0 | 110.97 | 111.0 | 7800.0 |
| 2004-09-28 08:30:00 | SPY | ETF | 111.01 | 111.01 | 110.92 | 110.97 | 36500.0 |
| 2004-09-28 09:00:00 | SPY | ETF | 110.94 | 110.94 | 110.91 | 110.93 | 9500.0 |
| 2004-09-28 09:30:00 | SPY | ETF | 110.91 | 111.03 | 110.73 | 110.75 | 3878100.0 |
| 2004-09-28 10:00:00 | SPY | ETF | 110.75 | 110.91 | 110.65 | 110.72 | 3597100.0 |
| 2004-09-28 10:30:00 | SPY | ETF | 110.72 | 110.74 | 110.41 | 110.68 | 3397300.0 |
| 2004-09-28 11:00:00 | SPY | ETF | 110.69 | 110.9 | 110.64 | 110.82 | 1917300.0 |
| 2004-09-28 11:30:00 | SPY | ETF | 110.82 | 111.11 | 110.74 | 111.01 | 2335400.0 |
| 2004-09-28 12:00:00 | SPY | ETF | 111.01 | 111.15 | 110.98 | 111.04 | 1398600.0 |
| 2004-09-28 12:30:00 | SPY | ETF | 111.05 | 111.09 | 110.94 | 110.99 | 1334100.0 |
| 2004-09-28 13:00:00 | SPY | ETF | 110.99 | 111.07 | 110.83 | 110.83 | 1159500.0 |
| 2004-09-28 13:30:00 | SPY | ETF | 110.84 | 111.08 | 110.8 | 110.91 | 1843800.0 |
| 2004-09-28 14:00:00 | SPY | ETF | 110.92 | 111.14 | 110.84 | 111.14 | 1996300.0 |
| 2004-09-28 14:30:00 | SPY | ETF | 111.12 | 111.44 | 111.09 | 111.39 | 3805500.0 |
| 2004-09-28 15:00:00 | SPY | ETF | 111.39 | 111.5 | 111.3 | 111.44 | 4070200.0 |
| 2004-09-28 15:30:00 | SPY | ETF | 111.44 | 111.51 | 111.29 | 111.35 | 4588400.0 |
| 2004-09-28 16:00:00 | SPY | ETF | 111.35 | 111.46 | 111.22 | 111.26 | 4352300.0 |
| 2004-09-28 16:30:00 | SPY | ETF | 111.25 | 111.3725 | 111.22 | 111.29 | 207400.0 |
| 2004-09-28 17:00:00 | SPY | ETF | 111.29 | 111.3 | 111.28 | 111.28 | 7000.0 |
| 2004-09-28 17:30:00 | SPY | ETF | 111.29 | 111.31 | 111.29 | 111.31 | 2600.0 |
| 2004-09-28 18:00:00 | SPY | ETF | 111.31 | 111.32 | 111.28 | 111.28 | 9000.0 |
| 2004-09-28 18:30:00 | SPY | ETF | 111.28 | 111.28 | 111.28 | 111.28 | 2700.0 |
| 2004-09-28 19:00:00 | SPY | ETF | 111.25 | 111.25 | 111.25 | 111.25 | 300.0 |
| 2004-09-28 19:30:00 | SPY | ETF | 111.29 | 111.29 | 111.29 | 111.29 | 100.0 |
| 2004-09-28 08:00:00 | QQQ | ETF | 34.56 | 34.6 | 34.56 | 34.59 | 34400.0 |
| 2004-09-28 08:30:00 | QQQ | ETF | 34.61 | 34.61 | 34.53 | 34.56 | 121400.0 |
| 2004-09-28 09:00:00 | QQQ | ETF | 34.56 | 34.56 | 34.53 | 34.56 | 393500.0 |
| 2004-09-28 09:30:00 | QQQ | ETF | 34.55 | 34.586 | 34.42 | 34.448 | 9357400.0 |
| 2004-09-28 10:00:00 | QQQ | ETF | 34.44 | 34.54 | 34.37 | 34.421 | 8742000.0 |
| 2004-09-28 10:30:00 | QQQ | ETF | 34.43 | 34.43 | 34.23 | 34.36 | 10766200.0 |
| 2004-09-28 11:00:00 | QQQ | ETF | 34.36 | 34.47 | 34.34 | 34.42 | 6112200.0 |
| 2004-09-28 11:30:00 | QQQ | ETF | 34.42 | 34.57 | 34.37 | 34.5 | 6454200.0 |
| 2004-09-28 12:00:00 | QQQ | ETF | 34.5 | 34.53 | 34.46 | 34.47 | 2930100.0 |
| 2004-09-28 12:30:00 | QQQ | ETF | 34.47 | 34.5 | 34.43 | 34.45 | 2315700.0 |
| 2004-09-28 13:00:00 | QQQ | ETF | 34.44 | 34.48 | 34.33 | 34.35 | 3165300.0 |
| 2004-09-28 13:30:00 | QQQ | ETF | 34.35 | 34.46 | 34.32 | 34.415 | 4348900.0 |
| 2004-09-28 14:00:00 | QQQ | ETF | 34.417 | 34.47 | 34.36 | 34.46 | 3950100.0 |
| 2004-09-28 14:30:00 | QQQ | ETF | 34.47 | 34.58 | 34.45 | 34.56 | 6983500.0 |
| 2004-09-28 15:00:00 | QQQ | ETF | 34.56 | 34.68 | 34.53 | 34.64 | 7880800.0 |
| 2004-09-28 15:30:00 | QQQ | ETF | 34.64 | 34.69 | 34.55 | 34.59 | 7197800.0 |
| 2004-09-28 16:00:00 | QQQ | ETF | 34.589 | 34.6166 | 34.54 | 34.55 | 2060100.0 |
| 2004-09-28 16:30:00 | QQQ | ETF | 34.554 | 34.56 | 34.53 | 34.56 | 109200.0 |
| 2004-09-28 17:00:00 | QQQ | ETF | 34.56 | 34.58 | 34.55 | 34.57 | 35600.0 |
| 2004-09-28 17:30:00 | QQQ | ETF | 34.58 | 34.6 | 34.57 | 34.57 | 127600.0 |
| 2004-09-28 18:00:00 | QQQ | ETF | 34.58 | 34.6 | 34.575 | 34.6 | 31600.0 |
| 2004-09-28 18:30:00 | QQQ | ETF | 34.59 | 34.6 | 34.56 | 34.58 | 9000.0 |
| 2004-09-28 19:00:00 | QQQ | ETF | 34.57 | 34.57 | 34.57 | 34.57 | 800.0 |
| 2004-09-28 19:30:00 | QQQ | ETF | 34.57 | 34.58 | 34.57 | 34.58 | 23700.0 |
| 2004-09-28 09:00:00 | IWM | ETF | 55.79 | 55.79 | 55.79 | 55.79 | 2000.0 |
| 2004-09-28 09:30:00 | IWM | ETF | 55.79 | 56.0 | 55.7 | 55.745 | 1951800.0 |
> showing 50 of 1,132 rows — these rows as CSV