PREVIEW / etf_1hour / 2001-04-18
file: by_date/etf_1hour/2001/2001-04-18.parquet size: 12 KB rows: 245
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-18 09:00:00 | SPY | ETF | 121.06 | 121.29 | 120.69 | 121.21 | 2121700.0 |
| 2001-04-18 10:00:00 | SPY | ETF | 121.24 | 126.0 | 120.95 | 126.0 | 3410800.0 |
| 2001-04-18 11:00:00 | SPY | ETF | 124.56 | 125.6 | 123.61 | 124.69 | 4774100.0 |
| 2001-04-18 12:00:00 | SPY | ETF | 124.69 | 124.86 | 124.3 | 124.44 | 1225200.0 |
| 2001-04-18 13:00:00 | SPY | ETF | 124.45 | 124.75 | 124.05 | 124.65 | 1740700.0 |
| 2001-04-18 14:00:00 | SPY | ETF | 124.69 | 125.26 | 124.35 | 124.87 | 2763300.0 |
| 2001-04-18 15:00:00 | SPY | ETF | 124.83 | 124.98 | 123.86 | 124.14 | 2973300.0 |
| 2001-04-18 16:00:00 | SPY | ETF | 124.06 | 124.95 | 123.5 | 124.9 | 12711300.0 |
| 2001-04-18 17:00:00 | SPY | ETF | 124.91 | 125.43 | 124.91 | 125.4 | 126100.0 |
| 2001-04-18 18:00:00 | SPY | ETF | 125.3 | 125.38 | 125.0 | 125.37 | 7500.0 |
| 2001-04-18 09:00:00 | QQQ | ETF | 43.72 | 43.94 | 43.35 | 43.75 | 15331800.0 |
| 2001-04-18 10:00:00 | QQQ | ETF | 43.75 | 51.0 | 43.69 | 46.5 | 24467000.0 |
| 2001-04-18 11:00:00 | QQQ | ETF | 46.5 | 48.0 | 45.4 | 46.15 | 30498300.0 |
| 2001-04-18 12:00:00 | QQQ | ETF | 46.18 | 46.65 | 46.0 | 46.33 | 9577800.0 |
| 2001-04-18 13:00:00 | QQQ | ETF | 46.33 | 46.9 | 46.2 | 46.9 | 7644300.0 |
| 2001-04-18 14:00:00 | QQQ | ETF | 46.9 | 47.25 | 46.53 | 46.85 | 12526600.0 |
| 2001-04-18 15:00:00 | QQQ | ETF | 46.84 | 46.94 | 45.5 | 45.59 | 16812300.0 |
| 2001-04-18 16:00:00 | QQQ | ETF | 45.62 | 47.16 | 45.4 | 46.77 | 7414600.0 |
| 2001-04-18 17:00:00 | QQQ | ETF | 46.79 | 47.0 | 43.5 | 46.85 | 1884500.0 |
| 2001-04-18 18:00:00 | QQQ | ETF | 46.85 | 46.96 | 46.75 | 46.85 | 187700.0 |
| 2001-04-18 09:00:00 | IWM | ETF | 46.075 | 46.15 | 46.0 | 46.125 | 287800.0 |
| 2001-04-18 10:00:00 | IWM | ETF | 46.125 | 47.25 | 46.125 | 47.0 | 64600.0 |
| 2001-04-18 11:00:00 | IWM | ETF | 48.0 | 48.0 | 46.5 | 47.25 | 119200.0 |
| 2001-04-18 12:00:00 | IWM | ETF | 47.47 | 47.495 | 47.15 | 47.275 | 10600.0 |
| 2001-04-18 13:00:00 | IWM | ETF | 47.2 | 47.455 | 47.2 | 47.32 | 39400.0 |
| 2001-04-18 14:00:00 | IWM | ETF | 47.325 | 47.325 | 47.245 | 47.3 | 25400.0 |
| 2001-04-18 15:00:00 | IWM | ETF | 47.23 | 47.245 | 46.45 | 46.5 | 127600.0 |
| 2001-04-18 16:00:00 | IWM | ETF | 46.7 | 46.7 | 46.675 | 46.7 | 3800.0 |
| 2001-04-18 09:00:00 | DIA | ETF | 103.25 | 103.7 | 103.11 | 103.59 | 968900.0 |
| 2001-04-18 10:00:00 | DIA | ETF | 103.48 | 107.1 | 103.4 | 106.51 | 1589600.0 |
| 2001-04-18 11:00:00 | DIA | ETF | 106.99 | 107.45 | 105.5 | 106.74 | 2210800.0 |
| 2001-04-18 12:00:00 | DIA | ETF | 106.6 | 106.79 | 106.3 | 106.43 | 899700.0 |
| 2001-04-18 13:00:00 | DIA | ETF | 106.45 | 106.64 | 106.18 | 106.51 | 240700.0 |
| 2001-04-18 14:00:00 | DIA | ETF | 106.56 | 107.05 | 106.3 | 106.6 | 926400.0 |
| 2001-04-18 15:00:00 | DIA | ETF | 106.6 | 106.69 | 105.95 | 106.1 | 1045900.0 |
| 2001-04-18 16:00:00 | DIA | ETF | 106.1 | 107.49 | 106.0 | 106.55 | 160600.0 |
| 2001-04-18 17:00:00 | DIA | ETF | 106.42 | 107.7 | 106.42 | 107.7 | 40100.0 |
| 2001-04-18 18:00:00 | DIA | ETF | 108.9 | 108.95 | 107.64 | 107.8 | 5900.0 |
> showing 38 of 245 rows — these rows as CSV