PREVIEW / etf_1hour / 2001-05-30
file: by_date/etf_1hour/2001/2001-05-30.parquet size: 11 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-30 09:00:00 | SPY | ETF | 126.59 | 126.89 | 126.46 | 126.79 | 1850200.0 |
| 2001-05-30 10:00:00 | SPY | ETF | 126.78 | 127.09 | 126.02 | 126.17 | 1658500.0 |
| 2001-05-30 11:00:00 | SPY | ETF | 126.16 | 126.24 | 125.61 | 125.93 | 1222800.0 |
| 2001-05-30 12:00:00 | SPY | ETF | 125.86 | 126.07 | 125.7 | 125.94 | 310900.0 |
| 2001-05-30 13:00:00 | SPY | ETF | 125.87 | 125.9 | 125.0 | 125.13 | 1397300.0 |
| 2001-05-30 14:00:00 | SPY | ETF | 125.16 | 125.82 | 125.11 | 125.74 | 1183700.0 |
| 2001-05-30 15:00:00 | SPY | ETF | 125.74 | 125.95 | 125.08 | 125.29 | 1814600.0 |
| 2001-05-30 16:00:00 | SPY | ETF | 125.22 | 125.92 | 125.2 | 125.33 | 367900.0 |
| 2001-05-30 17:00:00 | SPY | ETF | 125.35 | 125.35 | 125.3 | 125.3 | 2000.0 |
| 2001-05-30 09:00:00 | QQQ | ETF | 45.43 | 45.56 | 45.15 | 45.49 | 10521200.0 |
| 2001-05-30 10:00:00 | QQQ | ETF | 45.45 | 45.85 | 44.85 | 44.91 | 16058800.0 |
| 2001-05-30 11:00:00 | QQQ | ETF | 44.9 | 44.96 | 44.47 | 44.77 | 12280800.0 |
| 2001-05-30 12:00:00 | QQQ | ETF | 44.73 | 44.94 | 44.51 | 44.75 | 5430300.0 |
| 2001-05-30 13:00:00 | QQQ | ETF | 44.74 | 44.75 | 44.08 | 44.18 | 10816800.0 |
| 2001-05-30 14:00:00 | QQQ | ETF | 44.17 | 44.82 | 44.09 | 44.73 | 9319300.0 |
| 2001-05-30 15:00:00 | QQQ | ETF | 44.73 | 44.94 | 44.11 | 44.3 | 13293200.0 |
| 2001-05-30 16:00:00 | QQQ | ETF | 44.3 | 44.93 | 44.27 | 44.6 | 1634700.0 |
| 2001-05-30 17:00:00 | QQQ | ETF | 44.55 | 44.62 | 44.47 | 44.58 | 25800.0 |
| 2001-05-30 18:00:00 | QQQ | ETF | 44.59 | 44.65 | 44.55 | 44.65 | 9500.0 |
| 2001-05-30 09:00:00 | IWM | ETF | 49.95 | 49.95 | 49.775 | 49.8 | 29800.0 |
| 2001-05-30 10:00:00 | IWM | ETF | 49.8 | 49.95 | 49.52 | 49.6 | 61800.0 |
| 2001-05-30 11:00:00 | IWM | ETF | 49.595 | 49.625 | 49.435 | 49.5 | 173400.0 |
| 2001-05-30 12:00:00 | IWM | ETF | 49.5 | 49.6 | 49.35 | 49.49 | 91400.0 |
| 2001-05-30 13:00:00 | IWM | ETF | 49.405 | 49.405 | 49.15 | 49.175 | 139400.0 |
| 2001-05-30 14:00:00 | IWM | ETF | 49.195 | 49.445 | 49.185 | 49.44 | 178600.0 |
| 2001-05-30 15:00:00 | IWM | ETF | 49.445 | 49.49 | 49.265 | 49.3 | 105200.0 |
| 2001-05-30 16:00:00 | IWM | ETF | 49.35 | 49.475 | 49.25 | 49.35 | 7600.0 |
| 2001-05-30 09:00:00 | DIA | ETF | 110.02 | 110.5 | 110.0 | 110.27 | 397100.0 |
| 2001-05-30 10:00:00 | DIA | ETF | 110.25 | 110.59 | 109.57 | 109.76 | 615600.0 |
| 2001-05-30 11:00:00 | DIA | ETF | 109.73 | 109.77 | 109.15 | 109.51 | 442600.0 |
| 2001-05-30 12:00:00 | DIA | ETF | 109.5 | 109.69 | 109.37 | 109.55 | 81600.0 |
| 2001-05-30 13:00:00 | DIA | ETF | 109.52 | 109.52 | 108.76 | 108.83 | 201000.0 |
| 2001-05-30 14:00:00 | DIA | ETF | 108.8 | 109.38 | 108.8 | 109.3 | 226600.0 |
| 2001-05-30 15:00:00 | DIA | ETF | 109.27 | 109.5 | 108.65 | 108.85 | 711600.0 |
| 2001-05-30 16:00:00 | DIA | ETF | 108.72 | 109.57 | 108.72 | 108.81 | 1192300.0 |
| 2001-05-30 17:00:00 | DIA | ETF | 109.05 | 109.05 | 109.05 | 109.05 | 100.0 |
> showing 36 of 223 rows — these rows as CSV