Advertisement
Guest User

Bistamp to Bitso transactions

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