PREVIEW / etf_1hour / 2001-04-26
file: by_date/etf_1hour/2001/2001-04-26.parquet size: 11 KB rows: 226
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-26 09:00:00 | SPY | ETF | 123.73 | 124.1 | 123.51 | 124.06 | 1108600.0 |
| 2001-04-26 10:00:00 | SPY | ETF | 124.0 | 124.65 | 123.92 | 124.5 | 2011400.0 |
| 2001-04-26 11:00:00 | SPY | ETF | 124.54 | 124.54 | 123.82 | 124.07 | 876300.0 |
| 2001-04-26 12:00:00 | SPY | ETF | 124.09 | 124.94 | 123.82 | 124.78 | 667800.0 |
| 2001-04-26 13:00:00 | SPY | ETF | 124.87 | 125.22 | 124.58 | 124.75 | 744100.0 |
| 2001-04-26 14:00:00 | SPY | ETF | 124.87 | 124.87 | 123.68 | 123.81 | 1766000.0 |
| 2001-04-26 15:00:00 | SPY | ETF | 123.88 | 124.23 | 123.5 | 123.74 | 1988500.0 |
| 2001-04-26 16:00:00 | SPY | ETF | 123.83 | 126.0 | 123.66 | 124.0 | 841200.0 |
| 2001-04-26 17:00:00 | SPY | ETF | 124.98 | 124.98 | 123.01 | 123.01 | 300.0 |
| 2001-04-26 18:00:00 | SPY | ETF | 124.98 | 124.98 | 123.01 | 123.01 | 300.0 |
| 2001-04-26 09:00:00 | QQQ | ETF | 45.9 | 45.95 | 45.25 | 45.62 | 8936400.0 |
| 2001-04-26 10:00:00 | QQQ | ETF | 45.6 | 46.0 | 45.42 | 45.82 | 8940300.0 |
| 2001-04-26 11:00:00 | QQQ | ETF | 45.81 | 45.83 | 44.95 | 45.25 | 9764400.0 |
| 2001-04-26 12:00:00 | QQQ | ETF | 45.24 | 45.83 | 45.03 | 45.7 | 6548700.0 |
| 2001-04-26 13:00:00 | QQQ | ETF | 45.79 | 45.85 | 45.25 | 45.39 | 5170200.0 |
| 2001-04-26 14:00:00 | QQQ | ETF | 45.38 | 45.4 | 44.04 | 44.22 | 14410500.0 |
| 2001-04-26 15:00:00 | QQQ | ETF | 44.23 | 44.55 | 43.87 | 43.94 | 11195400.0 |
| 2001-04-26 16:00:00 | QQQ | ETF | 43.94 | 44.54 | 43.9 | 44.18 | 1748700.0 |
| 2001-04-26 17:00:00 | QQQ | ETF | 44.16 | 44.18 | 43.99 | 44.05 | 78800.0 |
| 2001-04-26 18:00:00 | QQQ | ETF | 44.02 | 44.09 | 44.02 | 44.04 | 3700.0 |
| 2001-04-26 09:00:00 | IWM | ETF | 47.25 | 47.425 | 47.175 | 47.425 | 83400.0 |
| 2001-04-26 10:00:00 | IWM | ETF | 47.525 | 47.85 | 47.525 | 47.85 | 62000.0 |
| 2001-04-26 11:00:00 | IWM | ETF | 47.825 | 47.825 | 47.6 | 47.675 | 37200.0 |
| 2001-04-26 12:00:00 | IWM | ETF | 47.845 | 47.875 | 47.65 | 47.875 | 5400.0 |
| 2001-04-26 13:00:00 | IWM | ETF | 47.95 | 47.95 | 47.755 | 47.95 | 14800.0 |
| 2001-04-26 14:00:00 | IWM | ETF | 47.8 | 47.9 | 47.45 | 47.45 | 20600.0 |
| 2001-04-26 15:00:00 | IWM | ETF | 47.5 | 47.725 | 47.4 | 47.625 | 31600.0 |
| 2001-04-26 16:00:00 | IWM | ETF | 47.675 | 47.85 | 47.675 | 47.85 | 17200.0 |
| 2001-04-26 09:00:00 | DIA | ETF | 106.7 | 106.7 | 106.29 | 106.69 | 272200.0 |
| 2001-04-26 10:00:00 | DIA | ETF | 106.7 | 107.18 | 106.55 | 106.9 | 310200.0 |
| 2001-04-26 11:00:00 | DIA | ETF | 106.98 | 106.99 | 106.52 | 106.65 | 308500.0 |
| 2001-04-26 12:00:00 | DIA | ETF | 106.65 | 107.39 | 106.51 | 107.34 | 326500.0 |
| 2001-04-26 13:00:00 | DIA | ETF | 107.23 | 107.79 | 107.18 | 107.45 | 597900.0 |
| 2001-04-26 14:00:00 | DIA | ETF | 107.54 | 107.54 | 106.8 | 106.96 | 324900.0 |
| 2001-04-26 15:00:00 | DIA | ETF | 106.97 | 107.25 | 106.69 | 107.05 | 366000.0 |
| 2001-04-26 16:00:00 | DIA | ETF | 106.95 | 107.2 | 106.15 | 106.82 | 18600.0 |
> showing 36 of 226 rows — these rows as CSV