PREVIEW / etf_1hour / 2002-02-27
file: by_date/etf_1hour/2002/2002-02-27.parquet size: 14 KB rows: 300
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-02-27 09:00:00 | SPY | ETF | 111.96 | 112.43 | 111.85 | 112.36 | 2611400.0 |
| 2002-02-27 10:00:00 | SPY | ETF | 112.35 | 112.84 | 111.87 | 112.6 | 4367300.0 |
| 2002-02-27 11:00:00 | SPY | ETF | 112.62 | 112.86 | 112.39 | 112.55 | 2773600.0 |
| 2002-02-27 12:00:00 | SPY | ETF | 112.58 | 112.8 | 112.45 | 112.57 | 1028000.0 |
| 2002-02-27 13:00:00 | SPY | ETF | 112.6 | 112.75 | 111.7 | 111.86 | 3345200.0 |
| 2002-02-27 14:00:00 | SPY | ETF | 111.88 | 112.01 | 110.9 | 110.97 | 6336300.0 |
| 2002-02-27 15:00:00 | SPY | ETF | 110.97 | 111.62 | 110.65 | 111.58 | 4815700.0 |
| 2002-02-27 16:00:00 | SPY | ETF | 111.55 | 111.74 | 111.32 | 111.73 | 2237700.0 |
| 2002-02-27 09:00:00 | QQQ | ETF | 35.39 | 35.43 | 35.11 | 35.28 | 8238700.0 |
| 2002-02-27 10:00:00 | QQQ | ETF | 35.29 | 35.51 | 35.02 | 35.38 | 15557900.0 |
| 2002-02-27 11:00:00 | QQQ | ETF | 35.38 | 35.49 | 35.24 | 35.26 | 6838400.0 |
| 2002-02-27 12:00:00 | QQQ | ETF | 35.26 | 35.39 | 35.15 | 35.28 | 7373800.0 |
| 2002-02-27 13:00:00 | QQQ | ETF | 35.28 | 35.44 | 34.59 | 34.72 | 13372800.0 |
| 2002-02-27 14:00:00 | QQQ | ETF | 34.72 | 34.85 | 34.17 | 34.25 | 23340200.0 |
| 2002-02-27 15:00:00 | QQQ | ETF | 34.25 | 34.48 | 34.06 | 34.34 | 15624000.0 |
| 2002-02-27 16:00:00 | QQQ | ETF | 34.33 | 34.52 | 34.3 | 34.43 | 2843300.0 |
| 2002-02-27 17:00:00 | QQQ | ETF | 34.43 | 34.44 | 34.38 | 34.42 | 47800.0 |
| 2002-02-27 18:00:00 | QQQ | ETF | 34.44 | 34.45 | 34.4 | 34.44 | 16900.0 |
| 2002-02-27 09:00:00 | IWM | ETF | 47.125 | 47.245 | 47.005 | 47.2 | 108400.0 |
| 2002-02-27 10:00:00 | IWM | ETF | 47.195 | 47.245 | 46.985 | 47.245 | 130800.0 |
| 2002-02-27 11:00:00 | IWM | ETF | 47.235 | 47.255 | 47.145 | 47.255 | 60400.0 |
| 2002-02-27 12:00:00 | IWM | ETF | 47.175 | 47.255 | 47.175 | 47.2 | 101000.0 |
| 2002-02-27 13:00:00 | IWM | ETF | 47.245 | 47.295 | 47.125 | 47.135 | 198200.0 |
| 2002-02-27 14:00:00 | IWM | ETF | 47.135 | 47.175 | 46.9 | 46.965 | 294200.0 |
| 2002-02-27 15:00:00 | IWM | ETF | 46.89 | 47.075 | 46.815 | 47.065 | 243800.0 |
| 2002-02-27 16:00:00 | IWM | ETF | 47.075 | 47.1 | 46.575 | 46.575 | 32800.0 |
| 2002-02-27 09:00:00 | DIA | ETF | 101.9 | 102.24 | 101.7 | 102.24 | 740700.0 |
| 2002-02-27 10:00:00 | DIA | ETF | 102.18 | 102.7 | 101.74 | 102.55 | 1667600.0 |
| 2002-02-27 11:00:00 | DIA | ETF | 102.53 | 102.7 | 102.32 | 102.49 | 749300.0 |
| 2002-02-27 12:00:00 | DIA | ETF | 102.5 | 102.65 | 102.35 | 102.45 | 211500.0 |
| 2002-02-27 13:00:00 | DIA | ETF | 102.4 | 102.53 | 101.6 | 101.79 | 732400.0 |
| 2002-02-27 14:00:00 | DIA | ETF | 101.79 | 101.92 | 100.9 | 100.97 | 1850000.0 |
| 2002-02-27 15:00:00 | DIA | ETF | 100.95 | 101.57 | 100.65 | 101.4 | 1188200.0 |
| 2002-02-27 16:00:00 | DIA | ETF | 101.35 | 101.68 | 101.35 | 101.65 | 288800.0 |
| 2002-02-27 17:00:00 | DIA | ETF | 101.68 | 101.68 | 101.65 | 101.65 | 2200.0 |
> showing 35 of 300 rows — these rows as CSV