Sbhn_NPThe Percentage of Locked ETH that Unlocked Early
    Updated 2023-04-13
    with tab1 as (
    select count (DISTINCT tx_hash) as tx_count,sum (event_inputs:value/1e18) as fees1
    from ethereum.core.fact_event_logs
    where origin_to_address ='0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0'
    and origin_function_signature ='0xbe5021ec'
    and event_inputs:to = origin_from_address
    and event_name ='Transfer'
    ),

    tab2 as (
    select count (DISTINCT tx_hash) as tx_count,sum (event_inputs:value/1e18) as fees2
    from ethereum.core.fact_event_logs
    where origin_to_address ='0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0'
    and origin_function_signature ='0x0f221cab'
    and event_inputs:from = origin_from_address
    and event_name ='Transfer'
    )

    select (fees1/fees2)*100 as fees
    from tab1,tab2
    Run a query to Download Data