flipside

    Number of contracts per protocol
    KaskoazulNumber of contracts per protocol
    Updated 2022-03-08
    --Question 162: Based on your analysis for #161, provide the top 20 smart contract addresses that users interact with or the top 2 smart contract addresses per each of the protocols that you previously analyzed.
    --Grand prize-winning submissions will assess both!
    --Question 161: Assess the extent to which new users interact with each of the following projects. For Definition, clearly define what “interact with” means, e.g. “at least 1 transaction”, “at least 5 transactions”, etc.
    --Anchor, Mirror, Pylon, Astroport, Terraswap, Prism, Mars
    SELECT
    label as protocol,
    label_type,
    label_subtype,
    count(address) as contracts,
    address_name
    FROM
    terra.labels
    --WHERE
    --label IN ('anchor', 'mirror', 'pylon', 'astroport', 'terraswap', 'prism', 'mars')
    GROUP BY 1,2,3,5
    ORDER BY 4 desc

    Run a query to Download Data