lanoToken Transfer User copy
    Updated 2024-10-01
    -- forked from Token Transfer User @ https://flipsidecrypto.xyz/studio/queries/4b290dd6-548a-4940-a594-197d217cd746

    select mon, count(distinct origin_from_address) as cnt from (
    select * from (
    select
    date_trunc('month', block_timestamp) as mon,
    origin_from_address,
    count(distinct tx_hash) as tx_count,
    sum(coalesce(amount_usd,0)) as volume
    from ethereum.core.ez_token_transfers
    where block_timestamp > timestamp '2024-06-01'
    group by mon, origin_from_address
    )
    -- where volume > 0
    )
    group by 1


    QueryRunArchived: QueryRun has been archived