Bistamp to Bitso #2 transactions

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 = 'rLSn6Z3T8uCxbcd1oxwfGQN1Fdn5CyGujK'
  AND
  TransactionResult = 'tesSUCCESS'
ORDER BY TransactionDate