PREVIEW / stock_5min / 2016-11-07
file: by_date/stock_5min/2016/2016-11-07.parquet size: 5.3 MB rows: 349,650 symbols: 3,165
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 |
|---|---|---|---|---|---|---|---|
| 2016-11-07 04:00:00 | AAPL | Stock | 27.6625 | 27.6625 | 27.6 | 27.6 | 3760.0 |
| 2016-11-07 04:05:00 | AAPL | Stock | 27.6 | 27.6 | 27.6 | 27.6 | 3200.0 |
| 2016-11-07 04:15:00 | AAPL | Stock | 27.5875 | 27.6125 | 27.5875 | 27.6125 | 1200.0 |
| 2016-11-07 04:25:00 | AAPL | Stock | 27.665 | 27.7025 | 27.65 | 27.7025 | 1660.0 |
| 2016-11-07 04:40:00 | AAPL | Stock | 27.6975 | 27.6975 | 27.6975 | 27.6975 | 800.0 |
| 2016-11-07 04:45:00 | AAPL | Stock | 27.67 | 27.67 | 27.67 | 27.67 | 400.0 |
| 2016-11-07 04:50:00 | AAPL | Stock | 27.66 | 27.66 | 27.66 | 27.66 | 1900.0 |
| 2016-11-07 04:55:00 | AAPL | Stock | 27.67 | 27.67 | 27.6675 | 27.6675 | 1784.0 |
| 2016-11-07 05:00:00 | AAPL | Stock | 27.665 | 27.665 | 27.665 | 27.665 | 400.0 |
| 2016-11-07 05:10:00 | AAPL | Stock | 27.625 | 27.625 | 27.625 | 27.625 | 5512.0 |
| 2016-11-07 05:15:00 | AAPL | Stock | 27.6575 | 27.6575 | 27.6575 | 27.6575 | 400.0 |
| 2016-11-07 05:20:00 | AAPL | Stock | 27.625 | 27.625 | 27.625 | 27.625 | 400.0 |
| 2016-11-07 05:35:00 | AAPL | Stock | 27.6275 | 27.6375 | 27.625 | 27.6375 | 4400.0 |
| 2016-11-07 05:40:00 | AAPL | Stock | 27.63 | 27.63 | 27.6275 | 27.6275 | 1200.0 |
| 2016-11-07 05:45:00 | AAPL | Stock | 27.6275 | 27.6275 | 27.6275 | 27.6275 | 1200.0 |
| 2016-11-07 05:50:00 | AAPL | Stock | 27.625 | 27.625 | 27.615 | 27.615 | 5080.0 |
| 2016-11-07 06:00:00 | AAPL | Stock | 27.635 | 27.6375 | 27.61 | 27.6375 | 3056.0 |
| 2016-11-07 06:05:00 | AAPL | Stock | 27.625 | 27.625 | 27.625 | 27.625 | 800.0 |
| 2016-11-07 06:15:00 | AAPL | Stock | 27.625 | 27.625 | 27.6025 | 27.6025 | 14864.0 |
| 2016-11-07 06:35:00 | AAPL | Stock | 27.605 | 27.6075 | 27.605 | 27.6075 | 1900.0 |
| 2016-11-07 06:40:00 | AAPL | Stock | 27.6075 | 27.6075 | 27.6 | 27.6 | 2976.0 |
| 2016-11-07 06:45:00 | AAPL | Stock | 27.5625 | 27.5625 | 27.54 | 27.54 | 7280.0 |
| 2016-11-07 06:50:00 | AAPL | Stock | 27.55 | 27.595 | 27.55 | 27.5925 | 9760.0 |
| 2016-11-07 07:00:00 | AAPL | Stock | 27.5875 | 27.5875 | 27.575 | 27.575 | 19960.0 |
| 2016-11-07 07:05:00 | AAPL | Stock | 27.5825 | 27.5825 | 27.58 | 27.5825 | 3008.0 |
| 2016-11-07 07:10:00 | AAPL | Stock | 27.5725 | 27.5725 | 27.5675 | 27.5725 | 16116.0 |
| 2016-11-07 07:15:00 | AAPL | Stock | 27.57 | 27.57 | 27.55 | 27.55 | 10600.0 |
| 2016-11-07 07:20:00 | AAPL | Stock | 27.5575 | 27.56 | 27.545 | 27.545 | 5080.0 |
| 2016-11-07 07:25:00 | AAPL | Stock | 27.55 | 27.55 | 27.545 | 27.55 | 11240.0 |
| 2016-11-07 07:30:00 | AAPL | Stock | 27.55 | 27.5675 | 27.5375 | 27.5675 | 12420.0 |
| 2016-11-07 07:35:00 | AAPL | Stock | 27.545 | 27.5525 | 27.54 | 27.5525 | 5200.0 |
| 2016-11-07 07:40:00 | AAPL | Stock | 27.5525 | 27.5675 | 27.5525 | 27.5525 | 6104.0 |
| 2016-11-07 07:45:00 | AAPL | Stock | 27.55 | 27.5625 | 27.545 | 27.55 | 8400.0 |
| 2016-11-07 07:55:00 | AAPL | Stock | 27.5575 | 27.5625 | 27.5575 | 27.5625 | 9600.0 |
| 2016-11-07 08:00:00 | AAPL | Stock | 27.57 | 27.6075 | 27.5375 | 27.5625 | 82120.0 |
| 2016-11-07 08:05:00 | AAPL | Stock | 27.5625 | 27.5625 | 27.55 | 27.555 | 39008.0 |
| 2016-11-07 08:10:00 | AAPL | Stock | 27.5625 | 27.5625 | 27.54 | 27.54 | 28260.0 |
| 2016-11-07 08:15:00 | AAPL | Stock | 27.55 | 27.55 | 27.535 | 27.535 | 26908.0 |
| 2016-11-07 08:20:00 | AAPL | Stock | 27.5425 | 27.5525 | 27.5375 | 27.5375 | 25512.0 |
| 2016-11-07 08:25:00 | AAPL | Stock | 27.535 | 27.5375 | 27.53 | 27.53 | 14280.0 |
| 2016-11-07 08:30:00 | AAPL | Stock | 27.535 | 27.5375 | 27.525 | 27.525 | 28056.0 |
| 2016-11-07 08:35:00 | AAPL | Stock | 27.5275 | 27.5275 | 27.5 | 27.5025 | 27976.0 |
| 2016-11-07 08:40:00 | AAPL | Stock | 27.5025 | 27.5125 | 27.4975 | 27.4975 | 78736.0 |
| 2016-11-07 08:45:00 | AAPL | Stock | 27.5075 | 27.5075 | 27.48 | 27.48 | 25504.0 |
| 2016-11-07 08:50:00 | AAPL | Stock | 27.475 | 27.48 | 27.475 | 27.48 | 29464.0 |
| 2016-11-07 08:55:00 | AAPL | Stock | 27.4775 | 27.48 | 27.47 | 27.4775 | 47396.0 |
| 2016-11-07 09:00:00 | AAPL | Stock | 27.49 | 27.525 | 27.49 | 27.525 | 46784.0 |
| 2016-11-07 09:05:00 | AAPL | Stock | 27.525 | 27.55 | 27.525 | 27.535 | 95972.0 |
| 2016-11-07 09:10:00 | AAPL | Stock | 27.53 | 27.535 | 27.49 | 27.49 | 103000.0 |
| 2016-11-07 09:15:00 | AAPL | Stock | 27.515 | 27.5175 | 27.5 | 27.5 | 15236.0 |
> showing 50 of 349,650 rows — these rows as CSV