PREVIEW / etf_30min / 2002-07-23
file: by_date/etf_30min/2002/2002-07-23.parquet size: 20 KB rows: 547
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-23 09:30:00 | SPY | ETF | 82.55 | 83.24 | 81.95 | 82.99 | 7784100.0 |
| 2002-07-23 10:00:00 | SPY | ETF | 82.99 | 83.0 | 81.1 | 81.87 | 6912500.0 |
| 2002-07-23 10:30:00 | SPY | ETF | 81.82 | 82.53 | 81.5 | 81.88 | 4685100.0 |
| 2002-07-23 11:00:00 | SPY | ETF | 81.89 | 82.37 | 81.3 | 82.23 | 2833100.0 |
| 2002-07-23 11:30:00 | SPY | ETF | 82.29 | 82.33 | 81.53 | 81.75 | 2377700.0 |
| 2002-07-23 12:00:00 | SPY | ETF | 81.79 | 82.27 | 81.62 | 81.74 | 2140800.0 |
| 2002-07-23 12:30:00 | SPY | ETF | 81.75 | 81.8 | 80.94 | 81.16 | 4214100.0 |
| 2002-07-23 13:00:00 | SPY | ETF | 81.14 | 81.62 | 80.52 | 80.67 | 3221200.0 |
| 2002-07-23 13:30:00 | SPY | ETF | 80.7 | 81.03 | 79.88 | 80.67 | 6394800.0 |
| 2002-07-23 14:00:00 | SPY | ETF | 80.67 | 81.12 | 79.9 | 80.73 | 4286700.0 |
| 2002-07-23 14:30:00 | SPY | ETF | 80.79 | 81.83 | 80.52 | 80.61 | 6600900.0 |
| 2002-07-23 15:00:00 | SPY | ETF | 80.6 | 81.25 | 80.15 | 80.89 | 4262200.0 |
| 2002-07-23 15:30:00 | SPY | ETF | 80.85 | 81.4 | 79.75 | 80.0 | 5687300.0 |
| 2002-07-23 16:00:00 | SPY | ETF | 80.14 | 80.2 | 79.8 | 79.95 | 1785100.0 |
| 2002-07-23 09:30:00 | QQQ | ETF | 23.45 | 23.75 | 23.2 | 23.68 | 24381300.0 |
| 2002-07-23 10:00:00 | QQQ | ETF | 23.75 | 23.75 | 23.18 | 23.45 | 14172500.0 |
| 2002-07-23 10:30:00 | QQQ | ETF | 23.44 | 23.58 | 23.25 | 23.37 | 12803900.0 |
| 2002-07-23 11:00:00 | QQQ | ETF | 23.39 | 23.43 | 23.14 | 23.37 | 6060700.0 |
| 2002-07-23 11:30:00 | QQQ | ETF | 23.4 | 23.44 | 23.24 | 23.31 | 4729900.0 |
| 2002-07-23 12:00:00 | QQQ | ETF | 23.32 | 23.39 | 23.16 | 23.18 | 4870600.0 |
| 2002-07-23 12:30:00 | QQQ | ETF | 23.2 | 23.2 | 22.93 | 23.02 | 12602500.0 |
| 2002-07-23 13:00:00 | QQQ | ETF | 22.99 | 23.06 | 22.77 | 22.82 | 11060900.0 |
| 2002-07-23 13:30:00 | QQQ | ETF | 22.82 | 23.0 | 22.66 | 22.88 | 10810700.0 |
| 2002-07-23 14:00:00 | QQQ | ETF | 22.87 | 23.07 | 22.68 | 22.98 | 9661900.0 |
| 2002-07-23 14:30:00 | QQQ | ETF | 22.98 | 23.24 | 22.85 | 22.88 | 12169300.0 |
| 2002-07-23 15:00:00 | QQQ | ETF | 22.88 | 23.04 | 22.69 | 22.86 | 8274600.0 |
| 2002-07-23 15:30:00 | QQQ | ETF | 22.83 | 22.92 | 22.28 | 22.29 | 12945300.0 |
| 2002-07-23 16:00:00 | QQQ | ETF | 22.33 | 22.5 | 22.28 | 22.4 | 864900.0 |
| 2002-07-23 09:30:00 | IWM | ETF | 38.075 | 38.075 | 37.53 | 37.945 | 483000.0 |
| 2002-07-23 10:00:00 | IWM | ETF | 37.95 | 37.955 | 37.38 | 37.5 | 221000.0 |
| 2002-07-23 10:30:00 | IWM | ETF | 37.515 | 37.675 | 37.42 | 37.475 | 163200.0 |
| 2002-07-23 11:00:00 | IWM | ETF | 37.475 | 37.475 | 37.25 | 37.42 | 87600.0 |
| 2002-07-23 11:30:00 | IWM | ETF | 37.38 | 37.5 | 37.21 | 37.25 | 32800.0 |
| 2002-07-23 12:00:00 | IWM | ETF | 37.22 | 37.275 | 37.07 | 37.1 | 138800.0 |
| 2002-07-23 12:30:00 | IWM | ETF | 37.0 | 37.075 | 36.565 | 36.81 | 187000.0 |
| 2002-07-23 13:00:00 | IWM | ETF | 36.605 | 36.74 | 36.45 | 36.455 | 251400.0 |
| 2002-07-23 13:30:00 | IWM | ETF | 36.46 | 36.55 | 36.2 | 36.355 | 133600.0 |
| 2002-07-23 14:00:00 | IWM | ETF | 36.365 | 36.56 | 36.205 | 36.56 | 440200.0 |
| 2002-07-23 14:30:00 | IWM | ETF | 36.465 | 36.725 | 36.4 | 36.405 | 368400.0 |
| 2002-07-23 15:00:00 | IWM | ETF | 36.4 | 36.55 | 36.205 | 36.245 | 215200.0 |
| 2002-07-23 15:30:00 | IWM | ETF | 36.4 | 36.52 | 35.955 | 36.235 | 453000.0 |
| 2002-07-23 16:00:00 | IWM | ETF | 35.875 | 35.875 | 35.875 | 35.875 | 200.0 |
| 2002-07-23 09:30:00 | DIA | ETF | 78.33 | 79.21 | 77.8 | 78.96 | 2411300.0 |
| 2002-07-23 10:00:00 | DIA | ETF | 78.96 | 79.15 | 77.34 | 78.27 | 2158600.0 |
| 2002-07-23 10:30:00 | DIA | ETF | 78.45 | 78.99 | 77.84 | 78.37 | 1767500.0 |
| 2002-07-23 11:00:00 | DIA | ETF | 78.35 | 79.0 | 77.81 | 78.8 | 845900.0 |
| 2002-07-23 11:30:00 | DIA | ETF | 78.79 | 78.91 | 78.2 | 78.42 | 634600.0 |
| 2002-07-23 12:00:00 | DIA | ETF | 78.41 | 79.05 | 78.41 | 78.47 | 843100.0 |
| 2002-07-23 12:30:00 | DIA | ETF | 78.5 | 78.56 | 77.68 | 77.95 | 1234700.0 |
| 2002-07-23 13:00:00 | DIA | ETF | 77.98 | 78.2 | 77.5 | 77.7 | 775600.0 |
> showing 50 of 547 rows — these rows as CSV