PREVIEW / etf_1hour / 2003-12-24
file: by_date/etf_1hour/2003/2003-12-24.parquet size: 14 KB rows: 290
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-12-24 08:00:00 | SPY | ETF | 109.55 | 109.55 | 109.38 | 109.42 | 42100.0 |
| 2003-12-24 09:00:00 | SPY | ETF | 109.48 | 109.61 | 109.43 | 109.58 | 1297400.0 |
| 2003-12-24 10:00:00 | SPY | ETF | 109.59 | 109.88 | 109.53 | 109.84 | 1987200.0 |
| 2003-12-24 11:00:00 | SPY | ETF | 109.84 | 109.86 | 109.65 | 109.69 | 1627900.0 |
| 2003-12-24 12:00:00 | SPY | ETF | 109.68 | 109.78 | 109.55 | 109.64 | 2455000.0 |
| 2003-12-24 13:00:00 | SPY | ETF | 109.64 | 109.65 | 109.51 | 109.62 | 166700.0 |
| 2003-12-24 08:00:00 | QQQ | ETF | 35.83 | 35.89 | 35.77 | 35.81 | 100600.0 |
| 2003-12-24 09:00:00 | QQQ | ETF | 35.81 | 35.93 | 35.8 | 35.91 | 4762500.0 |
| 2003-12-24 10:00:00 | QQQ | ETF | 35.91 | 36.006 | 35.86 | 35.985 | 6565000.0 |
| 2003-12-24 11:00:00 | QQQ | ETF | 35.98 | 36.02 | 35.92 | 35.94 | 7374400.0 |
| 2003-12-24 12:00:00 | QQQ | ETF | 35.94 | 35.991 | 35.85 | 35.875 | 24362200.0 |
| 2003-12-24 13:00:00 | QQQ | ETF | 35.877 | 35.9 | 35.85 | 35.9 | 151600.0 |
| 2003-12-24 09:00:00 | IWM | ETF | 55.035 | 55.085 | 54.935 | 55.055 | 256600.0 |
| 2003-12-24 10:00:00 | IWM | ETF | 55.03 | 55.135 | 54.98 | 55.075 | 249000.0 |
| 2003-12-24 11:00:00 | IWM | ETF | 55.075 | 55.18 | 55.025 | 55.125 | 152600.0 |
| 2003-12-24 12:00:00 | IWM | ETF | 55.14 | 55.18 | 54.982 | 55.01 | 463000.0 |
| 2003-12-24 13:00:00 | IWM | ETF | 55.03 | 55.04 | 54.945 | 55.04 | 80600.0 |
| 2003-12-24 08:00:00 | DIA | ETF | 103.22 | 103.4 | 103.1 | 103.12 | 15600.0 |
| 2003-12-24 09:00:00 | DIA | ETF | 103.2 | 103.33 | 103.1 | 103.27 | 356400.0 |
| 2003-12-24 10:00:00 | DIA | ETF | 103.26 | 103.44 | 103.2 | 103.41 | 794900.0 |
| 2003-12-24 11:00:00 | DIA | ETF | 103.41 | 103.43 | 103.2 | 103.25 | 421400.0 |
| 2003-12-24 12:00:00 | DIA | ETF | 103.26 | 103.31 | 103.15 | 103.16 | 1499900.0 |
| 2003-12-24 13:00:00 | DIA | ETF | 103.16 | 103.2 | 103.11 | 103.2 | 24400.0 |
| 2003-12-24 09:00:00 | TLT | ETF | 86.37 | 86.52 | 86.33 | 86.34 | 29900.0 |
| 2003-12-24 10:00:00 | TLT | ETF | 86.41 | 86.41 | 86.17 | 86.31 | 31100.0 |
| 2003-12-24 11:00:00 | TLT | ETF | 86.3 | 86.53 | 86.3 | 86.53 | 49500.0 |
| 2003-12-24 12:00:00 | TLT | ETF | 86.59 | 86.64 | 86.5 | 86.6 | 23400.0 |
| 2003-12-24 13:00:00 | TLT | ETF | 86.59 | 86.66 | 86.59 | 86.66 | 5000.0 |
> showing 28 of 290 rows — these rows as CSV