PREVIEW / etf_30min / 2004-06-08
file: by_date/etf_30min/2004/2004-06-08.parquet size: 35 KB rows: 1,167
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-06-08 08:00:00 | SPY | ETF | 114.53 | 114.53 | 114.48 | 114.5 | 7500.0 |
| 2004-06-08 08:30:00 | SPY | ETF | 114.49 | 114.5 | 114.46 | 114.48 | 31400.0 |
| 2004-06-08 09:00:00 | SPY | ETF | 114.49 | 114.5 | 114.29 | 114.37 | 119600.0 |
| 2004-06-08 09:30:00 | SPY | ETF | 114.39 | 114.48 | 114.24 | 114.26 | 5719600.0 |
| 2004-06-08 10:00:00 | SPY | ETF | 114.27 | 114.43 | 114.17 | 114.4 | 2813400.0 |
| 2004-06-08 10:30:00 | SPY | ETF | 114.4 | 114.56 | 114.37 | 114.44 | 1837100.0 |
| 2004-06-08 11:00:00 | SPY | ETF | 114.44 | 114.5 | 114.38 | 114.44 | 1285700.0 |
| 2004-06-08 11:30:00 | SPY | ETF | 114.44 | 114.46 | 114.3 | 114.42 | 1368500.0 |
| 2004-06-08 12:00:00 | SPY | ETF | 114.4 | 114.64 | 114.4 | 114.61 | 1477900.0 |
| 2004-06-08 12:30:00 | SPY | ETF | 114.61 | 114.63 | 114.51 | 114.59 | 833600.0 |
| 2004-06-08 13:00:00 | SPY | ETF | 114.58 | 114.65 | 114.48 | 114.56 | 935400.0 |
| 2004-06-08 13:30:00 | SPY | ETF | 114.56 | 114.73 | 114.52 | 114.7 | 2457300.0 |
| 2004-06-08 14:00:00 | SPY | ETF | 114.66 | 114.82 | 114.57 | 114.81 | 2003100.0 |
| 2004-06-08 14:30:00 | SPY | ETF | 114.81 | 114.92 | 114.7 | 114.77 | 2114500.0 |
| 2004-06-08 15:00:00 | SPY | ETF | 114.77 | 114.78 | 114.42 | 114.45 | 2043300.0 |
| 2004-06-08 15:30:00 | SPY | ETF | 114.44 | 114.86 | 114.38 | 114.85 | 3737500.0 |
| 2004-06-08 16:00:00 | SPY | ETF | 114.87 | 114.9 | 114.7186 | 114.89 | 1676000.0 |
| 2004-06-08 16:30:00 | SPY | ETF | 114.83 | 114.84 | 114.81 | 114.81 | 63000.0 |
| 2004-06-08 17:00:00 | SPY | ETF | 114.84 | 114.93 | 114.81 | 114.93 | 324400.0 |
| 2004-06-08 17:30:00 | SPY | ETF | 114.92 | 114.92 | 114.92 | 114.92 | 700.0 |
| 2004-06-08 18:00:00 | SPY | ETF | 114.92 | 114.93 | 114.89 | 114.89 | 5100.0 |
| 2004-06-08 18:30:00 | SPY | ETF | 114.9 | 114.9 | 114.9 | 114.9 | 300.0 |
| 2004-06-08 19:30:00 | SPY | ETF | 114.88 | 114.88 | 114.87 | 114.87 | 2400.0 |
| 2004-06-08 08:00:00 | QQQ | ETF | 36.99 | 36.99 | 36.95 | 36.98 | 63300.0 |
| 2004-06-08 08:30:00 | QQQ | ETF | 36.97 | 37.0 | 36.97 | 36.97 | 57000.0 |
| 2004-06-08 09:00:00 | QQQ | ETF | 36.98 | 36.98 | 36.9 | 36.91 | 317800.0 |
| 2004-06-08 09:30:00 | QQQ | ETF | 36.9 | 37.03 | 36.85 | 36.92 | 8726800.0 |
| 2004-06-08 10:00:00 | QQQ | ETF | 36.91 | 36.99 | 36.85 | 36.99 | 7987100.0 |
| 2004-06-08 10:30:00 | QQQ | ETF | 36.982 | 37.041 | 36.93 | 36.994 | 5715000.0 |
| 2004-06-08 11:00:00 | QQQ | ETF | 36.99 | 37.021 | 36.918 | 36.958 | 4183900.0 |
| 2004-06-08 11:30:00 | QQQ | ETF | 36.95 | 36.96 | 36.88 | 36.94 | 3335700.0 |
| 2004-06-08 12:00:00 | QQQ | ETF | 36.933 | 37.07 | 36.93 | 37.04 | 4651700.0 |
| 2004-06-08 12:30:00 | QQQ | ETF | 37.049 | 37.06 | 36.99 | 37.03 | 2919100.0 |
| 2004-06-08 13:00:00 | QQQ | ETF | 37.04 | 37.05 | 36.97 | 37.002 | 2370200.0 |
| 2004-06-08 13:30:00 | QQQ | ETF | 37.01 | 37.1 | 36.98 | 37.055 | 2945500.0 |
| 2004-06-08 14:00:00 | QQQ | ETF | 37.05 | 37.132 | 37.005 | 37.13 | 4041400.0 |
| 2004-06-08 14:30:00 | QQQ | ETF | 37.13 | 37.17 | 37.1 | 37.11 | 4879400.0 |
| 2004-06-08 15:00:00 | QQQ | ETF | 37.126 | 37.13 | 36.97 | 36.97 | 6022600.0 |
| 2004-06-08 15:30:00 | QQQ | ETF | 36.97 | 37.19 | 36.93 | 37.16 | 9501000.0 |
| 2004-06-08 16:00:00 | QQQ | ETF | 37.16 | 37.19 | 37.09 | 37.11 | 2970200.0 |
| 2004-06-08 16:30:00 | QQQ | ETF | 37.11 | 37.16 | 37.103 | 37.16 | 82300.0 |
| 2004-06-08 17:00:00 | QQQ | ETF | 37.113 | 37.17 | 37.11 | 37.13 | 393100.0 |
| 2004-06-08 17:30:00 | QQQ | ETF | 37.14 | 37.189 | 37.11 | 37.15 | 45400.0 |
| 2004-06-08 18:00:00 | QQQ | ETF | 37.129 | 37.15 | 37.12 | 37.12 | 33100.0 |
| 2004-06-08 19:00:00 | QQQ | ETF | 37.12 | 37.12 | 37.12 | 37.12 | 2700.0 |
| 2004-06-08 19:30:00 | QQQ | ETF | 37.1 | 37.1 | 37.1 | 37.1 | 1000.0 |
| 2004-06-08 08:00:00 | IWM | ETF | 57.525 | 57.55 | 57.525 | 57.55 | 1200.0 |
| 2004-06-08 08:30:00 | IWM | ETF | 57.6 | 57.6 | 57.6 | 57.6 | 400.0 |
| 2004-06-08 09:00:00 | IWM | ETF | 57.57 | 57.625 | 57.49 | 57.55 | 40400.0 |
| 2004-06-08 09:30:00 | IWM | ETF | 57.555 | 57.615 | 57.415 | 57.5 | 1242400.0 |
> showing 50 of 1,167 rows — these rows as CSV