Skip to content

Instantly share code, notes, and snippets.

@vgrichina

vgrichina/incoming-transactions.sql

Created April 16, 2022 23:06
Show Gist options
  • Save vgrichina/b3e95e7052d0980248b9c82ddec42367 to your computer and use it in GitHub Desktop.
Save vgrichina/b3e95e7052d0980248b9c82ddec42367 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
incoming-transactions.sql
select
to_timestamp(receipt_included_in_block_timestamp / 1000000000) as timestamp,
(args->>'deposit')::numeric / (10 ^ 24) as deposit,
receipt_predecessor_account_id
from action_receipt_actions
where receipt_receiver_account_id = 'root.near'
and receipt_predecessor_account_id != 'system'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment