select eth_to_address as buyer, count(eth_to_address) as purchase_count, max(block_timestamp) as last_buy

from ethereum.core.ez_eth_transfers

group by eth_to_address),

eth_seller as (

select eth_from_address as seller, count(eth_from_address) as sell_count, max(block_timestamp) as last_sell

from ethereum.core.ez_eth_transfers

where seller in (select buyer from eth_buyer)

group by seller

),

time as (

select seller, timediff('month', last_sell, last_buy) as hold_time

from eth_seller inner join eth_buyer on seller = buyer

where purchase_count > 2)

select count(seller) from time

where hold_time > 24