PREVIEW / etf_30min / 2004-08-27
file: by_date/etf_30min/2004/2004-08-27.parquet size: 32 KB rows: 1,103
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-08-27 08:00:00 | SPY | ETF | 111.03 | 111.04 | 111.01 | 111.04 | 6700.0 |
| 2004-08-27 08:30:00 | SPY | ETF | 111.09 | 111.21 | 111.06 | 111.2 | 39200.0 |
| 2004-08-27 09:00:00 | SPY | ETF | 111.17 | 111.25 | 111.17 | 111.21 | 31800.0 |
| 2004-08-27 09:30:00 | SPY | ETF | 111.2 | 111.33 | 111.05 | 111.3 | 3046800.0 |
| 2004-08-27 10:00:00 | SPY | ETF | 111.3 | 111.5 | 111.23 | 111.37 | 4561800.0 |
| 2004-08-27 10:30:00 | SPY | ETF | 111.38 | 111.43 | 111.25 | 111.32 | 1715500.0 |
| 2004-08-27 11:00:00 | SPY | ETF | 111.32 | 111.4 | 111.3 | 111.35 | 1060800.0 |
| 2004-08-27 11:30:00 | SPY | ETF | 111.35 | 111.47 | 111.27 | 111.31 | 1141400.0 |
| 2004-08-27 12:00:00 | SPY | ETF | 111.31 | 111.33 | 111.26 | 111.29 | 1055100.0 |
| 2004-08-27 12:30:00 | SPY | ETF | 111.29 | 111.38 | 111.27 | 111.38 | 795000.0 |
| 2004-08-27 13:00:00 | SPY | ETF | 111.38 | 111.49 | 111.35 | 111.43 | 1343600.0 |
| 2004-08-27 13:30:00 | SPY | ETF | 111.44 | 111.47 | 111.38 | 111.4 | 737100.0 |
| 2004-08-27 14:00:00 | SPY | ETF | 111.41 | 111.56 | 111.39 | 111.47 | 1661800.0 |
| 2004-08-27 14:30:00 | SPY | ETF | 111.46 | 111.62 | 111.4 | 111.6 | 1376600.0 |
| 2004-08-27 15:00:00 | SPY | ETF | 111.59 | 111.63 | 111.47 | 111.5 | 1465300.0 |
| 2004-08-27 15:30:00 | SPY | ETF | 111.49 | 111.5 | 111.33 | 111.46 | 2936700.0 |
| 2004-08-27 16:00:00 | SPY | ETF | 111.46 | 111.53 | 111.38 | 111.49 | 1190900.0 |
| 2004-08-27 16:30:00 | SPY | ETF | 111.52 | 111.63 | 111.48 | 111.63 | 10300.0 |
| 2004-08-27 17:00:00 | SPY | ETF | 111.5 | 111.53 | 111.45 | 111.53 | 2100.0 |
| 2004-08-27 17:30:00 | SPY | ETF | 111.55 | 111.55 | 111.51 | 111.55 | 1100.0 |
| 2004-08-27 18:00:00 | SPY | ETF | 111.5 | 111.55 | 111.5 | 111.55 | 300.0 |
| 2004-08-27 18:30:00 | SPY | ETF | 111.55 | 111.55 | 111.55 | 111.55 | 200.0 |
| 2004-08-27 19:00:00 | SPY | ETF | 111.55 | 111.55 | 111.55 | 111.55 | 200.0 |
| 2004-08-27 08:00:00 | QQQ | ETF | 34.41 | 34.42 | 34.38 | 34.39 | 43900.0 |
| 2004-08-27 08:30:00 | QQQ | ETF | 34.41 | 34.47 | 34.38 | 34.46 | 145500.0 |
| 2004-08-27 09:00:00 | QQQ | ETF | 34.46 | 34.48 | 34.45 | 34.46 | 365800.0 |
| 2004-08-27 09:30:00 | QQQ | ETF | 34.465 | 34.597 | 34.44 | 34.57 | 8714000.0 |
| 2004-08-27 10:00:00 | QQQ | ETF | 34.56 | 34.64 | 34.5 | 34.6 | 8024500.0 |
| 2004-08-27 10:30:00 | QQQ | ETF | 34.6 | 34.63 | 34.51 | 34.57 | 3944300.0 |
| 2004-08-27 11:00:00 | QQQ | ETF | 34.57 | 34.618 | 34.54 | 34.593 | 2927800.0 |
| 2004-08-27 11:30:00 | QQQ | ETF | 34.59 | 34.68 | 34.54 | 34.56 | 3765300.0 |
| 2004-08-27 12:00:00 | QQQ | ETF | 34.56 | 34.59 | 34.52 | 34.55 | 2159200.0 |
| 2004-08-27 12:30:00 | QQQ | ETF | 34.55 | 34.59 | 34.53 | 34.56 | 2321100.0 |
| 2004-08-27 13:00:00 | QQQ | ETF | 34.56 | 34.65 | 34.55 | 34.585 | 4466800.0 |
| 2004-08-27 13:30:00 | QQQ | ETF | 34.59 | 34.61 | 34.56 | 34.59 | 1911400.0 |
| 2004-08-27 14:00:00 | QQQ | ETF | 34.593 | 34.659 | 34.54 | 34.57 | 3781700.0 |
| 2004-08-27 14:30:00 | QQQ | ETF | 34.57 | 34.65 | 34.55 | 34.63 | 3728800.0 |
| 2004-08-27 15:00:00 | QQQ | ETF | 34.63 | 34.64 | 34.55 | 34.558 | 3312200.0 |
| 2004-08-27 15:30:00 | QQQ | ETF | 34.56 | 34.58 | 34.48 | 34.56 | 6124600.0 |
| 2004-08-27 16:00:00 | QQQ | ETF | 34.56 | 34.59 | 34.485 | 34.57 | 2000400.0 |
| 2004-08-27 16:30:00 | QQQ | ETF | 34.553 | 34.57 | 34.54 | 34.54 | 33600.0 |
| 2004-08-27 17:00:00 | QQQ | ETF | 34.54 | 34.54 | 34.52 | 34.53 | 26600.0 |
| 2004-08-27 17:30:00 | QQQ | ETF | 34.53 | 34.53 | 34.511 | 34.52 | 17500.0 |
| 2004-08-27 18:00:00 | QQQ | ETF | 34.54 | 34.55 | 34.53 | 34.54 | 8000.0 |
| 2004-08-27 19:00:00 | QQQ | ETF | 34.53 | 34.54 | 34.53 | 34.54 | 600.0 |
| 2004-08-27 19:30:00 | QQQ | ETF | 34.54 | 34.56 | 34.54 | 34.56 | 600.0 |
| 2004-08-27 08:30:00 | IWM | ETF | 54.5 | 54.5 | 54.5 | 54.5 | 12000.0 |
| 2004-08-27 09:30:00 | IWM | ETF | 54.575 | 54.83 | 54.575 | 54.8 | 986000.0 |
| 2004-08-27 10:00:00 | IWM | ETF | 54.805 | 54.875 | 54.715 | 54.765 | 1124400.0 |
| 2004-08-27 10:30:00 | IWM | ETF | 54.77 | 54.81 | 54.7 | 54.775 | 409400.0 |
> showing 50 of 1,103 rows — these rows as CSV