PREVIEW / etf_30min / 2002-06-28
file: by_date/etf_30min/2002/2002-06-28.parquet size: 19 KB rows: 529
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-28 09:30:00 | SPY | ETF | 99.3 | 100.0 | 99.05 | 99.64 | 3569900.0 |
| 2002-06-28 10:00:00 | SPY | ETF | 99.7 | 100.5 | 99.45 | 100.11 | 2492900.0 |
| 2002-06-28 10:30:00 | SPY | ETF | 100.11 | 100.33 | 99.88 | 100.11 | 1103100.0 |
| 2002-06-28 11:00:00 | SPY | ETF | 100.14 | 100.25 | 99.9 | 100.11 | 593600.0 |
| 2002-06-28 11:30:00 | SPY | ETF | 100.13 | 100.25 | 99.9 | 100.19 | 757700.0 |
| 2002-06-28 12:00:00 | SPY | ETF | 100.2 | 100.44 | 100.08 | 100.31 | 762400.0 |
| 2002-06-28 12:30:00 | SPY | ETF | 100.32 | 100.4 | 99.96 | 100.07 | 643500.0 |
| 2002-06-28 13:00:00 | SPY | ETF | 100.13 | 100.32 | 100.06 | 100.15 | 514200.0 |
| 2002-06-28 13:30:00 | SPY | ETF | 100.15 | 100.34 | 100.0 | 100.23 | 678400.0 |
| 2002-06-28 14:00:00 | SPY | ETF | 100.21 | 100.48 | 100.16 | 100.18 | 746100.0 |
| 2002-06-28 14:30:00 | SPY | ETF | 100.18 | 100.2 | 99.42 | 99.7 | 1817800.0 |
| 2002-06-28 15:00:00 | SPY | ETF | 99.68 | 99.75 | 99.06 | 99.58 | 1561300.0 |
| 2002-06-28 15:30:00 | SPY | ETF | 99.57 | 99.68 | 99.08 | 99.25 | 2092900.0 |
| 2002-06-28 16:00:00 | SPY | ETF | 99.26 | 99.55 | 98.88 | 99.01 | 7488800.0 |
| 2002-06-28 16:30:00 | SPY | ETF | 98.99 | 99.26 | 98.95 | 99.26 | 34700.0 |
| 2002-06-28 17:30:00 | SPY | ETF | 98.83 | 98.83 | 98.83 | 98.83 | 100.0 |
| 2002-06-28 18:00:00 | SPY | ETF | 98.83 | 98.83 | 98.75 | 98.75 | 1300.0 |
| 2002-06-28 09:30:00 | QQQ | ETF | 26.03 | 26.55 | 26.02 | 26.35 | 11886300.0 |
| 2002-06-28 10:00:00 | QQQ | ETF | 26.35 | 26.68 | 26.28 | 26.43 | 9506900.0 |
| 2002-06-28 10:30:00 | QQQ | ETF | 26.43 | 26.55 | 26.35 | 26.48 | 5061600.0 |
| 2002-06-28 11:00:00 | QQQ | ETF | 26.49 | 26.58 | 26.39 | 26.46 | 3538200.0 |
| 2002-06-28 11:30:00 | QQQ | ETF | 26.46 | 26.55 | 26.4 | 26.53 | 2463700.0 |
| 2002-06-28 12:00:00 | QQQ | ETF | 26.53 | 26.7 | 26.49 | 26.65 | 3291200.0 |
| 2002-06-28 12:30:00 | QQQ | ETF | 26.67 | 26.75 | 26.51 | 26.62 | 6299700.0 |
| 2002-06-28 13:00:00 | QQQ | ETF | 26.61 | 26.69 | 26.4 | 26.41 | 3483000.0 |
| 2002-06-28 13:30:00 | QQQ | ETF | 26.43 | 26.57 | 26.31 | 26.42 | 2849500.0 |
| 2002-06-28 14:00:00 | QQQ | ETF | 26.45 | 26.62 | 26.38 | 26.39 | 2400600.0 |
| 2002-06-28 14:30:00 | QQQ | ETF | 26.45 | 26.45 | 26.04 | 26.22 | 5458000.0 |
| 2002-06-28 15:00:00 | QQQ | ETF | 26.23 | 26.27 | 25.85 | 26.1 | 10459800.0 |
| 2002-06-28 15:30:00 | QQQ | ETF | 26.09 | 26.23 | 25.95 | 26.1 | 6849100.0 |
| 2002-06-28 16:00:00 | QQQ | ETF | 26.1 | 26.2 | 26.04 | 26.07 | 2817100.0 |
| 2002-06-28 16:30:00 | QQQ | ETF | 26.07 | 26.23 | 26.0 | 26.01 | 545700.0 |
| 2002-06-28 17:00:00 | QQQ | ETF | 26.04 | 26.09 | 26.01 | 26.05 | 9500.0 |
| 2002-06-28 17:30:00 | QQQ | ETF | 26.06 | 26.09 | 26.02 | 26.07 | 9500.0 |
| 2002-06-28 18:00:00 | QQQ | ETF | 26.06 | 26.09 | 26.05 | 26.08 | 15500.0 |
| 2002-06-28 09:30:00 | IWM | ETF | 45.73 | 46.15 | 45.555 | 46.0 | 364200.0 |
| 2002-06-28 10:00:00 | IWM | ETF | 45.91 | 46.12 | 45.9 | 46.0 | 24800.0 |
| 2002-06-28 10:30:00 | IWM | ETF | 45.935 | 46.02 | 45.935 | 45.945 | 70200.0 |
| 2002-06-28 11:00:00 | IWM | ETF | 45.95 | 46.06 | 45.95 | 46.025 | 46000.0 |
| 2002-06-28 11:30:00 | IWM | ETF | 46.02 | 46.08 | 45.975 | 46.05 | 218600.0 |
| 2002-06-28 12:00:00 | IWM | ETF | 46.025 | 46.225 | 46.015 | 46.165 | 278600.0 |
| 2002-06-28 12:30:00 | IWM | ETF | 46.11 | 46.15 | 46.06 | 46.1 | 66200.0 |
| 2002-06-28 13:00:00 | IWM | ETF | 46.15 | 46.275 | 46.125 | 46.275 | 33400.0 |
| 2002-06-28 13:30:00 | IWM | ETF | 46.255 | 46.255 | 46.12 | 46.125 | 28800.0 |
| 2002-06-28 14:00:00 | IWM | ETF | 46.11 | 46.325 | 46.1 | 46.125 | 65200.0 |
| 2002-06-28 14:30:00 | IWM | ETF | 46.125 | 46.125 | 45.8 | 46.0 | 237800.0 |
| 2002-06-28 15:00:00 | IWM | ETF | 45.985 | 46.03 | 45.775 | 46.02 | 306400.0 |
| 2002-06-28 15:30:00 | IWM | ETF | 46.02 | 46.03 | 45.705 | 45.8 | 217600.0 |
| 2002-06-28 16:00:00 | IWM | ETF | 45.8 | 45.825 | 45.325 | 45.325 | 267600.0 |
| 2002-06-28 16:30:00 | IWM | ETF | 45.375 | 46.06 | 45.375 | 46.06 | 119400.0 |
> showing 50 of 529 rows — these rows as CSV