PREVIEW / etf_1hour / 2001-05-16
file: by_date/etf_1hour/2001/2001-05-16.parquet size: 12 KB rows: 223
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-16 09:00:00 | SPY | ETF | 124.84 | 125.32 | 124.62 | 124.86 | 1197200.0 |
| 2001-05-16 10:00:00 | SPY | ETF | 124.94 | 126.61 | 124.77 | 126.35 | 2246500.0 |
| 2001-05-16 11:00:00 | SPY | ETF | 126.35 | 126.95 | 126.27 | 126.63 | 1326400.0 |
| 2001-05-16 12:00:00 | SPY | ETF | 126.7 | 126.96 | 126.52 | 126.91 | 573500.0 |
| 2001-05-16 13:00:00 | SPY | ETF | 126.93 | 127.75 | 126.93 | 127.7 | 1494800.0 |
| 2001-05-16 14:00:00 | SPY | ETF | 127.72 | 128.59 | 127.65 | 128.56 | 1880200.0 |
| 2001-05-16 15:00:00 | SPY | ETF | 128.58 | 129.2 | 128.42 | 128.96 | 3332300.0 |
| 2001-05-16 16:00:00 | SPY | ETF | 128.97 | 129.07 | 128.39 | 129.05 | 2561100.0 |
| 2001-05-16 17:00:00 | SPY | ETF | 128.99 | 129.13 | 128.99 | 129.12 | 23300.0 |
| 2001-05-16 09:00:00 | QQQ | ETF | 44.31 | 44.87 | 44.06 | 44.53 | 10647800.0 |
| 2001-05-16 10:00:00 | QQQ | ETF | 44.53 | 45.66 | 44.32 | 45.45 | 13157500.0 |
| 2001-05-16 11:00:00 | QQQ | ETF | 45.43 | 45.95 | 45.23 | 45.46 | 10197600.0 |
| 2001-05-16 12:00:00 | QQQ | ETF | 45.53 | 45.89 | 45.45 | 45.87 | 3397700.0 |
| 2001-05-16 13:00:00 | QQQ | ETF | 45.88 | 46.53 | 45.8 | 46.53 | 9604600.0 |
| 2001-05-16 14:00:00 | QQQ | ETF | 46.53 | 47.34 | 46.45 | 47.25 | 12782600.0 |
| 2001-05-16 15:00:00 | QQQ | ETF | 47.27 | 47.52 | 46.94 | 47.26 | 14454600.0 |
| 2001-05-16 16:00:00 | QQQ | ETF | 47.25 | 47.36 | 46.6 | 47.34 | 2403100.0 |
| 2001-05-16 17:00:00 | QQQ | ETF | 47.31 | 47.48 | 47.25 | 47.44 | 378200.0 |
| 2001-05-16 18:00:00 | QQQ | ETF | 47.42 | 47.49 | 47.35 | 47.42 | 26500.0 |
| 2001-05-16 09:00:00 | IWM | ETF | 48.55 | 48.85 | 48.55 | 48.835 | 37600.0 |
| 2001-05-16 10:00:00 | IWM | ETF | 48.6 | 49.275 | 48.6 | 49.275 | 24400.0 |
| 2001-05-16 11:00:00 | IWM | ETF | 49.175 | 49.345 | 49.125 | 49.2 | 133400.0 |
| 2001-05-16 12:00:00 | IWM | ETF | 49.295 | 49.295 | 49.175 | 49.25 | 25600.0 |
| 2001-05-16 13:00:00 | IWM | ETF | 49.27 | 49.4 | 49.25 | 49.4 | 9000.0 |
| 2001-05-16 14:00:00 | IWM | ETF | 49.475 | 49.775 | 49.425 | 49.775 | 120800.0 |
| 2001-05-16 15:00:00 | IWM | ETF | 49.745 | 49.875 | 49.675 | 49.865 | 171600.0 |
| 2001-05-16 16:00:00 | IWM | ETF | 49.865 | 49.865 | 49.865 | 49.865 | 6600.0 |
| 2001-05-16 09:00:00 | DIA | ETF | 108.4 | 108.9 | 108.35 | 108.59 | 451100.0 |
| 2001-05-16 10:00:00 | DIA | ETF | 108.6 | 110.22 | 108.58 | 110.0 | 1608100.0 |
| 2001-05-16 11:00:00 | DIA | ETF | 109.93 | 110.5 | 109.87 | 110.17 | 1083700.0 |
| 2001-05-16 12:00:00 | DIA | ETF | 110.19 | 110.6 | 110.13 | 110.6 | 376300.0 |
| 2001-05-16 13:00:00 | DIA | ETF | 110.59 | 111.31 | 110.56 | 111.19 | 715900.0 |
| 2001-05-16 14:00:00 | DIA | ETF | 111.19 | 111.85 | 111.12 | 111.75 | 629500.0 |
| 2001-05-16 15:00:00 | DIA | ETF | 111.78 | 112.65 | 111.66 | 112.42 | 2705200.0 |
| 2001-05-16 16:00:00 | DIA | ETF | 112.45 | 112.6 | 112.12 | 112.43 | 137700.0 |
| 2001-05-16 17:00:00 | DIA | ETF | 112.43 | 112.56 | 112.4 | 112.56 | 1100.0 |
| 2001-05-16 18:00:00 | DIA | ETF | 112.4 | 112.4 | 112.3 | 112.3 | 500.0 |
> showing 37 of 223 rows — these rows as CSV