flipside

    FRIEND.TECH - MOST ACTIVE USERS (BUYERS) By Transaction Count
    rackhaelFRIEND.TECH - MOST ACTIVE USERS (BUYERS) By Transaction Count
    Updated 2023-09-15
    SELECT
    from_address AS buyers,
    count(tx_hash) AS num_transactions
    FROM
    base.core.fact_transactions
    WHERE
    to_address = lower('0xCF205808Ed36593aa40a44F10c7f7C2F67d4A4d4')
    GROUP BY
    1
    ORDER BY
    num_transactions DESC
    LIMIT 20;