PREVIEW / etf_30min / 2008-12-16
file: by_date/etf_30min/2008/2008-12-16.parquet size: 189 KB rows: 6,785
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-12-16 04:00:00 | SPY | ETF | 88.02 | 88.21 | 88.02 | 88.21 | 200.0 |
| 2008-12-16 04:30:00 | SPY | ETF | 88.24 | 88.56 | 88.24 | 88.34 | 600.0 |
| 2008-12-16 05:00:00 | SPY | ETF | 88.25 | 88.4 | 88.2 | 88.4 | 1300.0 |
| 2008-12-16 06:30:00 | SPY | ETF | 88.01 | 88.1 | 87.98 | 88.08 | 105400.0 |
| 2008-12-16 07:00:00 | SPY | ETF | 88.14 | 88.8 | 88.03 | 88.49 | 662902.0 |
| 2008-12-16 07:30:00 | SPY | ETF | 88.46 | 88.55 | 88.25 | 88.41 | 373026.0 |
| 2008-12-16 08:00:00 | SPY | ETF | 88.43 | 88.89 | 87.65 | 88.67 | 3450421.0 |
| 2008-12-16 08:30:00 | SPY | ETF | 88.68 | 88.8 | 88.14 | 88.6 | 2585059.0 |
| 2008-12-16 09:00:00 | SPY | ETF | 88.61 | 88.91 | 88.32 | 88.32 | 1621379.0 |
| 2008-12-16 09:30:00 | SPY | ETF | 88.3 | 89.0 | 88.18 | 88.58 | 33685451.0 |
| 2008-12-16 10:00:00 | SPY | ETF | 88.59 | 89.09 | 88.45 | 88.6901 | 22821836.0 |
| 2008-12-16 10:30:00 | SPY | ETF | 88.7 | 88.83 | 88.34 | 88.67 | 11417269.0 |
| 2008-12-16 11:00:00 | SPY | ETF | 88.67 | 88.9 | 88.59 | 88.85 | 10022990.0 |
| 2008-12-16 11:30:00 | SPY | ETF | 88.86 | 89.15 | 88.85 | 89.048 | 9885869.0 |
| 2008-12-16 12:00:00 | SPY | ETF | 89.04 | 89.09 | 88.81 | 88.93 | 6519212.0 |
| 2008-12-16 12:30:00 | SPY | ETF | 88.92 | 89.03 | 88.72 | 88.72 | 6229817.0 |
| 2008-12-16 13:00:00 | SPY | ETF | 88.71 | 89.01 | 88.65 | 88.95 | 9820396.0 |
| 2008-12-16 13:30:00 | SPY | ETF | 88.959 | 89.05 | 88.73 | 88.81 | 8520790.0 |
| 2008-12-16 14:00:00 | SPY | ETF | 88.81 | 89.96 | 88.75 | 89.61 | 39736814.0 |
| 2008-12-16 14:30:00 | SPY | ETF | 89.599 | 90.5 | 89.3 | 90.266 | 56735001.0 |
| 2008-12-16 15:00:00 | SPY | ETF | 90.27 | 91.85 | 89.7 | 91.46 | 58680215.0 |
| 2008-12-16 15:30:00 | SPY | ETF | 91.45 | 92.02 | 90.96 | 91.84 | 58816038.0 |
| 2008-12-16 16:00:00 | SPY | ETF | 91.89 | 92.03 | 88.05 | 91.85 | 20428113.0 |
| 2008-12-16 16:30:00 | SPY | ETF | 91.85 | 91.98 | 87.3731 | 91.75 | 7048255.0 |
| 2008-12-16 17:00:00 | SPY | ETF | 91.75 | 91.88 | 91.66 | 91.68 | 2127933.0 |
| 2008-12-16 17:30:00 | SPY | ETF | 91.66 | 91.71 | 91.6 | 91.7 | 56144.0 |
| 2008-12-16 18:00:00 | SPY | ETF | 91.7 | 91.98 | 91.7 | 91.93 | 97659.0 |
| 2008-12-16 18:30:00 | SPY | ETF | 91.94 | 91.98 | 91.77 | 91.92 | 117486.0 |
| 2008-12-16 19:00:00 | SPY | ETF | 91.87 | 91.87 | 91.64 | 91.64 | 1103761.0 |
| 2008-12-16 19:30:00 | SPY | ETF | 91.67 | 91.68 | 91.53 | 91.53 | 56615.0 |
| 2008-12-16 04:00:00 | QQQ | ETF | 29.46 | 29.46 | 29.46 | 29.46 | 100.0 |
| 2008-12-16 04:30:00 | QQQ | ETF | 29.51 | 29.59 | 29.51 | 29.59 | 200.0 |
| 2008-12-16 05:30:00 | QQQ | ETF | 29.5 | 29.5 | 29.5 | 29.5 | 300.0 |
| 2008-12-16 06:00:00 | QQQ | ETF | 29.42 | 29.42 | 29.42 | 29.42 | 656.0 |
| 2008-12-16 06:30:00 | QQQ | ETF | 29.45 | 29.52 | 29.45 | 29.52 | 3098.0 |
| 2008-12-16 07:00:00 | QQQ | ETF | 29.49 | 29.73 | 29.49 | 29.64 | 27854.0 |
| 2008-12-16 07:30:00 | QQQ | ETF | 29.61 | 29.61 | 29.5 | 29.56 | 94550.0 |
| 2008-12-16 08:00:00 | QQQ | ETF | 29.56 | 29.69 | 29.54 | 29.65 | 1147115.0 |
| 2008-12-16 08:30:00 | QQQ | ETF | 29.65 | 29.68 | 29.46 | 29.59 | 1208095.0 |
| 2008-12-16 09:00:00 | QQQ | ETF | 29.59 | 29.64 | 29.42 | 29.43 | 836166.0 |
| 2008-12-16 09:30:00 | QQQ | ETF | 29.42 | 29.68 | 29.4 | 29.62 | 16933189.0 |
| 2008-12-16 10:00:00 | QQQ | ETF | 29.62 | 29.72 | 29.55 | 29.61 | 9548382.0 |
| 2008-12-16 10:30:00 | QQQ | ETF | 29.6 | 29.69 | 29.53 | 29.68 | 5461439.0 |
| 2008-12-16 11:00:00 | QQQ | ETF | 29.67 | 29.72 | 29.6 | 29.7 | 4388391.0 |
| 2008-12-16 11:30:00 | QQQ | ETF | 29.7 | 29.93 | 29.7 | 29.87 | 7224014.0 |
| 2008-12-16 12:00:00 | QQQ | ETF | 29.88 | 29.89 | 29.77 | 29.8 | 2638558.0 |
| 2008-12-16 12:30:00 | QQQ | ETF | 29.8 | 29.84 | 29.76 | 29.76 | 2513324.0 |
| 2008-12-16 13:00:00 | QQQ | ETF | 29.7601 | 29.83 | 29.71 | 29.82 | 3276885.0 |
| 2008-12-16 13:30:00 | QQQ | ETF | 29.82 | 29.85 | 29.71 | 29.7304 | 2655595.0 |
| 2008-12-16 14:00:00 | QQQ | ETF | 29.73 | 30.07 | 29.71 | 30.0 | 10159239.0 |
> showing 50 of 6,785 rows — these rows as CSV