PREVIEW / etf_1hour / 2001-08-10
file: by_date/etf_1hour/2001/2001-08-10.parquet size: 11 KB rows: 227
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-08-10 09:00:00 | SPY | ETF | 118.8 | 118.87 | 118.43 | 118.58 | 1168200.0 |
| 2001-08-10 10:00:00 | SPY | ETF | 118.55 | 118.63 | 117.34 | 117.73 | 2052200.0 |
| 2001-08-10 11:00:00 | SPY | ETF | 117.76 | 118.26 | 117.45 | 118.06 | 1739800.0 |
| 2001-08-10 12:00:00 | SPY | ETF | 118.06 | 119.32 | 117.91 | 119.0 | 1247600.0 |
| 2001-08-10 13:00:00 | SPY | ETF | 119.05 | 119.68 | 119.0 | 119.43 | 1977100.0 |
| 2001-08-10 14:00:00 | SPY | ETF | 119.33 | 119.71 | 119.0 | 119.68 | 1022000.0 |
| 2001-08-10 15:00:00 | SPY | ETF | 119.68 | 119.84 | 119.16 | 119.44 | 1237600.0 |
| 2001-08-10 16:00:00 | SPY | ETF | 119.55 | 119.55 | 118.51 | 118.51 | 455400.0 |
| 2001-08-10 17:00:00 | SPY | ETF | 119.24 | 119.3 | 119.24 | 119.3 | 600.0 |
| 2001-08-10 09:00:00 | QQQ | ETF | 40.42 | 40.75 | 40.12 | 40.2 | 6353000.0 |
| 2001-08-10 10:00:00 | QQQ | ETF | 40.2 | 40.25 | 39.23 | 39.55 | 18599400.0 |
| 2001-08-10 11:00:00 | QQQ | ETF | 39.55 | 39.99 | 39.37 | 39.81 | 10448000.0 |
| 2001-08-10 12:00:00 | QQQ | ETF | 39.81 | 40.22 | 39.5 | 40.2 | 7778900.0 |
| 2001-08-10 13:00:00 | QQQ | ETF | 40.17 | 40.52 | 40.0 | 40.35 | 8230200.0 |
| 2001-08-10 14:00:00 | QQQ | ETF | 40.37 | 40.62 | 40.1 | 40.6 | 5321500.0 |
| 2001-08-10 15:00:00 | QQQ | ETF | 40.6 | 40.68 | 40.21 | 40.33 | 7721400.0 |
| 2001-08-10 16:00:00 | QQQ | ETF | 40.35 | 40.38 | 40.08 | 40.17 | 983200.0 |
| 2001-08-10 17:00:00 | QQQ | ETF | 40.16 | 40.3 | 40.0 | 40.1 | 62000.0 |
| 2001-08-10 18:00:00 | QQQ | ETF | 40.1 | 40.18 | 40.05 | 40.1 | 26200.0 |
| 2001-08-10 09:00:00 | IWM | ETF | 47.175 | 47.295 | 47.175 | 47.25 | 54000.0 |
| 2001-08-10 10:00:00 | IWM | ETF | 47.245 | 47.245 | 46.755 | 46.925 | 24600.0 |
| 2001-08-10 11:00:00 | IWM | ETF | 46.825 | 46.995 | 46.8 | 46.995 | 108400.0 |
| 2001-08-10 12:00:00 | IWM | ETF | 47.01 | 47.15 | 46.86 | 47.125 | 17600.0 |
| 2001-08-10 13:00:00 | IWM | ETF | 47.15 | 47.55 | 47.15 | 47.45 | 54600.0 |
| 2001-08-10 14:00:00 | IWM | ETF | 47.45 | 47.45 | 47.28 | 47.45 | 17400.0 |
| 2001-08-10 15:00:00 | IWM | ETF | 47.435 | 47.6 | 47.28 | 47.28 | 144600.0 |
| 2001-08-10 16:00:00 | IWM | ETF | 47.3 | 47.3 | 47.3 | 47.3 | 2000.0 |
| 2001-08-10 09:00:00 | DIA | ETF | 102.93 | 103.29 | 102.93 | 103.09 | 332600.0 |
| 2001-08-10 10:00:00 | DIA | ETF | 103.11 | 103.15 | 102.02 | 102.4 | 591100.0 |
| 2001-08-10 11:00:00 | DIA | ETF | 102.4 | 103.05 | 102.18 | 102.8 | 423700.0 |
| 2001-08-10 12:00:00 | DIA | ETF | 102.83 | 103.88 | 102.7 | 103.88 | 604400.0 |
| 2001-08-10 13:00:00 | DIA | ETF | 103.91 | 104.46 | 103.88 | 104.17 | 1189300.0 |
| 2001-08-10 14:00:00 | DIA | ETF | 104.08 | 104.39 | 103.72 | 104.37 | 590100.0 |
| 2001-08-10 15:00:00 | DIA | ETF | 104.4 | 104.46 | 103.93 | 104.2 | 515100.0 |
| 2001-08-10 16:00:00 | DIA | ETF | 104.22 | 104.35 | 104.2 | 104.23 | 148700.0 |
> showing 35 of 227 rows — these rows as CSV