PREVIEW / etf_30min / 2002-06-11
file: by_date/etf_30min/2002/2002-06-11.parquet size: 19 KB rows: 514
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 |
|---|---|---|---|---|---|---|---|
| 2002-06-11 09:30:00 | SPY | ETF | 104.13 | 104.44 | 103.88 | 104.04 | 2198300.0 |
| 2002-06-11 10:00:00 | SPY | ETF | 103.98 | 104.34 | 103.77 | 104.2 | 1230100.0 |
| 2002-06-11 10:30:00 | SPY | ETF | 104.2 | 104.47 | 103.93 | 104.31 | 891700.0 |
| 2002-06-11 11:00:00 | SPY | ETF | 104.32 | 104.54 | 104.03 | 104.07 | 719200.0 |
| 2002-06-11 11:30:00 | SPY | ETF | 104.07 | 104.14 | 103.9 | 103.96 | 399000.0 |
| 2002-06-11 12:00:00 | SPY | ETF | 103.94 | 104.07 | 103.56 | 103.6 | 687600.0 |
| 2002-06-11 12:30:00 | SPY | ETF | 103.6 | 103.71 | 103.19 | 103.22 | 1047300.0 |
| 2002-06-11 13:00:00 | SPY | ETF | 103.23 | 103.31 | 102.91 | 103.1 | 1038800.0 |
| 2002-06-11 13:30:00 | SPY | ETF | 103.1 | 103.37 | 103.07 | 103.19 | 1092800.0 |
| 2002-06-11 14:00:00 | SPY | ETF | 103.19 | 103.33 | 102.84 | 102.95 | 609700.0 |
| 2002-06-11 14:30:00 | SPY | ETF | 102.96 | 103.27 | 102.57 | 102.71 | 2023900.0 |
| 2002-06-11 15:00:00 | SPY | ETF | 102.7 | 102.7 | 102.11 | 102.2 | 2211000.0 |
| 2002-06-11 15:30:00 | SPY | ETF | 102.19 | 102.31 | 101.76 | 101.82 | 2656300.0 |
| 2002-06-11 16:00:00 | SPY | ETF | 101.87 | 102.05 | 101.73 | 101.92 | 1673700.0 |
| 2002-06-11 16:30:00 | SPY | ETF | 101.95 | 101.96 | 101.91 | 101.96 | 779300.0 |
| 2002-06-11 17:00:00 | SPY | ETF | 101.92 | 101.92 | 101.92 | 101.92 | 200.0 |
| 2002-06-11 18:00:00 | SPY | ETF | 101.87 | 101.96 | 101.87 | 101.96 | 1500.0 |
| 2002-06-11 09:30:00 | QQQ | ETF | 28.6 | 28.69 | 28.35 | 28.43 | 8662000.0 |
| 2002-06-11 10:00:00 | QQQ | ETF | 28.43 | 28.66 | 28.26 | 28.61 | 7560400.0 |
| 2002-06-11 10:30:00 | QQQ | ETF | 28.61 | 28.65 | 28.4 | 28.54 | 4802900.0 |
| 2002-06-11 11:00:00 | QQQ | ETF | 28.55 | 28.62 | 28.43 | 28.46 | 2802700.0 |
| 2002-06-11 11:30:00 | QQQ | ETF | 28.45 | 28.5 | 28.42 | 28.44 | 2575300.0 |
| 2002-06-11 12:00:00 | QQQ | ETF | 28.44 | 28.5 | 28.31 | 28.35 | 3038600.0 |
| 2002-06-11 12:30:00 | QQQ | ETF | 28.37 | 28.4 | 28.11 | 28.14 | 6191900.0 |
| 2002-06-11 13:00:00 | QQQ | ETF | 28.15 | 28.18 | 27.95 | 28.08 | 5860100.0 |
| 2002-06-11 13:30:00 | QQQ | ETF | 28.06 | 28.18 | 28.04 | 28.08 | 3272500.0 |
| 2002-06-11 14:00:00 | QQQ | ETF | 28.07 | 28.15 | 27.85 | 27.91 | 5256700.0 |
| 2002-06-11 14:30:00 | QQQ | ETF | 27.88 | 28.04 | 27.64 | 27.71 | 7879700.0 |
| 2002-06-11 15:00:00 | QQQ | ETF | 27.67 | 27.74 | 27.54 | 27.56 | 7547200.0 |
| 2002-06-11 15:30:00 | QQQ | ETF | 27.58 | 27.62 | 27.36 | 27.41 | 12912300.0 |
| 2002-06-11 16:00:00 | QQQ | ETF | 27.41 | 27.97 | 27.3 | 27.41 | 2834200.0 |
| 2002-06-11 16:30:00 | QQQ | ETF | 27.42 | 27.47 | 27.41 | 27.43 | 191400.0 |
| 2002-06-11 17:00:00 | QQQ | ETF | 27.43 | 27.46 | 27.41 | 27.44 | 35500.0 |
| 2002-06-11 17:30:00 | QQQ | ETF | 27.43 | 27.45 | 27.4 | 27.4 | 20600.0 |
| 2002-06-11 18:00:00 | QQQ | ETF | 27.4 | 27.44 | 27.36 | 27.42 | 15900.0 |
| 2002-06-11 09:30:00 | IWM | ETF | 47.0 | 47.095 | 46.88 | 46.93 | 58400.0 |
| 2002-06-11 10:00:00 | IWM | ETF | 46.89 | 47.03 | 46.78 | 46.925 | 145400.0 |
| 2002-06-11 10:30:00 | IWM | ETF | 46.925 | 47.0 | 46.9 | 46.945 | 168800.0 |
| 2002-06-11 11:00:00 | IWM | ETF | 46.955 | 47.0 | 46.9 | 46.945 | 143600.0 |
| 2002-06-11 11:30:00 | IWM | ETF | 46.875 | 46.875 | 46.745 | 46.745 | 120800.0 |
| 2002-06-11 12:00:00 | IWM | ETF | 46.745 | 46.82 | 46.615 | 46.625 | 63400.0 |
| 2002-06-11 12:30:00 | IWM | ETF | 46.625 | 46.715 | 46.525 | 46.525 | 75200.0 |
| 2002-06-11 13:00:00 | IWM | ETF | 46.51 | 46.51 | 46.385 | 46.43 | 61600.0 |
| 2002-06-11 13:30:00 | IWM | ETF | 46.505 | 46.565 | 46.5 | 46.505 | 46000.0 |
| 2002-06-11 14:00:00 | IWM | ETF | 46.535 | 46.535 | 46.44 | 46.44 | 54000.0 |
| 2002-06-11 14:30:00 | IWM | ETF | 46.435 | 46.49 | 46.235 | 46.235 | 121600.0 |
| 2002-06-11 15:00:00 | IWM | ETF | 46.27 | 46.29 | 46.155 | 46.155 | 331600.0 |
| 2002-06-11 15:30:00 | IWM | ETF | 46.195 | 46.215 | 46.07 | 46.075 | 434200.0 |
| 2002-06-11 16:00:00 | IWM | ETF | 46.07 | 46.075 | 46.0 | 46.05 | 277000.0 |
| 2002-06-11 17:00:00 | IWM | ETF | 46.135 | 46.135 | 46.135 | 46.135 | 765000.0 |
> showing 50 of 514 rows — these rows as CSV