Technical question

[shiwa]

 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

[at3n]

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 December 22, 2021 by at3n