PREVIEW / stock_5min / 2014-05-21
file: by_date/stock_5min/2014/2014-05-21.parquet size: 5.3 MB rows: 355,868 symbols: 3,534
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-05-21 04:00:00 | AAPL | Stock | 21.5893 | 21.5893 | 21.5889 | 21.5889 | 11200.0 |
| 2014-05-21 05:15:00 | AAPL | Stock | 21.6 | 21.6 | 21.6 | 21.6 | 2800.0 |
| 2014-05-21 05:30:00 | AAPL | Stock | 21.6286 | 21.6286 | 21.6286 | 21.6286 | 2800.0 |
| 2014-05-21 07:00:00 | AAPL | Stock | 21.5821 | 21.5821 | 21.5786 | 21.5786 | 12236.0 |
| 2014-05-21 07:05:00 | AAPL | Stock | 21.5771 | 21.6071 | 21.575 | 21.6071 | 32060.0 |
| 2014-05-21 07:10:00 | AAPL | Stock | 21.5893 | 21.5893 | 21.5804 | 21.5821 | 25200.0 |
| 2014-05-21 07:15:00 | AAPL | Stock | 21.5964 | 21.5964 | 21.5857 | 21.5857 | 16800.0 |
| 2014-05-21 07:20:00 | AAPL | Stock | 21.5882 | 21.5893 | 21.5882 | 21.5893 | 26880.0 |
| 2014-05-21 07:25:00 | AAPL | Stock | 21.5982 | 21.5982 | 21.5982 | 21.5982 | 8400.0 |
| 2014-05-21 07:45:00 | AAPL | Stock | 21.6071 | 21.6071 | 21.6071 | 21.6071 | 8400.0 |
| 2014-05-21 07:50:00 | AAPL | Stock | 21.6139 | 21.6139 | 21.6139 | 21.6139 | 5600.0 |
| 2014-05-21 07:55:00 | AAPL | Stock | 21.6171 | 21.6179 | 21.6107 | 21.6107 | 32900.0 |
| 2014-05-21 08:00:00 | AAPL | Stock | 21.5986 | 21.6186 | 21.5539 | 21.5539 | 236208.0 |
| 2014-05-21 08:05:00 | AAPL | Stock | 21.5514 | 21.5879 | 21.5468 | 21.5861 | 51772.0 |
| 2014-05-21 08:10:00 | AAPL | Stock | 21.5732 | 21.5768 | 21.5732 | 21.5768 | 42000.0 |
| 2014-05-21 08:15:00 | AAPL | Stock | 21.5714 | 21.5804 | 21.5714 | 21.5804 | 23800.0 |
| 2014-05-21 08:20:00 | AAPL | Stock | 21.5714 | 21.5786 | 21.5643 | 21.5643 | 56980.0 |
| 2014-05-21 08:25:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5632 | 21.5632 | 104664.0 |
| 2014-05-21 08:30:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5711 | 21.5714 | 18200.0 |
| 2014-05-21 08:40:00 | AAPL | Stock | 21.5625 | 21.57 | 21.5614 | 21.57 | 51352.0 |
| 2014-05-21 08:45:00 | AAPL | Stock | 21.5643 | 21.5893 | 21.5643 | 21.5871 | 49812.0 |
| 2014-05-21 08:50:00 | AAPL | Stock | 21.5893 | 21.5975 | 21.5846 | 21.5846 | 43428.0 |
| 2014-05-21 08:55:00 | AAPL | Stock | 21.5889 | 21.5893 | 21.5889 | 21.5893 | 8400.0 |
| 2014-05-21 09:00:00 | AAPL | Stock | 21.5846 | 21.5846 | 21.5846 | 21.5846 | 5600.0 |
| 2014-05-21 09:05:00 | AAPL | Stock | 21.5757 | 21.5757 | 21.5714 | 21.5714 | 30800.0 |
| 2014-05-21 09:10:00 | AAPL | Stock | 21.5789 | 21.5804 | 21.5696 | 21.5696 | 66080.0 |
| 2014-05-21 09:15:00 | AAPL | Stock | 21.5696 | 21.5714 | 21.5632 | 21.5661 | 43960.0 |
| 2014-05-21 09:20:00 | AAPL | Stock | 21.5696 | 21.5696 | 21.5607 | 21.5607 | 54600.0 |
| 2014-05-21 09:25:00 | AAPL | Stock | 21.5714 | 21.5804 | 21.5696 | 21.5711 | 74900.0 |
| 2014-05-21 09:30:00 | AAPL | Stock | 21.5654 | 21.605 | 21.5475 | 21.5607 | 8515108.0 |
| 2014-05-21 09:35:00 | AAPL | Stock | 21.5607 | 21.5954 | 21.5379 | 21.5827 | 5515552.0 |
| 2014-05-21 09:40:00 | AAPL | Stock | 21.5825 | 21.585 | 21.5386 | 21.5661 | 4190172.0 |
| 2014-05-21 09:45:00 | AAPL | Stock | 21.5679 | 21.6218 | 21.5604 | 21.6118 | 5863872.0 |
| 2014-05-21 09:50:00 | AAPL | Stock | 21.6118 | 21.6286 | 21.6082 | 21.6116 | 5399408.0 |
| 2014-05-21 09:55:00 | AAPL | Stock | 21.6146 | 21.6168 | 21.5836 | 21.5996 | 2809240.0 |
| 2014-05-21 10:00:00 | AAPL | Stock | 21.5971 | 21.5989 | 21.5596 | 21.5684 | 4531016.0 |
| 2014-05-21 10:05:00 | AAPL | Stock | 21.5668 | 21.5743 | 21.5446 | 21.5618 | 6554240.0 |
| 2014-05-21 10:10:00 | AAPL | Stock | 21.5642 | 21.5807 | 21.5196 | 21.5204 | 3133928.0 |
| 2014-05-21 10:15:00 | AAPL | Stock | 21.52 | 21.5307 | 21.5021 | 21.5286 | 3481940.0 |
| 2014-05-21 10:20:00 | AAPL | Stock | 21.5261 | 21.5446 | 21.5143 | 21.5289 | 2276792.0 |
| 2014-05-21 10:25:00 | AAPL | Stock | 21.5307 | 21.5561 | 21.5286 | 21.5407 | 1592556.0 |
| 2014-05-21 10:30:00 | AAPL | Stock | 21.5429 | 21.5504 | 21.5246 | 21.5299 | 1701420.0 |
| 2014-05-21 10:35:00 | AAPL | Stock | 21.5336 | 21.5714 | 21.529 | 21.5636 | 3228344.0 |
| 2014-05-21 10:40:00 | AAPL | Stock | 21.5668 | 21.5946 | 21.5664 | 21.5896 | 3179232.0 |
| 2014-05-21 10:45:00 | AAPL | Stock | 21.5869 | 21.6096 | 21.5796 | 21.5821 | 2546152.0 |
| 2014-05-21 10:50:00 | AAPL | Stock | 21.5818 | 21.5868 | 21.5711 | 21.5829 | 892220.0 |
| 2014-05-21 10:55:00 | AAPL | Stock | 21.5839 | 21.5893 | 21.5679 | 21.58 | 1002176.0 |
| 2014-05-21 11:00:00 | AAPL | Stock | 21.574 | 21.5789 | 21.5464 | 21.5464 | 1945104.0 |
| 2014-05-21 11:05:00 | AAPL | Stock | 21.545 | 21.5668 | 21.5389 | 21.5589 | 3333148.0 |
| 2014-05-21 11:10:00 | AAPL | Stock | 21.5589 | 21.5696 | 21.5493 | 21.5646 | 2938292.0 |
> showing 50 of 355,868 rows — these rows as CSV