PREVIEW / etf_1hour / 2001-11-21
file: by_date/etf_1hour/2001/2001-11-21.parquet size: 13 KB rows: 266
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-11-21 09:00:00 | SPY | ETF | 114.5 | 114.67 | 114.18 | 114.4 | 2260200.0 |
| 2001-11-21 10:00:00 | SPY | ETF | 114.39 | 114.64 | 113.66 | 113.84 | 2309900.0 |
| 2001-11-21 11:00:00 | SPY | ETF | 113.81 | 114.04 | 113.71 | 113.75 | 1109600.0 |
| 2001-11-21 12:00:00 | SPY | ETF | 113.73 | 114.07 | 113.7 | 113.73 | 1581900.0 |
| 2001-11-21 13:00:00 | SPY | ETF | 113.72 | 114.25 | 113.51 | 114.24 | 1618800.0 |
| 2001-11-21 14:00:00 | SPY | ETF | 114.24 | 114.29 | 113.8 | 113.97 | 885100.0 |
| 2001-11-21 15:00:00 | SPY | ETF | 113.98 | 114.22 | 113.68 | 114.15 | 1027300.0 |
| 2001-11-21 16:00:00 | SPY | ETF | 114.12 | 114.45 | 113.9 | 114.45 | 546000.0 |
| 2001-11-21 17:00:00 | SPY | ETF | 114.4 | 114.4 | 114.25 | 114.25 | 900.0 |
| 2001-11-21 09:00:00 | QQQ | ETF | 38.47 | 38.76 | 38.47 | 38.68 | 12004500.0 |
| 2001-11-21 10:00:00 | QQQ | ETF | 38.65 | 38.95 | 37.98 | 38.15 | 17991100.0 |
| 2001-11-21 11:00:00 | QQQ | ETF | 38.15 | 38.4 | 38.02 | 38.17 | 8102700.0 |
| 2001-11-21 12:00:00 | QQQ | ETF | 38.17 | 38.34 | 38.1 | 38.13 | 3264500.0 |
| 2001-11-21 13:00:00 | QQQ | ETF | 38.13 | 38.74 | 38.05 | 38.72 | 8110400.0 |
| 2001-11-21 14:00:00 | QQQ | ETF | 38.72 | 38.76 | 38.4 | 38.54 | 4847300.0 |
| 2001-11-21 15:00:00 | QQQ | ETF | 38.53 | 38.66 | 38.3 | 38.66 | 5248100.0 |
| 2001-11-21 16:00:00 | QQQ | ETF | 38.68 | 39.0 | 38.46 | 38.8 | 879000.0 |
| 2001-11-21 17:00:00 | QQQ | ETF | 38.82 | 38.82 | 38.73 | 38.76 | 38400.0 |
| 2001-11-21 18:00:00 | QQQ | ETF | 38.75 | 38.75 | 38.6 | 38.61 | 41100.0 |
| 2001-11-21 09:00:00 | IWM | ETF | 45.15 | 45.225 | 45.0 | 45.01 | 28000.0 |
| 2001-11-21 10:00:00 | IWM | ETF | 45.09 | 45.175 | 44.68 | 44.9 | 63800.0 |
| 2001-11-21 11:00:00 | IWM | ETF | 44.875 | 44.975 | 44.755 | 44.86 | 31400.0 |
| 2001-11-21 12:00:00 | IWM | ETF | 44.92 | 44.945 | 44.73 | 44.92 | 2200.0 |
| 2001-11-21 13:00:00 | IWM | ETF | 44.9 | 45.01 | 44.81 | 45.01 | 72000.0 |
| 2001-11-21 14:00:00 | IWM | ETF | 45.035 | 45.065 | 44.895 | 44.91 | 163800.0 |
| 2001-11-21 15:00:00 | IWM | ETF | 45.015 | 45.085 | 44.895 | 45.085 | 17400.0 |
| 2001-11-21 09:00:00 | DIA | ETF | 99.1 | 99.1 | 98.6 | 98.75 | 622400.0 |
| 2001-11-21 10:00:00 | DIA | ETF | 98.75 | 98.96 | 98.3 | 98.4 | 993400.0 |
| 2001-11-21 11:00:00 | DIA | ETF | 98.45 | 98.64 | 98.3 | 98.31 | 430200.0 |
| 2001-11-21 12:00:00 | DIA | ETF | 98.3 | 98.54 | 98.28 | 98.28 | 449900.0 |
| 2001-11-21 13:00:00 | DIA | ETF | 98.25 | 98.73 | 98.12 | 98.7 | 308700.0 |
| 2001-11-21 14:00:00 | DIA | ETF | 98.7 | 98.75 | 98.26 | 98.39 | 141500.0 |
| 2001-11-21 15:00:00 | DIA | ETF | 98.37 | 98.6 | 98.14 | 98.51 | 161900.0 |
| 2001-11-21 16:00:00 | DIA | ETF | 98.5 | 98.5 | 98.34 | 98.48 | 97400.0 |
> showing 34 of 266 rows — these rows as CSV