PREVIEW / etf_1hour / 2002-06-28
file: by_date/etf_1hour/2002/2002-06-28.parquet size: 14 KB rows: 329
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-28 09:00:00 | SPY | ETF | 99.3 | 100.0 | 99.05 | 99.64 | 3569900.0 |
| 2002-06-28 10:00:00 | SPY | ETF | 99.7 | 100.5 | 99.45 | 100.11 | 3596000.0 |
| 2002-06-28 11:00:00 | SPY | ETF | 100.14 | 100.25 | 99.9 | 100.19 | 1351300.0 |
| 2002-06-28 12:00:00 | SPY | ETF | 100.2 | 100.44 | 99.96 | 100.07 | 1405900.0 |
| 2002-06-28 13:00:00 | SPY | ETF | 100.13 | 100.34 | 100.0 | 100.23 | 1192600.0 |
| 2002-06-28 14:00:00 | SPY | ETF | 100.21 | 100.48 | 99.42 | 99.7 | 2563900.0 |
| 2002-06-28 15:00:00 | SPY | ETF | 99.68 | 99.75 | 99.06 | 99.25 | 3654200.0 |
| 2002-06-28 16:00:00 | SPY | ETF | 99.26 | 99.55 | 98.88 | 99.26 | 7523500.0 |
| 2002-06-28 17:00:00 | SPY | ETF | 98.83 | 98.83 | 98.83 | 98.83 | 100.0 |
| 2002-06-28 18:00:00 | SPY | ETF | 98.83 | 98.83 | 98.75 | 98.75 | 1300.0 |
| 2002-06-28 09:00:00 | QQQ | ETF | 26.03 | 26.55 | 26.02 | 26.35 | 11886300.0 |
| 2002-06-28 10:00:00 | QQQ | ETF | 26.35 | 26.68 | 26.28 | 26.48 | 14568500.0 |
| 2002-06-28 11:00:00 | QQQ | ETF | 26.49 | 26.58 | 26.39 | 26.53 | 6001900.0 |
| 2002-06-28 12:00:00 | QQQ | ETF | 26.53 | 26.75 | 26.49 | 26.62 | 9590900.0 |
| 2002-06-28 13:00:00 | QQQ | ETF | 26.61 | 26.69 | 26.31 | 26.42 | 6332500.0 |
| 2002-06-28 14:00:00 | QQQ | ETF | 26.45 | 26.62 | 26.04 | 26.22 | 7858600.0 |
| 2002-06-28 15:00:00 | QQQ | ETF | 26.23 | 26.27 | 25.85 | 26.1 | 17308900.0 |
| 2002-06-28 16:00:00 | QQQ | ETF | 26.1 | 26.23 | 26.0 | 26.01 | 3362800.0 |
| 2002-06-28 17:00:00 | QQQ | ETF | 26.04 | 26.09 | 26.01 | 26.07 | 19000.0 |
| 2002-06-28 18:00:00 | QQQ | ETF | 26.06 | 26.09 | 26.05 | 26.08 | 15500.0 |
| 2002-06-28 09:00:00 | IWM | ETF | 45.73 | 46.15 | 45.555 | 46.0 | 364200.0 |
| 2002-06-28 10:00:00 | IWM | ETF | 45.91 | 46.12 | 45.9 | 45.945 | 95000.0 |
| 2002-06-28 11:00:00 | IWM | ETF | 45.95 | 46.08 | 45.95 | 46.05 | 264600.0 |
| 2002-06-28 12:00:00 | IWM | ETF | 46.025 | 46.225 | 46.015 | 46.1 | 344800.0 |
| 2002-06-28 13:00:00 | IWM | ETF | 46.15 | 46.275 | 46.12 | 46.125 | 62200.0 |
| 2002-06-28 14:00:00 | IWM | ETF | 46.11 | 46.325 | 45.8 | 46.0 | 303000.0 |
| 2002-06-28 15:00:00 | IWM | ETF | 45.985 | 46.03 | 45.705 | 45.8 | 524000.0 |
| 2002-06-28 16:00:00 | IWM | ETF | 45.8 | 46.06 | 45.325 | 46.06 | 387000.0 |
| 2002-06-28 17:00:00 | IWM | ETF | 46.06 | 46.06 | 46.06 | 46.06 | 2300000.0 |
| 2002-06-28 09:00:00 | DIA | ETF | 92.62 | 93.3 | 92.49 | 92.94 | 333200.0 |
| 2002-06-28 10:00:00 | DIA | ETF | 92.9 | 93.69 | 92.78 | 93.32 | 622800.0 |
| 2002-06-28 11:00:00 | DIA | ETF | 93.25 | 93.46 | 93.08 | 93.4 | 139100.0 |
| 2002-06-28 12:00:00 | DIA | ETF | 93.33 | 93.6 | 93.25 | 93.42 | 158400.0 |
| 2002-06-28 13:00:00 | DIA | ETF | 93.44 | 93.62 | 93.3 | 93.44 | 138200.0 |
| 2002-06-28 14:00:00 | DIA | ETF | 93.45 | 93.79 | 92.83 | 93.14 | 364700.0 |
| 2002-06-28 15:00:00 | DIA | ETF | 93.06 | 93.25 | 92.58 | 92.64 | 1470900.0 |
| 2002-06-28 16:00:00 | DIA | ETF | 92.7 | 92.85 | 92.43 | 92.55 | 1373600.0 |
> showing 37 of 329 rows — these rows as CSV