PREVIEW / stock_5min / 2014-10-20
file: by_date/stock_5min/2014/2014-10-20.parquet size: 5.4 MB rows: 358,512 symbols: 3,563
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-20 04:00:00 | AAPL | Stock | 24.6875 | 24.7675 | 24.5375 | 24.55 | 28708.0 |
| 2014-10-20 04:05:00 | AAPL | Stock | 24.55 | 24.55 | 24.55 | 24.55 | 3800.0 |
| 2014-10-20 04:10:00 | AAPL | Stock | 24.5425 | 24.5425 | 24.5425 | 24.5425 | 1200.0 |
| 2014-10-20 04:15:00 | AAPL | Stock | 24.535 | 24.535 | 24.535 | 24.535 | 520.0 |
| 2014-10-20 04:20:00 | AAPL | Stock | 24.545 | 24.5475 | 24.5325 | 24.545 | 2796.0 |
| 2014-10-20 04:25:00 | AAPL | Stock | 24.5475 | 24.5475 | 24.5475 | 24.5475 | 400.0 |
| 2014-10-20 04:30:00 | AAPL | Stock | 24.5475 | 24.5475 | 24.5475 | 24.5475 | 400.0 |
| 2014-10-20 04:35:00 | AAPL | Stock | 24.5725 | 24.575 | 24.57 | 24.57 | 2800.0 |
| 2014-10-20 04:40:00 | AAPL | Stock | 24.5725 | 24.5725 | 24.5725 | 24.5725 | 1200.0 |
| 2014-10-20 04:45:00 | AAPL | Stock | 24.585 | 24.585 | 24.585 | 24.585 | 2000.0 |
| 2014-10-20 04:55:00 | AAPL | Stock | 24.585 | 24.5875 | 24.585 | 24.5875 | 4000.0 |
| 2014-10-20 05:00:00 | AAPL | Stock | 24.55 | 24.55 | 24.55 | 24.55 | 400.0 |
| 2014-10-20 05:05:00 | AAPL | Stock | 24.55 | 24.55 | 24.525 | 24.525 | 21540.0 |
| 2014-10-20 05:10:00 | AAPL | Stock | 24.5375 | 24.5375 | 24.5375 | 24.5375 | 1600.0 |
| 2014-10-20 05:20:00 | AAPL | Stock | 24.5625 | 24.565 | 24.5625 | 24.565 | 1600.0 |
| 2014-10-20 05:35:00 | AAPL | Stock | 24.58 | 24.58 | 24.58 | 24.58 | 400.0 |
| 2014-10-20 05:40:00 | AAPL | Stock | 24.575 | 24.575 | 24.575 | 24.575 | 400.0 |
| 2014-10-20 05:55:00 | AAPL | Stock | 24.575 | 24.575 | 24.575 | 24.575 | 2000.0 |
| 2014-10-20 06:00:00 | AAPL | Stock | 24.58 | 24.625 | 24.58 | 24.625 | 24488.0 |
| 2014-10-20 06:05:00 | AAPL | Stock | 24.615 | 24.625 | 24.6075 | 24.625 | 10408.0 |
| 2014-10-20 06:10:00 | AAPL | Stock | 24.62 | 24.625 | 24.62 | 24.625 | 1588.0 |
| 2014-10-20 06:15:00 | AAPL | Stock | 24.635 | 24.635 | 24.6075 | 24.6075 | 9732.0 |
| 2014-10-20 06:20:00 | AAPL | Stock | 24.6025 | 24.6025 | 24.6025 | 24.6025 | 1100.0 |
| 2014-10-20 06:25:00 | AAPL | Stock | 24.615 | 24.615 | 24.5875 | 24.5875 | 10000.0 |
| 2014-10-20 06:30:00 | AAPL | Stock | 24.625 | 24.6375 | 24.6 | 24.6 | 47408.0 |
| 2014-10-20 06:35:00 | AAPL | Stock | 24.6 | 24.625 | 24.6 | 24.625 | 6344.0 |
| 2014-10-20 06:45:00 | AAPL | Stock | 24.65 | 24.6625 | 24.65 | 24.65 | 33796.0 |
| 2014-10-20 06:50:00 | AAPL | Stock | 24.625 | 24.625 | 24.5875 | 24.59 | 3600.0 |
| 2014-10-20 06:55:00 | AAPL | Stock | 24.5875 | 24.5875 | 24.5875 | 24.5875 | 1200.0 |
| 2014-10-20 07:00:00 | AAPL | Stock | 24.5775 | 24.595 | 24.5675 | 24.575 | 22368.0 |
| 2014-10-20 07:05:00 | AAPL | Stock | 24.5625 | 24.5825 | 24.55 | 24.56 | 34156.0 |
| 2014-10-20 07:10:00 | AAPL | Stock | 24.565 | 24.565 | 24.5275 | 24.535 | 53320.0 |
| 2014-10-20 07:15:00 | AAPL | Stock | 24.535 | 24.5375 | 24.515 | 24.53 | 21824.0 |
| 2014-10-20 07:20:00 | AAPL | Stock | 24.5375 | 24.5875 | 24.5375 | 24.5875 | 39024.0 |
| 2014-10-20 07:25:00 | AAPL | Stock | 24.5875 | 24.5925 | 24.5375 | 24.575 | 20088.0 |
| 2014-10-20 07:30:00 | AAPL | Stock | 24.5725 | 24.625 | 24.5725 | 24.625 | 79408.0 |
| 2014-10-20 07:35:00 | AAPL | Stock | 24.6325 | 24.7 | 24.6175 | 24.6875 | 82388.0 |
| 2014-10-20 07:40:00 | AAPL | Stock | 24.7 | 24.7175 | 24.6425 | 24.6575 | 70928.0 |
| 2014-10-20 07:45:00 | AAPL | Stock | 24.6575 | 24.6575 | 24.6225 | 24.625 | 139848.0 |
| 2014-10-20 07:50:00 | AAPL | Stock | 24.62 | 24.625 | 24.5875 | 24.5875 | 53144.0 |
| 2014-10-20 07:55:00 | AAPL | Stock | 24.5825 | 24.6 | 24.5575 | 24.575 | 113636.0 |
| 2014-10-20 08:00:00 | AAPL | Stock | 24.6055 | 24.7075 | 24.5025 | 24.6 | 722296.0 |
| 2014-10-20 08:05:00 | AAPL | Stock | 24.5962 | 24.6225 | 24.595 | 24.6125 | 44368.0 |
| 2014-10-20 08:10:00 | AAPL | Stock | 24.6125 | 24.625 | 24.6 | 24.61 | 58160.0 |
| 2014-10-20 08:15:00 | AAPL | Stock | 24.61 | 24.6125 | 24.575 | 24.58 | 74564.0 |
| 2014-10-20 08:20:00 | AAPL | Stock | 24.5825 | 24.625 | 24.58 | 24.605 | 73312.0 |
| 2014-10-20 08:25:00 | AAPL | Stock | 24.605 | 24.625 | 24.605 | 24.62 | 54964.0 |
| 2014-10-20 08:30:00 | AAPL | Stock | 24.62 | 24.62 | 24.6125 | 24.6125 | 60064.0 |
| 2014-10-20 08:35:00 | AAPL | Stock | 24.6125 | 24.6225 | 24.6125 | 24.6125 | 51068.0 |
| 2014-10-20 08:40:00 | AAPL | Stock | 24.615 | 24.62 | 24.6075 | 24.615 | 27496.0 |
> showing 50 of 358,512 rows — these rows as CSV