PREVIEW / etf_1hour / 2001-05-11
file: by_date/etf_1hour/2001/2001-05-11.parquet size: 11 KB rows: 218
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-05-11 09:00:00 | SPY | ETF | 126.0 | 126.49 | 125.9 | 126.06 | 891500.0 |
| 2001-05-11 10:00:00 | SPY | ETF | 126.15 | 126.18 | 124.81 | 125.05 | 1741700.0 |
| 2001-05-11 11:00:00 | SPY | ETF | 125.09 | 125.33 | 124.91 | 125.2 | 589000.0 |
| 2001-05-11 12:00:00 | SPY | ETF | 125.21 | 125.21 | 124.6 | 125.05 | 837900.0 |
| 2001-05-11 13:00:00 | SPY | ETF | 125.06 | 125.27 | 124.75 | 124.75 | 588400.0 |
| 2001-05-11 14:00:00 | SPY | ETF | 124.8 | 125.08 | 124.66 | 124.85 | 330400.0 |
| 2001-05-11 15:00:00 | SPY | ETF | 124.79 | 124.94 | 124.4 | 124.82 | 1990300.0 |
| 2001-05-11 16:00:00 | SPY | ETF | 124.82 | 125.29 | 124.82 | 125.25 | 489700.0 |
| 2001-05-11 17:00:00 | SPY | ETF | 125.25 | 125.25 | 125.15 | 125.15 | 2200.0 |
| 2001-05-11 18:00:00 | SPY | ETF | 125.15 | 125.15 | 125.15 | 125.15 | 2800.0 |
| 2001-05-11 09:00:00 | QQQ | ETF | 45.84 | 46.42 | 45.7 | 46.27 | 6947600.0 |
| 2001-05-11 10:00:00 | QQQ | ETF | 46.2 | 46.3 | 45.57 | 45.82 | 10597800.0 |
| 2001-05-11 11:00:00 | QQQ | ETF | 45.81 | 45.99 | 45.51 | 45.7 | 7402800.0 |
| 2001-05-11 12:00:00 | QQQ | ETF | 45.66 | 45.7 | 45.3 | 45.58 | 5733100.0 |
| 2001-05-11 13:00:00 | QQQ | ETF | 45.58 | 45.78 | 45.41 | 45.41 | 3384000.0 |
| 2001-05-11 14:00:00 | QQQ | ETF | 45.43 | 45.8 | 45.36 | 45.65 | 4640400.0 |
| 2001-05-11 15:00:00 | QQQ | ETF | 45.6 | 45.62 | 45.09 | 45.41 | 7277900.0 |
| 2001-05-11 16:00:00 | QQQ | ETF | 45.38 | 45.59 | 45.35 | 45.53 | 1168600.0 |
| 2001-05-11 17:00:00 | QQQ | ETF | 45.55 | 45.65 | 45.53 | 45.6 | 6700.0 |
| 2001-05-11 18:00:00 | QQQ | ETF | 45.66 | 45.7 | 45.6 | 45.67 | 5500.0 |
| 2001-05-11 09:00:00 | IWM | ETF | 48.825 | 49.175 | 48.825 | 49.05 | 50600.0 |
| 2001-05-11 10:00:00 | IWM | ETF | 49.0 | 49.0 | 48.55 | 48.6 | 123400.0 |
| 2001-05-11 11:00:00 | IWM | ETF | 48.6 | 48.8 | 48.505 | 48.575 | 72400.0 |
| 2001-05-11 12:00:00 | IWM | ETF | 48.675 | 48.7 | 48.505 | 48.53 | 70800.0 |
| 2001-05-11 13:00:00 | IWM | ETF | 48.53 | 48.67 | 48.505 | 48.625 | 104600.0 |
| 2001-05-11 14:00:00 | IWM | ETF | 48.575 | 48.67 | 48.5 | 48.66 | 41800.0 |
| 2001-05-11 15:00:00 | IWM | ETF | 48.505 | 48.67 | 48.325 | 48.375 | 410600.0 |
| 2001-05-11 16:00:00 | IWM | ETF | 48.475 | 48.565 | 48.4 | 48.46 | 18000.0 |
| 2001-05-11 09:00:00 | DIA | ETF | 109.11 | 109.37 | 108.95 | 109.11 | 517900.0 |
| 2001-05-11 10:00:00 | DIA | ETF | 109.11 | 109.25 | 108.01 | 108.3 | 1064700.0 |
| 2001-05-11 11:00:00 | DIA | ETF | 108.27 | 108.61 | 108.2 | 108.42 | 202300.0 |
| 2001-05-11 12:00:00 | DIA | ETF | 108.45 | 108.45 | 108.01 | 108.3 | 446800.0 |
| 2001-05-11 13:00:00 | DIA | ETF | 108.32 | 108.55 | 108.1 | 108.11 | 310600.0 |
| 2001-05-11 14:00:00 | DIA | ETF | 108.12 | 108.5 | 108.06 | 108.2 | 194400.0 |
| 2001-05-11 15:00:00 | DIA | ETF | 108.26 | 108.3 | 107.84 | 108.25 | 453400.0 |
| 2001-05-11 16:00:00 | DIA | ETF | 108.21 | 108.53 | 108.21 | 108.45 | 103600.0 |
> showing 36 of 218 rows — these rows as CSV