PREVIEW / etf_1hour / 2006-11-10
file: by_date/etf_1hour/2006/2006-11-10.parquet size: 56 KB rows: 1,745
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-10 07:00:00 | SPY | ETF | 138.35 | 138.43 | 138.3 | 138.33 | 162600.0 |
| 2006-11-10 08:00:00 | SPY | ETF | 138.34 | 138.43 | 138.19 | 138.27 | 1360500.0 |
| 2006-11-10 09:00:00 | SPY | ETF | 138.24 | 138.28 | 137.99 | 138.14 | 6593300.0 |
| 2006-11-10 10:00:00 | SPY | ETF | 138.14 | 138.34 | 137.94 | 138.06 | 10453900.0 |
| 2006-11-10 11:00:00 | SPY | ETF | 138.05 | 138.17 | 137.85 | 137.99 | 6751400.0 |
| 2006-11-10 12:00:00 | SPY | ETF | 137.99 | 138.11 | 137.97 | 138.03 | 2445900.0 |
| 2006-11-10 13:00:00 | SPY | ETF | 138.03 | 138.05 | 137.72 | 137.83 | 5904200.0 |
| 2006-11-10 14:00:00 | SPY | ETF | 137.83 | 138.2 | 137.76 | 138.11 | 5352800.0 |
| 2006-11-10 15:00:00 | SPY | ETF | 138.12 | 138.3 | 138.0 | 138.27 | 6093600.0 |
| 2006-11-10 16:00:00 | SPY | ETF | 138.28 | 138.32 | 138.22 | 138.29 | 1086900.0 |
| 2006-11-10 17:00:00 | SPY | ETF | 138.29 | 138.35 | 138.29 | 138.31 | 521800.0 |
| 2006-11-10 18:00:00 | SPY | ETF | 138.3 | 138.3 | 138.3 | 138.3 | 500.0 |
| 2006-11-10 09:00:00 | QQQ | ETF | 42.83 | 42.9 | 42.67 | 42.81 | 15169600.0 |
| 2006-11-10 10:00:00 | QQQ | ETF | 42.8 | 42.95 | 42.75 | 42.89 | 17140000.0 |
| 2006-11-10 11:00:00 | QQQ | ETF | 42.88 | 42.95 | 42.77 | 42.86 | 7757100.0 |
| 2006-11-10 12:00:00 | QQQ | ETF | 42.86 | 42.96 | 42.86 | 42.9 | 3866900.0 |
| 2006-11-10 13:00:00 | QQQ | ETF | 42.9 | 42.91 | 42.78 | 42.83 | 9171900.0 |
| 2006-11-10 14:00:00 | QQQ | ETF | 42.83 | 43.0 | 42.8 | 42.98 | 8315300.0 |
| 2006-11-10 15:00:00 | QQQ | ETF | 42.97 | 43.04 | 42.92 | 43.03 | 10412500.0 |
| 2006-11-10 08:00:00 | IWM | ETF | 75.95 | 75.95 | 75.77 | 75.8 | 64900.0 |
| 2006-11-10 09:00:00 | IWM | ETF | 75.83 | 76.0 | 75.61 | 75.77 | 7419500.0 |
| 2006-11-10 10:00:00 | IWM | ETF | 75.77 | 76.1 | 75.75 | 75.94 | 9518600.0 |
| 2006-11-10 11:00:00 | IWM | ETF | 75.91 | 76.25 | 75.8 | 76.15 | 4556200.0 |
| 2006-11-10 12:00:00 | IWM | ETF | 76.14 | 76.2 | 75.97 | 76.03 | 1668100.0 |
| 2006-11-10 13:00:00 | IWM | ETF | 76.03 | 76.09 | 75.85 | 76.01 | 1991600.0 |
| 2006-11-10 14:00:00 | IWM | ETF | 76.01 | 76.39 | 75.92 | 76.33 | 4624700.0 |
| 2006-11-10 15:00:00 | IWM | ETF | 76.32 | 76.49 | 76.25 | 76.48 | 5019200.0 |
| 2006-11-10 16:00:00 | IWM | ETF | 76.49 | 76.57 | 76.42 | 76.52 | 124300.0 |
| 2006-11-10 17:00:00 | IWM | ETF | 76.4 | 76.4 | 76.4 | 76.4 | 300.0 |
| 2006-11-10 08:00:00 | DIA | ETF | 121.24 | 121.24 | 121.17 | 121.23 | 11100.0 |
| 2006-11-10 09:00:00 | DIA | ETF | 121.2 | 121.26 | 121.09 | 121.17 | 597600.0 |
| 2006-11-10 10:00:00 | DIA | ETF | 121.18 | 121.26 | 120.91 | 121.03 | 688100.0 |
| 2006-11-10 11:00:00 | DIA | ETF | 121.02 | 121.09 | 120.88 | 120.96 | 527200.0 |
| 2006-11-10 12:00:00 | DIA | ETF | 120.96 | 121.03 | 120.89 | 120.97 | 223500.0 |
| 2006-11-10 13:00:00 | DIA | ETF | 120.98 | 120.98 | 120.77 | 120.85 | 360200.0 |
| 2006-11-10 14:00:00 | DIA | ETF | 120.86 | 121.06 | 120.8 | 120.99 | 572900.0 |
| 2006-11-10 15:00:00 | DIA | ETF | 120.99 | 121.12 | 120.91 | 121.11 | 704200.0 |
| 2006-11-10 16:00:00 | DIA | ETF | 121.1 | 121.25 | 121.03 | 121.25 | 12600.0 |
| 2006-11-10 07:00:00 | GLD | ETF | 63.0 | 63.0 | 62.98 | 62.98 | 6000.0 |
| 2006-11-10 08:00:00 | GLD | ETF | 62.83 | 63.0 | 62.46 | 62.88 | 484600.0 |
| 2006-11-10 09:00:00 | GLD | ETF | 62.9 | 62.93 | 62.4354 | 62.67 | 831000.0 |
| 2006-11-10 10:00:00 | GLD | ETF | 62.68 | 62.69 | 62.17 | 62.4445 | 1184000.0 |
| 2006-11-10 11:00:00 | GLD | ETF | 62.4499 | 62.61 | 62.19 | 62.3 | 507800.0 |
| 2006-11-10 12:00:00 | GLD | ETF | 62.28 | 62.44 | 62.06 | 62.16 | 518100.0 |
| 2006-11-10 13:00:00 | GLD | ETF | 62.16 | 62.5 | 62.128 | 62.37 | 418000.0 |
| 2006-11-10 14:00:00 | GLD | ETF | 62.39 | 62.39 | 62.23 | 62.29 | 161600.0 |
| 2006-11-10 15:00:00 | GLD | ETF | 62.29 | 62.35 | 62.26 | 62.33 | 298100.0 |
| 2006-11-10 16:00:00 | GLD | ETF | 62.38 | 62.48 | 62.38 | 62.44 | 3200.0 |
| 2006-11-10 17:00:00 | GLD | ETF | 62.47 | 62.47 | 62.47 | 62.47 | 200.0 |
| 2006-11-10 18:00:00 | GLD | ETF | 62.47 | 62.47 | 62.3 | 62.3 | 1100.0 |
> showing 50 of 1,745 rows — these rows as CSV