PREVIEW / etf_1hour / 2006-10-25
file: by_date/etf_1hour/2006/2006-10-25.parquet size: 55 KB rows: 1,731
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-10-25 06:00:00 | SPY | ETF | 137.99 | 137.99 | 137.93 | 137.93 | 5800.0 |
| 2006-10-25 07:00:00 | SPY | ETF | 137.91 | 138.03 | 137.9 | 137.94 | 9500.0 |
| 2006-10-25 08:00:00 | SPY | ETF | 137.95 | 137.99 | 137.76 | 137.85 | 285000.0 |
| 2006-10-25 09:00:00 | SPY | ETF | 137.83 | 137.94 | 137.71 | 137.86 | 3443300.0 |
| 2006-10-25 10:00:00 | SPY | ETF | 137.86 | 138.07 | 137.75 | 137.88 | 11460700.0 |
| 2006-10-25 11:00:00 | SPY | ETF | 137.88 | 138.0 | 137.8 | 137.94 | 4153200.0 |
| 2006-10-25 12:00:00 | SPY | ETF | 137.94 | 137.96 | 137.63 | 137.74 | 7929100.0 |
| 2006-10-25 13:00:00 | SPY | ETF | 137.73 | 137.97 | 137.7 | 137.93 | 3876900.0 |
| 2006-10-25 14:00:00 | SPY | ETF | 137.92 | 138.39 | 137.51 | 138.11 | 23213100.0 |
| 2006-10-25 15:00:00 | SPY | ETF | 138.12 | 138.41 | 138.01 | 138.2 | 11058700.0 |
| 2006-10-25 16:00:00 | SPY | ETF | 138.2 | 138.43 | 138.17 | 138.38 | 1513200.0 |
| 2006-10-25 17:00:00 | SPY | ETF | 138.39 | 138.43 | 138.38 | 138.4 | 7808500.0 |
| 2006-10-25 18:00:00 | SPY | ETF | 138.38 | 138.38 | 138.34 | 138.34 | 7500.0 |
| 2006-10-25 19:00:00 | SPY | ETF | 138.36 | 138.37 | 138.33 | 138.37 | 3300.0 |
| 2006-10-25 09:00:00 | QQQ | ETF | 42.15 | 42.35 | 42.12 | 42.31 | 9128900.0 |
| 2006-10-25 10:00:00 | QQQ | ETF | 42.3 | 42.52 | 42.24 | 42.33 | 17954200.0 |
| 2006-10-25 11:00:00 | QQQ | ETF | 42.34 | 42.43 | 42.31 | 42.35 | 6783500.0 |
| 2006-10-25 12:00:00 | QQQ | ETF | 42.35 | 42.38 | 42.19 | 42.27 | 12992700.0 |
| 2006-10-25 13:00:00 | QQQ | ETF | 42.26 | 42.35 | 42.25 | 42.27 | 6880000.0 |
| 2006-10-25 14:00:00 | QQQ | ETF | 42.27 | 42.46 | 42.05 | 42.26 | 41037700.0 |
| 2006-10-25 15:00:00 | QQQ | ETF | 42.26 | 42.49 | 42.23 | 42.42 | 21726400.0 |
| 2006-10-25 07:00:00 | IWM | ETF | 75.85 | 75.85 | 75.85 | 75.85 | 100.0 |
| 2006-10-25 08:00:00 | IWM | ETF | 75.84 | 75.84 | 75.8 | 75.83 | 90300.0 |
| 2006-10-25 09:00:00 | IWM | ETF | 75.84 | 76.23 | 75.73 | 76.1414 | 3877000.0 |
| 2006-10-25 10:00:00 | IWM | ETF | 76.15 | 76.46 | 76.08 | 76.13 | 9616100.0 |
| 2006-10-25 11:00:00 | IWM | ETF | 76.13 | 76.3 | 76.09 | 76.21 | 2693700.0 |
| 2006-10-25 12:00:00 | IWM | ETF | 76.2 | 76.25 | 75.74 | 75.81 | 6435900.0 |
| 2006-10-25 13:00:00 | IWM | ETF | 75.8 | 76.01 | 75.75 | 75.95 | 2647100.0 |
| 2006-10-25 14:00:00 | IWM | ETF | 75.94 | 76.24 | 75.48 | 75.97 | 11275900.0 |
| 2006-10-25 15:00:00 | IWM | ETF | 75.97 | 76.3 | 75.94 | 76.27 | 10429100.0 |
| 2006-10-25 16:00:00 | IWM | ETF | 76.27 | 76.5 | 76.23 | 76.5 | 1996700.0 |
| 2006-10-25 17:00:00 | IWM | ETF | 76.43 | 76.44 | 76.43 | 76.44 | 1000300.0 |
| 2006-10-25 18:00:00 | IWM | ETF | 76.42 | 76.46 | 76.42 | 76.46 | 750200.0 |
| 2006-10-25 07:00:00 | DIA | ETF | 121.36 | 121.36 | 121.32 | 121.32 | 1100.0 |
| 2006-10-25 08:00:00 | DIA | ETF | 121.34 | 121.41 | 121.13 | 121.14 | 38900.0 |
| 2006-10-25 09:00:00 | DIA | ETF | 121.13 | 121.17 | 121.0 | 121.07 | 801600.0 |
| 2006-10-25 10:00:00 | DIA | ETF | 121.08 | 121.25 | 120.87 | 120.87 | 1296300.0 |
| 2006-10-25 11:00:00 | DIA | ETF | 120.86 | 120.96 | 120.81 | 120.9 | 614600.0 |
| 2006-10-25 12:00:00 | DIA | ETF | 120.9 | 120.92 | 120.71 | 120.79 | 750800.0 |
| 2006-10-25 13:00:00 | DIA | ETF | 120.78 | 120.99 | 120.758 | 120.95 | 534300.0 |
| 2006-10-25 14:00:00 | DIA | ETF | 120.9525 | 121.33 | 120.69 | 121.08 | 2740000.0 |
| 2006-10-25 15:00:00 | DIA | ETF | 121.08 | 121.38 | 121.0 | 121.18 | 1753900.0 |
| 2006-10-25 16:00:00 | DIA | ETF | 121.18 | 121.41 | 121.18 | 121.4 | 21800.0 |
| 2006-10-25 17:00:00 | DIA | ETF | 121.4 | 121.42 | 121.39 | 121.42 | 1200.0 |
| 2006-10-25 18:00:00 | DIA | ETF | 121.43 | 121.43 | 121.43 | 121.43 | 100.0 |
| 2006-10-25 19:00:00 | DIA | ETF | 121.35 | 121.35 | 121.3 | 121.3 | 600.0 |
| 2006-10-25 08:00:00 | GLD | ETF | 57.92 | 57.93 | 57.73 | 57.73 | 21600.0 |
| 2006-10-25 09:00:00 | GLD | ETF | 57.78 | 57.9 | 57.63 | 57.66 | 379700.0 |
| 2006-10-25 10:00:00 | GLD | ETF | 57.66 | 58.52 | 57.55 | 58.43 | 1085000.0 |
| 2006-10-25 11:00:00 | GLD | ETF | 58.42 | 58.6 | 58.34 | 58.57 | 946500.0 |
> showing 50 of 1,731 rows — these rows as CSV