{"action":"created","issue":{"url":"https://api.github.com/repos/liangcai2012/savant-torrey-ranch/issues/56","labels_url":"https://api.github.com/repos/liangcai2012/savant-torrey-ranch/issues/56/labels{/name}","comments_url":"https://api.github.com/repos/liangcai2012/savant-torrey-ranch/issues/56/comments","events_url":"https://api.github.com/repos/liangcai2012/savant-torrey-ranch/issues/56/events","html_url":"https://github.com/liangcai2012/savant-torrey-ranch/issues/56","id":113235223,"number":56,"title":"Create tick exception table","user":{"login":"liangcai2012","id":5770621,"avatar_url":"https://avatars.githubusercontent.com/u/5770621?v=3","gravatar_id":"","url":"https://api.github.com/users/liangcai2012","html_url":"https://github.com/liangcai2012","followers_url":"https://api.github.com/users/liangcai2012/followers","following_url":"https://api.github.com/users/liangcai2012/following{/other_user}","gists_url":"https://api.github.com/users/liangcai2012/gists{/gist_id}","starred_url":"https://api.github.com/users/liangcai2012/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/liangcai2012/subscriptions","organizations_url":"https://api.github.com/users/liangcai2012/orgs","repos_url":"https://api.github.com/users/liangcai2012/repos","events_url":"https://api.github.com/users/liangcai2012/events{/privacy}","received_events_url":"https://api.github.com/users/liangcai2012/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-25T16:33:12Z","updated_at":"2015-10-30T15:02:33Z","closed_at":null,"body":"ActiveTick contains incomplete or faulty data. Need to create a except table to exclude these tick data. One example is SPLK. The IPO data only contains a few record.  "},"comment":{"url":"https://api.github.com/repos/liangcai2012/savant-torrey-ranch/issues/comments/152549179","html_url":"https://github.com/liangcai2012/savant-torrey-ranch/issues/56#issuecomment-152549179","issue_url":"https://api.github.com/repos/liangcai2012/savant-torrey-ranch/issues/56","id":152549179,"user":{"login":"liangcai2012","id":5770621,"avatar_url":"https://avatars.githubusercontent.com/u/5770621?v=3","gravatar_id":"","url":"https://api.github.com/users/liangcai2012","html_url":"https://github.com/liangcai2012","followers_url":"https://api.github.com/users/liangcai2012/followers","following_url":"https://api.github.com/users/liangcai2012/following{/other_user}","gists_url":"https://api.github.com/users/liangcai2012/gists{/gist_id}","starred_url":"https://api.github.com/users/liangcai2012/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/liangcai2012/subscriptions","organizations_url":"https://api.github.com/users/liangcai2012/orgs","repos_url":"https://api.github.com/users/liangcai2012/repos","events_url":"https://api.github.com/users/liangcai2012/events{/privacy}","received_events_url":"https://api.github.com/users/liangcai2012/received_events","type":"User","site_admin":false},"created_at":"2015-10-30T15:02:33Z","updated_at":"2015-10-30T15:02:33Z","body":"CSOD also has strange tick data. The open price is 0.0001 "}}