PREVIEW / etf_30min / 2002-09-18
file: by_date/etf_30min/2002/2002-09-18.parquet size: 20 KB rows: 569
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-18 09:30:00 | SPY | ETF | 87.01 | 87.51 | 86.81 | 87.29 | 6678900.0 |
| 2002-09-18 10:00:00 | SPY | ETF | 87.3 | 87.31 | 86.96 | 87.07 | 3109100.0 |
| 2002-09-18 10:30:00 | SPY | ETF | 87.05 | 87.12 | 86.44 | 86.5 | 3853800.0 |
| 2002-09-18 11:00:00 | SPY | ETF | 86.5 | 86.8 | 86.49 | 86.7 | 1839600.0 |
| 2002-09-18 11:30:00 | SPY | ETF | 86.68 | 86.73 | 86.28 | 86.53 | 2051100.0 |
| 2002-09-18 12:00:00 | SPY | ETF | 86.53 | 86.98 | 86.46 | 86.88 | 2554000.0 |
| 2002-09-18 12:30:00 | SPY | ETF | 86.85 | 86.89 | 86.51 | 86.54 | 1110100.0 |
| 2002-09-18 13:00:00 | SPY | ETF | 86.57 | 86.9 | 86.47 | 86.79 | 2329500.0 |
| 2002-09-18 13:30:00 | SPY | ETF | 86.78 | 87.35 | 86.74 | 87.11 | 4567700.0 |
| 2002-09-18 14:00:00 | SPY | ETF | 87.12 | 87.6 | 86.96 | 87.44 | 4141200.0 |
| 2002-09-18 14:30:00 | SPY | ETF | 87.43 | 88.11 | 87.42 | 87.92 | 3984100.0 |
| 2002-09-18 15:00:00 | SPY | ETF | 87.93 | 88.5 | 87.89 | 88.17 | 5432500.0 |
| 2002-09-18 15:30:00 | SPY | ETF | 88.17 | 88.34 | 87.4 | 87.49 | 5163400.0 |
| 2002-09-18 16:00:00 | SPY | ETF | 87.46 | 87.57 | 86.49 | 86.95 | 1755400.0 |
| 2002-09-18 09:30:00 | QQQ | ETF | 22.01 | 22.24 | 21.95 | 22.09 | 12601900.0 |
| 2002-09-18 10:00:00 | QQQ | ETF | 22.09 | 22.13 | 21.91 | 22.0 | 5778100.0 |
| 2002-09-18 10:30:00 | QQQ | ETF | 22.0 | 22.02 | 21.82 | 21.86 | 4944700.0 |
| 2002-09-18 11:00:00 | QQQ | ETF | 21.83 | 21.94 | 21.81 | 21.9 | 3548100.0 |
| 2002-09-18 11:30:00 | QQQ | ETF | 21.92 | 21.93 | 21.78 | 21.89 | 4211600.0 |
| 2002-09-18 12:00:00 | QQQ | ETF | 21.9 | 22.05 | 21.85 | 21.97 | 5026000.0 |
| 2002-09-18 12:30:00 | QQQ | ETF | 21.98 | 21.98 | 21.83 | 21.84 | 2284100.0 |
| 2002-09-18 13:00:00 | QQQ | ETF | 21.83 | 22.0 | 21.81 | 21.96 | 2915300.0 |
| 2002-09-18 13:30:00 | QQQ | ETF | 21.98 | 22.14 | 21.95 | 22.04 | 5333000.0 |
| 2002-09-18 14:00:00 | QQQ | ETF | 22.08 | 22.24 | 22.01 | 22.16 | 5723600.0 |
| 2002-09-18 14:30:00 | QQQ | ETF | 22.17 | 22.44 | 22.15 | 22.36 | 7477700.0 |
| 2002-09-18 15:00:00 | QQQ | ETF | 22.36 | 22.55 | 22.32 | 22.41 | 10297600.0 |
| 2002-09-18 15:30:00 | QQQ | ETF | 22.41 | 22.5 | 22.15 | 22.24 | 10974000.0 |
| 2002-09-18 16:00:00 | QQQ | ETF | 22.24 | 22.25 | 21.85 | 21.93 | 2121400.0 |
| 2002-09-18 09:30:00 | IWM | ETF | 37.325 | 37.665 | 37.3 | 37.63 | 491800.0 |
| 2002-09-18 10:00:00 | IWM | ETF | 37.53 | 37.53 | 37.34 | 37.365 | 86200.0 |
| 2002-09-18 10:30:00 | IWM | ETF | 37.355 | 37.365 | 37.155 | 37.155 | 121200.0 |
| 2002-09-18 11:00:00 | IWM | ETF | 37.16 | 37.3 | 37.155 | 37.3 | 100400.0 |
| 2002-09-18 11:30:00 | IWM | ETF | 37.285 | 37.285 | 37.185 | 37.275 | 31000.0 |
| 2002-09-18 12:00:00 | IWM | ETF | 37.27 | 37.375 | 37.235 | 37.3 | 40200.0 |
| 2002-09-18 12:30:00 | IWM | ETF | 37.28 | 37.28 | 37.125 | 37.125 | 45400.0 |
| 2002-09-18 13:00:00 | IWM | ETF | 37.145 | 37.225 | 37.1 | 37.175 | 26200.0 |
| 2002-09-18 13:30:00 | IWM | ETF | 37.21 | 37.325 | 37.19 | 37.205 | 124800.0 |
| 2002-09-18 14:00:00 | IWM | ETF | 37.205 | 37.405 | 37.205 | 37.405 | 93600.0 |
| 2002-09-18 14:30:00 | IWM | ETF | 37.45 | 37.635 | 37.4 | 37.625 | 81000.0 |
| 2002-09-18 15:00:00 | IWM | ETF | 37.595 | 37.85 | 37.595 | 37.715 | 501200.0 |
| 2002-09-18 15:30:00 | IWM | ETF | 37.765 | 37.81 | 37.425 | 37.425 | 354800.0 |
| 2002-09-18 16:00:00 | IWM | ETF | 37.775 | 37.775 | 37.775 | 37.775 | 600.0 |
| 2002-09-18 09:30:00 | DIA | ETF | 81.41 | 81.98 | 81.25 | 81.74 | 1843800.0 |
| 2002-09-18 10:00:00 | DIA | ETF | 81.7 | 81.75 | 81.44 | 81.45 | 665200.0 |
| 2002-09-18 10:30:00 | DIA | ETF | 81.47 | 81.49 | 80.86 | 80.99 | 816400.0 |
| 2002-09-18 11:00:00 | DIA | ETF | 80.99 | 81.29 | 80.93 | 81.19 | 545600.0 |
| 2002-09-18 11:30:00 | DIA | ETF | 81.2 | 81.25 | 80.77 | 81.03 | 469800.0 |
| 2002-09-18 12:00:00 | DIA | ETF | 81.02 | 81.57 | 80.95 | 81.33 | 1135700.0 |
| 2002-09-18 12:30:00 | DIA | ETF | 81.32 | 81.38 | 81.07 | 81.08 | 364800.0 |
| 2002-09-18 13:00:00 | DIA | ETF | 81.1 | 81.42 | 81.07 | 81.3 | 303400.0 |
> showing 50 of 569 rows — these rows as CSV