PREVIEW / stock_30min / 2015-05-13
file: by_date/stock_30min/2015/2015-05-13.parquet size: 1.6 MB rows: 82,634 symbols: 3,489
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-05-13 04:00:00 | AAPL | Stock | 31.625 | 31.65 | 31.6025 | 31.6025 | 4460.0 |
| 2015-05-13 05:00:00 | AAPL | Stock | 31.54 | 31.6425 | 31.54 | 31.64 | 15520.0 |
| 2015-05-13 05:30:00 | AAPL | Stock | 31.625 | 31.625 | 31.6075 | 31.62 | 19376.0 |
| 2015-05-13 06:00:00 | AAPL | Stock | 31.6125 | 31.6125 | 31.5675 | 31.5675 | 6864.0 |
| 2015-05-13 06:30:00 | AAPL | Stock | 31.585 | 31.6 | 31.5375 | 31.5375 | 43312.0 |
| 2015-05-13 07:00:00 | AAPL | Stock | 31.5375 | 31.5475 | 31.4975 | 31.53 | 95936.0 |
| 2015-05-13 07:30:00 | AAPL | Stock | 31.5175 | 31.5625 | 31.5 | 31.5625 | 52452.0 |
| 2015-05-13 08:00:00 | AAPL | Stock | 31.5625 | 31.5975 | 31.5025 | 31.545 | 294916.0 |
| 2015-05-13 08:30:00 | AAPL | Stock | 31.5575 | 31.565 | 31.5 | 31.5425 | 305500.0 |
| 2015-05-13 09:00:00 | AAPL | Stock | 31.55 | 31.5825 | 31.495 | 31.5825 | 614380.0 |
| 2015-05-13 09:30:00 | AAPL | Stock | 31.5375 | 31.7975 | 31.5025 | 31.6922 | 24616520.0 |
| 2015-05-13 10:00:00 | AAPL | Stock | 31.69 | 31.74 | 31.6275 | 31.6525 | 11746652.0 |
| 2015-05-13 10:30:00 | AAPL | Stock | 31.6525 | 31.69 | 31.5925 | 31.62 | 10298764.0 |
| 2015-05-13 11:00:00 | AAPL | Stock | 31.6225 | 31.6582 | 31.5675 | 31.61 | 8585772.0 |
| 2015-05-13 11:30:00 | AAPL | Stock | 31.6088 | 31.68 | 31.575 | 31.6515 | 5783468.0 |
| 2015-05-13 12:00:00 | AAPL | Stock | 31.6525 | 31.6725 | 31.545 | 31.565 | 4681064.0 |
| 2015-05-13 12:30:00 | AAPL | Stock | 31.565 | 31.6475 | 31.535 | 31.605 | 5103300.0 |
| 2015-05-13 13:00:00 | AAPL | Stock | 31.605 | 31.6875 | 31.6 | 31.6638 | 5353576.0 |
| 2015-05-13 13:30:00 | AAPL | Stock | 31.665 | 31.7 | 31.6275 | 31.6858 | 5028584.0 |
| 2015-05-13 14:00:00 | AAPL | Stock | 31.6875 | 31.7025 | 31.565 | 31.5875 | 6973872.0 |
| 2015-05-13 14:30:00 | AAPL | Stock | 31.585 | 31.6225 | 31.5525 | 31.5788 | 5821552.0 |
| 2015-05-13 15:00:00 | AAPL | Stock | 31.5788 | 31.5925 | 31.5125 | 31.5362 | 8595420.0 |
| 2015-05-13 15:30:00 | AAPL | Stock | 31.535 | 31.5475 | 31.4675 | 31.5 | 13495492.0 |
| 2015-05-13 16:00:00 | AAPL | Stock | 31.5025 | 31.505 | 31.475 | 31.495 | 4640668.0 |
| 2015-05-13 16:30:00 | AAPL | Stock | 31.495 | 31.5125 | 31.495 | 31.5025 | 802048.0 |
| 2015-05-13 17:00:00 | AAPL | Stock | 31.505 | 31.5125 | 31.5 | 31.505 | 21608.0 |
| 2015-05-13 17:30:00 | AAPL | Stock | 31.5048 | 31.5075 | 31.495 | 31.5075 | 72364.0 |
| 2015-05-13 18:00:00 | AAPL | Stock | 31.495 | 31.525 | 31.475 | 31.5198 | 78324.0 |
| 2015-05-13 18:30:00 | AAPL | Stock | 31.5125 | 31.5175 | 31.505 | 31.505 | 38540.0 |
| 2015-05-13 19:00:00 | AAPL | Stock | 31.5 | 31.5125 | 31.4975 | 31.5 | 30492.0 |
| 2015-05-13 19:30:00 | AAPL | Stock | 31.5125 | 31.5125 | 31.4625 | 31.4925 | 81044.0 |
| 2015-05-13 05:00:00 | MSFT | Stock | 47.7 | 47.92 | 47.7 | 47.9 | 41625.0 |
| 2015-05-13 05:30:00 | MSFT | Stock | 47.94 | 48.0 | 47.86 | 47.92 | 26631.0 |
| 2015-05-13 06:00:00 | MSFT | Stock | 47.99 | 47.99 | 47.91 | 47.91 | 12379.0 |
| 2015-05-13 06:30:00 | MSFT | Stock | 47.87 | 48.02 | 47.87 | 48.02 | 23642.0 |
| 2015-05-13 07:00:00 | MSFT | Stock | 47.97 | 48.06 | 47.97 | 48.01 | 17891.0 |
| 2015-05-13 07:30:00 | MSFT | Stock | 48.01 | 48.1 | 48.0 | 48.1 | 15299.0 |
| 2015-05-13 08:00:00 | MSFT | Stock | 48.02 | 48.07 | 47.96 | 47.96 | 56524.0 |
| 2015-05-13 08:30:00 | MSFT | Stock | 47.92 | 47.99 | 47.88 | 47.97 | 21315.0 |
| 2015-05-13 09:00:00 | MSFT | Stock | 47.99 | 48.2 | 47.88 | 48.2 | 134797.0 |
| 2015-05-13 09:30:00 | MSFT | Stock | 48.16 | 48.32 | 48.04 | 48.08 | 6195753.0 |
| 2015-05-13 10:00:00 | MSFT | Stock | 48.08 | 48.23 | 48.04 | 48.16 | 2407910.0 |
| 2015-05-13 10:30:00 | MSFT | Stock | 48.16 | 48.17 | 47.84 | 47.95 | 3748830.0 |
| 2015-05-13 11:00:00 | MSFT | Stock | 47.95 | 48.03 | 47.85 | 47.915 | 2417203.0 |
| 2015-05-13 11:30:00 | MSFT | Stock | 47.91 | 48.07 | 47.84 | 47.98 | 1261641.0 |
| 2015-05-13 12:00:00 | MSFT | Stock | 47.98 | 48.01 | 47.87 | 47.875 | 981461.0 |
| 2015-05-13 12:30:00 | MSFT | Stock | 47.87 | 47.89 | 47.82 | 47.855 | 1170876.0 |
| 2015-05-13 13:00:00 | MSFT | Stock | 47.85 | 48.01 | 47.85 | 47.94 | 1331479.0 |
| 2015-05-13 13:30:00 | MSFT | Stock | 47.94 | 47.99 | 47.94 | 47.96 | 746924.0 |
| 2015-05-13 14:00:00 | MSFT | Stock | 47.96 | 47.98 | 47.7 | 47.745 | 1317071.0 |
> showing 50 of 82,634 rows — these rows as CSV