Skip to content

Instantly share code, notes, and snippets.

@WietseWind

WietseWind/query.sql

Created March 27, 2019 15:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save WietseWind/b0c0566b649b93f539a7efa4d0bd1687 to your computer and use it in GitHub Desktop.
Save WietseWind/b0c0566b649b93f539a7efa4d0bd1687 to your computer and use it in GitHub Desktop.
Download ZIP
XRPL BigQuery: Find activation date for Account
Raw
query.sql
SELECT
CloseTimeHuman
FROM
xrpledgerdata.fullhistory.ledgers
WHERE
LedgerIndex = (
SELECT
LedgerIndex
FROM
xrpledgerdata.fullhistory.transactions
WHERE
Destination = 'rPdvC6ccq8hCdPKSPJkPmyZ4Mi1oG2FFkT'
ORDER BY
LedgerIndex ASC
LIMIT 1
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment