KARTODCelsius wallet
    Updated 2022-06-13
    SELECT
    Address AS "Address",
    COUNT(F.TX_HASH) AS "Send transactions",
    COUNT(T.TX_HASH) AS "Received transactions",
    "Send transactions" + "Received transactions" AS "Total transactions"
    FROM flipside_prod_db.crosschain.address_labels L
    LEFT JOIN ethereum.core.fact_transactions F ON Address = F.FROM_ADDRESS
    LEFT JOIN ethereum.core.fact_transactions T ON Address = T.TO_ADDRESS
    WHERE L.ADDRESS_NAME = 'celsius wallet'
    GROUP BY 1
    ORDER BY "Total transactions" DESC
    Run a query to Download Data