PREVIEW / etf_1hour / 2006-11-29
file: by_date/etf_1hour/2006/2006-11-29.parquet size: 58 KB rows: 1,807
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-29 04:00:00 | SPY | ETF | 139.33 | 139.49 | 139.33 | 139.49 | 200.0 |
| 2006-11-29 05:00:00 | SPY | ETF | 139.58 | 139.58 | 139.58 | 139.58 | 300.0 |
| 2006-11-29 07:00:00 | SPY | ETF | 139.46 | 139.51 | 139.36 | 139.38 | 51200.0 |
| 2006-11-29 08:00:00 | SPY | ETF | 139.44 | 139.59 | 139.35 | 139.5 | 2654600.0 |
| 2006-11-29 09:00:00 | SPY | ETF | 139.51 | 139.87 | 139.42 | 139.75 | 12542700.0 |
| 2006-11-29 10:00:00 | SPY | ETF | 139.74 | 140.07 | 139.58 | 139.96 | 18967600.0 |
| 2006-11-29 11:00:00 | SPY | ETF | 139.96 | 140.41 | 139.96 | 140.19 | 10672100.0 |
| 2006-11-29 12:00:00 | SPY | ETF | 140.19 | 140.3 | 140.02 | 140.1095 | 6485000.0 |
| 2006-11-29 13:00:00 | SPY | ETF | 140.1 | 140.11 | 139.57 | 139.87 | 10862700.0 |
| 2006-11-29 14:00:00 | SPY | ETF | 139.87 | 140.32 | 139.67 | 140.25 | 8730800.0 |
| 2006-11-29 15:00:00 | SPY | ETF | 140.24 | 140.53 | 140.18 | 140.35 | 12682300.0 |
| 2006-11-29 16:00:00 | SPY | ETF | 140.31 | 140.47 | 140.29 | 140.39 | 1361500.0 |
| 2006-11-29 17:00:00 | SPY | ETF | 140.38 | 140.42 | 140.32 | 140.37 | 926000.0 |
| 2006-11-29 18:00:00 | SPY | ETF | 140.37 | 140.47 | 140.36 | 140.36 | 1507200.0 |
| 2006-11-29 09:00:00 | QQQ | ETF | 44.0 | 44.09 | 43.96 | 44.02 | 21104900.0 |
| 2006-11-29 10:00:00 | QQQ | ETF | 44.01 | 44.16 | 43.78 | 44.03 | 23435300.0 |
| 2006-11-29 11:00:00 | QQQ | ETF | 44.03 | 44.18 | 44.02 | 44.07 | 10104900.0 |
| 2006-11-29 12:00:00 | QQQ | ETF | 44.07 | 44.15 | 43.95 | 43.96 | 9194600.0 |
| 2006-11-29 13:00:00 | QQQ | ETF | 43.95 | 43.95 | 43.66 | 43.85 | 27280700.0 |
| 2006-11-29 14:00:00 | QQQ | ETF | 43.84 | 44.09 | 43.8 | 44.03 | 16437200.0 |
| 2006-11-29 15:00:00 | QQQ | ETF | 44.03 | 44.15 | 44.0 | 44.07 | 13072200.0 |
| 2006-11-29 08:00:00 | IWM | ETF | 77.25 | 77.65 | 77.25 | 77.59 | 949100.0 |
| 2006-11-29 09:00:00 | IWM | ETF | 77.56 | 77.82 | 77.46 | 77.69 | 6893300.0 |
| 2006-11-29 10:00:00 | IWM | ETF | 77.69 | 78.06 | 77.59 | 77.83 | 10311600.0 |
| 2006-11-29 11:00:00 | IWM | ETF | 77.83 | 78.15 | 77.82 | 77.97 | 5529400.0 |
| 2006-11-29 12:00:00 | IWM | ETF | 77.9799 | 78.04 | 77.74 | 77.78 | 3581000.0 |
| 2006-11-29 13:00:00 | IWM | ETF | 77.78 | 77.78 | 77.3 | 77.57 | 7899600.0 |
| 2006-11-29 14:00:00 | IWM | ETF | 77.56 | 77.9 | 77.48 | 77.83 | 5543600.0 |
| 2006-11-29 15:00:00 | IWM | ETF | 77.8205 | 78.2 | 77.8 | 78.03 | 7533800.0 |
| 2006-11-29 16:00:00 | IWM | ETF | 78.02 | 78.09 | 77.77 | 78.05 | 310100.0 |
| 2006-11-29 17:00:00 | IWM | ETF | 78.05 | 78.05 | 78.03 | 78.03 | 54300.0 |
| 2006-11-29 07:00:00 | DIA | ETF | 121.6 | 121.6 | 121.56 | 121.56 | 600.0 |
| 2006-11-29 08:00:00 | DIA | ETF | 121.61 | 121.72 | 121.52 | 121.7 | 49500.0 |
| 2006-11-29 09:00:00 | DIA | ETF | 121.63 | 121.88 | 121.55 | 121.85 | 1162300.0 |
| 2006-11-29 10:00:00 | DIA | ETF | 121.85 | 122.15 | 121.72 | 121.99 | 2024500.0 |
| 2006-11-29 11:00:00 | DIA | ETF | 121.98 | 122.35 | 121.98 | 122.19 | 1193500.0 |
| 2006-11-29 12:00:00 | DIA | ETF | 122.19 | 122.27 | 122.02 | 122.06 | 742400.0 |
| 2006-11-29 13:00:00 | DIA | ETF | 122.06 | 122.06 | 121.67 | 121.9 | 1261900.0 |
| 2006-11-29 14:00:00 | DIA | ETF | 121.89 | 122.23 | 121.72 | 122.18 | 899700.0 |
| 2006-11-29 15:00:00 | DIA | ETF | 122.18 | 122.4 | 122.13 | 122.29 | 1326900.0 |
| 2006-11-29 16:00:00 | DIA | ETF | 122.25 | 122.38 | 122.25 | 122.33 | 57600.0 |
| 2006-11-29 08:00:00 | GLD | ETF | 63.23 | 63.23 | 63.03 | 63.06 | 58700.0 |
| 2006-11-29 09:00:00 | GLD | ETF | 63.12 | 63.37 | 63.12 | 63.261 | 582800.0 |
| 2006-11-29 10:00:00 | GLD | ETF | 63.27 | 63.39 | 63.2 | 63.2 | 640600.0 |
| 2006-11-29 11:00:00 | GLD | ETF | 63.18 | 63.35 | 63.08 | 63.3101 | 958500.0 |
| 2006-11-29 12:00:00 | GLD | ETF | 63.31 | 63.365 | 63.2 | 63.31 | 350700.0 |
| 2006-11-29 13:00:00 | GLD | ETF | 63.31 | 63.35 | 63.12 | 63.14 | 668100.0 |
| 2006-11-29 14:00:00 | GLD | ETF | 63.13 | 63.2 | 63.1 | 63.14 | 259000.0 |
| 2006-11-29 15:00:00 | GLD | ETF | 63.148 | 63.25 | 63.14 | 63.18 | 481300.0 |
| 2006-11-29 16:00:00 | GLD | ETF | 63.1728 | 63.27 | 63.156 | 63.18 | 1400.0 |
> showing 50 of 1,807 rows — these rows as CSV