zakkisyedAnalyse
    Updated 2023-05-23
    with event_logs as (
    select * from ethereum.core.fact_event_logs
    where origin_function_signature = '0x23b872dd'
    and contract_address = '0x8dbf9a4c99580fc7fd4024ee08f3994420035727'
    )

    select distinct event_name, count(*) from ethereum.core.fact_decoded_event_logs as t2
    left join event_logs as t1
    on t1.tx_hash=t2.tx_hash

    group by 1
    Run a query to Download Data