PREVIEW / etf_30min / 2002-09-04
file: by_date/etf_30min/2002/2002-09-04.parquet size: 20 KB rows: 575
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-04 09:30:00 | SPY | ETF | 88.61 | 89.27 | 88.25 | 89.23 | 7569200.0 |
| 2002-09-04 10:00:00 | SPY | ETF | 89.23 | 89.38 | 88.6 | 88.76 | 5514100.0 |
| 2002-09-04 10:30:00 | SPY | ETF | 88.77 | 89.12 | 88.41 | 88.62 | 4247000.0 |
| 2002-09-04 11:00:00 | SPY | ETF | 88.58 | 88.87 | 88.3 | 88.7 | 1991300.0 |
| 2002-09-04 11:30:00 | SPY | ETF | 88.72 | 88.99 | 88.62 | 88.72 | 1714900.0 |
| 2002-09-04 12:00:00 | SPY | ETF | 88.72 | 88.79 | 88.06 | 88.2 | 4134100.0 |
| 2002-09-04 12:30:00 | SPY | ETF | 88.2 | 88.7 | 88.11 | 88.61 | 1815600.0 |
| 2002-09-04 13:00:00 | SPY | ETF | 88.61 | 89.1 | 88.44 | 88.94 | 1935000.0 |
| 2002-09-04 13:30:00 | SPY | ETF | 88.96 | 89.09 | 88.67 | 88.79 | 2235200.0 |
| 2002-09-04 14:00:00 | SPY | ETF | 88.79 | 89.54 | 88.77 | 89.38 | 3984700.0 |
| 2002-09-04 14:30:00 | SPY | ETF | 89.37 | 89.9 | 89.08 | 89.7 | 3254400.0 |
| 2002-09-04 15:00:00 | SPY | ETF | 89.68 | 90.0 | 89.57 | 89.8 | 3867900.0 |
| 2002-09-04 15:30:00 | SPY | ETF | 89.83 | 90.25 | 89.57 | 89.74 | 3822100.0 |
| 2002-09-04 16:00:00 | SPY | ETF | 89.73 | 89.8 | 89.32 | 89.54 | 1523500.0 |
| 2002-09-04 09:30:00 | QQQ | ETF | 22.5 | 22.85 | 22.42 | 22.84 | 12809900.0 |
| 2002-09-04 10:00:00 | QQQ | ETF | 22.84 | 22.9 | 22.58 | 22.68 | 8872200.0 |
| 2002-09-04 10:30:00 | QQQ | ETF | 22.68 | 22.76 | 22.51 | 22.56 | 4684400.0 |
| 2002-09-04 11:00:00 | QQQ | ETF | 22.56 | 22.67 | 22.43 | 22.59 | 4382300.0 |
| 2002-09-04 11:30:00 | QQQ | ETF | 22.57 | 22.69 | 22.51 | 22.54 | 2500800.0 |
| 2002-09-04 12:00:00 | QQQ | ETF | 22.54 | 22.54 | 22.26 | 22.34 | 5948500.0 |
| 2002-09-04 12:30:00 | QQQ | ETF | 22.35 | 22.49 | 22.24 | 22.45 | 4358500.0 |
| 2002-09-04 13:00:00 | QQQ | ETF | 22.43 | 22.57 | 22.32 | 22.54 | 3482700.0 |
| 2002-09-04 13:30:00 | QQQ | ETF | 22.53 | 22.6 | 22.44 | 22.47 | 4846600.0 |
| 2002-09-04 14:00:00 | QQQ | ETF | 22.45 | 22.84 | 22.45 | 22.79 | 6561900.0 |
| 2002-09-04 14:30:00 | QQQ | ETF | 22.79 | 22.93 | 22.61 | 22.88 | 6943500.0 |
| 2002-09-04 15:00:00 | QQQ | ETF | 22.88 | 22.98 | 22.82 | 22.91 | 6724300.0 |
| 2002-09-04 15:30:00 | QQQ | ETF | 22.92 | 23.02 | 22.82 | 22.85 | 7387200.0 |
| 2002-09-04 16:00:00 | QQQ | ETF | 22.85 | 22.89 | 22.72 | 22.73 | 601600.0 |
| 2002-09-04 09:30:00 | IWM | ETF | 37.85 | 38.205 | 37.725 | 38.195 | 89000.0 |
| 2002-09-04 10:00:00 | IWM | ETF | 38.08 | 38.245 | 37.87 | 37.925 | 319400.0 |
| 2002-09-04 10:30:00 | IWM | ETF | 37.97 | 38.02 | 37.825 | 37.87 | 136400.0 |
| 2002-09-04 11:00:00 | IWM | ETF | 37.92 | 37.99 | 37.83 | 37.95 | 91400.0 |
| 2002-09-04 11:30:00 | IWM | ETF | 37.95 | 38.05 | 37.95 | 37.99 | 64800.0 |
| 2002-09-04 12:00:00 | IWM | ETF | 38.05 | 38.05 | 37.94 | 37.99 | 26800.0 |
| 2002-09-04 12:30:00 | IWM | ETF | 37.98 | 38.07 | 37.85 | 38.065 | 64200.0 |
| 2002-09-04 13:00:00 | IWM | ETF | 38.05 | 38.15 | 37.95 | 38.15 | 324200.0 |
| 2002-09-04 13:30:00 | IWM | ETF | 38.12 | 38.19 | 38.11 | 38.175 | 24600.0 |
| 2002-09-04 14:00:00 | IWM | ETF | 38.18 | 38.535 | 38.155 | 38.49 | 184600.0 |
| 2002-09-04 14:30:00 | IWM | ETF | 38.555 | 38.725 | 38.45 | 38.725 | 36400.0 |
| 2002-09-04 15:00:00 | IWM | ETF | 38.65 | 38.85 | 38.645 | 38.79 | 382400.0 |
| 2002-09-04 15:30:00 | IWM | ETF | 38.825 | 38.9 | 38.7 | 38.735 | 76600.0 |
| 2002-09-04 16:00:00 | IWM | ETF | 38.7 | 38.7 | 38.675 | 38.675 | 2600.0 |
| 2002-09-04 09:30:00 | DIA | ETF | 83.59 | 84.0 | 83.04 | 83.93 | 1660900.0 |
| 2002-09-04 10:00:00 | DIA | ETF | 83.91 | 83.99 | 83.47 | 83.7 | 1265400.0 |
| 2002-09-04 10:30:00 | DIA | ETF | 83.69 | 83.94 | 83.3 | 83.47 | 700600.0 |
| 2002-09-04 11:00:00 | DIA | ETF | 83.47 | 83.72 | 83.14 | 83.57 | 676600.0 |
| 2002-09-04 11:30:00 | DIA | ETF | 83.57 | 83.8 | 83.47 | 83.54 | 376100.0 |
| 2002-09-04 12:00:00 | DIA | ETF | 83.55 | 83.59 | 82.95 | 83.08 | 739500.0 |
| 2002-09-04 12:30:00 | DIA | ETF | 83.01 | 83.49 | 83.01 | 83.38 | 785800.0 |
| 2002-09-04 13:00:00 | DIA | ETF | 83.41 | 83.86 | 83.23 | 83.67 | 820400.0 |
> showing 50 of 575 rows — these rows as CSV