PREVIEW / etf_30min / 2005-12-08
file: by_date/etf_30min/2005/2005-12-08.parquet size: 58 KB rows: 2,021
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-08 06:00:00 | SPY | ETF | 125.79 | 125.79 | 125.79 | 125.79 | 300.0 |
| 2005-12-08 07:00:00 | SPY | ETF | 125.86 | 125.88 | 125.81 | 125.81 | 3700.0 |
| 2005-12-08 07:30:00 | SPY | ETF | 125.81 | 125.84 | 125.79 | 125.84 | 104900.0 |
| 2005-12-08 08:00:00 | SPY | ETF | 125.82 | 126.0 | 125.79 | 126.0 | 162300.0 |
| 2005-12-08 08:30:00 | SPY | ETF | 126.0 | 126.18 | 125.95 | 126.18 | 1179600.0 |
| 2005-12-08 09:00:00 | SPY | ETF | 126.16 | 126.25 | 125.88 | 126.19 | 2079900.0 |
| 2005-12-08 09:30:00 | SPY | ETF | 126.22 | 126.29 | 125.86 | 125.94 | 5339800.0 |
| 2005-12-08 10:00:00 | SPY | ETF | 125.95 | 126.05 | 125.86 | 125.97 | 3187800.0 |
| 2005-12-08 10:30:00 | SPY | ETF | 125.96 | 126.52 | 125.9 | 126.49 | 7016000.0 |
| 2005-12-08 11:00:00 | SPY | ETF | 126.5 | 126.7 | 126.43 | 126.62 | 6016400.0 |
| 2005-12-08 11:30:00 | SPY | ETF | 126.62 | 126.82 | 126.1675 | 126.73 | 4365400.0 |
| 2005-12-08 12:00:00 | SPY | ETF | 126.73 | 126.74 | 126.51 | 126.54 | 2628500.0 |
| 2005-12-08 12:30:00 | SPY | ETF | 126.55 | 126.55 | 126.28 | 126.39 | 3010500.0 |
| 2005-12-08 13:00:00 | SPY | ETF | 126.4 | 126.41 | 125.94 | 125.97 | 4649100.0 |
| 2005-12-08 13:30:00 | SPY | ETF | 125.98 | 126.21 | 125.95 | 126.07 | 3109100.0 |
| 2005-12-08 14:00:00 | SPY | ETF | 126.08 | 126.4 | 125.64 | 125.77 | 4442300.0 |
| 2005-12-08 14:30:00 | SPY | ETF | 125.76 | 125.82 | 125.48 | 125.74 | 5132100.0 |
| 2005-12-08 15:00:00 | SPY | ETF | 125.75 | 125.99 | 125.69 | 125.79 | 3599300.0 |
| 2005-12-08 15:30:00 | SPY | ETF | 125.8 | 126.09 | 125.77 | 126.05 | 4115600.0 |
| 2005-12-08 16:00:00 | SPY | ETF | 126.05 | 126.08 | 125.8 | 125.92 | 689200.0 |
| 2005-12-08 16:30:00 | SPY | ETF | 125.92 | 126.05 | 125.77 | 125.78 | 447800.0 |
| 2005-12-08 17:00:00 | SPY | ETF | 125.84 | 125.84 | 125.77 | 125.81 | 263000.0 |
| 2005-12-08 17:30:00 | SPY | ETF | 125.79 | 125.79 | 125.74 | 125.75 | 93900.0 |
| 2005-12-08 18:00:00 | SPY | ETF | 125.78 | 125.84 | 125.77 | 125.83 | 15800.0 |
| 2005-12-08 18:30:00 | SPY | ETF | 125.88 | 125.9 | 125.84 | 125.84 | 21700.0 |
| 2005-12-08 19:00:00 | SPY | ETF | 125.84 | 125.84 | 125.84 | 125.84 | 100.0 |
| 2005-12-08 19:30:00 | SPY | ETF | 125.86 | 125.86 | 125.86 | 125.86 | 600.0 |
| 2005-12-08 09:30:00 | QQQ | ETF | 41.96 | 42.0 | 41.66 | 41.68 | 10976300.0 |
| 2005-12-08 10:00:00 | QQQ | ETF | 41.69 | 41.77 | 41.67 | 41.76 | 6369300.0 |
| 2005-12-08 10:30:00 | QQQ | ETF | 41.76 | 41.94 | 41.72 | 41.92 | 6373100.0 |
| 2005-12-08 11:00:00 | QQQ | ETF | 41.92 | 41.98 | 41.9 | 41.92 | 6751800.0 |
| 2005-12-08 11:30:00 | QQQ | ETF | 41.92 | 41.98 | 41.88 | 41.93 | 5187900.0 |
| 2005-12-08 12:00:00 | QQQ | ETF | 41.93 | 41.94 | 41.79 | 41.8 | 3075600.0 |
| 2005-12-08 12:30:00 | QQQ | ETF | 41.8 | 41.81 | 41.67 | 41.73 | 5071900.0 |
| 2005-12-08 13:00:00 | QQQ | ETF | 41.72 | 41.73 | 41.54 | 41.57 | 6806100.0 |
| 2005-12-08 13:30:00 | QQQ | ETF | 41.58 | 41.64 | 41.51 | 41.57 | 5106300.0 |
| 2005-12-08 14:00:00 | QQQ | ETF | 41.57 | 41.58 | 41.35 | 41.39 | 9125400.0 |
| 2005-12-08 14:30:00 | QQQ | ETF | 41.38 | 41.42 | 41.0 | 41.39 | 10853100.0 |
| 2005-12-08 15:00:00 | QQQ | ETF | 41.39 | 41.58 | 41.38 | 41.46 | 8120900.0 |
| 2005-12-08 15:30:00 | QQQ | ETF | 41.46 | 41.59 | 41.45 | 41.56 | 10909800.0 |
| 2005-12-08 07:30:00 | IWM | ETF | 67.97 | 67.97 | 67.97 | 67.97 | 5000.0 |
| 2005-12-08 08:00:00 | IWM | ETF | 67.97 | 68.08 | 67.93 | 68.08 | 113200.0 |
| 2005-12-08 08:30:00 | IWM | ETF | 68.05 | 68.17 | 68.05 | 68.17 | 22200.0 |
| 2005-12-08 09:00:00 | IWM | ETF | 68.18 | 68.26 | 68.18 | 68.24 | 84400.0 |
| 2005-12-08 09:30:00 | IWM | ETF | 68.25 | 68.29 | 67.89 | 67.92 | 2169300.0 |
| 2005-12-08 10:00:00 | IWM | ETF | 67.92 | 68.18 | 67.91 | 68.09 | 2567400.0 |
| 2005-12-08 10:30:00 | IWM | ETF | 68.08 | 68.45 | 68.06 | 68.44 | 2471300.0 |
| 2005-12-08 11:00:00 | IWM | ETF | 68.44 | 68.72 | 68.43 | 68.68 | 6367200.0 |
| 2005-12-08 11:30:00 | IWM | ETF | 68.69 | 68.81 | 68.68 | 68.77 | 2531400.0 |
| 2005-12-08 12:00:00 | IWM | ETF | 68.76 | 68.78 | 68.64 | 68.64 | 1096700.0 |
> showing 50 of 2,021 rows — these rows as CSV