PREVIEW / etf_1hour / 2004-11-26
file: by_date/etf_1hour/2004/2004-11-26.parquet size: 18 KB rows: 449
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-11-26 08:00:00 | SPY | ETF | 118.5 | 118.55 | 118.49 | 118.5 | 113500.0 |
| 2004-11-26 09:00:00 | SPY | ETF | 118.52 | 118.85 | 118.45 | 118.76 | 2923800.0 |
| 2004-11-26 10:00:00 | SPY | ETF | 118.74 | 118.87 | 118.66 | 118.86 | 2770600.0 |
| 2004-11-26 11:00:00 | SPY | ETF | 118.85 | 118.98 | 118.71 | 118.73 | 3423800.0 |
| 2004-11-26 12:00:00 | SPY | ETF | 118.73 | 118.86 | 118.54 | 118.54 | 3634400.0 |
| 2004-11-26 13:00:00 | SPY | ETF | 118.54 | 118.55 | 118.3 | 118.35 | 578600.0 |
| 2004-11-26 08:00:00 | QQQ | ETF | 39.32 | 39.43 | 39.32 | 39.4 | 173000.0 |
| 2004-11-26 09:00:00 | QQQ | ETF | 39.4 | 39.45 | 39.348 | 39.41 | 7880900.0 |
| 2004-11-26 10:00:00 | QQQ | ETF | 39.41 | 39.46 | 39.368 | 39.43 | 5815200.0 |
| 2004-11-26 11:00:00 | QQQ | ETF | 39.43 | 39.48 | 39.33 | 39.331 | 6407400.0 |
| 2004-11-26 12:00:00 | QQQ | ETF | 39.33 | 39.36 | 39.28 | 39.31 | 8778000.0 |
| 2004-11-26 13:00:00 | QQQ | ETF | 39.31 | 39.31 | 39.17 | 39.21 | 1408700.0 |
| 2004-11-26 08:00:00 | IWM | ETF | 62.825 | 62.825 | 62.825 | 62.825 | 9600.0 |
| 2004-11-26 09:00:00 | IWM | ETF | 62.85 | 63.075 | 62.8 | 62.985 | 2025000.0 |
| 2004-11-26 10:00:00 | IWM | ETF | 62.99 | 63.14 | 62.96 | 63.14 | 834400.0 |
| 2004-11-26 11:00:00 | IWM | ETF | 63.14 | 63.2 | 63.09 | 63.09 | 991800.0 |
| 2004-11-26 12:00:00 | IWM | ETF | 63.085 | 63.14 | 62.905 | 62.925 | 1714600.0 |
| 2004-11-26 13:00:00 | IWM | ETF | 62.935 | 62.935 | 62.75 | 62.75 | 105000.0 |
| 2004-11-26 08:00:00 | DIA | ETF | 105.15 | 105.15 | 105.07 | 105.07 | 2100.0 |
| 2004-11-26 09:00:00 | DIA | ETF | 105.11 | 105.26 | 105.06 | 105.21 | 534500.0 |
| 2004-11-26 10:00:00 | DIA | ETF | 105.23 | 105.28 | 105.1 | 105.27 | 439200.0 |
| 2004-11-26 11:00:00 | DIA | ETF | 105.25 | 105.35 | 105.14 | 105.14 | 262800.0 |
| 2004-11-26 12:00:00 | DIA | ETF | 105.14 | 105.3 | 105.07 | 105.14 | 479100.0 |
| 2004-11-26 13:00:00 | DIA | ETF | 105.14 | 105.15 | 104.9 | 104.92 | 49400.0 |
| 2004-11-26 09:00:00 | GLD | ETF | 45.25 | 45.3 | 45.06 | 45.09 | 798700.0 |
| 2004-11-26 10:00:00 | GLD | ETF | 45.11 | 45.3 | 45.07 | 45.3 | 953500.0 |
| 2004-11-26 11:00:00 | GLD | ETF | 45.28 | 45.6 | 45.27 | 45.29 | 795000.0 |
| 2004-11-26 12:00:00 | GLD | ETF | 45.3 | 45.36 | 45.29 | 45.3 | 522000.0 |
| 2004-11-26 13:00:00 | GLD | ETF | 45.3 | 45.3 | 45.29 | 45.29 | 26800.0 |
| 2004-11-26 08:00:00 | TLT | ETF | 88.35 | 88.35 | 88.31 | 88.31 | 11800.0 |
| 2004-11-26 09:00:00 | TLT | ETF | 88.3 | 88.31 | 88.23 | 88.3 | 191700.0 |
| 2004-11-26 10:00:00 | TLT | ETF | 88.29 | 88.34 | 88.26 | 88.27 | 294500.0 |
| 2004-11-26 11:00:00 | TLT | ETF | 88.26 | 88.32 | 88.26 | 88.28 | 111400.0 |
| 2004-11-26 12:00:00 | TLT | ETF | 88.29 | 88.3 | 88.23 | 88.25 | 87300.0 |
> showing 34 of 449 rows — these rows as CSV