PREVIEW / stock_5min / 2016-04-06
file: by_date/stock_5min/2016/2016-04-06.parquet size: 5.3 MB rows: 355,004 symbols: 3,328
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-04-06 04:25:00 | AAPL | Stock | 27.525 | 27.525 | 27.525 | 27.525 | 400.0 |
| 2016-04-06 05:05:00 | AAPL | Stock | 27.55 | 27.55 | 27.55 | 27.55 | 760.0 |
| 2016-04-06 05:30:00 | AAPL | Stock | 27.5975 | 27.5975 | 27.5975 | 27.5975 | 400.0 |
| 2016-04-06 07:00:00 | AAPL | Stock | 27.55 | 27.55 | 27.55 | 27.55 | 8000.0 |
| 2016-04-06 07:05:00 | AAPL | Stock | 27.5375 | 27.5375 | 27.5 | 27.5375 | 11516.0 |
| 2016-04-06 07:10:00 | AAPL | Stock | 27.5375 | 27.5375 | 27.515 | 27.515 | 1760.0 |
| 2016-04-06 07:15:00 | AAPL | Stock | 27.5125 | 27.5125 | 27.5025 | 27.5025 | 1200.0 |
| 2016-04-06 07:20:00 | AAPL | Stock | 27.53 | 27.53 | 27.53 | 27.53 | 400.0 |
| 2016-04-06 07:25:00 | AAPL | Stock | 27.5325 | 27.5375 | 27.5325 | 27.5375 | 20000.0 |
| 2016-04-06 07:30:00 | AAPL | Stock | 27.5625 | 27.575 | 27.5625 | 27.5625 | 5440.0 |
| 2016-04-06 07:35:00 | AAPL | Stock | 27.5625 | 27.5625 | 27.5625 | 27.5625 | 1040.0 |
| 2016-04-06 07:55:00 | AAPL | Stock | 27.5775 | 27.5825 | 27.5725 | 27.5825 | 9216.0 |
| 2016-04-06 08:00:00 | AAPL | Stock | 27.53 | 27.585 | 27.5 | 27.575 | 25216.0 |
| 2016-04-06 08:05:00 | AAPL | Stock | 27.575 | 27.6125 | 27.575 | 27.6125 | 30444.0 |
| 2016-04-06 08:10:00 | AAPL | Stock | 27.6125 | 27.6475 | 27.6125 | 27.6475 | 65636.0 |
| 2016-04-06 08:15:00 | AAPL | Stock | 27.6375 | 27.6475 | 27.6225 | 27.6275 | 69812.0 |
| 2016-04-06 08:20:00 | AAPL | Stock | 27.625 | 27.63 | 27.6125 | 27.625 | 35736.0 |
| 2016-04-06 08:25:00 | AAPL | Stock | 27.6125 | 27.635 | 27.61 | 27.635 | 10060.0 |
| 2016-04-06 08:30:00 | AAPL | Stock | 27.635 | 27.645 | 27.625 | 27.645 | 67600.0 |
| 2016-04-06 08:35:00 | AAPL | Stock | 27.645 | 27.645 | 27.6225 | 27.6225 | 13880.0 |
| 2016-04-06 08:40:00 | AAPL | Stock | 27.6225 | 27.6225 | 27.6025 | 27.605 | 15000.0 |
| 2016-04-06 08:45:00 | AAPL | Stock | 27.615 | 27.6175 | 27.59 | 27.6125 | 21100.0 |
| 2016-04-06 08:50:00 | AAPL | Stock | 27.6075 | 27.6125 | 27.6075 | 27.61 | 5400.0 |
| 2016-04-06 08:55:00 | AAPL | Stock | 27.6075 | 27.6075 | 27.6075 | 27.6075 | 2000.0 |
| 2016-04-06 09:00:00 | AAPL | Stock | 27.6175 | 27.6175 | 27.6075 | 27.6125 | 10812.0 |
| 2016-04-06 09:05:00 | AAPL | Stock | 27.615 | 27.625 | 27.6075 | 27.625 | 30928.0 |
| 2016-04-06 09:10:00 | AAPL | Stock | 27.625 | 27.6375 | 27.6125 | 27.6375 | 88440.0 |
| 2016-04-06 09:15:00 | AAPL | Stock | 27.63 | 27.6375 | 27.6125 | 27.6275 | 117440.0 |
| 2016-04-06 09:20:00 | AAPL | Stock | 27.6275 | 27.65 | 27.625 | 27.65 | 23052.0 |
| 2016-04-06 09:25:00 | AAPL | Stock | 27.6475 | 27.6575 | 27.555 | 27.5575 | 106932.0 |
| 2016-04-06 09:30:00 | AAPL | Stock | 27.5575 | 27.625 | 27.5125 | 27.5448 | 4139612.0 |
| 2016-04-06 09:35:00 | AAPL | Stock | 27.5525 | 27.575 | 27.4175 | 27.475 | 2713928.0 |
| 2016-04-06 09:40:00 | AAPL | Stock | 27.475 | 27.5125 | 27.4625 | 27.4738 | 1979752.0 |
| 2016-04-06 09:45:00 | AAPL | Stock | 27.4725 | 27.5012 | 27.4325 | 27.4962 | 2162052.0 |
| 2016-04-06 09:50:00 | AAPL | Stock | 27.495 | 27.5035 | 27.4625 | 27.4975 | 2305132.0 |
| 2016-04-06 09:55:00 | AAPL | Stock | 27.5 | 27.515 | 27.45 | 27.4698 | 1804528.0 |
| 2016-04-06 10:00:00 | AAPL | Stock | 27.4675 | 27.51 | 27.465 | 27.4805 | 1526768.0 |
| 2016-04-06 10:05:00 | AAPL | Stock | 27.4805 | 27.485 | 27.445 | 27.4562 | 1287960.0 |
| 2016-04-06 10:10:00 | AAPL | Stock | 27.455 | 27.4725 | 27.4075 | 27.415 | 1687200.0 |
| 2016-04-06 10:15:00 | AAPL | Stock | 27.4162 | 27.4525 | 27.3975 | 27.3975 | 1449848.0 |
| 2016-04-06 10:20:00 | AAPL | Stock | 27.3975 | 27.4025 | 27.36 | 27.36 | 2523108.0 |
| 2016-04-06 10:25:00 | AAPL | Stock | 27.3575 | 27.3575 | 27.3 | 27.315 | 3001656.0 |
| 2016-04-06 10:30:00 | AAPL | Stock | 27.315 | 27.385 | 27.3 | 27.38 | 2399464.0 |
| 2016-04-06 10:35:00 | AAPL | Stock | 27.3825 | 27.4175 | 27.36 | 27.3875 | 1436064.0 |
| 2016-04-06 10:40:00 | AAPL | Stock | 27.3888 | 27.4458 | 27.3875 | 27.42 | 1155564.0 |
| 2016-04-06 10:45:00 | AAPL | Stock | 27.4225 | 27.4775 | 27.4225 | 27.4375 | 1329684.0 |
| 2016-04-06 10:50:00 | AAPL | Stock | 27.4375 | 27.4575 | 27.42 | 27.445 | 992424.0 |
| 2016-04-06 10:55:00 | AAPL | Stock | 27.445 | 27.475 | 27.4402 | 27.475 | 1145712.0 |
| 2016-04-06 11:00:00 | AAPL | Stock | 27.475 | 27.475 | 27.4525 | 27.4625 | 953764.0 |
| 2016-04-06 11:05:00 | AAPL | Stock | 27.4625 | 27.475 | 27.455 | 27.475 | 1094920.0 |
> showing 50 of 355,004 rows — these rows as CSV