Mitytotal rep txs
    Updated 2023-04-21
    select count(distinct TX_HASH)as total_RepayBorrow_txs,
    case
    when CONTRACT_ADDRESS='0xc22f01ddc8010ee05574028528614634684ec29e'then 'AVAX total RepayBorrow transactions'
    when CONTRACT_ADDRESS='0x8b650e26404ac6837539ca96812f0123601e4448'then 'USDT total RepayBorrow transactions'
    when CONTRACT_ADDRESS='0x929f5cab61dfec79a5431a7734a68d714c4633fa'then 'WETH total RepayBorrow transactions'
    when CONTRACT_ADDRESS='0xed6aaf91a2b084bd594dbd1245be3691f9f637ac'then 'USDC total RepayBorrow transactions'
    when CONTRACT_ADDRESS='0x585e7bc75089ed111b656faa7aeb1104f5b96c15'then 'LINK total RepayBorrow transactions'
    when CONTRACT_ADDRESS='0xc988c170d0e38197dc634a45bf00169c7aa7ca19'then 'DAI total RepayBorrow transactions'
    when CONTRACT_ADDRESS='0x3fe38b7b610c0acd10296fef69d9b18eb7a9eb1f'then 'WBTC total RepayBorrow transactions' end as RepayBorrow_txs
    from avalanche.core.fact_event_logs
    where EVENT_NAME='RepayBorrow'
    and TX_STATUS='SUCCESS'
    and RepayBorrow_txs is not null
    group by 2




    Run a query to Download Data