PREVIEW / etf_1hour / 2002-07-09
file: by_date/etf_1hour/2002/2002-07-09.parquet size: 14 KB rows: 307
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-07-09 09:00:00 | SPY | ETF | 97.73 | 98.27 | 97.68 | 98.05 | 2456400.0 |
| 2002-07-09 10:00:00 | SPY | ETF | 97.92 | 98.09 | 97.32 | 97.79 | 3889100.0 |
| 2002-07-09 11:00:00 | SPY | ETF | 97.81 | 98.34 | 97.23 | 97.31 | 3846500.0 |
| 2002-07-09 12:00:00 | SPY | ETF | 97.33 | 97.77 | 97.23 | 97.4 | 2795200.0 |
| 2002-07-09 13:00:00 | SPY | ETF | 97.44 | 97.73 | 96.92 | 97.11 | 1810000.0 |
| 2002-07-09 14:00:00 | SPY | ETF | 97.08 | 97.16 | 96.13 | 96.26 | 3220600.0 |
| 2002-07-09 15:00:00 | SPY | ETF | 96.24 | 96.43 | 95.4 | 95.61 | 6339000.0 |
| 2002-07-09 16:00:00 | SPY | ETF | 95.55 | 97.04 | 95.52 | 95.57 | 3204800.0 |
| 2002-07-09 17:00:00 | SPY | ETF | 95.58 | 96.0 | 95.57 | 95.93 | 61000.0 |
| 2002-07-09 18:00:00 | SPY | ETF | 95.9 | 95.9 | 95.0 | 95.47 | 12700.0 |
| 2002-07-09 09:00:00 | QQQ | ETF | 25.25 | 25.45 | 25.14 | 25.33 | 12363500.0 |
| 2002-07-09 10:00:00 | QQQ | ETF | 25.33 | 25.37 | 24.88 | 25.24 | 20430400.0 |
| 2002-07-09 11:00:00 | QQQ | ETF | 25.23 | 25.48 | 25.0 | 25.07 | 13787100.0 |
| 2002-07-09 12:00:00 | QQQ | ETF | 25.06 | 25.29 | 25.01 | 25.15 | 5993400.0 |
| 2002-07-09 13:00:00 | QQQ | ETF | 25.15 | 25.33 | 25.04 | 25.09 | 6395300.0 |
| 2002-07-09 14:00:00 | QQQ | ETF | 25.11 | 25.14 | 24.77 | 24.84 | 11234900.0 |
| 2002-07-09 15:00:00 | QQQ | ETF | 24.84 | 24.95 | 24.59 | 24.68 | 15360800.0 |
| 2002-07-09 16:00:00 | QQQ | ETF | 24.66 | 24.76 | 24.52 | 24.64 | 3142800.0 |
| 2002-07-09 17:00:00 | QQQ | ETF | 24.65 | 24.68 | 24.56 | 24.67 | 104200.0 |
| 2002-07-09 18:00:00 | QQQ | ETF | 24.66 | 25.49 | 24.55 | 24.55 | 51100.0 |
| 2002-07-09 09:00:00 | IWM | ETF | 43.1 | 43.355 | 43.05 | 43.285 | 93400.0 |
| 2002-07-09 10:00:00 | IWM | ETF | 43.3 | 43.3 | 42.965 | 43.1 | 215800.0 |
| 2002-07-09 11:00:00 | IWM | ETF | 43.195 | 43.435 | 43.15 | 43.225 | 196200.0 |
| 2002-07-09 12:00:00 | IWM | ETF | 43.15 | 43.285 | 43.14 | 43.27 | 185600.0 |
| 2002-07-09 13:00:00 | IWM | ETF | 43.23 | 43.425 | 43.18 | 43.275 | 79600.0 |
| 2002-07-09 14:00:00 | IWM | ETF | 43.2 | 43.2 | 42.895 | 42.9 | 376800.0 |
| 2002-07-09 15:00:00 | IWM | ETF | 42.895 | 43.035 | 42.65 | 42.775 | 454200.0 |
| 2002-07-09 16:00:00 | IWM | ETF | 42.825 | 42.885 | 42.82 | 42.885 | 9400.0 |
| 2002-07-09 09:00:00 | DIA | ETF | 92.78 | 93.24 | 92.78 | 93.09 | 247000.0 |
| 2002-07-09 10:00:00 | DIA | ETF | 93.04 | 93.2 | 92.5 | 92.97 | 1023400.0 |
| 2002-07-09 11:00:00 | DIA | ETF | 92.99 | 93.49 | 92.55 | 92.72 | 630200.0 |
| 2002-07-09 12:00:00 | DIA | ETF | 92.7 | 93.09 | 92.56 | 92.75 | 335200.0 |
| 2002-07-09 13:00:00 | DIA | ETF | 92.93 | 93.09 | 92.48 | 92.65 | 317000.0 |
| 2002-07-09 14:00:00 | DIA | ETF | 92.66 | 92.68 | 91.6 | 91.68 | 918700.0 |
| 2002-07-09 15:00:00 | DIA | ETF | 91.68 | 91.85 | 90.91 | 91.07 | 1547100.0 |
| 2002-07-09 16:00:00 | DIA | ETF | 91.05 | 91.25 | 91.0 | 91.0 | 145400.0 |
| 2002-07-09 17:00:00 | DIA | ETF | 90.96 | 90.96 | 90.9 | 90.9 | 700.0 |
> showing 37 of 307 rows — these rows as CSV