PREVIEW / etf_1hour / 2002-06-06
file: by_date/etf_1hour/2002/2002-06-06.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-06-06 09:00:00 | SPY | ETF | 105.54 | 105.6 | 104.75 | 104.87 | 2184100.0 |
| 2002-06-06 10:00:00 | SPY | ETF | 104.8 | 104.98 | 104.36 | 104.51 | 2917500.0 |
| 2002-06-06 11:00:00 | SPY | ETF | 104.51 | 104.59 | 103.7 | 104.09 | 2928200.0 |
| 2002-06-06 12:00:00 | SPY | ETF | 104.1 | 104.23 | 103.57 | 103.91 | 1796300.0 |
| 2002-06-06 13:00:00 | SPY | ETF | 103.91 | 104.36 | 103.82 | 104.03 | 1758900.0 |
| 2002-06-06 14:00:00 | SPY | ETF | 104.01 | 104.12 | 103.15 | 103.39 | 2609300.0 |
| 2002-06-06 15:00:00 | SPY | ETF | 103.4 | 103.7 | 103.21 | 103.42 | 3655200.0 |
| 2002-06-06 16:00:00 | SPY | ETF | 103.45 | 104.05 | 101.81 | 102.2 | 3171300.0 |
| 2002-06-06 17:00:00 | SPY | ETF | 102.2 | 103.54 | 101.84 | 102.08 | 899700.0 |
| 2002-06-06 18:00:00 | SPY | ETF | 102.1 | 102.18 | 102.08 | 102.18 | 5700.0 |
| 2002-06-06 09:00:00 | QQQ | ETF | 29.5 | 29.51 | 29.1 | 29.17 | 10964000.0 |
| 2002-06-06 10:00:00 | QQQ | ETF | 29.2 | 29.26 | 28.93 | 29.09 | 16970900.0 |
| 2002-06-06 11:00:00 | QQQ | ETF | 29.1 | 29.14 | 28.7 | 28.96 | 15701300.0 |
| 2002-06-06 12:00:00 | QQQ | ETF | 28.96 | 29.12 | 28.81 | 29.0 | 6773600.0 |
| 2002-06-06 13:00:00 | QQQ | ETF | 29.01 | 29.17 | 28.94 | 28.99 | 7032700.0 |
| 2002-06-06 14:00:00 | QQQ | ETF | 28.97 | 29.05 | 28.63 | 28.81 | 11110500.0 |
| 2002-06-06 15:00:00 | QQQ | ETF | 28.82 | 29.02 | 28.72 | 28.84 | 9607700.0 |
| 2002-06-06 16:00:00 | QQQ | ETF | 28.82 | 28.98 | 27.5 | 27.98 | 4975600.0 |
| 2002-06-06 17:00:00 | QQQ | ETF | 27.98 | 28.93 | 27.5 | 27.85 | 4338900.0 |
| 2002-06-06 18:00:00 | QQQ | ETF | 27.85 | 27.86 | 27.72 | 27.85 | 553900.0 |
| 2002-06-06 09:00:00 | IWM | ETF | 47.275 | 47.3 | 46.98 | 46.98 | 34200.0 |
| 2002-06-06 10:00:00 | IWM | ETF | 47.08 | 47.08 | 46.7 | 46.82 | 272200.0 |
| 2002-06-06 11:00:00 | IWM | ETF | 46.805 | 46.805 | 46.425 | 46.65 | 338400.0 |
| 2002-06-06 12:00:00 | IWM | ETF | 46.675 | 46.7 | 46.5 | 46.625 | 104800.0 |
| 2002-06-06 13:00:00 | IWM | ETF | 46.625 | 46.775 | 46.525 | 46.525 | 234000.0 |
| 2002-06-06 14:00:00 | IWM | ETF | 46.64 | 46.645 | 46.34 | 46.45 | 116200.0 |
| 2002-06-06 15:00:00 | IWM | ETF | 46.435 | 46.52 | 46.275 | 46.345 | 147200.0 |
| 2002-06-06 16:00:00 | IWM | ETF | 46.275 | 46.405 | 46.275 | 46.285 | 454800.0 |
| 2002-06-06 17:00:00 | IWM | ETF | 46.72 | 46.72 | 46.28 | 46.28 | 26200.0 |
| 2002-06-06 18:00:00 | IWM | ETF | 46.38 | 46.38 | 46.0 | 46.0 | 1741200.0 |
| 2002-06-06 09:00:00 | DIA | ETF | 98.12 | 98.2 | 97.41 | 97.41 | 211700.0 |
| 2002-06-06 10:00:00 | DIA | ETF | 97.41 | 97.68 | 97.07 | 97.38 | 832900.0 |
| 2002-06-06 11:00:00 | DIA | ETF | 97.37 | 97.37 | 96.65 | 96.99 | 1008200.0 |
| 2002-06-06 12:00:00 | DIA | ETF | 97.0 | 97.13 | 96.51 | 96.86 | 459800.0 |
| 2002-06-06 13:00:00 | DIA | ETF | 96.76 | 97.22 | 96.74 | 96.9 | 328900.0 |
| 2002-06-06 14:00:00 | DIA | ETF | 96.92 | 97.0 | 96.2 | 96.4 | 572600.0 |
| 2002-06-06 15:00:00 | DIA | ETF | 96.4 | 96.73 | 96.15 | 96.41 | 1079100.0 |
| 2002-06-06 16:00:00 | DIA | ETF | 96.41 | 96.58 | 95.3 | 95.5 | 514900.0 |
| 2002-06-06 17:00:00 | DIA | ETF | 95.4 | 96.58 | 95.19 | 95.41 | 45400.0 |
| 2002-06-06 18:00:00 | DIA | ETF | 95.4 | 95.5 | 95.4 | 95.5 | 1000.0 |
> showing 40 of 317 rows — these rows as CSV