PREVIEW / etf_30min / 2002-10-29
file: by_date/etf_30min/2002/2002-10-29.parquet size: 22 KB rows: 618
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-10-29 08:00:00 | SPY | ETF | 89.26 | 89.34 | 89.25 | 89.34 | 1100.0 |
| 2002-10-29 08:30:00 | SPY | ETF | 89.2 | 89.26 | 89.2 | 89.26 | 2000.0 |
| 2002-10-29 09:00:00 | SPY | ETF | 89.22 | 89.23 | 89.1 | 89.15 | 8300.0 |
| 2002-10-29 09:30:00 | SPY | ETF | 89.08 | 89.49 | 88.84 | 89.05 | 4589100.0 |
| 2002-10-29 10:00:00 | SPY | ETF | 89.11 | 89.11 | 87.67 | 87.76 | 8829900.0 |
| 2002-10-29 10:30:00 | SPY | ETF | 87.83 | 87.88 | 87.0 | 87.58 | 7248700.0 |
| 2002-10-29 11:00:00 | SPY | ETF | 87.54 | 87.7 | 87.21 | 87.39 | 3442100.0 |
| 2002-10-29 11:30:00 | SPY | ETF | 87.36 | 87.74 | 87.34 | 87.63 | 2550700.0 |
| 2002-10-29 12:00:00 | SPY | ETF | 87.57 | 87.99 | 87.39 | 87.76 | 2779100.0 |
| 2002-10-29 12:30:00 | SPY | ETF | 87.76 | 87.76 | 87.37 | 87.44 | 1501200.0 |
| 2002-10-29 13:00:00 | SPY | ETF | 87.48 | 87.67 | 87.28 | 87.49 | 1286500.0 |
| 2002-10-29 13:30:00 | SPY | ETF | 87.55 | 87.99 | 87.5 | 87.83 | 2026400.0 |
| 2002-10-29 14:00:00 | SPY | ETF | 87.82 | 87.88 | 87.3 | 87.37 | 1984200.0 |
| 2002-10-29 14:30:00 | SPY | ETF | 87.44 | 87.84 | 87.17 | 87.64 | 3385600.0 |
| 2002-10-29 15:00:00 | SPY | ETF | 87.7 | 88.7 | 87.64 | 88.59 | 6022400.0 |
| 2002-10-29 15:30:00 | SPY | ETF | 88.6 | 89.1 | 88.36 | 88.6 | 5062900.0 |
| 2002-10-29 16:00:00 | SPY | ETF | 88.56 | 88.64 | 88.37 | 88.6 | 2159000.0 |
| 2002-10-29 16:30:00 | SPY | ETF | 88.57 | 88.7 | 88.55 | 88.63 | 53200.0 |
| 2002-10-29 17:00:00 | SPY | ETF | 88.58 | 88.65 | 88.55 | 88.65 | 516700.0 |
| 2002-10-29 17:30:00 | SPY | ETF | 88.64 | 88.8 | 88.64 | 88.8 | 16900.0 |
| 2002-10-29 18:00:00 | SPY | ETF | 88.8 | 88.82 | 88.66 | 88.75 | 12000.0 |
| 2002-10-29 19:30:00 | SPY | ETF | 88.8 | 88.8 | 88.71 | 88.71 | 2000.0 |
| 2002-10-29 08:00:00 | QQQ | ETF | 24.34 | 24.38 | 24.34 | 24.38 | 8000.0 |
| 2002-10-29 08:30:00 | QQQ | ETF | 24.38 | 24.38 | 24.35 | 24.35 | 6100.0 |
| 2002-10-29 09:00:00 | QQQ | ETF | 24.34 | 24.34 | 24.25 | 24.25 | 15600.0 |
| 2002-10-29 09:30:00 | QQQ | ETF | 24.31 | 24.47 | 24.15 | 24.26 | 9033500.0 |
| 2002-10-29 10:00:00 | QQQ | ETF | 24.26 | 24.26 | 23.71 | 23.78 | 16505000.0 |
| 2002-10-29 10:30:00 | QQQ | ETF | 23.79 | 23.8 | 23.48 | 23.61 | 8689800.0 |
| 2002-10-29 11:00:00 | QQQ | ETF | 23.63 | 23.7 | 23.48 | 23.53 | 4735100.0 |
| 2002-10-29 11:30:00 | QQQ | ETF | 23.51 | 23.64 | 23.49 | 23.56 | 2964900.0 |
| 2002-10-29 12:00:00 | QQQ | ETF | 23.57 | 23.68 | 23.48 | 23.63 | 3776200.0 |
| 2002-10-29 12:30:00 | QQQ | ETF | 23.66 | 23.67 | 23.49 | 23.51 | 4225900.0 |
| 2002-10-29 13:00:00 | QQQ | ETF | 23.53 | 23.59 | 23.44 | 23.55 | 3955100.0 |
| 2002-10-29 13:30:00 | QQQ | ETF | 23.55 | 23.7 | 23.53 | 23.63 | 3667300.0 |
| 2002-10-29 14:00:00 | QQQ | ETF | 23.62 | 23.66 | 23.45 | 23.48 | 3728000.0 |
| 2002-10-29 14:30:00 | QQQ | ETF | 23.48 | 23.54 | 23.37 | 23.51 | 4826300.0 |
| 2002-10-29 15:00:00 | QQQ | ETF | 23.53 | 23.9 | 23.5 | 23.85 | 7756900.0 |
| 2002-10-29 15:30:00 | QQQ | ETF | 23.85 | 24.03 | 23.8 | 23.91 | 8442300.0 |
| 2002-10-29 16:00:00 | QQQ | ETF | 23.9 | 23.93 | 23.83 | 23.86 | 1825900.0 |
| 2002-10-29 16:30:00 | QQQ | ETF | 23.85 | 23.9 | 23.84 | 23.9 | 59200.0 |
| 2002-10-29 17:00:00 | QQQ | ETF | 23.88 | 23.93 | 23.85 | 23.93 | 76600.0 |
| 2002-10-29 17:30:00 | QQQ | ETF | 23.95 | 24.0 | 23.92 | 23.99 | 160600.0 |
| 2002-10-29 18:00:00 | QQQ | ETF | 24.0 | 24.01 | 23.89 | 23.96 | 49300.0 |
| 2002-10-29 18:30:00 | QQQ | ETF | 23.99 | 24.0 | 23.99 | 24.0 | 500.0 |
| 2002-10-29 19:00:00 | QQQ | ETF | 24.02 | 24.03 | 24.02 | 24.02 | 1400.0 |
| 2002-10-29 19:30:00 | QQQ | ETF | 24.02 | 24.06 | 24.0 | 24.06 | 2700.0 |
| 2002-10-29 09:30:00 | IWM | ETF | 36.775 | 36.89 | 36.62 | 36.72 | 120600.0 |
| 2002-10-29 10:00:00 | IWM | ETF | 36.5 | 36.5 | 36.25 | 36.305 | 506600.0 |
| 2002-10-29 10:30:00 | IWM | ETF | 36.32 | 36.32 | 36.09 | 36.205 | 350400.0 |
| 2002-10-29 11:00:00 | IWM | ETF | 36.22 | 36.27 | 36.14 | 36.22 | 127600.0 |
> showing 50 of 618 rows — these rows as CSV