Skip to content

Instantly share code, notes, and snippets.

@WietseWind

WietseWind/stdsql.sql

Last active October 25, 2019 09:32
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/0cf858aeb3c24a5088f0b3e5e99896f3 to your computer and use it in GitHub Desktop.
Save WietseWind/0cf858aeb3c24a5088f0b3e5e99896f3 to your computer and use it in GitHub Desktop.
Download ZIP
XRPL BigQuery TX per ledger per time frame
Raw
stdsql.sql
SELECT
T.LedgerIndex,
COUNT(1) as TxCount,
MIN(L.CloseTime) as LedgerClosed
FROM xrpledgerdata.fullhistory.transactions as T
JOIN xrpledgerdata.fullhistory.ledgers as L ON (
L.LedgerIndex = T.LedgerIndex
)
WHERE
L.CloseTime > '2019-10-01 12:00:00'
AND
L.CloseTime < '2019-10-02 12:10:00'
GROUP BY T.LedgerIndex
ORDER BY TxCount DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment