select

distinct swapper as swappers,

sum(swap_from_amount) as amount

from solana.defi.ez_dex_swaps

where swap_to_mint = 'FQ1tyso61AH1tzodyJfSwmzsD3GToybbRNoZxUBz21p8'

and swap_from_mint = 'So11111111111111111111111111111111111111112'

and block_timestamp <= '2024-11-15 16:30:00.000'

group by 1

having sum(swap_from_amount) >= 0.5

),

tab2 as (

select

distinct swapper as users,

count(*) as tx_count

from solana.defi.ez_dex_swaps

where swapper in (select swappers from buyer)

and block_timestamp >= current_date - 30

group by 1),

tab_users as (select users

from tab2

where tx_count < 150

and tx_count > 10),

tab_buy as (select

distinct swapper,

sum(swap_from_amount) as buy

from solana.defi.ez_dex_swaps

where swap_from_mint = 'So11111111111111111111111111111111111111112'

and swap_to_mint = 'FQ1tyso61AH1tzodyJfSwmzsD3GToybbRNoZxUBz21p8'

and swapper in (select users from tab_users)

group by 1),

tab_sell as (select