PREVIEW / etf_30min / 2002-09-24
file: by_date/etf_30min/2002/2002-09-24.parquet size: 21 KB rows: 601
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-09-24 09:30:00 | SPY | ETF | 82.44 | 83.06 | 82.3 | 82.49 | 5745300.0 |
| 2002-09-24 10:00:00 | SPY | ETF | 82.54 | 83.65 | 82.47 | 83.3 | 7623100.0 |
| 2002-09-24 10:30:00 | SPY | ETF | 83.42 | 83.45 | 82.82 | 82.84 | 3304900.0 |
| 2002-09-24 11:00:00 | SPY | ETF | 82.82 | 83.13 | 82.56 | 82.57 | 3755600.0 |
| 2002-09-24 11:30:00 | SPY | ETF | 82.55 | 82.96 | 82.53 | 82.9 | 1748100.0 |
| 2002-09-24 12:00:00 | SPY | ETF | 82.89 | 82.98 | 82.11 | 82.25 | 2401100.0 |
| 2002-09-24 12:30:00 | SPY | ETF | 82.25 | 82.55 | 82.19 | 82.46 | 2872000.0 |
| 2002-09-24 13:00:00 | SPY | ETF | 82.47 | 82.87 | 82.34 | 82.8 | 1422900.0 |
| 2002-09-24 13:30:00 | SPY | ETF | 82.82 | 83.25 | 82.77 | 83.15 | 2842700.0 |
| 2002-09-24 14:00:00 | SPY | ETF | 83.12 | 83.19 | 82.02 | 82.05 | 7924100.0 |
| 2002-09-24 14:30:00 | SPY | ETF | 82.05 | 82.87 | 82.0 | 82.74 | 7280600.0 |
| 2002-09-24 15:00:00 | SPY | ETF | 82.74 | 83.3 | 82.59 | 82.84 | 5196300.0 |
| 2002-09-24 15:30:00 | SPY | ETF | 82.8 | 82.85 | 81.85 | 82.15 | 6777500.0 |
| 2002-09-24 16:00:00 | SPY | ETF | 82.15 | 82.5 | 82.08 | 82.31 | 1408700.0 |
| 2002-09-24 09:30:00 | QQQ | ETF | 20.68 | 21.08 | 20.65 | 20.89 | 10899100.0 |
| 2002-09-24 10:00:00 | QQQ | ETF | 20.93 | 21.41 | 20.91 | 21.26 | 11160500.0 |
| 2002-09-24 10:30:00 | QQQ | ETF | 21.26 | 21.31 | 21.09 | 21.11 | 3669300.0 |
| 2002-09-24 11:00:00 | QQQ | ETF | 21.1 | 21.2 | 20.96 | 21.01 | 3387000.0 |
| 2002-09-24 11:30:00 | QQQ | ETF | 21.01 | 21.17 | 20.98 | 21.12 | 3332400.0 |
| 2002-09-24 12:00:00 | QQQ | ETF | 21.13 | 21.17 | 20.9 | 20.93 | 3002400.0 |
| 2002-09-24 12:30:00 | QQQ | ETF | 20.95 | 21.01 | 20.87 | 20.97 | 3682100.0 |
| 2002-09-24 13:00:00 | QQQ | ETF | 20.98 | 21.09 | 20.91 | 21.08 | 2118400.0 |
| 2002-09-24 13:30:00 | QQQ | ETF | 21.08 | 21.23 | 21.05 | 21.17 | 3357200.0 |
| 2002-09-24 14:00:00 | QQQ | ETF | 21.18 | 21.23 | 20.85 | 20.86 | 11934300.0 |
| 2002-09-24 14:30:00 | QQQ | ETF | 20.85 | 21.23 | 20.82 | 21.19 | 9538100.0 |
| 2002-09-24 15:00:00 | QQQ | ETF | 21.19 | 21.45 | 21.15 | 21.3 | 10656200.0 |
| 2002-09-24 15:30:00 | QQQ | ETF | 21.3 | 21.33 | 20.88 | 20.98 | 7487400.0 |
| 2002-09-24 16:00:00 | QQQ | ETF | 20.99 | 21.05 | 20.95 | 21.03 | 727700.0 |
| 2002-09-24 09:30:00 | IWM | ETF | 35.345 | 35.52 | 35.25 | 35.4 | 394000.0 |
| 2002-09-24 10:00:00 | IWM | ETF | 35.4 | 35.93 | 35.4 | 35.88 | 246400.0 |
| 2002-09-24 10:30:00 | IWM | ETF | 35.825 | 35.925 | 35.68 | 35.68 | 43800.0 |
| 2002-09-24 11:00:00 | IWM | ETF | 35.84 | 35.84 | 35.6 | 35.6 | 107800.0 |
| 2002-09-24 11:30:00 | IWM | ETF | 35.59 | 35.59 | 35.45 | 35.45 | 14200.0 |
| 2002-09-24 12:00:00 | IWM | ETF | 35.64 | 35.64 | 35.435 | 35.435 | 80800.0 |
| 2002-09-24 12:30:00 | IWM | ETF | 35.44 | 35.525 | 35.44 | 35.5 | 14600.0 |
| 2002-09-24 13:00:00 | IWM | ETF | 35.53 | 35.64 | 35.485 | 35.64 | 62800.0 |
| 2002-09-24 13:30:00 | IWM | ETF | 35.635 | 35.73 | 35.575 | 35.66 | 97400.0 |
| 2002-09-24 14:00:00 | IWM | ETF | 35.715 | 35.8 | 35.41 | 35.41 | 190400.0 |
| 2002-09-24 14:30:00 | IWM | ETF | 35.5 | 35.67 | 35.415 | 35.605 | 175400.0 |
| 2002-09-24 15:00:00 | IWM | ETF | 35.645 | 35.745 | 35.565 | 35.65 | 76800.0 |
| 2002-09-24 15:30:00 | IWM | ETF | 35.575 | 35.6 | 35.355 | 35.51 | 135400.0 |
| 2002-09-24 16:00:00 | IWM | ETF | 35.5 | 35.5 | 35.375 | 35.375 | 45400.0 |
| 2002-09-24 09:30:00 | DIA | ETF | 77.71 | 78.8 | 77.5 | 77.57 | 2049400.0 |
| 2002-09-24 10:00:00 | DIA | ETF | 77.55 | 78.59 | 77.55 | 78.3 | 2138800.0 |
| 2002-09-24 10:30:00 | DIA | ETF | 78.3 | 78.42 | 77.92 | 78.05 | 427600.0 |
| 2002-09-24 11:00:00 | DIA | ETF | 77.93 | 78.12 | 77.61 | 77.61 | 989600.0 |
| 2002-09-24 11:30:00 | DIA | ETF | 77.62 | 77.89 | 77.54 | 77.89 | 373200.0 |
| 2002-09-24 12:00:00 | DIA | ETF | 77.89 | 77.95 | 77.12 | 77.25 | 1015800.0 |
| 2002-09-24 12:30:00 | DIA | ETF | 77.27 | 77.57 | 77.17 | 77.53 | 518900.0 |
| 2002-09-24 13:00:00 | DIA | ETF | 77.52 | 77.79 | 77.3 | 77.74 | 576600.0 |
> showing 50 of 601 rows — these rows as CSV