PREVIEW / etf_30min / 2004-09-08
file: by_date/etf_30min/2004/2004-09-08.parquet size: 35 KB rows: 1,151
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-08 08:00:00 | SPY | ETF | 112.71 | 112.75 | 112.71 | 112.71 | 22300.0 |
| 2004-09-08 08:30:00 | SPY | ETF | 112.7 | 112.7 | 112.66 | 112.67 | 70200.0 |
| 2004-09-08 09:00:00 | SPY | ETF | 112.71 | 112.73 | 112.62 | 112.64 | 71100.0 |
| 2004-09-08 09:30:00 | SPY | ETF | 112.62 | 112.82 | 112.54 | 112.64 | 4160800.0 |
| 2004-09-08 10:00:00 | SPY | ETF | 112.62 | 113.06 | 112.62 | 113.01 | 3386900.0 |
| 2004-09-08 10:30:00 | SPY | ETF | 113.01 | 113.03 | 112.54 | 112.64 | 3997300.0 |
| 2004-09-08 11:00:00 | SPY | ETF | 112.64 | 112.8 | 112.58 | 112.68 | 1773500.0 |
| 2004-09-08 11:30:00 | SPY | ETF | 112.68 | 112.82 | 112.56 | 112.63 | 1036800.0 |
| 2004-09-08 12:00:00 | SPY | ETF | 112.63 | 112.74 | 112.46 | 112.51 | 1251400.0 |
| 2004-09-08 12:30:00 | SPY | ETF | 112.51 | 112.54 | 112.36 | 112.47 | 1829800.0 |
| 2004-09-08 13:00:00 | SPY | ETF | 112.47 | 112.72 | 112.46 | 112.67 | 2389500.0 |
| 2004-09-08 13:30:00 | SPY | ETF | 112.67 | 112.77 | 112.58 | 112.69 | 1179700.0 |
| 2004-09-08 14:00:00 | SPY | ETF | 112.68 | 112.82 | 112.59 | 112.69 | 1414300.0 |
| 2004-09-08 14:30:00 | SPY | ETF | 112.68 | 112.7 | 112.4 | 112.48 | 1464200.0 |
| 2004-09-08 15:00:00 | SPY | ETF | 112.47 | 112.5 | 112.31 | 112.43 | 2637300.0 |
| 2004-09-08 15:30:00 | SPY | ETF | 112.45 | 112.61 | 112.31 | 112.35 | 3385900.0 |
| 2004-09-08 16:00:00 | SPY | ETF | 112.35 | 112.6 | 112.3 | 112.53 | 966700.0 |
| 2004-09-08 16:30:00 | SPY | ETF | 112.55 | 112.59 | 112.54 | 112.55 | 68000.0 |
| 2004-09-08 17:00:00 | SPY | ETF | 112.54 | 112.54 | 112.52 | 112.54 | 35200.0 |
| 2004-09-08 17:30:00 | SPY | ETF | 112.55 | 112.59 | 112.55 | 112.57 | 4500.0 |
| 2004-09-08 18:00:00 | SPY | ETF | 112.56 | 112.57 | 112.56 | 112.56 | 2000.0 |
| 2004-09-08 18:30:00 | SPY | ETF | 112.56 | 112.56 | 112.55 | 112.55 | 600.0 |
| 2004-09-08 19:00:00 | SPY | ETF | 112.56 | 112.57 | 112.56 | 112.57 | 3600.0 |
| 2004-09-08 19:30:00 | SPY | ETF | 112.57 | 112.57 | 112.57 | 112.57 | 4000.0 |
| 2004-09-08 08:00:00 | QQQ | ETF | 34.34 | 34.39 | 34.34 | 34.36 | 28500.0 |
| 2004-09-08 08:30:00 | QQQ | ETF | 34.36 | 34.36 | 34.32 | 34.32 | 128900.0 |
| 2004-09-08 09:00:00 | QQQ | ETF | 34.32 | 34.34 | 34.3 | 34.31 | 149700.0 |
| 2004-09-08 09:30:00 | QQQ | ETF | 34.31 | 34.46 | 34.29 | 34.37 | 12473100.0 |
| 2004-09-08 10:00:00 | QQQ | ETF | 34.37 | 34.62 | 34.35 | 34.6 | 9881300.0 |
| 2004-09-08 10:30:00 | QQQ | ETF | 34.6 | 34.68 | 34.37 | 34.444 | 10093000.0 |
| 2004-09-08 11:00:00 | QQQ | ETF | 34.445 | 34.55 | 34.406 | 34.47 | 4781300.0 |
| 2004-09-08 11:30:00 | QQQ | ETF | 34.471 | 34.535 | 34.37 | 34.4 | 4441600.0 |
| 2004-09-08 12:00:00 | QQQ | ETF | 34.401 | 34.45 | 34.27 | 34.32 | 4975800.0 |
| 2004-09-08 12:30:00 | QQQ | ETF | 34.31 | 34.34 | 34.182 | 34.25 | 8292900.0 |
| 2004-09-08 13:00:00 | QQQ | ETF | 34.26 | 34.39 | 34.25 | 34.33 | 5124500.0 |
| 2004-09-08 13:30:00 | QQQ | ETF | 34.33 | 34.4 | 34.28 | 34.37 | 3785300.0 |
| 2004-09-08 14:00:00 | QQQ | ETF | 34.369 | 34.44 | 34.34 | 34.388 | 5180600.0 |
| 2004-09-08 14:30:00 | QQQ | ETF | 34.4 | 34.42 | 34.25 | 34.27 | 4770100.0 |
| 2004-09-08 15:00:00 | QQQ | ETF | 34.26 | 34.28 | 34.18 | 34.27 | 9173800.0 |
| 2004-09-08 15:30:00 | QQQ | ETF | 34.27 | 34.35 | 34.23 | 34.23 | 7721900.0 |
| 2004-09-08 16:00:00 | QQQ | ETF | 34.23 | 34.34 | 34.2 | 34.28 | 2761500.0 |
| 2004-09-08 16:30:00 | QQQ | ETF | 34.288 | 34.396 | 34.288 | 34.36 | 401300.0 |
| 2004-09-08 17:00:00 | QQQ | ETF | 34.36 | 34.38 | 34.34 | 34.36 | 320100.0 |
| 2004-09-08 17:30:00 | QQQ | ETF | 34.36 | 34.373 | 34.34 | 34.34 | 7100.0 |
| 2004-09-08 18:00:00 | QQQ | ETF | 34.37 | 34.37 | 34.34 | 34.34 | 23300.0 |
| 2004-09-08 18:30:00 | QQQ | ETF | 34.34 | 34.36 | 34.34 | 34.36 | 4100.0 |
| 2004-09-08 19:30:00 | QQQ | ETF | 34.35 | 34.35 | 34.34 | 34.34 | 6300.0 |
| 2004-09-08 09:00:00 | IWM | ETF | 56.04 | 56.04 | 56.04 | 56.04 | 1800.0 |
| 2004-09-08 09:30:00 | IWM | ETF | 56.02 | 56.26 | 56.02 | 56.125 | 847600.0 |
| 2004-09-08 10:00:00 | IWM | ETF | 56.125 | 56.535 | 56.075 | 56.515 | 1840400.0 |
> showing 50 of 1,151 rows — these rows as CSV