Jump to content

Technical question


shiwa
 Share

Recommended Posts

 Hello

 

hellp me

How can I find a transaction (xrp) without having a recipient and sender address and without (txid) in a certain period of time, for example, 1/1/2020 to 10101/2021?
[۱۷:۰۹, ۱۴۰۰/۹/۲۹] @li: For example, 500 xrp in the desired historical range

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Google BigQuery, for example:

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-01-01 00:00:00' AND '2021-01-01 23:59:59'
  AND AmountXRP = 500000000
  AND Transactions.TransactionResult = 'tesSUCCESS'
ORDER BY CloseTime ASC;

Modify the "WHERE" section to include your dates and amounts, and any other details you may have to narrow down the search.

Note, "AmountXRP" is in drops (x1000000).

Edited by at3n
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.