PREVIEW / etf_1hour / 2004-10-11
file: by_date/etf_1hour/2004/2004-10-11.parquet size: 24 KB rows: 690
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-11 08:00:00 | SPY | ETF | 112.65 | 112.65 | 112.57 | 112.6 | 47900.0 |
| 2004-10-11 09:00:00 | SPY | ETF | 112.6 | 112.96 | 112.6 | 112.8 | 3464100.0 |
| 2004-10-11 10:00:00 | SPY | ETF | 112.82 | 112.86 | 112.67 | 112.76 | 4331900.0 |
| 2004-10-11 11:00:00 | SPY | ETF | 112.76 | 112.88 | 112.67 | 112.7 | 2054600.0 |
| 2004-10-11 12:00:00 | SPY | ETF | 112.71 | 112.83 | 112.64 | 112.79 | 1991200.0 |
| 2004-10-11 13:00:00 | SPY | ETF | 112.79 | 112.88 | 112.7 | 112.85 | 1370200.0 |
| 2004-10-11 14:00:00 | SPY | ETF | 112.85 | 112.98 | 112.84 | 112.86 | 1600900.0 |
| 2004-10-11 15:00:00 | SPY | ETF | 112.85 | 113.02 | 112.74 | 112.87 | 3909600.0 |
| 2004-10-11 16:00:00 | SPY | ETF | 112.86 | 112.99 | 112.84 | 112.95 | 1018500.0 |
| 2004-10-11 17:00:00 | SPY | ETF | 112.95 | 112.95 | 112.9 | 112.95 | 23500.0 |
| 2004-10-11 18:00:00 | SPY | ETF | 112.92 | 112.93 | 112.9 | 112.9 | 1900.0 |
| 2004-10-11 19:00:00 | SPY | ETF | 112.95 | 112.95 | 112.95 | 112.95 | 2600.0 |
| 2004-10-11 08:00:00 | QQQ | ETF | 35.66 | 35.66 | 35.61 | 35.62 | 51000.0 |
| 2004-10-11 09:00:00 | QQQ | ETF | 35.61 | 35.81 | 35.61 | 35.68 | 10774600.0 |
| 2004-10-11 10:00:00 | QQQ | ETF | 35.68 | 35.7 | 35.61 | 35.667 | 8021100.0 |
| 2004-10-11 11:00:00 | QQQ | ETF | 35.66 | 35.735 | 35.6 | 35.65 | 5857100.0 |
| 2004-10-11 12:00:00 | QQQ | ETF | 35.65 | 35.73 | 35.64 | 35.707 | 3465100.0 |
| 2004-10-11 13:00:00 | QQQ | ETF | 35.7 | 35.74 | 35.64 | 35.72 | 3940600.0 |
| 2004-10-11 14:00:00 | QQQ | ETF | 35.72 | 35.78 | 35.7 | 35.74 | 5974000.0 |
| 2004-10-11 15:00:00 | QQQ | ETF | 35.74 | 35.86 | 35.71 | 35.75 | 11112000.0 |
| 2004-10-11 16:00:00 | QQQ | ETF | 35.74 | 35.79 | 35.72 | 35.75 | 1030500.0 |
| 2004-10-11 17:00:00 | QQQ | ETF | 35.76 | 35.76 | 35.73 | 35.75 | 26300.0 |
| 2004-10-11 18:00:00 | QQQ | ETF | 35.75 | 35.76 | 35.74 | 35.75 | 15200.0 |
| 2004-10-11 19:00:00 | QQQ | ETF | 35.77 | 35.77 | 35.77 | 35.77 | 500.0 |
| 2004-10-11 08:00:00 | IWM | ETF | 57.335 | 57.335 | 57.335 | 57.335 | 1000.0 |
| 2004-10-11 09:00:00 | IWM | ETF | 57.45 | 57.57 | 57.31 | 57.31 | 1397400.0 |
| 2004-10-11 10:00:00 | IWM | ETF | 57.32 | 57.345 | 57.205 | 57.305 | 2325400.0 |
| 2004-10-11 11:00:00 | IWM | ETF | 57.3 | 57.38 | 57.255 | 57.3 | 1062000.0 |
| 2004-10-11 12:00:00 | IWM | ETF | 57.3 | 57.37 | 57.28 | 57.35 | 211800.0 |
| 2004-10-11 13:00:00 | IWM | ETF | 57.355 | 57.43 | 57.3 | 57.415 | 444600.0 |
| 2004-10-11 14:00:00 | IWM | ETF | 57.415 | 57.495 | 57.395 | 57.425 | 737400.0 |
| 2004-10-11 15:00:00 | IWM | ETF | 57.41 | 57.585 | 57.37 | 57.585 | 915400.0 |
| 2004-10-11 16:00:00 | IWM | ETF | 57.575 | 57.635 | 57.56 | 57.57 | 168800.0 |
| 2004-10-11 08:00:00 | DIA | ETF | 100.79 | 100.81 | 100.75 | 100.76 | 8400.0 |
| 2004-10-11 09:00:00 | DIA | ETF | 100.89 | 101.11 | 100.89 | 100.99 | 992600.0 |
| 2004-10-11 10:00:00 | DIA | ETF | 100.99 | 101.15 | 100.91 | 101.02 | 907800.0 |
| 2004-10-11 11:00:00 | DIA | ETF | 101.01 | 101.13 | 100.95 | 100.98 | 340300.0 |
| 2004-10-11 12:00:00 | DIA | ETF | 100.99 | 101.04 | 100.93 | 101.02 | 199200.0 |
| 2004-10-11 13:00:00 | DIA | ETF | 101.02 | 101.11 | 100.98 | 101.07 | 124200.0 |
| 2004-10-11 14:00:00 | DIA | ETF | 101.08 | 101.11 | 100.99 | 101.02 | 178900.0 |
| 2004-10-11 15:00:00 | DIA | ETF | 101.04 | 101.25 | 100.99 | 101.09 | 734600.0 |
| 2004-10-11 16:00:00 | DIA | ETF | 101.1 | 101.14 | 101.07 | 101.14 | 49400.0 |
| 2004-10-11 17:00:00 | DIA | ETF | 101.1 | 101.1 | 101.1 | 101.1 | 100.0 |
| 2004-10-11 09:00:00 | TLT | ETF | 87.95 | 87.95 | 87.73 | 87.85 | 13100.0 |
| 2004-10-11 10:00:00 | TLT | ETF | 87.86 | 87.95 | 87.79 | 87.95 | 12300.0 |
| 2004-10-11 11:00:00 | TLT | ETF | 87.95 | 87.98 | 87.86 | 87.92 | 8000.0 |
| 2004-10-11 12:00:00 | TLT | ETF | 87.95 | 88.0 | 87.86 | 87.86 | 5600.0 |
| 2004-10-11 13:00:00 | TLT | ETF | 87.96 | 88.0 | 87.96 | 88.0 | 3600.0 |
| 2004-10-11 14:00:00 | TLT | ETF | 88.0 | 88.1 | 87.95 | 87.95 | 9300.0 |
| 2004-10-11 15:00:00 | TLT | ETF | 88.03 | 88.1 | 87.98 | 88.0 | 6500.0 |
> showing 50 of 690 rows — these rows as CSV