PREVIEW / etf_1hour / 2002-06-07
file: by_date/etf_1hour/2002/2002-06-07.parquet size: 14 KB rows: 310
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-06-07 09:00:00 | SPY | ETF | 101.78 | 102.5 | 101.72 | 101.85 | 2917900.0 |
| 2002-06-07 10:00:00 | SPY | ETF | 101.85 | 102.7 | 101.75 | 102.21 | 4158600.0 |
| 2002-06-07 11:00:00 | SPY | ETF | 102.2 | 102.98 | 102.13 | 102.68 | 1843100.0 |
| 2002-06-07 12:00:00 | SPY | ETF | 102.67 | 103.12 | 102.62 | 102.78 | 1762200.0 |
| 2002-06-07 13:00:00 | SPY | ETF | 102.74 | 103.37 | 102.72 | 103.2 | 1703700.0 |
| 2002-06-07 14:00:00 | SPY | ETF | 103.2 | 103.92 | 103.03 | 103.23 | 4193400.0 |
| 2002-06-07 15:00:00 | SPY | ETF | 103.2 | 103.7 | 103.02 | 103.26 | 3801300.0 |
| 2002-06-07 16:00:00 | SPY | ETF | 103.25 | 103.62 | 103.12 | 103.3 | 2307400.0 |
| 2002-06-07 09:00:00 | QQQ | ETF | 27.63 | 27.99 | 27.52 | 27.6 | 17700200.0 |
| 2002-06-07 10:00:00 | QQQ | ETF | 27.6 | 28.12 | 27.55 | 27.91 | 20475600.0 |
| 2002-06-07 11:00:00 | QQQ | ETF | 27.91 | 28.3 | 27.84 | 28.07 | 13411200.0 |
| 2002-06-07 12:00:00 | QQQ | ETF | 28.07 | 28.32 | 28.06 | 28.16 | 7521000.0 |
| 2002-06-07 13:00:00 | QQQ | ETF | 28.13 | 28.48 | 28.1 | 28.36 | 8755300.0 |
| 2002-06-07 14:00:00 | QQQ | ETF | 28.36 | 28.79 | 28.25 | 28.35 | 16010500.0 |
| 2002-06-07 15:00:00 | QQQ | ETF | 28.35 | 28.6 | 28.24 | 28.37 | 13316300.0 |
| 2002-06-07 16:00:00 | QQQ | ETF | 28.37 | 28.46 | 27.55 | 28.33 | 1503100.0 |
| 2002-06-07 17:00:00 | QQQ | ETF | 28.34 | 28.39 | 27.87 | 28.35 | 83800.0 |
| 2002-06-07 18:00:00 | QQQ | ETF | 28.35 | 28.37 | 28.35 | 28.35 | 6200.0 |
| 2002-06-07 09:00:00 | IWM | ETF | 45.625 | 45.93 | 45.605 | 45.785 | 359800.0 |
| 2002-06-07 10:00:00 | IWM | ETF | 45.73 | 46.17 | 45.725 | 45.97 | 384600.0 |
| 2002-06-07 11:00:00 | IWM | ETF | 45.875 | 46.3 | 45.855 | 46.095 | 252800.0 |
| 2002-06-07 12:00:00 | IWM | ETF | 46.1 | 46.365 | 46.1 | 46.25 | 215800.0 |
| 2002-06-07 13:00:00 | IWM | ETF | 46.25 | 46.645 | 46.22 | 46.5 | 347000.0 |
| 2002-06-07 14:00:00 | IWM | ETF | 46.565 | 47.0 | 46.45 | 46.63 | 422000.0 |
| 2002-06-07 15:00:00 | IWM | ETF | 46.61 | 46.875 | 46.425 | 46.775 | 335000.0 |
| 2002-06-07 16:00:00 | IWM | ETF | 46.825 | 46.975 | 46.75 | 46.775 | 108200.0 |
| 2002-06-07 09:00:00 | DIA | ETF | 95.32 | 95.64 | 94.87 | 94.94 | 1084400.0 |
| 2002-06-07 10:00:00 | DIA | ETF | 95.0 | 95.7 | 94.92 | 95.25 | 1191300.0 |
| 2002-06-07 11:00:00 | DIA | ETF | 95.27 | 95.84 | 95.15 | 95.53 | 970600.0 |
| 2002-06-07 12:00:00 | DIA | ETF | 95.56 | 95.92 | 95.55 | 95.72 | 330700.0 |
| 2002-06-07 13:00:00 | DIA | ETF | 95.71 | 96.15 | 95.62 | 95.98 | 497500.0 |
| 2002-06-07 14:00:00 | DIA | ETF | 96.0 | 96.65 | 95.86 | 96.01 | 773500.0 |
| 2002-06-07 15:00:00 | DIA | ETF | 96.04 | 96.42 | 95.86 | 96.1 | 669100.0 |
| 2002-06-07 16:00:00 | DIA | ETF | 96.04 | 96.22 | 95.86 | 95.86 | 180800.0 |
| 2002-06-07 17:00:00 | DIA | ETF | 96.18 | 96.18 | 96.18 | 96.18 | 300.0 |
> showing 35 of 310 rows — these rows as CSV