PREVIEW / etf_1hour / 2003-02-19
file: by_date/etf_1hour/2003/2003-02-19.parquet size: 16 KB rows: 372
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 |
|---|---|---|---|---|---|---|---|
| 2003-02-19 08:00:00 | SPY | ETF | 85.56 | 85.56 | 85.26 | 85.3 | 109000.0 |
| 2003-02-19 09:00:00 | SPY | ETF | 85.33 | 85.47 | 85.07 | 85.2 | 4401000.0 |
| 2003-02-19 10:00:00 | SPY | ETF | 85.2 | 85.37 | 84.8 | 84.92 | 4249400.0 |
| 2003-02-19 11:00:00 | SPY | ETF | 84.9 | 85.09 | 84.7 | 84.91 | 2875700.0 |
| 2003-02-19 12:00:00 | SPY | ETF | 84.88 | 85.07 | 84.81 | 84.97 | 1771500.0 |
| 2003-02-19 13:00:00 | SPY | ETF | 85.0 | 85.0 | 84.46 | 84.62 | 3540900.0 |
| 2003-02-19 14:00:00 | SPY | ETF | 84.63 | 84.74 | 84.32 | 84.38 | 3455900.0 |
| 2003-02-19 15:00:00 | SPY | ETF | 84.37 | 84.94 | 84.28 | 84.93 | 6214600.0 |
| 2003-02-19 16:00:00 | SPY | ETF | 84.93 | 85.19 | 84.86 | 85.14 | 1540500.0 |
| 2003-02-19 17:00:00 | SPY | ETF | 85.12 | 85.14 | 85.07 | 85.1 | 29400.0 |
| 2003-02-19 18:00:00 | SPY | ETF | 85.07 | 85.15 | 85.07 | 85.15 | 4900.0 |
| 2003-02-19 19:00:00 | SPY | ETF | 85.14 | 85.18 | 85.14 | 85.18 | 1200.0 |
| 2003-02-19 08:00:00 | QQQ | ETF | 25.3 | 25.38 | 25.2 | 25.21 | 128200.0 |
| 2003-02-19 09:00:00 | QQQ | ETF | 25.22 | 25.24 | 25.05 | 25.15 | 6117400.0 |
| 2003-02-19 10:00:00 | QQQ | ETF | 25.14 | 25.24 | 24.96 | 25.05 | 7409700.0 |
| 2003-02-19 11:00:00 | QQQ | ETF | 25.05 | 25.1 | 24.91 | 25.0 | 4263100.0 |
| 2003-02-19 12:00:00 | QQQ | ETF | 24.97 | 25.07 | 24.95 | 25.02 | 2075500.0 |
| 2003-02-19 13:00:00 | QQQ | ETF | 25.02 | 25.05 | 24.78 | 24.86 | 4953500.0 |
| 2003-02-19 14:00:00 | QQQ | ETF | 24.87 | 24.93 | 24.71 | 24.75 | 5244900.0 |
| 2003-02-19 15:00:00 | QQQ | ETF | 24.74 | 25.02 | 24.71 | 25.02 | 7516600.0 |
| 2003-02-19 16:00:00 | QQQ | ETF | 25.02 | 25.09 | 24.95 | 25.08 | 2696400.0 |
| 2003-02-19 17:00:00 | QQQ | ETF | 25.07 | 25.1 | 25.01 | 25.08 | 149500.0 |
| 2003-02-19 18:00:00 | QQQ | ETF | 25.08 | 25.11 | 25.08 | 25.09 | 18900.0 |
| 2003-02-19 19:00:00 | QQQ | ETF | 25.09 | 25.12 | 25.08 | 25.11 | 16800.0 |
| 2003-02-19 09:00:00 | IWM | ETF | 36.275 | 36.275 | 36.09 | 36.135 | 626600.0 |
| 2003-02-19 10:00:00 | IWM | ETF | 36.125 | 36.2 | 35.94 | 35.94 | 333600.0 |
| 2003-02-19 11:00:00 | IWM | ETF | 35.96 | 36.015 | 35.87 | 35.95 | 606600.0 |
| 2003-02-19 12:00:00 | IWM | ETF | 35.91 | 35.96 | 35.89 | 35.94 | 15000.0 |
| 2003-02-19 13:00:00 | IWM | ETF | 35.925 | 35.945 | 35.725 | 35.775 | 378800.0 |
| 2003-02-19 14:00:00 | IWM | ETF | 35.75 | 35.825 | 35.69 | 35.7 | 521600.0 |
| 2003-02-19 15:00:00 | IWM | ETF | 35.685 | 35.935 | 35.665 | 35.9 | 856400.0 |
| 2003-02-19 16:00:00 | IWM | ETF | 35.895 | 35.925 | 35.79 | 35.9 | 269000.0 |
| 2003-02-19 17:00:00 | IWM | ETF | 35.92 | 35.92 | 35.92 | 35.92 | 2000.0 |
| 2003-02-19 08:00:00 | DIA | ETF | 80.51 | 80.51 | 80.4 | 80.5 | 2800.0 |
| 2003-02-19 09:00:00 | DIA | ETF | 80.5 | 80.73 | 80.35 | 80.46 | 850100.0 |
| 2003-02-19 10:00:00 | DIA | ETF | 80.45 | 80.64 | 80.13 | 80.24 | 955700.0 |
| 2003-02-19 11:00:00 | DIA | ETF | 80.25 | 80.35 | 79.98 | 80.13 | 634500.0 |
| 2003-02-19 12:00:00 | DIA | ETF | 80.12 | 80.28 | 80.05 | 80.28 | 201000.0 |
| 2003-02-19 13:00:00 | DIA | ETF | 80.28 | 80.33 | 79.83 | 79.94 | 561100.0 |
| 2003-02-19 14:00:00 | DIA | ETF | 79.97 | 80.03 | 79.72 | 79.75 | 590700.0 |
| 2003-02-19 15:00:00 | DIA | ETF | 79.75 | 80.39 | 79.7 | 80.35 | 1031000.0 |
| 2003-02-19 16:00:00 | DIA | ETF | 80.38 | 80.55 | 80.29 | 80.5 | 93100.0 |
| 2003-02-19 17:00:00 | DIA | ETF | 80.51 | 80.51 | 80.46 | 80.5 | 1700.0 |
| 2003-02-19 18:00:00 | DIA | ETF | 80.54 | 80.54 | 80.54 | 80.54 | 200.0 |
| 2003-02-19 19:00:00 | DIA | ETF | 80.53 | 80.53 | 80.53 | 80.53 | 100.0 |
| 2003-02-19 09:00:00 | TLT | ETF | 88.39 | 88.45 | 88.25 | 88.44 | 22000.0 |
| 2003-02-19 10:00:00 | TLT | ETF | 88.47 | 88.7 | 88.47 | 88.59 | 5600.0 |
| 2003-02-19 11:00:00 | TLT | ETF | 88.6 | 88.67 | 88.6 | 88.66 | 6200.0 |
| 2003-02-19 12:00:00 | TLT | ETF | 88.67 | 88.67 | 88.49 | 88.49 | 6200.0 |
| 2003-02-19 13:00:00 | TLT | ETF | 88.45 | 88.53 | 88.41 | 88.41 | 2000.0 |
> showing 50 of 372 rows — these rows as CSV