PREVIEW / etf_1hour / 2002-06-25
file: by_date/etf_1hour/2002/2002-06-25.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-25 09:00:00 | SPY | ETF | 100.3 | 100.48 | 99.97 | 100.04 | 2995300.0 |
| 2002-06-25 10:00:00 | SPY | ETF | 100.07 | 100.89 | 99.85 | 100.45 | 4845300.0 |
| 2002-06-25 11:00:00 | SPY | ETF | 100.46 | 100.8 | 100.07 | 100.47 | 3726000.0 |
| 2002-06-25 12:00:00 | SPY | ETF | 100.46 | 100.59 | 99.6 | 99.77 | 2548000.0 |
| 2002-06-25 13:00:00 | SPY | ETF | 99.77 | 99.97 | 98.91 | 98.98 | 3123700.0 |
| 2002-06-25 14:00:00 | SPY | ETF | 98.96 | 99.45 | 98.43 | 98.52 | 4240700.0 |
| 2002-06-25 15:00:00 | SPY | ETF | 98.52 | 98.89 | 97.54 | 97.9 | 4226300.0 |
| 2002-06-25 16:00:00 | SPY | ETF | 97.9 | 99.57 | 97.47 | 97.73 | 3223100.0 |
| 2002-06-25 17:00:00 | SPY | ETF | 97.57 | 100.83 | 97.48 | 100.83 | 37700.0 |
| 2002-06-25 18:00:00 | SPY | ETF | 97.53 | 97.53 | 96.81 | 96.92 | 29800.0 |
| 2002-06-25 09:00:00 | QQQ | ETF | 26.58 | 26.72 | 26.3 | 26.37 | 14420300.0 |
| 2002-06-25 10:00:00 | QQQ | ETF | 26.37 | 26.69 | 26.11 | 26.34 | 19626300.0 |
| 2002-06-25 11:00:00 | QQQ | ETF | 26.34 | 26.55 | 26.16 | 26.41 | 10820800.0 |
| 2002-06-25 12:00:00 | QQQ | ETF | 26.41 | 26.45 | 25.86 | 25.93 | 17677800.0 |
| 2002-06-25 13:00:00 | QQQ | ETF | 25.94 | 26.05 | 25.52 | 25.59 | 15963200.0 |
| 2002-06-25 14:00:00 | QQQ | ETF | 25.59 | 25.88 | 25.49 | 25.53 | 16929400.0 |
| 2002-06-25 15:00:00 | QQQ | ETF | 25.53 | 25.72 | 25.3 | 25.47 | 15531500.0 |
| 2002-06-25 16:00:00 | QQQ | ETF | 25.47 | 25.5 | 25.37 | 25.43 | 3683600.0 |
| 2002-06-25 17:00:00 | QQQ | ETF | 25.46 | 25.48 | 25.3 | 25.38 | 561100.0 |
| 2002-06-25 18:00:00 | QQQ | ETF | 25.39 | 25.4 | 24.5 | 24.99 | 264100.0 |
| 2002-06-25 09:00:00 | IWM | ETF | 45.95 | 46.02 | 45.8 | 45.85 | 82000.0 |
| 2002-06-25 10:00:00 | IWM | ETF | 45.9 | 46.175 | 45.69 | 45.925 | 318600.0 |
| 2002-06-25 11:00:00 | IWM | ETF | 45.98 | 46.035 | 45.83 | 45.91 | 60600.0 |
| 2002-06-25 12:00:00 | IWM | ETF | 45.95 | 45.97 | 45.515 | 45.56 | 126200.0 |
| 2002-06-25 13:00:00 | IWM | ETF | 45.54 | 45.63 | 45.135 | 45.225 | 214200.0 |
| 2002-06-25 14:00:00 | IWM | ETF | 45.15 | 45.27 | 45.005 | 45.005 | 194400.0 |
| 2002-06-25 15:00:00 | IWM | ETF | 45.09 | 45.12 | 44.78 | 44.975 | 245000.0 |
| 2002-06-25 16:00:00 | IWM | ETF | 44.925 | 45.01 | 44.85 | 44.85 | 37000.0 |
| 2002-06-25 09:00:00 | DIA | ETF | 93.74 | 93.94 | 93.48 | 93.52 | 526800.0 |
| 2002-06-25 10:00:00 | DIA | ETF | 93.69 | 94.18 | 93.32 | 93.91 | 971500.0 |
| 2002-06-25 11:00:00 | DIA | ETF | 93.91 | 94.2 | 93.55 | 93.84 | 561100.0 |
| 2002-06-25 12:00:00 | DIA | ETF | 93.84 | 94.05 | 93.1 | 93.3 | 1429700.0 |
| 2002-06-25 13:00:00 | DIA | ETF | 93.31 | 93.48 | 92.42 | 92.53 | 687000.0 |
| 2002-06-25 14:00:00 | DIA | ETF | 92.55 | 93.0 | 92.04 | 92.13 | 1248200.0 |
| 2002-06-25 15:00:00 | DIA | ETF | 92.15 | 92.38 | 91.05 | 91.46 | 1380700.0 |
| 2002-06-25 16:00:00 | DIA | ETF | 91.48 | 91.98 | 91.15 | 91.4 | 109800.0 |
| 2002-06-25 17:00:00 | DIA | ETF | 91.49 | 91.49 | 91.2 | 91.2 | 300.0 |
| 2002-06-25 18:00:00 | DIA | ETF | 91.2 | 91.2 | 90.85 | 90.85 | 1600.0 |
> showing 38 of 310 rows — these rows as CSV