select origin_from_address as claimer,

min (block_timestamp) as claim_date,

sum (AMOUNT) as volume

from ethereum.core.ez_token_transfers

where ORIGIN_TO_ADDRESS = '0x7ad4c1647aa947d1c05425a8d4d155ef811a5f9e'

and CONTRACT_ADDRESS = '0x24fcfc492c1393274b6bcd568ac9e225bec93584'

and ORIGIN_FUNCTION_SIGNATURE = '0x497de662'

and origin_from_address != '0x0000000000000000000000000000000000000000'

group by 1),

claimerscount as (select count (distinct claimer) as Total_Claimers from claimst),

sellerst as (

select from_address as sellers

from ethereum.core.ez_token_transfers t1 join claimst t2 on t1.from_address = t2.claimer and t1.block_timestamp >= t2.claim_date and datediff (day,claim_date,block_timestamp) <= 5

join ethereum.core.dim_labels t3 on t1.to_address = t3.address

where t3.label_type in ('cex','dex')

and t1.contract_address = '0x24fcfc492c1393274b6bcd568ac9e225bec93584'

and t1.amount >= t2.volume

union all

select origin_from_address as sellers

from ethereum.defi.ez_dex_swaps t1 join claimst t2 on t1.origin_from_address = t2.claimer and t1.block_timestamp >= t2.claim_date and datediff (day,claim_date,block_timestamp) <= 5

and t1.token_in = '0x24fcfc492c1393274b6bcd568ac9e225bec93584'

and t1.amount_in >= t2.volume),

sellerscount as (select count (distinct sellers) as Total_Sellers from sellerst)

select (Total_Sellers / Total_Claimers) * 100 as Percentage

from claimerscount join sellerscount