Advertisement
Guest User

Bistamp to Bitso tx top size

a guest
Apr 1st, 2019
2,087
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.49 KB | None | 0 0
  1. SELECT
  2.   CAST(t.AmountXRP / 1000000 AS INT64) AS AmountXRP,
  3.   COUNT(*) AS COUNT
  4. FROM
  5.   xrpledgerdata.fullhistory.transactions t
  6. JOIN
  7.   xrpledgerdata.fullhistory.ledgers l
  8. ON
  9.   t.LedgerIndex = l.LedgerIndex
  10. WHERE
  11.   t.Account = 'rDsbeomae4FXwgQTJp9Rs64Qg9vDiTCdBv'
  12.   AND
  13.   t.AmountXRP IS NOT NULL
  14.   AND
  15.   t.TransactionType = 'Payment'
  16.   AND
  17.   t.Destination = 'rfEu1Wnr7LxStoFx8DBdzgr8M16FBUbH3K'
  18.   AND
  19.   t.TransactionResult = 'tesSUCCESS'
  20. GROUP BY
  21.   AmountXRP
  22. ORDER BY
  23.   AmountXRP DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement