select

x.purchaser

--count(distinct tx_id) as buys

from solana.core.fact_nft_sales x

join solana.core.dim_nft_metadata y on x.mint = y.mint and y.contract_name = 'DeGods'

where block_timestamp >= '2022-01-01'

and marketplace like '%magic eden%'

trunc(block_timestamp,'day') as date,

count(distinct swapper) as users,

count(distinct tx_id) as swaps,

sum(swap_to_amount) as volume

from solana.core.fact_swaps

where block_timestamp::date >= '2022-01-01'

and swap_program = 'jupiter aggregator v2'

and succeeded = 'True'

and swap_to_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'

and swap_to_amount >0

and swapper in (

select

purchaser

from degods

)

group by 1

order by 1 asc