PREVIEW / etf_1hour / 2002-02-07
file: by_date/etf_1hour/2002/2002-02-07.parquet size: 13 KB rows: 285
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-02-07 09:00:00 | SPY | ETF | 108.72 | 109.04 | 108.56 | 108.99 | 2742500.0 |
| 2002-02-07 10:00:00 | SPY | ETF | 108.95 | 109.23 | 108.16 | 108.95 | 5118600.0 |
| 2002-02-07 11:00:00 | SPY | ETF | 108.95 | 109.86 | 108.92 | 109.47 | 5008300.0 |
| 2002-02-07 12:00:00 | SPY | ETF | 109.47 | 109.69 | 109.1 | 109.34 | 1820600.0 |
| 2002-02-07 13:00:00 | SPY | ETF | 109.3 | 109.66 | 109.1 | 109.5 | 1327300.0 |
| 2002-02-07 14:00:00 | SPY | ETF | 109.6 | 109.6 | 109.0 | 109.3 | 1761600.0 |
| 2002-02-07 15:00:00 | SPY | ETF | 109.3 | 109.3 | 108.28 | 108.38 | 3191200.0 |
| 2002-02-07 16:00:00 | SPY | ETF | 108.41 | 108.7 | 107.75 | 107.9 | 1425400.0 |
| 2002-02-07 17:00:00 | SPY | ETF | 107.97 | 108.03 | 107.91 | 108.01 | 5800.0 |
| 2002-02-07 18:00:00 | SPY | ETF | 108.01 | 108.04 | 107.88 | 108.04 | 1500.0 |
| 2002-02-07 09:00:00 | QQQ | ETF | 35.99 | 36.14 | 35.69 | 35.81 | 14173500.0 |
| 2002-02-07 10:00:00 | QQQ | ETF | 35.8 | 35.98 | 35.44 | 35.9 | 22013000.0 |
| 2002-02-07 11:00:00 | QQQ | ETF | 35.95 | 36.39 | 35.89 | 36.17 | 17488200.0 |
| 2002-02-07 12:00:00 | QQQ | ETF | 36.17 | 36.29 | 35.8 | 35.93 | 8954800.0 |
| 2002-02-07 13:00:00 | QQQ | ETF | 35.94 | 36.26 | 35.84 | 36.25 | 7791200.0 |
| 2002-02-07 14:00:00 | QQQ | ETF | 36.25 | 36.29 | 35.8 | 35.93 | 7954900.0 |
| 2002-02-07 15:00:00 | QQQ | ETF | 35.93 | 35.94 | 35.16 | 35.21 | 15547900.0 |
| 2002-02-07 16:00:00 | QQQ | ETF | 35.21 | 35.35 | 35.12 | 35.17 | 3056900.0 |
| 2002-02-07 17:00:00 | QQQ | ETF | 35.17 | 35.3 | 35.07 | 35.12 | 121300.0 |
| 2002-02-07 18:00:00 | QQQ | ETF | 35.13 | 35.2 | 35.1 | 35.15 | 21300.0 |
| 2002-02-07 09:00:00 | IWM | ETF | 45.95 | 46.05 | 45.885 | 45.94 | 112200.0 |
| 2002-02-07 10:00:00 | IWM | ETF | 45.955 | 45.975 | 45.475 | 45.685 | 342000.0 |
| 2002-02-07 11:00:00 | IWM | ETF | 45.765 | 46.035 | 45.765 | 45.98 | 241200.0 |
| 2002-02-07 12:00:00 | IWM | ETF | 45.965 | 45.995 | 45.83 | 45.915 | 125600.0 |
| 2002-02-07 13:00:00 | IWM | ETF | 45.905 | 45.94 | 45.8 | 45.94 | 380000.0 |
| 2002-02-07 14:00:00 | IWM | ETF | 45.93 | 45.94 | 45.74 | 45.9 | 229000.0 |
| 2002-02-07 15:00:00 | IWM | ETF | 45.885 | 45.895 | 45.5 | 45.5 | 357400.0 |
| 2002-02-07 16:00:00 | IWM | ETF | 45.535 | 45.545 | 45.375 | 45.4 | 71600.0 |
| 2002-02-07 09:00:00 | DIA | ETF | 96.73 | 97.32 | 96.73 | 97.16 | 886200.0 |
| 2002-02-07 10:00:00 | DIA | ETF | 97.15 | 97.44 | 96.37 | 97.02 | 519300.0 |
| 2002-02-07 11:00:00 | DIA | ETF | 97.05 | 97.6 | 96.99 | 97.33 | 473500.0 |
| 2002-02-07 12:00:00 | DIA | ETF | 97.37 | 97.6 | 97.05 | 97.1 | 202400.0 |
| 2002-02-07 13:00:00 | DIA | ETF | 97.2 | 97.48 | 97.08 | 97.3 | 176300.0 |
| 2002-02-07 14:00:00 | DIA | ETF | 97.24 | 97.24 | 96.9 | 97.1 | 188600.0 |
| 2002-02-07 15:00:00 | DIA | ETF | 97.06 | 97.06 | 96.38 | 96.4 | 367600.0 |
| 2002-02-07 16:00:00 | DIA | ETF | 96.36 | 96.45 | 96.15 | 96.15 | 43000.0 |
| 2002-02-07 17:00:00 | DIA | ETF | 96.4 | 96.4 | 96.4 | 96.4 | 10000.0 |
| 2002-02-07 18:00:00 | DIA | ETF | 95.75 | 95.75 | 95.75 | 95.75 | 100.0 |
> showing 38 of 285 rows — these rows as CSV