Baselight
-- Complete Transaction Count by Type (All Types)
SELECT 
    'Payment' as transaction_type,
    SUM(COALESCE(type_payment, 0)) as total_transactions,
    ROUND(AVG(COALESCE(type_payment, 0)), 0) as avg_daily_transactions,
    MAX(COALESCE(type_payment, 0)) as max_daily_transactions
FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'

UNION ALL SELECT 'OfferCreate', SUM(COALESCE(type_offercreate, 0)), ROUND(AVG(COALESCE(type_offercreate, 0)), 0), MAX(COALESCE(type_offercreate, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'TrustSet', SUM(COALESCE(type_trustset, 0)), ROUND(AVG(COALESCE(type_trustset, 0)), 0), MAX(COALESCE(type_trustset, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'OfferCancel', SUM(COALESCE(type_offercancel, 0)), ROUND(AVG(COALESCE(type_offercancel, 0)), 0), MAX(COALESCE(type_offercancel, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'NFTokenMint', SUM(COALESCE(type_nftokenmint, 0)), ROUND(AVG(COALESCE(type_nftokenmint, 0)), 0), MAX(COALESCE(type_nftokenmint, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'NFTokenAcceptOffer', SUM(COALESCE(type_nftokenacceptoffer, 0)), ROUND(AVG(COALESCE(type_nftokenacceptoffer, 0)), 0), MAX(COALESCE(type_nftokenacceptoffer, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'NFTokenCreateOffer', SUM(COALESCE(type_nftokencreateoffer, 0)), ROUND(AVG(COALESCE(type_nftokencreateoffer, 0)), 0), MAX(COALESCE(type_nftokencreateoffer, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'NFTokenCancelOffer', SUM(COALESCE(type_nftokencanceloffer, 0)), ROUND(AVG(COALESCE(type_nftokencanceloffer, 0)), 0), MAX(COALESCE(type_nftokencanceloffer, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'NFTokenBurn', SUM(COALESCE(type_nftokenburn, 0)), ROUND(AVG(COALESCE(type_nftokenburn, 0)), 0), MAX(COALESCE(type_nftokenburn, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'NFTokenModify', SUM(COALESCE(type_nftokenmodify, 0)), ROUND(AVG(COALESCE(type_nftokenmodify, 0)), 0), MAX(COALESCE(type_nftokenmodify, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'AccountSet', SUM(COALESCE(type_accountset, 0)), ROUND(AVG(COALESCE(type_accountset, 0)), 0), MAX(COALESCE(type_accountset, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'AccountDelete', SUM(COALESCE(type_accountdelete, 0)), ROUND(AVG(COALESCE(type_accountdelete, 0)), 0), MAX(COALESCE(type_accountdelete, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'AMMDeposit', SUM(COALESCE(type_ammdeposit, 0)), ROUND(AVG(COALESCE(type_ammdeposit, 0)), 0), MAX(COALESCE(type_ammdeposit, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'AMMWithdraw', SUM(COALESCE(type_ammwithdraw, 0)), ROUND(AVG(COALESCE(type_ammwithdraw, 0)), 0), MAX(COALESCE(type_ammwithdraw, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'AMMCreate', SUM(COALESCE(type_ammcreate, 0)), ROUND(AVG(COALESCE(type_ammcreate, 0)), 0), MAX(COALESCE(type_ammcreate, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'AMMDelete', SUM(COALESCE(type_ammdelete, 0)), ROUND(AVG(COALESCE(type_ammdelete, 0)), 0), MAX(COALESCE(type_ammdelete, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'AMMBid', SUM(COALESCE(type_ammbid, 0)), ROUND(AVG(COALESCE(type_ammbid, 0)), 0), MAX(COALESCE(type_ammbid, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'AMMVote', SUM(COALESCE(type_ammvote, 0)), ROUND(AVG(COALESCE(type_ammvote, 0)), 0), MAX(COALESCE(type_ammvote, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'CheckCreate', SUM(COALESCE(type_checkcreate, 0)), ROUND(AVG(COALESCE(type_checkcreate, 0)), 0), MAX(COALESCE(type_checkcreate, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'CheckCancel', SUM(COALESCE(type_checkcancel, 0)), ROUND(AVG(COALESCE(type_checkcancel, 0)), 0), MAX(COALESCE(type_checkcancel, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'CheckCash', SUM(COALESCE(type_checkcash, 0)), ROUND(AVG(COALESCE(type_checkcash, 0)), 0), MAX(COALESCE(type_checkcash, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'EscrowCreate', SUM(COALESCE(type_escrowcreate, 0)), ROUND(AVG(COALESCE(type_escrowcreate, 0)), 0), MAX(COALESCE(type_escrowcreate, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'EscrowCancel', SUM(COALESCE(type_escrowcancel, 0)), ROUND(AVG(COALESCE(type_escrowcancel, 0)), 0), MAX(COALESCE(type_escrowcancel, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'EscrowFinish', SUM(COALESCE(type_escrowfinish, 0)), ROUND(AVG(COALESCE(type_escrowfinish, 0)), 0), MAX(COALESCE(type_escrowfinish, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'PaymentChannelCreate', SUM(COALESCE(type_paymentchannelcreate, 0)), ROUND(AVG(COALESCE(type_paymentchannelcreate, 0)), 0), MAX(COALESCE(type_paymentchannelcreate, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'PaymentChannelClaim', SUM(COALESCE(type_paymentchannelclaim, 0)), ROUND(AVG(COALESCE(type_paymentchannelclaim, 0)), 0), MAX(COALESCE(type_paymentchannelclaim, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'
UNION ALL SELECT 'PaymentChannelFund', SUM(COALESCE(type_paymentchannelfund, 0)), ROUND(AVG(COALESCE(type_paymentchannelfund, 0)), 0), MAX(COALESCE(type_paymentchannelfund, 0)) FROM @xrpscan.xrp_ledger.metrics WHERE date >= '2013-01-01'

ORDER BY total_transactions DESC;
transaction_typetotal_transactionsavg_daily_transactionsmax_daily_transactions
OfferCreate24610701715365322182689
Payment11029869112404595998822
OfferCancel33627296873310615656
TrustSet129848796283081112134
NFTokenMint135841492961220761
NFTokenCreateOffer6038628131645839
AccountSet4890420106669296
NFTokenAcceptOffer312449168181780
NFTokenBurn1947535425230019
NFTokenCancelOffer12724582777654
PaymentChannelClaim92358320126409
AccountDelete73173416028717
PaymentChannelFund69777215235954
AMMDeposit6507731424951
AMMWithdraw339325746074
CheckCash119183266390
AMMVote4841211639
EscrowCreate4412910754
EscrowFinish339357965
AMMCreate308887704
CheckCreate215255515
PaymentChannelCreate161214385
CheckCancel53981370
EscrowCancel32051196
AMMBid1078068
AMMDelete1505
NFTokenModify1408

Share link

Anyone who has the link will be able to view this.