PREVIEW / stock_5min / 2015-04-15
file: by_date/stock_5min/2015/2015-04-15.parquet size: 5.5 MB rows: 364,395 symbols: 3,519
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-04-15 04:50:00 | AAPL | Stock | 31.68 | 31.68 | 31.68 | 31.68 | 800.0 |
| 2015-04-15 04:55:00 | AAPL | Stock | 31.705 | 31.705 | 31.705 | 31.705 | 3908.0 |
| 2015-04-15 05:55:00 | AAPL | Stock | 31.6875 | 31.6875 | 31.6875 | 31.6875 | 4000.0 |
| 2015-04-15 06:00:00 | AAPL | Stock | 31.655 | 31.675 | 31.6525 | 31.675 | 2476.0 |
| 2015-04-15 06:05:00 | AAPL | Stock | 31.6875 | 31.6875 | 31.6875 | 31.6875 | 400.0 |
| 2015-04-15 06:25:00 | AAPL | Stock | 31.675 | 31.675 | 31.675 | 31.675 | 800.0 |
| 2015-04-15 06:30:00 | AAPL | Stock | 31.675 | 31.675 | 31.675 | 31.675 | 800.0 |
| 2015-04-15 06:35:00 | AAPL | Stock | 31.675 | 31.6875 | 31.675 | 31.6875 | 2800.0 |
| 2015-04-15 06:40:00 | AAPL | Stock | 31.6875 | 31.75 | 31.6875 | 31.72 | 27060.0 |
| 2015-04-15 06:50:00 | AAPL | Stock | 31.7025 | 31.7025 | 31.7 | 31.7 | 3836.0 |
| 2015-04-15 06:55:00 | AAPL | Stock | 31.7075 | 31.7075 | 31.7075 | 31.7075 | 2272.0 |
| 2015-04-15 07:00:00 | AAPL | Stock | 31.7075 | 31.7075 | 31.7075 | 31.7075 | 800.0 |
| 2015-04-15 07:15:00 | AAPL | Stock | 31.675 | 31.675 | 31.6525 | 31.675 | 5516.0 |
| 2015-04-15 07:20:00 | AAPL | Stock | 31.6875 | 31.6875 | 31.6875 | 31.6875 | 800.0 |
| 2015-04-15 07:30:00 | AAPL | Stock | 31.6725 | 31.6725 | 31.66 | 31.66 | 1200.0 |
| 2015-04-15 07:35:00 | AAPL | Stock | 31.6525 | 31.655 | 31.64 | 31.64 | 5160.0 |
| 2015-04-15 07:45:00 | AAPL | Stock | 31.635 | 31.635 | 31.63 | 31.635 | 4000.0 |
| 2015-04-15 07:50:00 | AAPL | Stock | 31.64 | 31.6425 | 31.64 | 31.6425 | 2000.0 |
| 2015-04-15 07:55:00 | AAPL | Stock | 31.6425 | 31.645 | 31.6425 | 31.645 | 7200.0 |
| 2015-04-15 08:00:00 | AAPL | Stock | 31.6425 | 31.6875 | 31.625 | 31.645 | 119644.0 |
| 2015-04-15 08:05:00 | AAPL | Stock | 31.65 | 31.6675 | 31.63 | 31.63 | 79152.0 |
| 2015-04-15 08:10:00 | AAPL | Stock | 31.6375 | 31.6625 | 31.6375 | 31.655 | 20436.0 |
| 2015-04-15 08:15:00 | AAPL | Stock | 31.655 | 31.655 | 31.64 | 31.6428 | 4876.0 |
| 2015-04-15 08:20:00 | AAPL | Stock | 31.645 | 31.6525 | 31.645 | 31.6475 | 10400.0 |
| 2015-04-15 08:25:00 | AAPL | Stock | 31.645 | 31.645 | 31.6325 | 31.6448 | 10816.0 |
| 2015-04-15 08:30:00 | AAPL | Stock | 31.635 | 31.635 | 31.6075 | 31.63 | 27476.0 |
| 2015-04-15 08:35:00 | AAPL | Stock | 31.6325 | 31.6375 | 31.63 | 31.6375 | 9984.0 |
| 2015-04-15 08:40:00 | AAPL | Stock | 31.6325 | 31.6428 | 31.6325 | 31.6428 | 10520.0 |
| 2015-04-15 08:45:00 | AAPL | Stock | 31.6425 | 31.645 | 31.6425 | 31.645 | 8280.0 |
| 2015-04-15 08:50:00 | AAPL | Stock | 31.6375 | 31.6575 | 31.6375 | 31.6575 | 17444.0 |
| 2015-04-15 08:55:00 | AAPL | Stock | 31.6625 | 31.675 | 31.66 | 31.66 | 25392.0 |
| 2015-04-15 09:00:00 | AAPL | Stock | 31.6675 | 31.6825 | 31.6625 | 31.6825 | 15320.0 |
| 2015-04-15 09:05:00 | AAPL | Stock | 31.6825 | 31.7 | 31.6825 | 31.6975 | 54468.0 |
| 2015-04-15 09:10:00 | AAPL | Stock | 31.695 | 31.6975 | 31.6775 | 31.6775 | 4308.0 |
| 2015-04-15 09:15:00 | AAPL | Stock | 31.69 | 31.695 | 31.6675 | 31.6675 | 29040.0 |
| 2015-04-15 09:20:00 | AAPL | Stock | 31.6775 | 31.695 | 31.6775 | 31.6925 | 29016.0 |
| 2015-04-15 09:25:00 | AAPL | Stock | 31.6975 | 31.7125 | 31.6075 | 31.6175 | 97508.0 |
| 2015-04-15 09:30:00 | AAPL | Stock | 31.6025 | 31.705 | 31.545 | 31.586 | 4681732.0 |
| 2015-04-15 09:35:00 | AAPL | Stock | 31.58 | 31.635 | 31.545 | 31.565 | 2302396.0 |
| 2015-04-15 09:40:00 | AAPL | Stock | 31.5625 | 31.5752 | 31.5275 | 31.5672 | 2253720.0 |
| 2015-04-15 09:45:00 | AAPL | Stock | 31.57 | 31.5972 | 31.5475 | 31.5625 | 1473564.0 |
| 2015-04-15 09:50:00 | AAPL | Stock | 31.565 | 31.65 | 31.5425 | 31.6288 | 3036104.0 |
| 2015-04-15 09:55:00 | AAPL | Stock | 31.63 | 31.6625 | 31.575 | 31.59 | 2313240.0 |
| 2015-04-15 10:00:00 | AAPL | Stock | 31.585 | 31.64 | 31.585 | 31.6292 | 1527956.0 |
| 2015-04-15 10:05:00 | AAPL | Stock | 31.63 | 31.635 | 31.5525 | 31.5975 | 2088256.0 |
| 2015-04-15 10:10:00 | AAPL | Stock | 31.5975 | 31.5975 | 31.565 | 31.595 | 705080.0 |
| 2015-04-15 10:15:00 | AAPL | Stock | 31.595 | 31.61 | 31.5775 | 31.5925 | 935204.0 |
| 2015-04-15 10:20:00 | AAPL | Stock | 31.595 | 31.615 | 31.59 | 31.6025 | 910884.0 |
| 2015-04-15 10:25:00 | AAPL | Stock | 31.605 | 31.6065 | 31.58 | 31.59 | 989216.0 |
| 2015-04-15 10:30:00 | AAPL | Stock | 31.59 | 31.6325 | 31.59 | 31.6075 | 1523416.0 |
> showing 50 of 364,395 rows — these rows as CSV