PREVIEW / etf_1hour / 2008-08-29
file: by_date/etf_1hour/2008/2008-08-29.parquet size: 106 KB rows: 3,429
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-29 04:00:00 | SPY | ETF | 129.75 | 129.77 | 129.75 | 129.77 | 5600.0 |
| 2008-08-29 05:00:00 | SPY | ETF | 129.84 | 130.05 | 129.84 | 130.05 | 15000.0 |
| 2008-08-29 06:00:00 | SPY | ETF | 129.94 | 129.99 | 129.91 | 129.96 | 17100.0 |
| 2008-08-29 07:00:00 | SPY | ETF | 129.94 | 130.15 | 129.84 | 130.09 | 927892.0 |
| 2008-08-29 08:00:00 | SPY | ETF | 129.88 | 130.19 | 129.74 | 129.8 | 2885028.0 |
| 2008-08-29 09:00:00 | SPY | ETF | 129.8 | 130.19 | 129.57 | 129.91 | 34596860.0 |
| 2008-08-29 10:00:00 | SPY | ETF | 129.91 | 130.0 | 129.05 | 129.12 | 30444956.0 |
| 2008-08-29 11:00:00 | SPY | ETF | 129.12 | 129.35 | 129.03 | 129.18 | 19600091.0 |
| 2008-08-29 12:00:00 | SPY | ETF | 129.18 | 129.18 | 128.77 | 129.12 | 18133226.0 |
| 2008-08-29 13:00:00 | SPY | ETF | 129.12 | 129.54 | 129.1 | 129.23 | 19718369.0 |
| 2008-08-29 14:00:00 | SPY | ETF | 129.23 | 129.46 | 129.2 | 129.38 | 10287737.0 |
| 2008-08-29 15:00:00 | SPY | ETF | 129.38 | 129.96 | 128.61 | 128.69 | 33449574.0 |
| 2008-08-29 16:00:00 | SPY | ETF | 128.63 | 130.4011 | 127.4634 | 128.74 | 11551632.0 |
| 2008-08-29 17:00:00 | SPY | ETF | 128.65 | 128.76 | 128.62 | 128.65 | 41738.0 |
| 2008-08-29 18:00:00 | SPY | ETF | 128.65 | 128.65 | 128.62 | 128.65 | 6111.0 |
| 2008-08-29 19:00:00 | SPY | ETF | 128.65 | 128.65 | 128.58 | 128.65 | 8277.0 |
| 2008-08-29 04:00:00 | QQQ | ETF | 46.75 | 46.75 | 46.7 | 46.7 | 400.0 |
| 2008-08-29 07:00:00 | QQQ | ETF | 46.77 | 46.85 | 46.75 | 46.83 | 214701.0 |
| 2008-08-29 08:00:00 | QQQ | ETF | 46.83 | 46.86 | 46.69 | 46.71 | 1775906.0 |
| 2008-08-29 09:00:00 | QQQ | ETF | 46.71 | 46.81 | 46.52 | 46.67 | 16411159.0 |
| 2008-08-29 10:00:00 | QQQ | ETF | 46.66 | 46.7 | 46.06 | 46.09 | 31241700.0 |
| 2008-08-29 11:00:00 | QQQ | ETF | 46.1 | 46.2222 | 46.0 | 46.03 | 18200668.0 |
| 2008-08-29 12:00:00 | QQQ | ETF | 46.03 | 46.14 | 45.92 | 46.12 | 13111816.0 |
| 2008-08-29 13:00:00 | QQQ | ETF | 46.12 | 46.35 | 46.0 | 46.1796 | 12965860.0 |
| 2008-08-29 14:00:00 | QQQ | ETF | 46.172 | 46.45 | 46.16 | 46.28 | 8984061.0 |
| 2008-08-29 15:00:00 | QQQ | ETF | 46.28 | 46.29 | 46.04 | 46.13 | 18694963.0 |
| 2008-08-29 16:00:00 | QQQ | ETF | 46.14 | 46.24 | 45.99 | 46.08 | 5729077.0 |
| 2008-08-29 17:00:00 | QQQ | ETF | 46.08 | 46.12 | 46.05 | 46.07 | 72295.0 |
| 2008-08-29 18:00:00 | QQQ | ETF | 46.07 | 46.08 | 46.02 | 46.08 | 21145.0 |
| 2008-08-29 19:00:00 | QQQ | ETF | 46.05 | 46.13 | 46.05 | 46.13 | 61719.0 |
| 2008-08-29 07:00:00 | IWM | ETF | 74.34 | 74.43 | 74.33 | 74.43 | 9402.0 |
| 2008-08-29 08:00:00 | IWM | ETF | 74.14 | 74.48 | 74.14 | 74.32 | 1843366.0 |
| 2008-08-29 09:00:00 | IWM | ETF | 74.3 | 74.52 | 74.03 | 74.26 | 13740730.0 |
| 2008-08-29 10:00:00 | IWM | ETF | 74.25 | 74.31 | 73.53 | 73.65 | 12386908.0 |
| 2008-08-29 11:00:00 | IWM | ETF | 73.65 | 73.99 | 73.65 | 73.74 | 8085487.0 |
| 2008-08-29 12:00:00 | IWM | ETF | 73.75 | 73.89 | 73.58 | 73.85 | 5912872.0 |
| 2008-08-29 13:00:00 | IWM | ETF | 73.85 | 74.16 | 73.82 | 74.03 | 6586603.0 |
| 2008-08-29 14:00:00 | IWM | ETF | 74.03 | 74.14 | 73.93 | 74.11 | 3853772.0 |
| 2008-08-29 15:00:00 | IWM | ETF | 74.11 | 74.12 | 73.64 | 73.76 | 14227469.0 |
| 2008-08-29 16:00:00 | IWM | ETF | 73.76 | 74.66 | 73.66 | 73.88 | 12349888.0 |
| 2008-08-29 17:00:00 | IWM | ETF | 73.85 | 73.85 | 73.85 | 73.85 | 100.0 |
| 2008-08-29 19:00:00 | IWM | ETF | 73.94 | 73.94 | 73.94 | 73.94 | 1000.0 |
| 2008-08-29 05:00:00 | DIA | ETF | 116.96 | 116.96 | 116.95 | 116.95 | 500.0 |
| 2008-08-29 07:00:00 | DIA | ETF | 116.95 | 117.0 | 116.95 | 117.0 | 202.0 |
| 2008-08-29 08:00:00 | DIA | ETF | 116.99 | 116.99 | 116.61 | 116.63 | 44312.0 |
| 2008-08-29 09:00:00 | DIA | ETF | 116.64 | 117.04 | 116.43 | 116.74 | 2374732.0 |
| 2008-08-29 10:00:00 | DIA | ETF | 116.75 | 116.82 | 116.01 | 116.08 | 2710494.0 |
| 2008-08-29 11:00:00 | DIA | ETF | 116.11 | 116.25 | 115.96 | 116.05 | 2239360.0 |
| 2008-08-29 12:00:00 | DIA | ETF | 116.05 | 116.05 | 115.51 | 115.9 | 2161137.0 |
| 2008-08-29 13:00:00 | DIA | ETF | 115.91 | 116.31 | 115.9 | 116.03 | 1728969.0 |
> showing 50 of 3,429 rows — these rows as CSV