PREVIEW / etf_1hour / 2003-03-14
file: by_date/etf_1hour/2003/2003-03-14.parquet size: 16 KB rows: 389
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-03-14 08:00:00 | SPY | ETF | 84.65 | 84.65 | 84.05 | 84.15 | 123800.0 |
| 2003-03-14 09:00:00 | SPY | ETF | 84.15 | 84.4 | 83.4 | 83.47 | 8530600.0 |
| 2003-03-14 10:00:00 | SPY | ETF | 83.46 | 84.6 | 83.43 | 84.23 | 15026400.0 |
| 2003-03-14 11:00:00 | SPY | ETF | 84.2 | 84.77 | 83.9 | 83.92 | 9606600.0 |
| 2003-03-14 12:00:00 | SPY | ETF | 83.9 | 84.08 | 83.35 | 83.66 | 7029300.0 |
| 2003-03-14 13:00:00 | SPY | ETF | 83.65 | 83.98 | 83.5 | 83.59 | 3790000.0 |
| 2003-03-14 14:00:00 | SPY | ETF | 83.59 | 83.93 | 83.4 | 83.82 | 5234600.0 |
| 2003-03-14 15:00:00 | SPY | ETF | 83.85 | 84.25 | 83.5 | 83.9 | 8048900.0 |
| 2003-03-14 16:00:00 | SPY | ETF | 83.9 | 84.18 | 83.81 | 84.06 | 2122100.0 |
| 2003-03-14 17:00:00 | SPY | ETF | 84.06 | 84.14 | 84.02 | 84.09 | 7500.0 |
| 2003-03-14 18:00:00 | SPY | ETF | 84.13 | 84.2 | 84.1 | 84.18 | 9600.0 |
| 2003-03-14 19:00:00 | SPY | ETF | 84.15 | 84.16 | 84.15 | 84.15 | 600.0 |
| 2003-03-14 08:00:00 | QQQ | ETF | 25.85 | 25.87 | 25.71 | 25.74 | 267100.0 |
| 2003-03-14 09:00:00 | QQQ | ETF | 25.75 | 25.81 | 25.47 | 25.5 | 19861700.0 |
| 2003-03-14 10:00:00 | QQQ | ETF | 25.51 | 25.98 | 25.48 | 25.75 | 19557200.0 |
| 2003-03-14 11:00:00 | QQQ | ETF | 25.75 | 25.93 | 25.6 | 25.62 | 9968000.0 |
| 2003-03-14 12:00:00 | QQQ | ETF | 25.61 | 25.69 | 25.36 | 25.51 | 9023900.0 |
| 2003-03-14 13:00:00 | QQQ | ETF | 25.5 | 25.64 | 25.45 | 25.48 | 5703900.0 |
| 2003-03-14 14:00:00 | QQQ | ETF | 25.49 | 25.6 | 25.41 | 25.56 | 5364400.0 |
| 2003-03-14 15:00:00 | QQQ | ETF | 25.58 | 25.74 | 25.46 | 25.61 | 12022500.0 |
| 2003-03-14 16:00:00 | QQQ | ETF | 25.62 | 25.76 | 25.53 | 25.72 | 3411500.0 |
| 2003-03-14 17:00:00 | QQQ | ETF | 25.73 | 25.75 | 25.69 | 25.73 | 110300.0 |
| 2003-03-14 18:00:00 | QQQ | ETF | 25.73 | 25.84 | 25.72 | 25.79 | 39000.0 |
| 2003-03-14 19:00:00 | QQQ | ETF | 25.77 | 25.81 | 25.75 | 25.77 | 4500.0 |
| 2003-03-14 09:00:00 | IWM | ETF | 35.55 | 35.55 | 35.175 | 35.2 | 317200.0 |
| 2003-03-14 10:00:00 | IWM | ETF | 35.21 | 35.555 | 35.21 | 35.44 | 851600.0 |
| 2003-03-14 11:00:00 | IWM | ETF | 35.445 | 35.63 | 35.41 | 35.41 | 621200.0 |
| 2003-03-14 12:00:00 | IWM | ETF | 35.4 | 35.45 | 35.26 | 35.315 | 337400.0 |
| 2003-03-14 13:00:00 | IWM | ETF | 35.325 | 35.37 | 35.255 | 35.285 | 274400.0 |
| 2003-03-14 14:00:00 | IWM | ETF | 35.275 | 35.335 | 35.225 | 35.3 | 328400.0 |
| 2003-03-14 15:00:00 | IWM | ETF | 35.33 | 35.42 | 35.255 | 35.35 | 295400.0 |
| 2003-03-14 16:00:00 | IWM | ETF | 35.355 | 35.425 | 35.35 | 35.35 | 108800.0 |
| 2003-03-14 08:00:00 | DIA | ETF | 79.19 | 79.35 | 78.75 | 78.75 | 48300.0 |
| 2003-03-14 09:00:00 | DIA | ETF | 78.93 | 79.1 | 78.15 | 78.27 | 2111800.0 |
| 2003-03-14 10:00:00 | DIA | ETF | 78.26 | 79.4 | 78.18 | 79.11 | 3511600.0 |
| 2003-03-14 11:00:00 | DIA | ETF | 79.1 | 79.55 | 78.73 | 78.77 | 1479800.0 |
| 2003-03-14 12:00:00 | DIA | ETF | 78.75 | 79.0 | 78.3 | 78.59 | 1412100.0 |
| 2003-03-14 13:00:00 | DIA | ETF | 78.59 | 78.92 | 78.39 | 78.51 | 879000.0 |
| 2003-03-14 14:00:00 | DIA | ETF | 78.51 | 78.86 | 78.33 | 78.8 | 1370400.0 |
| 2003-03-14 15:00:00 | DIA | ETF | 78.8 | 79.15 | 78.48 | 78.85 | 1168300.0 |
| 2003-03-14 16:00:00 | DIA | ETF | 78.84 | 79.09 | 78.76 | 79.09 | 180100.0 |
| 2003-03-14 17:00:00 | DIA | ETF | 79.09 | 79.09 | 79.05 | 79.05 | 700.0 |
| 2003-03-14 18:00:00 | DIA | ETF | 79.14 | 79.16 | 79.14 | 79.16 | 1900.0 |
| 2003-03-14 19:00:00 | DIA | ETF | 79.15 | 79.17 | 79.15 | 79.17 | 300.0 |
| 2003-03-14 09:00:00 | TLT | ETF | 89.9 | 89.96 | 89.81 | 89.85 | 47500.0 |
| 2003-03-14 10:00:00 | TLT | ETF | 89.87 | 89.87 | 89.62 | 89.78 | 70900.0 |
| 2003-03-14 11:00:00 | TLT | ETF | 89.81 | 89.9 | 89.66 | 89.84 | 121700.0 |
| 2003-03-14 12:00:00 | TLT | ETF | 89.93 | 90.0 | 89.78 | 89.78 | 122100.0 |
| 2003-03-14 13:00:00 | TLT | ETF | 89.87 | 90.08 | 89.87 | 90.08 | 19500.0 |
| 2003-03-14 14:00:00 | TLT | ETF | 90.11 | 90.12 | 89.97 | 90.0 | 50000.0 |
> showing 50 of 389 rows — these rows as CSV