PREVIEW / stock_5min / 2015-09-30
file: by_date/stock_5min/2015/2015-09-30.parquet size: 5.5 MB rows: 370,050 symbols: 3,460
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-09-30 04:00:00 | AAPL | Stock | 27.5 | 27.575 | 27.5 | 27.575 | 9200.0 |
| 2015-09-30 04:05:00 | AAPL | Stock | 27.5625 | 27.5625 | 27.5625 | 27.5625 | 1600.0 |
| 2015-09-30 04:10:00 | AAPL | Stock | 27.5625 | 27.5625 | 27.5625 | 27.5625 | 1200.0 |
| 2015-09-30 04:20:00 | AAPL | Stock | 27.565 | 27.565 | 27.5625 | 27.5625 | 1748.0 |
| 2015-09-30 04:25:00 | AAPL | Stock | 27.565 | 27.615 | 27.565 | 27.615 | 2000.0 |
| 2015-09-30 04:35:00 | AAPL | Stock | 27.62 | 27.62 | 27.5875 | 27.5875 | 16400.0 |
| 2015-09-30 04:45:00 | AAPL | Stock | 27.5925 | 27.61 | 27.5925 | 27.61 | 800.0 |
| 2015-09-30 04:50:00 | AAPL | Stock | 27.5925 | 27.61 | 27.5875 | 27.61 | 1200.0 |
| 2015-09-30 04:55:00 | AAPL | Stock | 27.6125 | 27.6125 | 27.5925 | 27.5925 | 4796.0 |
| 2015-09-30 05:00:00 | AAPL | Stock | 27.5925 | 27.62 | 27.5925 | 27.5925 | 14800.0 |
| 2015-09-30 05:05:00 | AAPL | Stock | 27.5925 | 27.5925 | 27.5925 | 27.5925 | 28264.0 |
| 2015-09-30 05:10:00 | AAPL | Stock | 27.6225 | 27.6225 | 27.5925 | 27.5925 | 16816.0 |
| 2015-09-30 05:15:00 | AAPL | Stock | 27.5925 | 27.6225 | 27.5925 | 27.5925 | 63536.0 |
| 2015-09-30 05:20:00 | AAPL | Stock | 27.5925 | 27.5925 | 27.59 | 27.59 | 2800.0 |
| 2015-09-30 05:25:00 | AAPL | Stock | 27.5925 | 27.5925 | 27.5725 | 27.5825 | 12836.0 |
| 2015-09-30 05:30:00 | AAPL | Stock | 27.57 | 27.57 | 27.525 | 27.56 | 3712.0 |
| 2015-09-30 05:35:00 | AAPL | Stock | 27.5625 | 27.5625 | 27.5625 | 27.5625 | 1652.0 |
| 2015-09-30 05:40:00 | AAPL | Stock | 27.555 | 27.56 | 27.555 | 27.56 | 2460.0 |
| 2015-09-30 05:45:00 | AAPL | Stock | 27.5575 | 27.57 | 27.5575 | 27.57 | 12860.0 |
| 2015-09-30 05:50:00 | AAPL | Stock | 27.59 | 27.59 | 27.59 | 27.59 | 1440.0 |
| 2015-09-30 05:55:00 | AAPL | Stock | 27.58 | 27.5925 | 27.58 | 27.5925 | 6000.0 |
| 2015-09-30 06:00:00 | AAPL | Stock | 27.59 | 27.59 | 27.5625 | 27.5625 | 9820.0 |
| 2015-09-30 06:05:00 | AAPL | Stock | 27.58 | 27.58 | 27.58 | 27.58 | 800.0 |
| 2015-09-30 06:10:00 | AAPL | Stock | 27.58 | 27.5825 | 27.58 | 27.5825 | 3600.0 |
| 2015-09-30 06:15:00 | AAPL | Stock | 27.5825 | 27.5875 | 27.575 | 27.5875 | 6348.0 |
| 2015-09-30 06:20:00 | AAPL | Stock | 27.575 | 27.5925 | 27.5725 | 27.5925 | 22988.0 |
| 2015-09-30 06:25:00 | AAPL | Stock | 27.575 | 27.575 | 27.575 | 27.575 | 3616.0 |
| 2015-09-30 06:30:00 | AAPL | Stock | 27.575 | 27.575 | 27.5725 | 27.575 | 4240.0 |
| 2015-09-30 06:35:00 | AAPL | Stock | 27.5875 | 27.5875 | 27.5875 | 27.5875 | 2600.0 |
| 2015-09-30 06:40:00 | AAPL | Stock | 27.5925 | 27.5925 | 27.585 | 27.5925 | 18800.0 |
| 2015-09-30 06:45:00 | AAPL | Stock | 27.59 | 27.5925 | 27.59 | 27.5925 | 6800.0 |
| 2015-09-30 06:50:00 | AAPL | Stock | 27.5925 | 27.5975 | 27.5925 | 27.5975 | 8600.0 |
| 2015-09-30 06:55:00 | AAPL | Stock | 27.5875 | 27.5875 | 27.5825 | 27.5825 | 14800.0 |
| 2015-09-30 07:00:00 | AAPL | Stock | 27.575 | 27.58 | 27.53 | 27.54 | 51272.0 |
| 2015-09-30 07:05:00 | AAPL | Stock | 27.54 | 27.5425 | 27.505 | 27.5125 | 74920.0 |
| 2015-09-30 07:10:00 | AAPL | Stock | 27.51 | 27.5475 | 27.5 | 27.545 | 48692.0 |
| 2015-09-30 07:15:00 | AAPL | Stock | 27.54 | 27.555 | 27.51 | 27.525 | 30624.0 |
| 2015-09-30 07:20:00 | AAPL | Stock | 27.515 | 27.545 | 27.515 | 27.5275 | 13400.0 |
| 2015-09-30 07:25:00 | AAPL | Stock | 27.5425 | 27.5625 | 27.5425 | 27.5625 | 7000.0 |
| 2015-09-30 07:30:00 | AAPL | Stock | 27.56 | 27.5625 | 27.5425 | 27.5625 | 38664.0 |
| 2015-09-30 07:35:00 | AAPL | Stock | 27.5625 | 27.5675 | 27.48 | 27.48 | 63816.0 |
| 2015-09-30 07:40:00 | AAPL | Stock | 27.495 | 27.515 | 27.4825 | 27.505 | 23860.0 |
| 2015-09-30 07:45:00 | AAPL | Stock | 27.4975 | 27.5275 | 27.4975 | 27.5125 | 12680.0 |
| 2015-09-30 07:50:00 | AAPL | Stock | 27.52 | 27.5375 | 27.495 | 27.5275 | 28064.0 |
| 2015-09-30 07:55:00 | AAPL | Stock | 27.525 | 27.595 | 27.52 | 27.5825 | 88136.0 |
| 2015-09-30 08:00:00 | AAPL | Stock | 27.5825 | 27.625 | 27.485 | 27.61 | 392792.0 |
| 2015-09-30 08:05:00 | AAPL | Stock | 27.6075 | 27.625 | 27.5825 | 27.5875 | 102592.0 |
| 2015-09-30 08:10:00 | AAPL | Stock | 27.5975 | 27.6 | 27.575 | 27.5975 | 56820.0 |
| 2015-09-30 08:15:00 | AAPL | Stock | 27.5875 | 27.64 | 27.5875 | 27.64 | 134428.0 |
| 2015-09-30 08:20:00 | AAPL | Stock | 27.64 | 27.6575 | 27.6125 | 27.635 | 128772.0 |
> showing 50 of 370,050 rows — these rows as CSV