PREVIEW / etf_1hour / 2001-04-19
file: by_date/etf_1hour/2001/2001-04-19.parquet size: 12 KB rows: 229
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-04-19 09:00:00 | SPY | ETF | 124.25 | 124.4 | 123.7 | 123.94 | 1411600.0 |
| 2001-04-19 10:00:00 | SPY | ETF | 123.94 | 124.84 | 123.58 | 124.73 | 2031900.0 |
| 2001-04-19 11:00:00 | SPY | ETF | 124.73 | 124.98 | 124.01 | 124.01 | 1344200.0 |
| 2001-04-19 12:00:00 | SPY | ETF | 124.07 | 124.64 | 123.92 | 124.52 | 2455900.0 |
| 2001-04-19 13:00:00 | SPY | ETF | 124.51 | 125.4 | 124.45 | 125.29 | 1053800.0 |
| 2001-04-19 14:00:00 | SPY | ETF | 125.29 | 125.49 | 124.85 | 125.01 | 2721400.0 |
| 2001-04-19 15:00:00 | SPY | ETF | 125.05 | 125.83 | 124.63 | 125.72 | 2038700.0 |
| 2001-04-19 16:00:00 | SPY | ETF | 125.75 | 126.0 | 125.35 | 125.45 | 503300.0 |
| 2001-04-19 17:00:00 | SPY | ETF | 125.5 | 125.92 | 124.2 | 125.92 | 3600.0 |
| 2001-04-19 18:00:00 | SPY | ETF | 125.92 | 126.0 | 125.92 | 126.0 | 1200.0 |
| 2001-04-19 09:00:00 | QQQ | ETF | 46.1 | 46.45 | 45.58 | 46.2 | 16597600.0 |
| 2001-04-19 10:00:00 | QQQ | ETF | 46.2 | 47.1 | 45.87 | 46.98 | 22539800.0 |
| 2001-04-19 11:00:00 | QQQ | ETF | 46.98 | 47.12 | 46.4 | 46.45 | 10422200.0 |
| 2001-04-19 12:00:00 | QQQ | ETF | 46.48 | 46.99 | 46.25 | 46.96 | 6183100.0 |
| 2001-04-19 13:00:00 | QQQ | ETF | 46.95 | 47.83 | 46.86 | 47.78 | 13855800.0 |
| 2001-04-19 14:00:00 | QQQ | ETF | 47.8 | 48.0 | 46.5 | 47.5 | 11489300.0 |
| 2001-04-19 15:00:00 | QQQ | ETF | 47.51 | 48.73 | 47.21 | 48.7 | 16144300.0 |
| 2001-04-19 16:00:00 | QQQ | ETF | 48.7 | 49.5 | 46.5 | 48.64 | 6524400.0 |
| 2001-04-19 17:00:00 | QQQ | ETF | 48.6 | 49.5 | 48.5 | 49.1 | 799900.0 |
| 2001-04-19 18:00:00 | QQQ | ETF | 49.15 | 49.65 | 49.12 | 49.6 | 810000.0 |
| 2001-04-19 09:00:00 | IWM | ETF | 46.65 | 46.75 | 46.51 | 46.75 | 56000.0 |
| 2001-04-19 10:00:00 | IWM | ETF | 46.745 | 46.85 | 46.35 | 46.825 | 48200.0 |
| 2001-04-19 11:00:00 | IWM | ETF | 46.825 | 46.9 | 46.675 | 46.75 | 26200.0 |
| 2001-04-19 12:00:00 | IWM | ETF | 46.685 | 46.825 | 46.625 | 46.825 | 6400.0 |
| 2001-04-19 13:00:00 | IWM | ETF | 46.825 | 47.2 | 46.825 | 47.2 | 18200.0 |
| 2001-04-19 14:00:00 | IWM | ETF | 47.2 | 47.2 | 46.975 | 47.0 | 33200.0 |
| 2001-04-19 15:00:00 | IWM | ETF | 46.855 | 47.245 | 46.725 | 47.195 | 13400.0 |
| 2001-04-19 09:00:00 | DIA | ETF | 106.4 | 106.45 | 105.7 | 105.9 | 741100.0 |
| 2001-04-19 10:00:00 | DIA | ETF | 105.85 | 106.77 | 105.7 | 106.55 | 861800.0 |
| 2001-04-19 11:00:00 | DIA | ETF | 106.49 | 106.67 | 105.95 | 105.96 | 426500.0 |
| 2001-04-19 12:00:00 | DIA | ETF | 105.95 | 106.4 | 105.95 | 106.3 | 189600.0 |
| 2001-04-19 13:00:00 | DIA | ETF | 106.3 | 106.9 | 106.15 | 106.68 | 556400.0 |
| 2001-04-19 14:00:00 | DIA | ETF | 106.67 | 106.9 | 106.44 | 106.56 | 250000.0 |
| 2001-04-19 15:00:00 | DIA | ETF | 106.6 | 107.15 | 106.21 | 107.0 | 387000.0 |
| 2001-04-19 16:00:00 | DIA | ETF | 107.0 | 108.0 | 106.9 | 108.0 | 182600.0 |
| 2001-04-19 17:00:00 | DIA | ETF | 108.0 | 108.0 | 108.0 | 108.0 | 200.0 |
> showing 36 of 229 rows — these rows as CSV