PREVIEW / etf_30min / 2002-10-21
file: by_date/etf_30min/2002/2002-10-21.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-21 08:00:00 | SPY | ETF | 88.18 | 88.26 | 88.18 | 88.26 | 500.0 |
| 2002-10-21 08:30:00 | SPY | ETF | 88.17 | 88.17 | 88.03 | 88.03 | 1700.0 |
| 2002-10-21 09:00:00 | SPY | ETF | 88.09 | 88.1 | 88.09 | 88.1 | 300.0 |
| 2002-10-21 09:30:00 | SPY | ETF | 88.12 | 88.32 | 87.88 | 88.15 | 4211500.0 |
| 2002-10-21 10:00:00 | SPY | ETF | 88.15 | 88.24 | 87.57 | 88.05 | 3297000.0 |
| 2002-10-21 10:30:00 | SPY | ETF | 88.03 | 88.17 | 87.77 | 88.05 | 1421700.0 |
| 2002-10-21 11:00:00 | SPY | ETF | 88.06 | 88.76 | 88.02 | 88.67 | 3252500.0 |
| 2002-10-21 11:30:00 | SPY | ETF | 88.74 | 89.43 | 88.67 | 89.29 | 4313700.0 |
| 2002-10-21 12:00:00 | SPY | ETF | 89.3 | 89.62 | 89.18 | 89.57 | 2626200.0 |
| 2002-10-21 12:30:00 | SPY | ETF | 89.56 | 90.2 | 89.54 | 89.82 | 4012000.0 |
| 2002-10-21 13:00:00 | SPY | ETF | 89.8 | 90.03 | 89.68 | 90.0 | 2608500.0 |
| 2002-10-21 13:30:00 | SPY | ETF | 90.0 | 90.05 | 89.6 | 89.96 | 2069600.0 |
| 2002-10-21 14:00:00 | SPY | ETF | 89.93 | 90.28 | 89.78 | 90.08 | 3232200.0 |
| 2002-10-21 14:30:00 | SPY | ETF | 90.04 | 90.19 | 89.79 | 89.94 | 2533600.0 |
| 2002-10-21 15:00:00 | SPY | ETF | 89.94 | 90.19 | 89.58 | 90.15 | 3106200.0 |
| 2002-10-21 15:30:00 | SPY | ETF | 90.14 | 90.5 | 90.13 | 90.28 | 4179800.0 |
| 2002-10-21 16:00:00 | SPY | ETF | 90.29 | 90.37 | 90.14 | 90.22 | 2236700.0 |
| 2002-10-21 16:30:00 | SPY | ETF | 90.17 | 90.25 | 89.0 | 89.8 | 261100.0 |
| 2002-10-21 17:00:00 | SPY | ETF | 89.84 | 90.26 | 89.06 | 89.8 | 248200.0 |
| 2002-10-21 17:30:00 | SPY | ETF | 89.75 | 89.81 | 89.72 | 89.77 | 27000.0 |
| 2002-10-21 18:00:00 | SPY | ETF | 89.8 | 89.8 | 89.73 | 89.75 | 11100.0 |
| 2002-10-21 08:00:00 | QQQ | ETF | 23.56 | 23.56 | 23.54 | 23.54 | 10300.0 |
| 2002-10-21 08:30:00 | QQQ | ETF | 23.54 | 23.54 | 23.53 | 23.53 | 3000.0 |
| 2002-10-21 09:00:00 | QQQ | ETF | 23.54 | 23.54 | 23.52 | 23.52 | 2900.0 |
| 2002-10-21 09:30:00 | QQQ | ETF | 23.52 | 23.66 | 23.45 | 23.55 | 7968900.0 |
| 2002-10-21 10:00:00 | QQQ | ETF | 23.57 | 23.59 | 23.3 | 23.42 | 7816500.0 |
| 2002-10-21 10:30:00 | QQQ | ETF | 23.42 | 23.44 | 23.3 | 23.42 | 4600100.0 |
| 2002-10-21 11:00:00 | QQQ | ETF | 23.41 | 23.58 | 23.4 | 23.55 | 6447200.0 |
| 2002-10-21 11:30:00 | QQQ | ETF | 23.55 | 23.82 | 23.53 | 23.73 | 6613800.0 |
| 2002-10-21 12:00:00 | QQQ | ETF | 23.75 | 23.97 | 23.72 | 23.93 | 5502400.0 |
| 2002-10-21 12:30:00 | QQQ | ETF | 23.93 | 24.21 | 23.93 | 24.12 | 10267400.0 |
| 2002-10-21 13:00:00 | QQQ | ETF | 24.14 | 24.25 | 24.1 | 24.23 | 3946900.0 |
| 2002-10-21 13:30:00 | QQQ | ETF | 24.23 | 24.24 | 24.05 | 24.15 | 3358900.0 |
| 2002-10-21 14:00:00 | QQQ | ETF | 24.17 | 24.35 | 24.12 | 24.29 | 4291100.0 |
| 2002-10-21 14:30:00 | QQQ | ETF | 24.27 | 24.34 | 24.18 | 24.3 | 3285900.0 |
| 2002-10-21 15:00:00 | QQQ | ETF | 24.3 | 24.36 | 24.14 | 24.33 | 6217800.0 |
| 2002-10-21 15:30:00 | QQQ | ETF | 24.36 | 24.45 | 24.25 | 24.3 | 7165000.0 |
| 2002-10-21 16:00:00 | QQQ | ETF | 24.3 | 24.36 | 24.22 | 24.29 | 1970700.0 |
| 2002-10-21 16:30:00 | QQQ | ETF | 24.3 | 24.3 | 23.9 | 24.0 | 4155600.0 |
| 2002-10-21 17:00:00 | QQQ | ETF | 24.0 | 24.05 | 23.82 | 23.88 | 1211300.0 |
| 2002-10-21 17:30:00 | QQQ | ETF | 23.86 | 23.91 | 23.8 | 23.83 | 261800.0 |
| 2002-10-21 18:00:00 | QQQ | ETF | 23.9 | 23.93 | 23.8 | 23.87 | 70000.0 |
| 2002-10-21 18:30:00 | QQQ | ETF | 23.89 | 23.92 | 23.89 | 23.92 | 1100.0 |
| 2002-10-21 19:00:00 | QQQ | ETF | 23.9 | 23.9 | 23.89 | 23.9 | 1100.0 |
| 2002-10-21 19:30:00 | QQQ | ETF | 23.94 | 23.94 | 23.92 | 23.92 | 2400.0 |
| 2002-10-21 09:30:00 | IWM | ETF | 35.9 | 36.175 | 35.9 | 36.025 | 208400.0 |
| 2002-10-21 10:00:00 | IWM | ETF | 36.055 | 36.055 | 35.87 | 36.02 | 229000.0 |
| 2002-10-21 10:30:00 | IWM | ETF | 36.005 | 36.005 | 35.9 | 35.935 | 88200.0 |
| 2002-10-21 11:00:00 | IWM | ETF | 35.935 | 36.1 | 35.935 | 36.08 | 243800.0 |
| 2002-10-21 11:30:00 | IWM | ETF | 36.095 | 36.35 | 36.065 | 36.33 | 265800.0 |
> showing 50 of 618 rows — these rows as CSV