PREVIEW / etf_30min / 2010-10-11
file: by_date/etf_30min/2010/2010-10-11.parquet size: 241 KB rows: 8,367
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-11 04:00:00 | SPY | ETF | 116.61 | 116.76 | 116.61 | 116.76 | 2300.0 |
| 2010-10-11 04:30:00 | SPY | ETF | 116.79 | 116.81 | 116.79 | 116.81 | 2700.0 |
| 2010-10-11 05:00:00 | SPY | ETF | 116.77 | 116.86 | 116.77 | 116.86 | 600.0 |
| 2010-10-11 05:30:00 | SPY | ETF | 116.86 | 116.86 | 116.86 | 116.86 | 4600.0 |
| 2010-10-11 06:00:00 | SPY | ETF | 116.81 | 116.83 | 116.76 | 116.83 | 2400.0 |
| 2010-10-11 06:30:00 | SPY | ETF | 116.84 | 116.84 | 116.7 | 116.73 | 12600.0 |
| 2010-10-11 07:00:00 | SPY | ETF | 116.76 | 116.82 | 116.68 | 116.8 | 65675.0 |
| 2010-10-11 07:30:00 | SPY | ETF | 116.79 | 116.82 | 116.77 | 116.78 | 23323.0 |
| 2010-10-11 08:00:00 | SPY | ETF | 116.85 | 116.85 | 115.65 | 116.78 | 524434.0 |
| 2010-10-11 08:30:00 | SPY | ETF | 116.76 | 116.77 | 116.66 | 116.67 | 304821.0 |
| 2010-10-11 09:00:00 | SPY | ETF | 116.69 | 116.75 | 116.61 | 116.74 | 581695.0 |
| 2010-10-11 09:30:00 | SPY | ETF | 116.72 | 116.84 | 116.51 | 116.59 | 14002090.0 |
| 2010-10-11 10:00:00 | SPY | ETF | 116.59 | 116.92 | 116.59 | 116.9 | 10742818.0 |
| 2010-10-11 10:30:00 | SPY | ETF | 116.9 | 116.97 | 116.52 | 116.6 | 15227373.0 |
| 2010-10-11 11:00:00 | SPY | ETF | 116.59 | 116.73 | 116.49 | 116.69 | 5176704.0 |
| 2010-10-11 11:30:00 | SPY | ETF | 116.69 | 116.85 | 116.68 | 116.74 | 6381281.0 |
| 2010-10-11 12:00:00 | SPY | ETF | 116.745 | 116.81 | 116.6802 | 116.78 | 3632113.0 |
| 2010-10-11 12:30:00 | SPY | ETF | 116.775 | 116.89 | 116.7 | 116.78 | 3625709.0 |
| 2010-10-11 13:00:00 | SPY | ETF | 116.77 | 116.85 | 116.73 | 116.805 | 2463585.0 |
| 2010-10-11 13:30:00 | SPY | ETF | 116.81 | 116.88 | 116.76 | 116.8599 | 2657375.0 |
| 2010-10-11 14:00:00 | SPY | ETF | 116.86 | 116.87 | 116.73 | 116.81 | 4291530.0 |
| 2010-10-11 14:30:00 | SPY | ETF | 116.81 | 116.86 | 116.71 | 116.75 | 3184379.0 |
| 2010-10-11 15:00:00 | SPY | ETF | 116.75 | 116.8 | 116.53 | 116.55 | 5410636.0 |
| 2010-10-11 15:30:00 | SPY | ETF | 116.545 | 116.66 | 116.25 | 116.65 | 17299777.0 |
| 2010-10-11 16:00:00 | SPY | ETF | 116.65 | 116.825 | 116.585 | 116.7 | 2835199.0 |
| 2010-10-11 16:30:00 | SPY | ETF | 116.7 | 116.74 | 116.66 | 116.68 | 316985.0 |
| 2010-10-11 17:00:00 | SPY | ETF | 116.68 | 116.7217 | 116.66 | 116.7 | 84368.0 |
| 2010-10-11 17:30:00 | SPY | ETF | 116.71 | 116.73 | 116.7 | 116.7 | 5300.0 |
| 2010-10-11 18:00:00 | SPY | ETF | 116.68 | 116.72 | 116.65 | 116.72 | 36944.0 |
| 2010-10-11 18:30:00 | SPY | ETF | 116.69 | 116.73 | 116.68 | 116.72 | 9026.0 |
| 2010-10-11 19:00:00 | SPY | ETF | 116.71 | 116.71 | 116.61 | 116.61 | 101654.0 |
| 2010-10-11 19:30:00 | SPY | ETF | 116.59 | 116.71 | 116.59 | 116.71 | 31056.0 |
| 2010-10-11 06:00:00 | QQQ | ETF | 49.79 | 49.79 | 49.78 | 49.78 | 3000.0 |
| 2010-10-11 06:30:00 | QQQ | ETF | 49.75 | 49.75 | 49.75 | 49.75 | 200.0 |
| 2010-10-11 07:00:00 | QQQ | ETF | 49.76 | 49.81 | 49.75 | 49.81 | 35205.0 |
| 2010-10-11 07:30:00 | QQQ | ETF | 49.81 | 49.81 | 49.78 | 49.78 | 10400.0 |
| 2010-10-11 08:00:00 | QQQ | ETF | 49.79 | 49.8 | 49.77 | 49.78 | 57026.0 |
| 2010-10-11 08:30:00 | QQQ | ETF | 49.79 | 49.79 | 49.75 | 49.77 | 41211.0 |
| 2010-10-11 09:00:00 | QQQ | ETF | 49.77 | 49.78 | 49.72 | 49.78 | 205989.0 |
| 2010-10-11 09:30:00 | QQQ | ETF | 49.77 | 49.93 | 49.72 | 49.8 | 5877381.0 |
| 2010-10-11 10:00:00 | QQQ | ETF | 49.81 | 50.0 | 49.81 | 49.99 | 3877335.0 |
| 2010-10-11 10:30:00 | QQQ | ETF | 49.99 | 50.02 | 49.79 | 49.8338 | 7457728.0 |
| 2010-10-11 11:00:00 | QQQ | ETF | 49.84 | 49.9 | 49.79 | 49.86 | 3243304.0 |
| 2010-10-11 11:30:00 | QQQ | ETF | 49.87 | 49.95 | 49.8676 | 49.89 | 2423737.0 |
| 2010-10-11 12:00:00 | QQQ | ETF | 49.9 | 49.93 | 49.86 | 49.92 | 895650.0 |
| 2010-10-11 12:30:00 | QQQ | ETF | 49.92 | 49.99 | 49.895 | 49.93 | 1885580.0 |
| 2010-10-11 13:00:00 | QQQ | ETF | 49.93 | 49.96 | 49.9 | 49.95 | 768527.0 |
| 2010-10-11 13:30:00 | QQQ | ETF | 49.95 | 49.99 | 49.93 | 49.98 | 711109.0 |
| 2010-10-11 14:00:00 | QQQ | ETF | 49.98 | 49.99 | 49.91 | 49.9585 | 1068933.0 |
| 2010-10-11 14:30:00 | QQQ | ETF | 49.95 | 49.98 | 49.9 | 49.92 | 1436137.0 |
> showing 50 of 8,367 rows — these rows as CSV