PREVIEW / etf_1hour / 2002-05-08
file: by_date/etf_1hour/2002/2002-05-08.parquet size: 14 KB rows: 326
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-05-08 09:00:00 | SPY | ETF | 107.05 | 107.8 | 106.79 | 107.36 | 4619000.0 |
| 2002-05-08 10:00:00 | SPY | ETF | 107.33 | 108.0 | 107.33 | 107.8 | 3175500.0 |
| 2002-05-08 11:00:00 | SPY | ETF | 107.83 | 108.76 | 107.77 | 108.5 | 5749800.0 |
| 2002-05-08 12:00:00 | SPY | ETF | 108.5 | 108.98 | 108.49 | 108.69 | 2799000.0 |
| 2002-05-08 13:00:00 | SPY | ETF | 108.7 | 108.86 | 108.6 | 108.68 | 2544900.0 |
| 2002-05-08 14:00:00 | SPY | ETF | 108.73 | 109.15 | 108.51 | 108.98 | 2402600.0 |
| 2002-05-08 15:00:00 | SPY | ETF | 109.0 | 109.36 | 108.85 | 109.19 | 4122700.0 |
| 2002-05-08 16:00:00 | SPY | ETF | 109.16 | 109.3 | 108.61 | 109.0 | 1651300.0 |
| 2002-05-08 17:00:00 | SPY | ETF | 108.98 | 109.15 | 108.96 | 109.15 | 50900.0 |
| 2002-05-08 18:00:00 | SPY | ETF | 109.17 | 109.17 | 109.17 | 109.17 | 100.0 |
| 2002-05-08 09:00:00 | QQQ | ETF | 30.13 | 30.44 | 30.02 | 30.23 | 22045200.0 |
| 2002-05-08 10:00:00 | QQQ | ETF | 30.23 | 31.0 | 30.22 | 30.84 | 27055600.0 |
| 2002-05-08 11:00:00 | QQQ | ETF | 30.84 | 31.26 | 30.79 | 31.14 | 17784600.0 |
| 2002-05-08 12:00:00 | QQQ | ETF | 31.11 | 31.51 | 31.1 | 31.3 | 14593400.0 |
| 2002-05-08 13:00:00 | QQQ | ETF | 31.3 | 31.41 | 31.2 | 31.38 | 7792200.0 |
| 2002-05-08 14:00:00 | QQQ | ETF | 31.41 | 31.7 | 31.21 | 31.54 | 13775000.0 |
| 2002-05-08 15:00:00 | QQQ | ETF | 31.53 | 31.87 | 31.46 | 31.86 | 20012300.0 |
| 2002-05-08 16:00:00 | QQQ | ETF | 31.86 | 31.88 | 30.18 | 31.79 | 4374900.0 |
| 2002-05-08 17:00:00 | QQQ | ETF | 31.8 | 31.83 | 31.75 | 31.81 | 116200.0 |
| 2002-05-08 18:00:00 | QQQ | ETF | 31.8 | 31.82 | 31.78 | 31.78 | 28000.0 |
| 2002-05-08 09:00:00 | IWM | ETF | 50.45 | 50.575 | 50.3 | 50.35 | 129200.0 |
| 2002-05-08 10:00:00 | IWM | ETF | 50.35 | 50.51 | 50.275 | 50.35 | 948400.0 |
| 2002-05-08 11:00:00 | IWM | ETF | 50.32 | 50.45 | 50.295 | 50.335 | 432600.0 |
| 2002-05-08 12:00:00 | IWM | ETF | 50.42 | 50.45 | 50.325 | 50.325 | 166600.0 |
| 2002-05-08 13:00:00 | IWM | ETF | 50.325 | 50.37 | 50.28 | 50.34 | 91600.0 |
| 2002-05-08 14:00:00 | IWM | ETF | 50.34 | 50.4 | 50.24 | 50.385 | 114600.0 |
| 2002-05-08 15:00:00 | IWM | ETF | 50.385 | 50.81 | 50.32 | 50.665 | 332400.0 |
| 2002-05-08 16:00:00 | IWM | ETF | 50.7 | 50.8 | 50.7 | 50.8 | 7400.0 |
| 2002-05-08 09:00:00 | DIA | ETF | 99.89 | 100.36 | 99.81 | 99.97 | 840100.0 |
| 2002-05-08 10:00:00 | DIA | ETF | 99.97 | 100.64 | 99.96 | 100.46 | 978900.0 |
| 2002-05-08 11:00:00 | DIA | ETF | 100.5 | 101.34 | 100.4 | 101.11 | 692500.0 |
| 2002-05-08 12:00:00 | DIA | ETF | 101.1 | 101.57 | 101.06 | 101.16 | 744100.0 |
| 2002-05-08 13:00:00 | DIA | ETF | 101.16 | 101.38 | 101.03 | 101.15 | 202300.0 |
| 2002-05-08 14:00:00 | DIA | ETF | 101.13 | 101.45 | 100.88 | 101.38 | 243100.0 |
| 2002-05-08 15:00:00 | DIA | ETF | 101.38 | 101.68 | 101.25 | 101.6 | 794600.0 |
| 2002-05-08 16:00:00 | DIA | ETF | 101.56 | 101.67 | 101.28 | 101.35 | 94800.0 |
| 2002-05-08 17:00:00 | DIA | ETF | 101.3 | 101.3 | 101.28 | 101.28 | 300.0 |
> showing 37 of 326 rows — these rows as CSV