PREVIEW / etf_30min / 2002-10-18
file: by_date/etf_30min/2002/2002-10-18.parquet size: 22 KB rows: 615
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-18 08:00:00 | SPY | ETF | 87.51 | 87.77 | 87.51 | 87.75 | 9500.0 |
| 2002-10-18 08:30:00 | SPY | ETF | 87.59 | 87.65 | 87.41 | 87.62 | 7200.0 |
| 2002-10-18 09:00:00 | SPY | ETF | 87.62 | 87.7 | 87.62 | 87.62 | 5100.0 |
| 2002-10-18 09:30:00 | SPY | ETF | 87.65 | 87.85 | 87.02 | 87.13 | 6274600.0 |
| 2002-10-18 10:00:00 | SPY | ETF | 87.12 | 87.94 | 86.93 | 87.81 | 5379200.0 |
| 2002-10-18 10:30:00 | SPY | ETF | 87.85 | 88.5 | 87.7 | 88.32 | 4747500.0 |
| 2002-10-18 11:00:00 | SPY | ETF | 88.31 | 89.11 | 88.3 | 88.71 | 5362900.0 |
| 2002-10-18 11:30:00 | SPY | ETF | 88.72 | 88.88 | 88.43 | 88.59 | 3337800.0 |
| 2002-10-18 12:00:00 | SPY | ETF | 88.6 | 88.67 | 88.01 | 88.05 | 2329700.0 |
| 2002-10-18 12:30:00 | SPY | ETF | 88.06 | 88.29 | 88.0 | 88.13 | 1390000.0 |
| 2002-10-18 13:00:00 | SPY | ETF | 88.16 | 88.63 | 87.96 | 88.53 | 2085600.0 |
| 2002-10-18 13:30:00 | SPY | ETF | 88.53 | 88.76 | 88.44 | 88.54 | 1370200.0 |
| 2002-10-18 14:00:00 | SPY | ETF | 88.55 | 88.85 | 88.19 | 88.22 | 2104300.0 |
| 2002-10-18 14:30:00 | SPY | ETF | 88.2 | 88.69 | 88.2 | 88.43 | 2014800.0 |
| 2002-10-18 15:00:00 | SPY | ETF | 88.42 | 88.58 | 88.06 | 88.39 | 2666500.0 |
| 2002-10-18 15:30:00 | SPY | ETF | 88.38 | 88.74 | 88.34 | 88.7 | 2810800.0 |
| 2002-10-18 16:00:00 | SPY | ETF | 88.68 | 88.78 | 88.51 | 88.64 | 2786100.0 |
| 2002-10-18 16:30:00 | SPY | ETF | 88.6 | 88.76 | 87.12 | 88.59 | 318300.0 |
| 2002-10-18 17:00:00 | SPY | ETF | 88.45 | 88.6 | 87.7 | 88.6 | 39300.0 |
| 2002-10-18 17:30:00 | SPY | ETF | 88.6 | 88.65 | 88.6 | 88.63 | 7600.0 |
| 2002-10-18 18:00:00 | SPY | ETF | 88.56 | 88.68 | 88.55 | 88.64 | 3400.0 |
| 2002-10-18 18:30:00 | SPY | ETF | 88.64 | 88.64 | 88.64 | 88.64 | 500.0 |
| 2002-10-18 19:00:00 | SPY | ETF | 88.45 | 88.45 | 88.45 | 88.45 | 500.0 |
| 2002-10-18 19:30:00 | SPY | ETF | 88.45 | 88.45 | 88.45 | 88.45 | 400.0 |
| 2002-10-18 08:00:00 | QQQ | ETF | 23.56 | 23.56 | 23.08 | 23.22 | 64600.0 |
| 2002-10-18 08:30:00 | QQQ | ETF | 23.15 | 23.22 | 23.09 | 23.22 | 87200.0 |
| 2002-10-18 09:00:00 | QQQ | ETF | 23.24 | 23.36 | 23.24 | 23.33 | 39300.0 |
| 2002-10-18 09:30:00 | QQQ | ETF | 23.28 | 23.39 | 22.97 | 23.0 | 15131200.0 |
| 2002-10-18 10:00:00 | QQQ | ETF | 23.0 | 23.29 | 22.93 | 23.2 | 10280500.0 |
| 2002-10-18 10:30:00 | QQQ | ETF | 23.2 | 23.45 | 23.16 | 23.38 | 7242100.0 |
| 2002-10-18 11:00:00 | QQQ | ETF | 23.41 | 23.75 | 23.38 | 23.57 | 11229200.0 |
| 2002-10-18 11:30:00 | QQQ | ETF | 23.56 | 23.64 | 23.5 | 23.57 | 4160000.0 |
| 2002-10-18 12:00:00 | QQQ | ETF | 23.57 | 23.58 | 23.26 | 23.32 | 3965600.0 |
| 2002-10-18 12:30:00 | QQQ | ETF | 23.32 | 23.49 | 23.29 | 23.44 | 2553700.0 |
| 2002-10-18 13:00:00 | QQQ | ETF | 23.43 | 23.57 | 23.37 | 23.54 | 2625100.0 |
| 2002-10-18 13:30:00 | QQQ | ETF | 23.54 | 23.64 | 23.51 | 23.56 | 3507600.0 |
| 2002-10-18 14:00:00 | QQQ | ETF | 23.55 | 23.68 | 23.47 | 23.48 | 4023600.0 |
| 2002-10-18 14:30:00 | QQQ | ETF | 23.49 | 23.71 | 23.48 | 23.66 | 4101500.0 |
| 2002-10-18 15:00:00 | QQQ | ETF | 23.66 | 23.68 | 23.47 | 23.61 | 3942600.0 |
| 2002-10-18 15:30:00 | QQQ | ETF | 23.62 | 23.8 | 23.57 | 23.78 | 6477300.0 |
| 2002-10-18 16:00:00 | QQQ | ETF | 23.78 | 23.89 | 23.71 | 23.83 | 3779300.0 |
| 2002-10-18 16:30:00 | QQQ | ETF | 23.83 | 23.85 | 23.75 | 23.78 | 85100.0 |
| 2002-10-18 17:00:00 | QQQ | ETF | 23.8 | 23.81 | 23.76 | 23.81 | 22100.0 |
| 2002-10-18 17:30:00 | QQQ | ETF | 23.76 | 23.82 | 23.76 | 23.82 | 22200.0 |
| 2002-10-18 18:00:00 | QQQ | ETF | 23.81 | 23.88 | 23.81 | 23.88 | 37900.0 |
| 2002-10-18 19:00:00 | QQQ | ETF | 23.86 | 23.87 | 23.83 | 23.83 | 1500.0 |
| 2002-10-18 09:30:00 | IWM | ETF | 35.835 | 36.08 | 35.825 | 35.825 | 261600.0 |
| 2002-10-18 10:00:00 | IWM | ETF | 35.825 | 36.035 | 35.78 | 36.0 | 509600.0 |
| 2002-10-18 10:30:00 | IWM | ETF | 36.03 | 36.205 | 35.945 | 36.19 | 559600.0 |
| 2002-10-18 11:00:00 | IWM | ETF | 36.19 | 36.36 | 36.19 | 36.26 | 201000.0 |
> showing 50 of 615 rows — these rows as CSV