Require data analyist/SQL expert to provide help pulling specific data from SteemSQL.
Ideally, someone to set up query which can be run on a daily basis. Already have a premium subscription to SteemSQL.
**Specific Requirements: **
I want to pull on a list of posts which have the following attributes into Excel Spreadsheet
- Which have a specific tag (which can be set by me)
- Posts should be under 6 days old (in other words still actively receiving rewards)
List to include: (must haves)
- URL of the post
- Username of author
- Names of curating (upvoting) accounts
List to include: (nice to have, but not critical):
- Current reward amount (sp+sbd)
- Upvote weight for each curator
- Timestamp of post submission
- All tags used on this post (including the specific one mentioned above)
Components
This information will be used to derive an algorithm for a new application.
Deadline
24 February 2018
Communication
Email: dylan@anarcotech.com
Discord: @anarcotech
Posted on Utopian.io - Rewarding Open Source Contributors