Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- CAST(AmountXRP AS FLOAT64) / 1000000 AS XRP,
- DestinationTag,
- EXTRACT(DATE FROM l.CloseTime) AS TransactionDate
- FROM
- xrpledgerdata.fullhistory.transactions t
- JOIN
- xrpledgerdata.fullhistory.ledgers l
- ON
- t.LedgerIndex = l.LedgerIndex
- WHERE
- Account = 'rDsbeomae4FXwgQTJp9Rs64Qg9vDiTCdBv'
- AND
- AmountXRP IS NOT NULL
- AND
- TransactionType = 'Payment'
- AND
- Destination = 'rfEu1Wnr7LxStoFx8DBdzgr8M16FBUbH3K'
- AND
- TransactionResult = 'tesSUCCESS'
- ORDER BY TransactionDate
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement