PREVIEW / etf_1hour / 2001-05-23
file: by_date/etf_1hour/2001/2001-05-23.parquet size: 11 KB rows: 228
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-23 09:00:00 | SPY | ETF | 131.05 | 131.05 | 130.31 | 130.4 | 1383100.0 |
| 2001-05-23 10:00:00 | SPY | ETF | 130.38 | 130.48 | 129.8 | 130.18 | 1881700.0 |
| 2001-05-23 11:00:00 | SPY | ETF | 130.17 | 130.19 | 129.45 | 129.86 | 1620100.0 |
| 2001-05-23 12:00:00 | SPY | ETF | 129.9 | 130.2 | 129.77 | 129.96 | 1017900.0 |
| 2001-05-23 13:00:00 | SPY | ETF | 129.98 | 130.1 | 129.46 | 129.65 | 718300.0 |
| 2001-05-23 14:00:00 | SPY | ETF | 129.68 | 130.14 | 129.45 | 129.95 | 1440700.0 |
| 2001-05-23 15:00:00 | SPY | ETF | 129.98 | 130.12 | 129.29 | 129.29 | 2620400.0 |
| 2001-05-23 16:00:00 | SPY | ETF | 129.29 | 129.5 | 129.2 | 129.2 | 1192600.0 |
| 2001-05-23 17:00:00 | SPY | ETF | 129.18 | 129.27 | 129.18 | 129.18 | 500.0 |
| 2001-05-23 09:00:00 | QQQ | ETF | 50.44 | 50.45 | 49.77 | 49.8 | 10449700.0 |
| 2001-05-23 10:00:00 | QQQ | ETF | 49.79 | 49.99 | 49.37 | 49.8 | 12869700.0 |
| 2001-05-23 11:00:00 | QQQ | ETF | 49.82 | 49.87 | 49.16 | 49.54 | 8059100.0 |
| 2001-05-23 12:00:00 | QQQ | ETF | 49.55 | 49.9 | 49.47 | 49.8 | 5418100.0 |
| 2001-05-23 13:00:00 | QQQ | ETF | 49.82 | 49.94 | 49.3 | 49.37 | 5810500.0 |
| 2001-05-23 14:00:00 | QQQ | ETF | 49.35 | 49.72 | 49.14 | 49.52 | 7700800.0 |
| 2001-05-23 15:00:00 | QQQ | ETF | 49.53 | 49.68 | 48.77 | 48.8 | 11087900.0 |
| 2001-05-23 16:00:00 | QQQ | ETF | 48.8 | 49.25 | 48.57 | 48.59 | 2075300.0 |
| 2001-05-23 17:00:00 | QQQ | ETF | 48.6 | 48.66 | 48.52 | 48.56 | 26400.0 |
| 2001-05-23 18:00:00 | QQQ | ETF | 48.8 | 48.8 | 48.57 | 48.65 | 7600.0 |
| 2001-05-23 09:00:00 | IWM | ETF | 51.325 | 51.475 | 51.15 | 51.15 | 44600.0 |
| 2001-05-23 10:00:00 | IWM | ETF | 51.15 | 51.15 | 50.6 | 50.925 | 200600.0 |
| 2001-05-23 11:00:00 | IWM | ETF | 50.925 | 50.945 | 50.775 | 50.87 | 29000.0 |
| 2001-05-23 12:00:00 | IWM | ETF | 50.895 | 51.045 | 50.895 | 51.045 | 45600.0 |
| 2001-05-23 13:00:00 | IWM | ETF | 51.045 | 51.045 | 50.775 | 50.8 | 29200.0 |
| 2001-05-23 14:00:00 | IWM | ETF | 50.99 | 51.015 | 50.725 | 51.015 | 44400.0 |
| 2001-05-23 15:00:00 | IWM | ETF | 51.015 | 51.015 | 50.575 | 50.575 | 142200.0 |
| 2001-05-23 16:00:00 | IWM | ETF | 50.575 | 50.65 | 50.5 | 50.5 | 13200.0 |
| 2001-05-23 09:00:00 | DIA | ETF | 112.3 | 112.5 | 112.01 | 112.01 | 933800.0 |
| 2001-05-23 10:00:00 | DIA | ETF | 112.05 | 112.1 | 111.46 | 111.73 | 1608100.0 |
| 2001-05-23 11:00:00 | DIA | ETF | 111.69 | 111.78 | 111.27 | 111.65 | 380800.0 |
| 2001-05-23 12:00:00 | DIA | ETF | 111.69 | 111.93 | 111.62 | 111.71 | 128900.0 |
| 2001-05-23 13:00:00 | DIA | ETF | 111.79 | 111.79 | 111.33 | 111.43 | 151800.0 |
| 2001-05-23 14:00:00 | DIA | ETF | 111.46 | 111.8 | 111.28 | 111.65 | 239000.0 |
| 2001-05-23 15:00:00 | DIA | ETF | 111.69 | 111.69 | 111.06 | 111.15 | 288800.0 |
| 2001-05-23 16:00:00 | DIA | ETF | 111.25 | 111.25 | 111.1 | 111.1 | 133000.0 |
> showing 35 of 228 rows — these rows as CSV