lanoToken Transfer User
    Updated 2024-10-01
    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 kaia.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