PREVIEW / etf_1hour / 2002-02-12
file: by_date/etf_1hour/2002/2002-02-12.parquet size: 13 KB rows: 291
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-12 09:00:00 | SPY | ETF | 110.96 | 111.0 | 110.63 | 110.81 | 2558500.0 |
| 2002-02-12 10:00:00 | SPY | ETF | 110.77 | 111.2 | 110.62 | 111.17 | 1973100.0 |
| 2002-02-12 11:00:00 | SPY | ETF | 111.16 | 111.22 | 110.8 | 110.9 | 1409700.0 |
| 2002-02-12 12:00:00 | SPY | ETF | 110.88 | 111.3 | 110.83 | 111.29 | 1252100.0 |
| 2002-02-12 13:00:00 | SPY | ETF | 111.29 | 111.53 | 111.07 | 111.1 | 1241800.0 |
| 2002-02-12 14:00:00 | SPY | ETF | 111.12 | 111.71 | 111.08 | 111.5 | 1813200.0 |
| 2002-02-12 15:00:00 | SPY | ETF | 111.49 | 111.51 | 110.93 | 111.13 | 2540100.0 |
| 2002-02-12 16:00:00 | SPY | ETF | 111.11 | 111.2 | 111.01 | 111.14 | 992500.0 |
| 2002-02-12 17:00:00 | SPY | ETF | 111.16 | 111.18 | 111.15 | 111.17 | 11000.0 |
| 2002-02-12 18:00:00 | SPY | ETF | 111.2 | 111.2 | 111.2 | 111.2 | 700.0 |
| 2002-02-12 09:00:00 | QQQ | ETF | 36.31 | 36.34 | 36.04 | 36.09 | 7018000.0 |
| 2002-02-12 10:00:00 | QQQ | ETF | 36.1 | 36.47 | 36.04 | 36.43 | 8400900.0 |
| 2002-02-12 11:00:00 | QQQ | ETF | 36.43 | 36.48 | 36.23 | 36.27 | 5304900.0 |
| 2002-02-12 12:00:00 | QQQ | ETF | 36.28 | 36.6 | 36.25 | 36.59 | 4002200.0 |
| 2002-02-12 13:00:00 | QQQ | ETF | 36.58 | 36.75 | 36.46 | 36.52 | 5709600.0 |
| 2002-02-12 14:00:00 | QQQ | ETF | 36.52 | 36.98 | 36.49 | 36.84 | 7720200.0 |
| 2002-02-12 15:00:00 | QQQ | ETF | 36.84 | 36.89 | 36.45 | 36.52 | 8661200.0 |
| 2002-02-12 16:00:00 | QQQ | ETF | 36.53 | 36.6 | 36.25 | 36.38 | 4001100.0 |
| 2002-02-12 17:00:00 | QQQ | ETF | 36.38 | 36.5 | 36.38 | 36.47 | 116800.0 |
| 2002-02-12 18:00:00 | QQQ | ETF | 36.47 | 36.55 | 36.47 | 36.5 | 180900.0 |
| 2002-02-12 09:00:00 | IWM | ETF | 46.65 | 46.705 | 46.5 | 46.56 | 47200.0 |
| 2002-02-12 10:00:00 | IWM | ETF | 46.55 | 46.685 | 46.48 | 46.645 | 27000.0 |
| 2002-02-12 11:00:00 | IWM | ETF | 46.78 | 46.86 | 46.67 | 46.75 | 33200.0 |
| 2002-02-12 12:00:00 | IWM | ETF | 46.67 | 46.87 | 46.67 | 46.81 | 23200.0 |
| 2002-02-12 13:00:00 | IWM | ETF | 46.9 | 47.04 | 46.9 | 46.99 | 36200.0 |
| 2002-02-12 14:00:00 | IWM | ETF | 46.99 | 47.12 | 46.89 | 47.025 | 32400.0 |
| 2002-02-12 15:00:00 | IWM | ETF | 47.05 | 47.09 | 46.84 | 46.94 | 184600.0 |
| 2002-02-12 16:00:00 | IWM | ETF | 46.88 | 46.905 | 46.88 | 46.905 | 6000.0 |
| 2002-02-12 09:00:00 | DIA | ETF | 98.46 | 98.64 | 98.23 | 98.35 | 306700.0 |
| 2002-02-12 10:00:00 | DIA | ETF | 98.29 | 98.68 | 98.2 | 98.68 | 180500.0 |
| 2002-02-12 11:00:00 | DIA | ETF | 98.68 | 98.68 | 98.37 | 98.54 | 165300.0 |
| 2002-02-12 12:00:00 | DIA | ETF | 98.54 | 98.9 | 98.49 | 98.85 | 135600.0 |
| 2002-02-12 13:00:00 | DIA | ETF | 98.92 | 99.15 | 98.7 | 98.7 | 145400.0 |
| 2002-02-12 14:00:00 | DIA | ETF | 98.79 | 99.24 | 98.74 | 99.0 | 156500.0 |
| 2002-02-12 15:00:00 | DIA | ETF | 99.0 | 99.07 | 98.51 | 98.82 | 224600.0 |
| 2002-02-12 16:00:00 | DIA | ETF | 98.78 | 98.84 | 98.7 | 98.73 | 14900.0 |
> showing 36 of 291 rows — these rows as CSV