Sbhn_NPThe Percentage of Locked ETH that Unlocked Early
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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