PREVIEW / etf_1hour / 2002-05-17
file: by_date/etf_1hour/2002/2002-05-17.parquet size: 14 KB rows: 308
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-17 09:00:00 | SPY | ETF | 110.66 | 111.1 | 110.6 | 110.87 | 3505800.0 |
| 2002-05-17 10:00:00 | SPY | ETF | 110.9 | 111.16 | 110.1 | 110.36 | 2894300.0 |
| 2002-05-17 11:00:00 | SPY | ETF | 110.37 | 110.41 | 110.15 | 110.15 | 1720100.0 |
| 2002-05-17 12:00:00 | SPY | ETF | 110.17 | 110.61 | 110.12 | 110.52 | 1098100.0 |
| 2002-05-17 13:00:00 | SPY | ETF | 110.55 | 110.7 | 110.3 | 110.4 | 1682000.0 |
| 2002-05-17 14:00:00 | SPY | ETF | 110.42 | 110.57 | 110.25 | 110.57 | 2386400.0 |
| 2002-05-17 15:00:00 | SPY | ETF | 110.55 | 111.17 | 110.51 | 111.11 | 4480700.0 |
| 2002-05-17 16:00:00 | SPY | ETF | 111.09 | 111.25 | 110.65 | 110.91 | 1805600.0 |
| 2002-05-17 09:00:00 | QQQ | ETF | 33.29 | 33.41 | 33.05 | 33.22 | 17550000.0 |
| 2002-05-17 10:00:00 | QQQ | ETF | 33.22 | 33.38 | 32.55 | 32.72 | 19347500.0 |
| 2002-05-17 11:00:00 | QQQ | ETF | 32.72 | 32.8 | 32.51 | 32.52 | 7491400.0 |
| 2002-05-17 12:00:00 | QQQ | ETF | 32.53 | 32.89 | 32.5 | 32.79 | 6436500.0 |
| 2002-05-17 13:00:00 | QQQ | ETF | 32.76 | 32.85 | 32.47 | 32.55 | 4605200.0 |
| 2002-05-17 14:00:00 | QQQ | ETF | 32.55 | 32.66 | 32.48 | 32.61 | 4316700.0 |
| 2002-05-17 15:00:00 | QQQ | ETF | 32.61 | 33.01 | 32.59 | 33.0 | 14778200.0 |
| 2002-05-17 16:00:00 | QQQ | ETF | 32.98 | 33.07 | 32.7 | 33.04 | 4834700.0 |
| 2002-05-17 17:00:00 | QQQ | ETF | 33.0 | 33.03 | 32.95 | 32.99 | 66200.0 |
| 2002-05-17 18:00:00 | QQQ | ETF | 32.97 | 32.97 | 32.9 | 32.96 | 31400.0 |
| 2002-05-17 09:00:00 | IWM | ETF | 50.6 | 50.885 | 50.6 | 50.765 | 350400.0 |
| 2002-05-17 10:00:00 | IWM | ETF | 50.76 | 50.815 | 50.26 | 50.36 | 579000.0 |
| 2002-05-17 11:00:00 | IWM | ETF | 50.36 | 50.445 | 50.34 | 50.445 | 161800.0 |
| 2002-05-17 12:00:00 | IWM | ETF | 50.42 | 50.545 | 50.385 | 50.535 | 95000.0 |
| 2002-05-17 13:00:00 | IWM | ETF | 50.525 | 50.56 | 50.44 | 50.44 | 197400.0 |
| 2002-05-17 14:00:00 | IWM | ETF | 50.47 | 50.5 | 50.405 | 50.5 | 46800.0 |
| 2002-05-17 15:00:00 | IWM | ETF | 50.505 | 50.85 | 50.505 | 50.795 | 134200.0 |
| 2002-05-17 16:00:00 | IWM | ETF | 50.795 | 50.845 | 50.55 | 50.7 | 12800.0 |
| 2002-05-17 09:00:00 | DIA | ETF | 103.22 | 103.57 | 103.11 | 103.39 | 296000.0 |
| 2002-05-17 10:00:00 | DIA | ETF | 103.38 | 103.63 | 102.64 | 102.89 | 594100.0 |
| 2002-05-17 11:00:00 | DIA | ETF | 102.88 | 102.94 | 102.65 | 102.65 | 114400.0 |
| 2002-05-17 12:00:00 | DIA | ETF | 102.66 | 103.03 | 102.65 | 102.9 | 169500.0 |
| 2002-05-17 13:00:00 | DIA | ETF | 102.85 | 103.06 | 102.8 | 102.9 | 129900.0 |
| 2002-05-17 14:00:00 | DIA | ETF | 102.94 | 103.05 | 102.74 | 102.97 | 131800.0 |
| 2002-05-17 15:00:00 | DIA | ETF | 103.03 | 103.6 | 103.03 | 103.55 | 682700.0 |
| 2002-05-17 16:00:00 | DIA | ETF | 103.6 | 103.64 | 103.43 | 103.6 | 99200.0 |
| 2002-05-17 17:00:00 | DIA | ETF | 103.66 | 103.66 | 103.66 | 103.66 | 100.0 |
> showing 35 of 308 rows — these rows as CSV