droider Posted August 22, 2022 Share Posted August 22, 2022 Hello. For tax purposes I'd like to find the first giveaway transactions I received back in the days. Unfortunately the ripple.com client is gone and I don't know the transaction addresses since I transferred them back then to Kraken which doesn't show the addresses of the deposit. All I know is the "date and time", "amount" and "tag". Is there a way to find these old transactions? From the old ripple.com client I got the username, password and safe key but these won't help me to recover the wallet right? (just to see the transactions) Thank you very much for your help. Regards! Link to comment Share on other sites More sharing options...
droider Posted August 22, 2022 Author Share Posted August 22, 2022 One additional question does someone know if https://id.ripple.com/auth/migrate should still work? When trying to send the form I'm always getting a 504. (gateway timeout) Link to comment Share on other sites More sharing options...
at3n Posted August 24, 2022 Share Posted August 24, 2022 On 8/22/2022 at 8:33 AM, droider said: All I know is the "date and time", "amount" and "tag". Is there a way to find these old transactions? You can use Google BigQuery, which has the full history of XRP transactions in it. It starts to cost after the first few queries, but if you've never used Google Cloud Platform before then maybe you can get free trial credits. Create a new query in the SQL Workspace and use the following as a template: SELECT datetime(TIMESTAMP_seconds(Ledgers.CloseTimeTimestamp + 946684800)) as CloseTime, format_datetime("%Y-%b-%d %H:%M:%S", Ledgers.CloseTime) as CloseTimeHuman, Transactions.Account, Transactions.Destination, Transactions.TransactionType, (CAST(Transactions.AmountXRP AS float64) / 1000000) as AmountXRP, Transactions.Fee, Transactions.TransactionResult, Transactions.Hash FROM xrpledgerdata.fullhistory.ledgers AS Ledgers INNER JOIN xrpledgerdata.fullhistory.transactions AS Transactions ON Transactions.LedgerIndex = Ledgers.LedgerIndex WHERE CloseTime BETWEEN '2020-11-30 00:00:00' AND '2020-11-30 23:59:59' AND AmountXRP = 123456789 AND DestinationTag = 123456789 AND Transactions.TransactionResult = 'tesSUCCESS' ORDER BY AmountXRP ASC; Enter your own data on the last 5 lines to search your date/time range of interest (in UTC), amount and tag. Note that AmountXRP must be written in drops (multiply the XRP amount by 1,000,000). You can also use greater than / less than signs ( > < ) if you don't know the exact amount of XRP down to the last drop. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now