PREVIEW / stock_30min / 2015-10-12
file: by_date/stock_30min/2015/2015-10-12.parquet size: 1.5 MB rows: 79,176 symbols: 3,389
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-12 04:00:00 | AAPL | Stock | 28.03 | 28.1225 | 28.03 | 28.1 | 30072.0 |
| 2015-10-12 04:30:00 | AAPL | Stock | 28.1 | 28.1025 | 28.1 | 28.1 | 17656.0 |
| 2015-10-12 05:00:00 | AAPL | Stock | 28.09 | 28.095 | 28.0625 | 28.0625 | 1400.0 |
| 2015-10-12 05:30:00 | AAPL | Stock | 28.0875 | 28.1625 | 28.065 | 28.1625 | 64964.0 |
| 2015-10-12 06:00:00 | AAPL | Stock | 28.1675 | 28.1675 | 28.1475 | 28.15 | 55824.0 |
| 2015-10-12 06:30:00 | AAPL | Stock | 28.15 | 28.2 | 28.15 | 28.2 | 44484.0 |
| 2015-10-12 07:00:00 | AAPL | Stock | 28.2 | 28.2375 | 28.175 | 28.195 | 190624.0 |
| 2015-10-12 07:30:00 | AAPL | Stock | 28.1775 | 28.2925 | 28.165 | 28.18 | 336336.0 |
| 2015-10-12 08:00:00 | AAPL | Stock | 28.18 | 28.25 | 28.085 | 28.1625 | 551040.0 |
| 2015-10-12 08:30:00 | AAPL | Stock | 28.1625 | 28.195 | 28.15 | 28.18 | 252196.0 |
| 2015-10-12 09:00:00 | AAPL | Stock | 28.1775 | 28.2 | 28.15 | 28.1875 | 465108.0 |
| 2015-10-12 09:30:00 | AAPL | Stock | 28.1875 | 28.1875 | 27.96 | 27.9712 | 23005384.0 |
| 2015-10-12 10:00:00 | AAPL | Stock | 27.97 | 28.0738 | 27.9325 | 28.06 | 11168948.0 |
| 2015-10-12 10:30:00 | AAPL | Stock | 28.0612 | 28.1125 | 28.0025 | 28.01 | 8479376.0 |
| 2015-10-12 11:00:00 | AAPL | Stock | 28.01 | 28.0275 | 27.9625 | 27.9825 | 7324192.0 |
| 2015-10-12 11:30:00 | AAPL | Stock | 27.9825 | 28.02 | 27.915 | 27.9525 | 7739336.0 |
| 2015-10-12 12:00:00 | AAPL | Stock | 27.9525 | 28.025 | 27.92 | 27.95 | 5175072.0 |
| 2015-10-12 12:30:00 | AAPL | Stock | 27.95 | 27.9775 | 27.86 | 27.8725 | 7339488.0 |
| 2015-10-12 13:00:00 | AAPL | Stock | 27.875 | 27.93 | 27.86 | 27.9155 | 4663120.0 |
| 2015-10-12 13:30:00 | AAPL | Stock | 27.9145 | 28.01 | 27.9145 | 27.9438 | 5188424.0 |
| 2015-10-12 14:00:00 | AAPL | Stock | 27.9425 | 27.995 | 27.9325 | 27.9692 | 3527704.0 |
| 2015-10-12 14:30:00 | AAPL | Stock | 27.97 | 27.975 | 27.9275 | 27.935 | 3989736.0 |
| 2015-10-12 15:00:00 | AAPL | Stock | 27.935 | 27.975 | 27.915 | 27.9675 | 5460560.0 |
| 2015-10-12 15:30:00 | AAPL | Stock | 27.9662 | 27.97 | 27.86 | 27.895 | 13804128.0 |
| 2015-10-12 16:00:00 | AAPL | Stock | 27.9 | 27.91 | 27.8525 | 27.9 | 4295344.0 |
| 2015-10-12 16:30:00 | AAPL | Stock | 27.9 | 27.925 | 27.8925 | 27.9 | 54240.0 |
| 2015-10-12 17:00:00 | AAPL | Stock | 27.905 | 27.91 | 27.8875 | 27.9075 | 6800.0 |
| 2015-10-12 17:30:00 | AAPL | Stock | 27.9 | 27.905 | 27.89 | 27.9 | 19912.0 |
| 2015-10-12 18:00:00 | AAPL | Stock | 27.9 | 27.91 | 27.9 | 27.91 | 12148.0 |
| 2015-10-12 18:30:00 | AAPL | Stock | 27.92 | 27.9225 | 27.9 | 27.9 | 11900.0 |
| 2015-10-12 19:00:00 | AAPL | Stock | 27.9025 | 27.905 | 27.9 | 27.905 | 3916.0 |
| 2015-10-12 19:30:00 | AAPL | Stock | 27.91 | 27.9125 | 27.905 | 27.9125 | 17180.0 |
| 2015-10-12 08:00:00 | MSFT | Stock | 46.97 | 47.13 | 46.97 | 47.11 | 1800.0 |
| 2015-10-12 08:30:00 | MSFT | Stock | 47.02 | 47.02 | 46.8 | 46.8 | 2053.0 |
| 2015-10-12 09:00:00 | MSFT | Stock | 46.99 | 47.0 | 46.95 | 46.95 | 10960.0 |
| 2015-10-12 09:30:00 | MSFT | Stock | 46.98 | 47.0 | 46.72 | 46.76 | 2559539.0 |
| 2015-10-12 10:00:00 | MSFT | Stock | 46.75 | 46.77 | 46.5 | 46.58 | 1399438.0 |
| 2015-10-12 10:30:00 | MSFT | Stock | 46.58 | 46.78 | 46.55 | 46.695 | 1034169.0 |
| 2015-10-12 11:00:00 | MSFT | Stock | 46.7 | 46.92 | 46.7 | 46.77 | 1218515.0 |
| 2015-10-12 11:30:00 | MSFT | Stock | 46.77 | 46.85 | 46.76 | 46.77 | 1121534.0 |
| 2015-10-12 12:00:00 | MSFT | Stock | 46.78 | 46.84 | 46.77 | 46.81 | 581961.0 |
| 2015-10-12 12:30:00 | MSFT | Stock | 46.81 | 46.86 | 46.74 | 46.855 | 739806.0 |
| 2015-10-12 13:00:00 | MSFT | Stock | 46.855 | 46.86 | 46.79 | 46.83 | 439239.0 |
| 2015-10-12 13:30:00 | MSFT | Stock | 46.83 | 46.84 | 46.755 | 46.77 | 579851.0 |
| 2015-10-12 14:00:00 | MSFT | Stock | 46.78 | 46.91 | 46.77 | 46.9 | 926581.0 |
| 2015-10-12 14:30:00 | MSFT | Stock | 46.9 | 47.0 | 46.89 | 46.94 | 612545.0 |
| 2015-10-12 15:00:00 | MSFT | Stock | 46.93 | 47.07 | 46.93 | 47.054 | 1110650.0 |
| 2015-10-12 15:30:00 | MSFT | Stock | 47.056 | 47.07 | 46.92 | 47.0 | 2895544.0 |
| 2015-10-12 16:00:00 | MSFT | Stock | 47.0 | 47.0 | 46.97 | 46.99 | 3657483.0 |
| 2015-10-12 16:30:00 | MSFT | Stock | 47.03 | 47.03 | 47.0 | 47.0 | 6737.0 |
> showing 50 of 79,176 rows — these rows as CSV