PREVIEW / etf_30min / 2002-06-20
file: by_date/etf_30min/2002/2002-06-20.parquet size: 18 KB rows: 470
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-20 09:30:00 | SPY | ETF | 102.26 | 102.87 | 102.25 | 102.79 | 2558600.0 |
| 2002-06-20 10:00:00 | SPY | ETF | 102.76 | 103.05 | 101.95 | 102.14 | 2614300.0 |
| 2002-06-20 10:30:00 | SPY | ETF | 102.17 | 102.22 | 101.71 | 101.96 | 1448000.0 |
| 2002-06-20 11:00:00 | SPY | ETF | 101.97 | 102.24 | 101.84 | 102.12 | 1083500.0 |
| 2002-06-20 11:30:00 | SPY | ETF | 102.13 | 102.18 | 101.66 | 101.8 | 671600.0 |
| 2002-06-20 12:00:00 | SPY | ETF | 101.81 | 102.58 | 101.75 | 101.91 | 3016200.0 |
| 2002-06-20 12:30:00 | SPY | ETF | 101.92 | 102.13 | 101.52 | 102.0 | 1645500.0 |
| 2002-06-20 13:00:00 | SPY | ETF | 102.03 | 102.25 | 102.0 | 102.07 | 648400.0 |
| 2002-06-20 13:30:00 | SPY | ETF | 102.08 | 102.14 | 101.77 | 101.95 | 679900.0 |
| 2002-06-20 14:00:00 | SPY | ETF | 101.93 | 102.25 | 101.76 | 102.14 | 950800.0 |
| 2002-06-20 14:30:00 | SPY | ETF | 102.11 | 102.37 | 101.89 | 102.04 | 1776900.0 |
| 2002-06-20 15:00:00 | SPY | ETF | 102.01 | 102.08 | 101.41 | 101.52 | 1443800.0 |
| 2002-06-20 15:30:00 | SPY | ETF | 101.49 | 101.65 | 100.96 | 101.2 | 3993500.0 |
| 2002-06-20 16:00:00 | SPY | ETF | 101.19 | 101.31 | 101.12 | 101.3 | 2072600.0 |
| 2002-06-20 16:30:00 | SPY | ETF | 101.3 | 101.3 | 101.29 | 101.29 | 11000.0 |
| 2002-06-20 17:00:00 | SPY | ETF | 101.24 | 101.3 | 101.24 | 101.3 | 21600.0 |
| 2002-06-20 17:30:00 | SPY | ETF | 101.27 | 101.27 | 101.27 | 101.27 | 1000.0 |
| 2002-06-20 18:00:00 | SPY | ETF | 101.35 | 101.35 | 101.1 | 101.1 | 70400.0 |
| 2002-06-20 09:30:00 | QQQ | ETF | 27.27 | 27.45 | 27.16 | 27.25 | 11644800.0 |
| 2002-06-20 10:00:00 | QQQ | ETF | 27.23 | 27.39 | 26.76 | 26.9 | 12164600.0 |
| 2002-06-20 10:30:00 | QQQ | ETF | 26.9 | 26.94 | 26.67 | 26.87 | 7325200.0 |
| 2002-06-20 11:00:00 | QQQ | ETF | 26.87 | 26.98 | 26.8 | 26.88 | 5503000.0 |
| 2002-06-20 11:30:00 | QQQ | ETF | 26.87 | 26.9 | 26.75 | 26.81 | 4713100.0 |
| 2002-06-20 12:00:00 | QQQ | ETF | 26.81 | 27.06 | 26.72 | 26.79 | 10993700.0 |
| 2002-06-20 12:30:00 | QQQ | ETF | 26.77 | 26.88 | 26.68 | 26.82 | 5469100.0 |
| 2002-06-20 13:00:00 | QQQ | ETF | 26.8 | 26.95 | 26.8 | 26.82 | 3277400.0 |
| 2002-06-20 13:30:00 | QQQ | ETF | 26.82 | 26.85 | 26.67 | 26.72 | 3688400.0 |
| 2002-06-20 14:00:00 | QQQ | ETF | 26.72 | 26.9 | 26.6 | 26.8 | 4897900.0 |
| 2002-06-20 14:30:00 | QQQ | ETF | 26.79 | 26.89 | 26.67 | 26.8 | 4378800.0 |
| 2002-06-20 15:00:00 | QQQ | ETF | 26.8 | 26.84 | 26.51 | 26.55 | 7644300.0 |
| 2002-06-20 15:30:00 | QQQ | ETF | 26.53 | 26.56 | 26.3 | 26.46 | 10790700.0 |
| 2002-06-20 16:00:00 | QQQ | ETF | 26.46 | 26.54 | 26.43 | 26.44 | 2176300.0 |
| 2002-06-20 16:30:00 | QQQ | ETF | 26.44 | 26.48 | 26.39 | 26.42 | 104300.0 |
| 2002-06-20 17:00:00 | QQQ | ETF | 26.4 | 26.52 | 26.4 | 26.5 | 122300.0 |
| 2002-06-20 17:30:00 | QQQ | ETF | 26.46 | 26.55 | 26.46 | 26.5 | 12900.0 |
| 2002-06-20 18:00:00 | QQQ | ETF | 26.51 | 26.52 | 26.5 | 26.5 | 9900.0 |
| 2002-06-20 09:30:00 | IWM | ETF | 46.12 | 46.3 | 46.035 | 46.205 | 89200.0 |
| 2002-06-20 10:00:00 | IWM | ETF | 46.165 | 46.3 | 45.805 | 45.85 | 88800.0 |
| 2002-06-20 10:30:00 | IWM | ETF | 45.875 | 45.9 | 45.785 | 45.86 | 60600.0 |
| 2002-06-20 11:00:00 | IWM | ETF | 45.895 | 46.095 | 45.895 | 46.095 | 88800.0 |
| 2002-06-20 11:30:00 | IWM | ETF | 46.06 | 46.065 | 45.97 | 45.97 | 33600.0 |
| 2002-06-20 12:00:00 | IWM | ETF | 46.035 | 46.51 | 46.035 | 46.105 | 166200.0 |
| 2002-06-20 12:30:00 | IWM | ETF | 46.1 | 46.225 | 46.0 | 46.225 | 107800.0 |
| 2002-06-20 13:00:00 | IWM | ETF | 46.225 | 46.41 | 46.225 | 46.355 | 55800.0 |
| 2002-06-20 13:30:00 | IWM | ETF | 46.385 | 46.395 | 46.23 | 46.38 | 209000.0 |
| 2002-06-20 14:00:00 | IWM | ETF | 46.37 | 46.4 | 46.325 | 46.4 | 12600.0 |
| 2002-06-20 14:30:00 | IWM | ETF | 46.315 | 46.4 | 46.305 | 46.315 | 56800.0 |
| 2002-06-20 15:00:00 | IWM | ETF | 46.265 | 46.265 | 45.92 | 45.99 | 207000.0 |
| 2002-06-20 15:30:00 | IWM | ETF | 45.985 | 45.985 | 45.66 | 45.805 | 737600.0 |
| 2002-06-20 16:00:00 | IWM | ETF | 45.85 | 45.9 | 45.565 | 45.9 | 59400.0 |
> showing 50 of 470 rows — these rows as CSV