PREVIEW / etf_1hour / 2001-12-21
file: by_date/etf_1hour/2001/2001-12-21.parquet size: 14 KB rows: 294
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-21 09:00:00 | SPY | ETF | 115.03 | 115.07 | 114.68 | 114.75 | 2728100.0 |
| 2001-12-21 10:00:00 | SPY | ETF | 114.74 | 114.89 | 114.48 | 114.84 | 2062100.0 |
| 2001-12-21 11:00:00 | SPY | ETF | 114.83 | 114.84 | 114.43 | 114.47 | 912500.0 |
| 2001-12-21 12:00:00 | SPY | ETF | 114.47 | 114.51 | 114.26 | 114.35 | 886300.0 |
| 2001-12-21 13:00:00 | SPY | ETF | 114.36 | 114.62 | 114.2 | 114.54 | 1416800.0 |
| 2001-12-21 14:00:00 | SPY | ETF | 114.58 | 114.9 | 114.53 | 114.84 | 1814400.0 |
| 2001-12-21 15:00:00 | SPY | ETF | 114.83 | 114.99 | 114.64 | 114.66 | 2074400.0 |
| 2001-12-21 16:00:00 | SPY | ETF | 114.68 | 114.98 | 114.57 | 114.95 | 1633300.0 |
| 2001-12-21 17:00:00 | SPY | ETF | 114.75 | 114.97 | 114.75 | 114.9 | 5100.0 |
| 2001-12-21 18:00:00 | SPY | ETF | 114.9 | 114.9 | 114.9 | 114.9 | 500.0 |
| 2001-12-21 09:00:00 | QQQ | ETF | 39.42 | 39.59 | 39.21 | 39.52 | 10190800.0 |
| 2001-12-21 10:00:00 | QQQ | ETF | 39.52 | 39.54 | 39.18 | 39.45 | 10155400.0 |
| 2001-12-21 11:00:00 | QQQ | ETF | 39.44 | 39.48 | 39.18 | 39.23 | 4940900.0 |
| 2001-12-21 12:00:00 | QQQ | ETF | 39.25 | 39.35 | 39.15 | 39.27 | 4467000.0 |
| 2001-12-21 13:00:00 | QQQ | ETF | 39.29 | 39.39 | 39.17 | 39.37 | 3660900.0 |
| 2001-12-21 14:00:00 | QQQ | ETF | 39.37 | 39.71 | 39.33 | 39.55 | 7673200.0 |
| 2001-12-21 15:00:00 | QQQ | ETF | 39.55 | 39.64 | 39.26 | 39.34 | 11748900.0 |
| 2001-12-21 16:00:00 | QQQ | ETF | 39.3 | 39.56 | 39.28 | 39.54 | 2678200.0 |
| 2001-12-21 17:00:00 | QQQ | ETF | 39.54 | 39.55 | 39.42 | 39.46 | 60100.0 |
| 2001-12-21 18:00:00 | QQQ | ETF | 39.46 | 39.49 | 39.45 | 39.46 | 502600.0 |
| 2001-12-21 09:00:00 | IWM | ETF | 47.45 | 47.47 | 47.205 | 47.385 | 63400.0 |
| 2001-12-21 10:00:00 | IWM | ETF | 47.38 | 47.405 | 47.21 | 47.365 | 87400.0 |
| 2001-12-21 11:00:00 | IWM | ETF | 47.325 | 47.41 | 47.325 | 47.41 | 150400.0 |
| 2001-12-21 12:00:00 | IWM | ETF | 47.41 | 47.695 | 47.305 | 47.65 | 675400.0 |
| 2001-12-21 13:00:00 | IWM | ETF | 47.7 | 47.875 | 47.505 | 47.655 | 135600.0 |
| 2001-12-21 14:00:00 | IWM | ETF | 47.8 | 47.915 | 47.705 | 47.855 | 138400.0 |
| 2001-12-21 15:00:00 | IWM | ETF | 47.9 | 48.24 | 47.725 | 48.125 | 159200.0 |
| 2001-12-21 16:00:00 | IWM | ETF | 48.15 | 48.2 | 48.1 | 48.1 | 115600.0 |
| 2001-12-21 09:00:00 | DIA | ETF | 100.55 | 100.71 | 100.4 | 100.58 | 1050800.0 |
| 2001-12-21 10:00:00 | DIA | ETF | 100.55 | 100.77 | 100.38 | 100.64 | 440800.0 |
| 2001-12-21 11:00:00 | DIA | ETF | 100.6 | 100.67 | 100.26 | 100.26 | 59500.0 |
| 2001-12-21 12:00:00 | DIA | ETF | 100.31 | 100.31 | 100.13 | 100.24 | 136500.0 |
| 2001-12-21 13:00:00 | DIA | ETF | 100.18 | 100.25 | 100.01 | 100.25 | 714500.0 |
| 2001-12-21 14:00:00 | DIA | ETF | 100.28 | 100.48 | 100.16 | 100.45 | 197700.0 |
| 2001-12-21 15:00:00 | DIA | ETF | 100.36 | 100.6 | 100.36 | 100.45 | 282400.0 |
| 2001-12-21 16:00:00 | DIA | ETF | 100.36 | 100.5 | 100.36 | 100.44 | 36500.0 |
> showing 36 of 294 rows — these rows as CSV