Google BigQuery, Top 5 Transactions / Account

check-max-ledger-sync-state.sql

SELECT 
  COUNT(1) as TxCount,
  MIN(LedgerIndex) as MinLedger,
  MAX(LedgerIndex) as MaxLedger,
  COUNT(DISTINCT LedgerIndex) as LedgersWithTxCount
FROM 
  xrpledgerdata.fullhistory.transactions

top5-xrpl-payment-accounts-query.sql

SELECT 
  STRING_AGG(DISTINCT TransactionType) as TransactionType,
  Account,
  COUNT(Destination) as TxCount,
  SUM(AmountXRP) as SumXRPDrops,
  SUM(Fee) as SumFeeDrops,
  MIN(LedgerIndex) as AccMinLedger,
  MAX(LedgerIndex) as AccMaxLedger
FROM 
  xrpledgerdata.fullhistory.transactions 
WHERE 
  AmountXRP IS NOT NULL
  AND 
  TransactionType = 'Payment'
GROUP BY
  Account
ORDER BY 
  COUNT(Destination) DESC
LIMIT 5