PREVIEW / etf_1hour / 2002-01-07
file: by_date/etf_1hour/2002/2002-01-07.parquet size: 14 KB rows: 296
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-01-07 09:00:00 | SPY | ETF | 117.7 | 117.99 | 117.47 | 117.51 | 2139800.0 |
| 2002-01-07 10:00:00 | SPY | ETF | 117.5 | 117.9 | 117.32 | 117.51 | 1752400.0 |
| 2002-01-07 11:00:00 | SPY | ETF | 117.45 | 117.53 | 116.85 | 116.94 | 1940600.0 |
| 2002-01-07 12:00:00 | SPY | ETF | 116.93 | 117.22 | 116.85 | 117.11 | 992900.0 |
| 2002-01-07 13:00:00 | SPY | ETF | 117.12 | 117.28 | 116.88 | 117.09 | 716600.0 |
| 2002-01-07 14:00:00 | SPY | ETF | 117.09 | 117.36 | 116.83 | 116.92 | 1604500.0 |
| 2002-01-07 15:00:00 | SPY | ETF | 116.95 | 117.1 | 116.56 | 116.74 | 2117800.0 |
| 2002-01-07 16:00:00 | SPY | ETF | 116.74 | 116.9 | 116.55 | 116.86 | 1631400.0 |
| 2002-01-07 09:00:00 | QQQ | ETF | 42.11 | 42.22 | 41.82 | 41.89 | 13025400.0 |
| 2002-01-07 10:00:00 | QQQ | ETF | 41.89 | 42.02 | 41.61 | 41.65 | 14539700.0 |
| 2002-01-07 11:00:00 | QQQ | ETF | 41.65 | 41.71 | 41.1 | 41.2 | 8579300.0 |
| 2002-01-07 12:00:00 | QQQ | ETF | 41.21 | 41.41 | 41.1 | 41.31 | 7466000.0 |
| 2002-01-07 13:00:00 | QQQ | ETF | 41.29 | 41.61 | 41.15 | 41.48 | 6069100.0 |
| 2002-01-07 14:00:00 | QQQ | ETF | 41.5 | 41.72 | 41.23 | 41.37 | 8529500.0 |
| 2002-01-07 15:00:00 | QQQ | ETF | 41.36 | 41.45 | 40.97 | 41.07 | 12273800.0 |
| 2002-01-07 16:00:00 | QQQ | ETF | 41.09 | 41.45 | 41.07 | 41.35 | 3595700.0 |
| 2002-01-07 17:00:00 | QQQ | ETF | 41.37 | 41.45 | 41.26 | 41.3 | 185400.0 |
| 2002-01-07 18:00:00 | QQQ | ETF | 41.29 | 41.3 | 41.19 | 41.19 | 115200.0 |
| 2002-01-07 09:00:00 | IWM | ETF | 49.675 | 49.9 | 49.625 | 49.745 | 458000.0 |
| 2002-01-07 10:00:00 | IWM | ETF | 49.795 | 49.795 | 49.525 | 49.72 | 86200.0 |
| 2002-01-07 11:00:00 | IWM | ETF | 49.65 | 49.685 | 49.35 | 49.44 | 510600.0 |
| 2002-01-07 12:00:00 | IWM | ETF | 49.36 | 49.55 | 49.36 | 49.505 | 67800.0 |
| 2002-01-07 13:00:00 | IWM | ETF | 49.45 | 49.535 | 49.36 | 49.49 | 138800.0 |
| 2002-01-07 14:00:00 | IWM | ETF | 49.485 | 49.575 | 49.375 | 49.38 | 78200.0 |
| 2002-01-07 15:00:00 | IWM | ETF | 49.45 | 49.49 | 48.925 | 48.925 | 319400.0 |
| 2002-01-07 16:00:00 | IWM | ETF | 49.0 | 49.0 | 49.0 | 49.0 | 200.0 |
| 2002-01-07 09:00:00 | DIA | ETF | 102.87 | 103.07 | 102.6 | 102.66 | 234700.0 |
| 2002-01-07 10:00:00 | DIA | ETF | 102.66 | 103.14 | 102.6 | 102.72 | 432000.0 |
| 2002-01-07 11:00:00 | DIA | ETF | 102.82 | 102.82 | 102.16 | 102.29 | 267800.0 |
| 2002-01-07 12:00:00 | DIA | ETF | 102.2 | 102.55 | 102.2 | 102.42 | 202500.0 |
| 2002-01-07 13:00:00 | DIA | ETF | 102.41 | 102.56 | 102.23 | 102.43 | 112500.0 |
| 2002-01-07 14:00:00 | DIA | ETF | 102.41 | 102.56 | 102.18 | 102.3 | 724100.0 |
| 2002-01-07 15:00:00 | DIA | ETF | 102.3 | 102.42 | 101.89 | 102.08 | 461300.0 |
| 2002-01-07 16:00:00 | DIA | ETF | 102.11 | 102.24 | 102.02 | 102.14 | 30200.0 |
> showing 34 of 296 rows — these rows as CSV