PREVIEW / etf_1hour / 2002-04-22
file: by_date/etf_1hour/2002/2002-04-22.parquet size: 14 KB rows: 317
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-04-22 09:00:00 | SPY | ETF | 112.38 | 112.43 | 111.98 | 111.99 | 1905800.0 |
| 2002-04-22 10:00:00 | SPY | ETF | 112.0 | 112.08 | 111.5 | 111.8 | 2408500.0 |
| 2002-04-22 11:00:00 | SPY | ETF | 111.81 | 111.83 | 111.35 | 111.37 | 1154800.0 |
| 2002-04-22 12:00:00 | SPY | ETF | 111.38 | 111.52 | 111.21 | 111.26 | 1967400.0 |
| 2002-04-22 13:00:00 | SPY | ETF | 111.25 | 111.52 | 111.1 | 111.11 | 1151300.0 |
| 2002-04-22 14:00:00 | SPY | ETF | 111.12 | 111.26 | 110.88 | 111.0 | 2047600.0 |
| 2002-04-22 15:00:00 | SPY | ETF | 111.01 | 111.21 | 110.84 | 111.14 | 1643000.0 |
| 2002-04-22 16:00:00 | SPY | ETF | 111.14 | 111.22 | 111.0 | 111.0 | 690400.0 |
| 2002-04-22 17:00:00 | SPY | ETF | 111.11 | 111.16 | 111.1 | 111.1 | 3000.0 |
| 2002-04-22 18:00:00 | SPY | ETF | 111.06 | 111.16 | 111.06 | 111.1 | 1000.0 |
| 2002-04-22 09:00:00 | QQQ | ETF | 34.01 | 34.02 | 33.75 | 33.75 | 9741600.0 |
| 2002-04-22 10:00:00 | QQQ | ETF | 33.76 | 33.82 | 33.56 | 33.8 | 13061000.0 |
| 2002-04-22 11:00:00 | QQQ | ETF | 33.8 | 33.81 | 33.49 | 33.49 | 5825600.0 |
| 2002-04-22 12:00:00 | QQQ | ETF | 33.49 | 33.52 | 33.36 | 33.41 | 9575600.0 |
| 2002-04-22 13:00:00 | QQQ | ETF | 33.41 | 33.59 | 33.37 | 33.39 | 4064400.0 |
| 2002-04-22 14:00:00 | QQQ | ETF | 33.4 | 33.44 | 33.25 | 33.3 | 5565300.0 |
| 2002-04-22 15:00:00 | QQQ | ETF | 33.3 | 33.58 | 33.26 | 33.56 | 9781600.0 |
| 2002-04-22 16:00:00 | QQQ | ETF | 33.57 | 33.7 | 33.51 | 33.58 | 1355000.0 |
| 2002-04-22 17:00:00 | QQQ | ETF | 33.56 | 33.58 | 33.5 | 33.5 | 85600.0 |
| 2002-04-22 18:00:00 | QQQ | ETF | 33.53 | 33.57 | 33.5 | 33.55 | 26100.0 |
| 2002-04-22 09:00:00 | IWM | ETF | 51.4 | 51.445 | 51.04 | 51.04 | 392000.0 |
| 2002-04-22 10:00:00 | IWM | ETF | 51.055 | 51.11 | 50.755 | 50.96 | 375400.0 |
| 2002-04-22 11:00:00 | IWM | ETF | 50.97 | 50.97 | 50.845 | 50.89 | 242800.0 |
| 2002-04-22 12:00:00 | IWM | ETF | 50.89 | 50.95 | 50.765 | 50.9 | 105400.0 |
| 2002-04-22 13:00:00 | IWM | ETF | 50.88 | 50.995 | 50.835 | 50.94 | 27200.0 |
| 2002-04-22 14:00:00 | IWM | ETF | 50.9 | 50.91 | 50.8 | 50.805 | 56400.0 |
| 2002-04-22 15:00:00 | IWM | ETF | 50.795 | 50.89 | 50.775 | 50.825 | 176800.0 |
| 2002-04-22 16:00:00 | IWM | ETF | 50.825 | 50.825 | 50.755 | 50.77 | 104200.0 |
| 2002-04-22 09:00:00 | DIA | ETF | 102.2 | 102.46 | 102.2 | 102.42 | 1347800.0 |
| 2002-04-22 10:00:00 | DIA | ETF | 102.19 | 102.26 | 101.68 | 101.97 | 287100.0 |
| 2002-04-22 11:00:00 | DIA | ETF | 101.99 | 102.0 | 101.6 | 101.7 | 696500.0 |
| 2002-04-22 12:00:00 | DIA | ETF | 101.71 | 101.87 | 101.5 | 101.58 | 390700.0 |
| 2002-04-22 13:00:00 | DIA | ETF | 101.59 | 101.81 | 101.36 | 101.42 | 294800.0 |
| 2002-04-22 14:00:00 | DIA | ETF | 101.48 | 101.55 | 101.18 | 101.25 | 326500.0 |
| 2002-04-22 15:00:00 | DIA | ETF | 101.24 | 101.52 | 101.11 | 101.49 | 360800.0 |
| 2002-04-22 16:00:00 | DIA | ETF | 101.47 | 101.5 | 101.38 | 101.38 | 74300.0 |
| 2002-04-22 17:00:00 | DIA | ETF | 101.39 | 101.39 | 101.39 | 101.39 | 100.0 |
> showing 37 of 317 rows — these rows as CSV