PREVIEW / etf_30min / 2004-05-28
file: by_date/etf_30min/2004/2004-05-28.parquet size: 33 KB rows: 1,153
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-28 08:00:00 | SPY | ETF | 112.63 | 112.63 | 112.52 | 112.52 | 14300.0 |
| 2004-05-28 08:30:00 | SPY | ETF | 112.56 | 112.9 | 112.56 | 112.88 | 238500.0 |
| 2004-05-28 09:00:00 | SPY | ETF | 112.89 | 112.89 | 112.68 | 112.73 | 36200.0 |
| 2004-05-28 09:30:00 | SPY | ETF | 112.73 | 112.8 | 112.48 | 112.56 | 3944500.0 |
| 2004-05-28 10:00:00 | SPY | ETF | 112.55 | 112.73 | 112.36 | 112.47 | 4347000.0 |
| 2004-05-28 10:30:00 | SPY | ETF | 112.44 | 112.55 | 112.37 | 112.51 | 1326500.0 |
| 2004-05-28 11:00:00 | SPY | ETF | 112.52 | 112.71 | 112.48 | 112.66 | 1034900.0 |
| 2004-05-28 11:30:00 | SPY | ETF | 112.65 | 112.7 | 112.49 | 112.54 | 799500.0 |
| 2004-05-28 12:00:00 | SPY | ETF | 112.56 | 112.78 | 112.53 | 112.61 | 754900.0 |
| 2004-05-28 12:30:00 | SPY | ETF | 112.6 | 112.65 | 112.52 | 112.58 | 625800.0 |
| 2004-05-28 13:00:00 | SPY | ETF | 112.57 | 112.65 | 112.53 | 112.58 | 794900.0 |
| 2004-05-28 13:30:00 | SPY | ETF | 112.58 | 112.61 | 112.44 | 112.55 | 670200.0 |
| 2004-05-28 14:00:00 | SPY | ETF | 112.54 | 112.75 | 112.52 | 112.69 | 571800.0 |
| 2004-05-28 14:30:00 | SPY | ETF | 112.69 | 112.72 | 112.6 | 112.66 | 648300.0 |
| 2004-05-28 15:00:00 | SPY | ETF | 112.67 | 112.75 | 112.51 | 112.71 | 1147100.0 |
| 2004-05-28 15:30:00 | SPY | ETF | 112.71 | 112.87 | 112.53 | 112.71 | 2427900.0 |
| 2004-05-28 16:00:00 | SPY | ETF | 112.7 | 112.93 | 112.62 | 112.9 | 2629900.0 |
| 2004-05-28 16:30:00 | SPY | ETF | 112.86 | 112.9 | 112.75 | 112.84 | 126500.0 |
| 2004-05-28 17:00:00 | SPY | ETF | 112.8 | 112.85 | 112.8 | 112.85 | 2600.0 |
| 2004-05-28 17:30:00 | SPY | ETF | 112.86 | 112.86 | 112.86 | 112.86 | 300.0 |
| 2004-05-28 18:00:00 | SPY | ETF | 112.86 | 112.89 | 112.86 | 112.89 | 400.0 |
| 2004-05-28 18:30:00 | SPY | ETF | 112.86 | 112.86 | 112.86 | 112.86 | 2000.0 |
| 2004-05-28 19:00:00 | SPY | ETF | 112.86 | 112.87 | 112.86 | 112.87 | 600.0 |
| 2004-05-28 19:30:00 | SPY | ETF | 112.9 | 112.9 | 112.9 | 112.9 | 600.0 |
| 2004-05-28 08:00:00 | QQQ | ETF | 36.35 | 36.36 | 36.34 | 36.34 | 76100.0 |
| 2004-05-28 08:30:00 | QQQ | ETF | 36.34 | 36.4 | 36.34 | 36.4 | 93700.0 |
| 2004-05-28 09:00:00 | QQQ | ETF | 36.39 | 36.4 | 36.38 | 36.39 | 33800.0 |
| 2004-05-28 09:30:00 | QQQ | ETF | 36.38 | 36.42 | 36.25 | 36.26 | 8478300.0 |
| 2004-05-28 10:00:00 | QQQ | ETF | 36.258 | 36.37 | 36.21 | 36.24 | 7243000.0 |
| 2004-05-28 10:30:00 | QQQ | ETF | 36.24 | 36.32 | 36.22 | 36.28 | 3629600.0 |
| 2004-05-28 11:00:00 | QQQ | ETF | 36.288 | 36.4 | 36.27 | 36.39 | 4445400.0 |
| 2004-05-28 11:30:00 | QQQ | ETF | 36.387 | 36.43 | 36.35 | 36.38 | 3264200.0 |
| 2004-05-28 12:00:00 | QQQ | ETF | 36.39 | 36.51 | 36.37 | 36.43 | 4182800.0 |
| 2004-05-28 12:30:00 | QQQ | ETF | 36.437 | 36.45 | 36.38 | 36.43 | 2481700.0 |
| 2004-05-28 13:00:00 | QQQ | ETF | 36.429 | 36.45 | 36.38 | 36.38 | 2252800.0 |
| 2004-05-28 13:30:00 | QQQ | ETF | 36.39 | 36.4 | 36.32 | 36.382 | 2639100.0 |
| 2004-05-28 14:00:00 | QQQ | ETF | 36.385 | 36.48 | 36.38 | 36.426 | 2535000.0 |
| 2004-05-28 14:30:00 | QQQ | ETF | 36.429 | 36.46 | 36.41 | 36.445 | 1892700.0 |
| 2004-05-28 15:00:00 | QQQ | ETF | 36.44 | 36.5 | 36.4 | 36.48 | 3519100.0 |
| 2004-05-28 15:30:00 | QQQ | ETF | 36.49 | 36.543 | 36.41 | 36.54 | 6095000.0 |
| 2004-05-28 16:00:00 | QQQ | ETF | 36.54 | 36.56 | 36.48 | 36.54 | 1625100.0 |
| 2004-05-28 16:30:00 | QQQ | ETF | 36.54 | 36.55 | 36.5 | 36.54 | 159100.0 |
| 2004-05-28 17:00:00 | QQQ | ETF | 36.549 | 36.56 | 36.54 | 36.54 | 18700.0 |
| 2004-05-28 17:30:00 | QQQ | ETF | 36.55 | 36.56 | 36.55 | 36.56 | 8500.0 |
| 2004-05-28 18:00:00 | QQQ | ETF | 36.55 | 36.57 | 36.55 | 36.57 | 13500.0 |
| 2004-05-28 18:30:00 | QQQ | ETF | 36.57 | 36.57 | 36.54 | 36.54 | 4500.0 |
| 2004-05-28 19:00:00 | QQQ | ETF | 36.57 | 36.57 | 36.57 | 36.57 | 2900.0 |
| 2004-05-28 19:30:00 | QQQ | ETF | 36.57 | 36.6 | 36.55 | 36.55 | 15600.0 |
| 2004-05-28 08:00:00 | IWM | ETF | 56.575 | 56.575 | 56.575 | 56.575 | 400.0 |
| 2004-05-28 08:30:00 | IWM | ETF | 56.635 | 56.635 | 56.635 | 56.635 | 2800.0 |
> showing 50 of 1,153 rows — these rows as CSV