flipside

    Type of activities done by users with their FRZ tokens
    negin-khType of activities done by users with their FRZ tokens
    Updated 2022-08-27
    select EVENT_NAME ,
    count (TX_HASH) as num_tx
    from ethereum.core.fact_event_logs
    where TX_HASH
    in (
    select TX_HASH
    from ethereum.core.ez_token_transfers
    where FROM_ADDRESS in ( select TO_ADDRESS as users
    from ethereum.core.ez_token_transfers
    where SYMBOL = 'FRZ'
    and ORIGIN_FUNCTION_SIGNATURE = '0x2e7ba6ef')
    and SYMBOL = 'FRZ'
    )
    group by EVENT_NAME
    order by num_tx desc
    Run a query to Download Data