Pulling specific data from SteemSQL - Support request via Utopian
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: [email protected]
Discord: @anarcotech
Posted on Utopian.io - Rewarding Open Source Contributors
the post is very interesting @anarcotech
thank you for posting it is very helpful information and also very interesting to be understood and applied. thank you again sir @anarcotech
Thanks for information sir @anarcotech
I think I could do that. I already run a similar query. I use python to automate.
Bloody brilliant @geekgirl. Do you want to jump on discord and talk it through?
Hope you find one man!
Catch me on steemit.chat if you're still looking for help with this.
Thanks @blervin. Much obliged
Hi, I am sorry but your task request cannot be approved at the moment. It seems that your website code is not in the GitHub repository and as such we could not consider it as a valid open source project.
I will share your post in Discord where you could also find people interested in helping you with the query.
You can contact us on Discord.
[utopian-moderator]
fair enough. If I'd put even a basic HTML in the github, this would be accepted? Perhaps I should go back and do more than skimread the rules next time! :)