Skip to content

Instantly share code, notes, and snippets.

@Netherdrake
Created February 25, 2017 17:21
Show Gist options
  • Save Netherdrake/a844ebf771c96929bee8ddb446d1cfa6 to your computer and use it in GitHub Desktop.
Save Netherdrake/a844ebf771c96929bee8ddb446d1cfa6 to your computer and use it in GitHub Desktop.
SteemData Sample Queries
// lets see whats in block 9508058
db.getCollection('Operations').find({'block_num': 9508058})
// operation types
db.getCollection('Operations').distinct('type', {})
// find latest payments to poloniex
db.getCollection('Operations').find({type: 'transfer', to: 'poloniex'}).sort({timestamp:-1})
// its me :)
db.getCollection('Accounts').find({'name':'furion'})
// highest paid post of all time
db.getCollection('Posts').find().sort({'total_payout_reward.amount': -1}).limit(1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment