PREVIEW / etf_1hour / 2001-05-10
file: by_date/etf_1hour/2001/2001-05-10.parquet size: 11 KB rows: 220
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-10 09:00:00 | SPY | ETF | 127.26 | 127.5 | 126.71 | 126.99 | 1676600.0 |
| 2001-05-10 10:00:00 | SPY | ETF | 126.99 | 127.24 | 126.7 | 127.0 | 868500.0 |
| 2001-05-10 11:00:00 | SPY | ETF | 126.97 | 127.0 | 126.34 | 126.46 | 723100.0 |
| 2001-05-10 12:00:00 | SPY | ETF | 126.47 | 126.47 | 125.98 | 126.25 | 893300.0 |
| 2001-05-10 13:00:00 | SPY | ETF | 126.21 | 126.65 | 126.06 | 126.58 | 405300.0 |
| 2001-05-10 14:00:00 | SPY | ETF | 126.56 | 126.62 | 125.85 | 125.98 | 758300.0 |
| 2001-05-10 15:00:00 | SPY | ETF | 126.02 | 126.32 | 125.77 | 125.99 | 779900.0 |
| 2001-05-10 16:00:00 | SPY | ETF | 125.98 | 126.17 | 125.8 | 126.15 | 536900.0 |
| 2001-05-10 17:00:00 | SPY | ETF | 126.15 | 126.28 | 126.15 | 126.17 | 1400.0 |
| 2001-05-10 09:00:00 | QQQ | ETF | 47.92 | 48.05 | 47.31 | 47.5 | 9503600.0 |
| 2001-05-10 10:00:00 | QQQ | ETF | 47.5 | 47.75 | 47.15 | 47.53 | 7784800.0 |
| 2001-05-10 11:00:00 | QQQ | ETF | 47.53 | 47.6 | 46.75 | 46.85 | 7675800.0 |
| 2001-05-10 12:00:00 | QQQ | ETF | 46.82 | 46.87 | 46.41 | 46.55 | 8634200.0 |
| 2001-05-10 13:00:00 | QQQ | ETF | 46.6 | 47.07 | 46.45 | 46.85 | 6170400.0 |
| 2001-05-10 14:00:00 | QQQ | ETF | 46.88 | 46.98 | 46.09 | 46.15 | 8124500.0 |
| 2001-05-10 15:00:00 | QQQ | ETF | 46.19 | 46.47 | 45.75 | 45.82 | 8998800.0 |
| 2001-05-10 16:00:00 | QQQ | ETF | 45.8 | 47.49 | 45.6 | 45.78 | 1268700.0 |
| 2001-05-10 17:00:00 | QQQ | ETF | 45.78 | 46.0 | 45.7 | 45.7 | 334400.0 |
| 2001-05-10 18:00:00 | QQQ | ETF | 45.7 | 45.8 | 45.6 | 45.7 | 28700.0 |
| 2001-05-10 09:00:00 | IWM | ETF | 49.425 | 49.425 | 49.125 | 49.125 | 43800.0 |
| 2001-05-10 10:00:00 | IWM | ETF | 49.13 | 49.325 | 49.13 | 49.25 | 40000.0 |
| 2001-05-10 11:00:00 | IWM | ETF | 49.2 | 49.29 | 49.0 | 49.025 | 60000.0 |
| 2001-05-10 12:00:00 | IWM | ETF | 49.025 | 49.22 | 48.925 | 48.925 | 82600.0 |
| 2001-05-10 13:00:00 | IWM | ETF | 48.925 | 49.2 | 48.925 | 48.975 | 45000.0 |
| 2001-05-10 14:00:00 | IWM | ETF | 48.975 | 49.15 | 48.9 | 49.05 | 124800.0 |
| 2001-05-10 15:00:00 | IWM | ETF | 48.85 | 49.09 | 48.75 | 48.88 | 118000.0 |
| 2001-05-10 16:00:00 | IWM | ETF | 48.9 | 48.9 | 48.75 | 48.75 | 37400.0 |
| 2001-05-10 09:00:00 | DIA | ETF | 109.74 | 109.83 | 109.35 | 109.55 | 452500.0 |
| 2001-05-10 10:00:00 | DIA | ETF | 109.6 | 109.95 | 109.56 | 109.76 | 431500.0 |
| 2001-05-10 11:00:00 | DIA | ETF | 109.76 | 109.82 | 109.41 | 109.47 | 214300.0 |
| 2001-05-10 12:00:00 | DIA | ETF | 109.46 | 109.5 | 109.13 | 109.34 | 303000.0 |
| 2001-05-10 13:00:00 | DIA | ETF | 109.37 | 109.69 | 109.32 | 109.54 | 60400.0 |
| 2001-05-10 14:00:00 | DIA | ETF | 109.56 | 109.7 | 109.2 | 109.25 | 148100.0 |
| 2001-05-10 15:00:00 | DIA | ETF | 109.25 | 109.49 | 109.11 | 109.26 | 398500.0 |
| 2001-05-10 16:00:00 | DIA | ETF | 109.26 | 109.4 | 109.23 | 109.24 | 114400.0 |
| 2001-05-10 18:00:00 | DIA | ETF | 109.26 | 109.26 | 109.26 | 109.26 | 400.0 |
> showing 36 of 220 rows — these rows as CSV