Guest User

Bitstamp to Bitso Ripple tx size

a guest
Apr 1st, 2019
196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.53 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.DestinationTag = 25490962
  20.   AND
  21.   t.TransactionResult = 'tesSUCCESS'
  22. GROUP BY
  23.   AmountXRP
  24. ORDER BY
  25.   COUNT DESC
Add Comment
Please, Sign In to add comment