rackhaelFRIEND.TECH - MOST ACTIVE USERS (BUYERS) By Transaction Volume - ETH
    Updated 2024-01-16
    SELECT
    from_address AS address,
    SUM(eth_value) AS total_eth_volume,
    count(tx_hash) as transactions,
    sum(tx_fee) as "fees(ETH)"
    FROM
    base.core.fact_transactions
    WHERE
    to_address = lower('0xCF205808Ed36593aa40a44F10c7f7C2F67d4A4d4')
    GROUP BY
    from_address
    ORDER BY
    total_eth_volume DESC
    LIMIT 20;

    QueryRunArchived: QueryRun has been archived