PREVIEW / etf_30min / 2002-07-22
file: by_date/etf_30min/2002/2002-07-22.parquet size: 21 KB rows: 574
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-07-22 09:30:00 | SPY | ETF | 84.1 | 85.91 | 84.0 | 85.06 | 9624300.0 |
| 2002-07-22 10:00:00 | SPY | ETF | 85.06 | 85.33 | 84.04 | 84.25 | 4856900.0 |
| 2002-07-22 10:30:00 | SPY | ETF | 84.32 | 84.83 | 83.98 | 84.3 | 2906300.0 |
| 2002-07-22 11:00:00 | SPY | ETF | 84.39 | 84.5 | 82.97 | 83.11 | 4168800.0 |
| 2002-07-22 11:30:00 | SPY | ETF | 83.11 | 83.23 | 82.15 | 82.61 | 6499700.0 |
| 2002-07-22 12:00:00 | SPY | ETF | 82.63 | 82.97 | 82.15 | 82.21 | 3165100.0 |
| 2002-07-22 12:30:00 | SPY | ETF | 82.26 | 82.71 | 81.45 | 82.56 | 7556900.0 |
| 2002-07-22 13:00:00 | SPY | ETF | 82.64 | 83.25 | 82.17 | 82.71 | 5268600.0 |
| 2002-07-22 13:30:00 | SPY | ETF | 82.75 | 84.64 | 82.73 | 84.64 | 8040900.0 |
| 2002-07-22 14:00:00 | SPY | ETF | 84.65 | 84.8 | 83.55 | 84.0 | 4376700.0 |
| 2002-07-22 14:30:00 | SPY | ETF | 83.99 | 84.04 | 82.9 | 83.05 | 3927300.0 |
| 2002-07-22 15:00:00 | SPY | ETF | 83.01 | 84.02 | 82.45 | 83.65 | 4142500.0 |
| 2002-07-22 15:30:00 | SPY | ETF | 83.67 | 84.11 | 82.03 | 82.21 | 6798400.0 |
| 2002-07-22 16:00:00 | SPY | ETF | 82.26 | 82.5 | 82.08 | 82.2 | 1789300.0 |
| 2002-07-22 09:30:00 | QQQ | ETF | 23.85 | 24.48 | 23.77 | 24.06 | 19696000.0 |
| 2002-07-22 10:00:00 | QQQ | ETF | 24.05 | 24.15 | 23.61 | 23.71 | 12472900.0 |
| 2002-07-22 10:30:00 | QQQ | ETF | 23.7 | 23.99 | 23.64 | 23.82 | 7075700.0 |
| 2002-07-22 11:00:00 | QQQ | ETF | 23.83 | 23.85 | 23.37 | 23.46 | 8723600.0 |
| 2002-07-22 11:30:00 | QQQ | ETF | 23.45 | 23.54 | 23.1 | 23.35 | 11202100.0 |
| 2002-07-22 12:00:00 | QQQ | ETF | 23.35 | 23.54 | 23.17 | 23.27 | 8839000.0 |
| 2002-07-22 12:30:00 | QQQ | ETF | 23.29 | 23.65 | 23.09 | 23.59 | 12048500.0 |
| 2002-07-22 13:00:00 | QQQ | ETF | 23.57 | 23.71 | 23.34 | 23.4 | 8421400.0 |
| 2002-07-22 13:30:00 | QQQ | ETF | 23.43 | 24.07 | 23.4 | 24.01 | 16827400.0 |
| 2002-07-22 14:00:00 | QQQ | ETF | 24.07 | 24.12 | 23.69 | 23.89 | 8994400.0 |
| 2002-07-22 14:30:00 | QQQ | ETF | 23.87 | 23.9 | 23.44 | 23.45 | 8961400.0 |
| 2002-07-22 15:00:00 | QQQ | ETF | 23.45 | 23.83 | 23.37 | 23.68 | 7778400.0 |
| 2002-07-22 15:30:00 | QQQ | ETF | 23.68 | 23.75 | 23.28 | 23.38 | 12143900.0 |
| 2002-07-22 16:00:00 | QQQ | ETF | 23.36 | 23.4 | 23.32 | 23.4 | 1416000.0 |
| 2002-07-22 09:30:00 | IWM | ETF | 38.3 | 38.895 | 38.3 | 38.745 | 192400.0 |
| 2002-07-22 10:00:00 | IWM | ETF | 38.745 | 38.75 | 38.39 | 38.395 | 232600.0 |
| 2002-07-22 10:30:00 | IWM | ETF | 38.37 | 38.51 | 38.26 | 38.345 | 86000.0 |
| 2002-07-22 11:00:00 | IWM | ETF | 38.34 | 38.405 | 37.85 | 37.975 | 99000.0 |
| 2002-07-22 11:30:00 | IWM | ETF | 37.97 | 38.0 | 37.575 | 37.745 | 272400.0 |
| 2002-07-22 12:00:00 | IWM | ETF | 37.745 | 37.745 | 37.475 | 37.475 | 231600.0 |
| 2002-07-22 12:30:00 | IWM | ETF | 37.475 | 37.475 | 37.3 | 37.46 | 426000.0 |
| 2002-07-22 13:00:00 | IWM | ETF | 37.485 | 37.6 | 37.38 | 37.55 | 180400.0 |
| 2002-07-22 13:30:00 | IWM | ETF | 37.52 | 38.105 | 37.52 | 38.105 | 278200.0 |
| 2002-07-22 14:00:00 | IWM | ETF | 38.115 | 38.275 | 37.985 | 38.05 | 471200.0 |
| 2002-07-22 14:30:00 | IWM | ETF | 38.1 | 38.185 | 37.9 | 38.015 | 142400.0 |
| 2002-07-22 15:00:00 | IWM | ETF | 38.015 | 38.05 | 37.825 | 38.05 | 99200.0 |
| 2002-07-22 15:30:00 | IWM | ETF | 38.05 | 38.05 | 37.625 | 37.705 | 243600.0 |
| 2002-07-22 16:00:00 | IWM | ETF | 37.75 | 37.95 | 37.725 | 37.855 | 19800.0 |
| 2002-07-22 09:30:00 | DIA | ETF | 79.37 | 81.49 | 79.25 | 80.44 | 2568200.0 |
| 2002-07-22 10:00:00 | DIA | ETF | 80.42 | 80.8 | 79.55 | 79.85 | 1736400.0 |
| 2002-07-22 10:30:00 | DIA | ETF | 79.83 | 80.68 | 79.58 | 80.1 | 1170300.0 |
| 2002-07-22 11:00:00 | DIA | ETF | 80.15 | 80.24 | 78.75 | 78.94 | 1683100.0 |
| 2002-07-22 11:30:00 | DIA | ETF | 79.0 | 79.0 | 77.83 | 78.45 | 2017500.0 |
| 2002-07-22 12:00:00 | DIA | ETF | 78.39 | 78.7 | 77.89 | 77.99 | 1339200.0 |
| 2002-07-22 12:30:00 | DIA | ETF | 77.97 | 78.4 | 77.1 | 78.2 | 2239200.0 |
| 2002-07-22 13:00:00 | DIA | ETF | 78.2 | 79.08 | 77.8 | 78.6 | 1481300.0 |
> showing 50 of 574 rows — these rows as CSV