select distinct tx_to as address, * from

solana.core.fact_transfers

where tx_from in (

'9AhKqLR67hwapvG8SA2JFXaCshXc9nALJjpKaHZrsbkw',

'6JZoszTBzkGsskbheswiS6z2LRGckyFY4SpEGiLZqA9p')

and mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

and block_timestamp >= '2022-12-24'

),

transfers_from as (

select

date_trunc('day',block_timestamp) as date,

tx_id,

tx.tx_from as address,

sum(tx.amount) * -1 as n_tokens

from solana.core.fact_transfers tx

where tx.block_timestamp >= '2022-12-24'

and tx.mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

and address not in (

'9AhKqLR67hwapvG8SA2JFXaCshXc9nALJjpKaHZrsbkw', -- 'bonk airdrop address'

'6JZoszTBzkGsskbheswiS6z2LRGckyFY4SpEGiLZqA9p', -- 'bonk new airdrop address'

'BqnpCdDLPV2pFdAaLnVidmn3G93RP2p5oRdGEY2sJGez', -- 'orca bonk-sol pool'

'5P6n5omLbLbP4kaPGL8etqQAHEx2UCkaUyvjLDnwV4EY', -- 'orca bonk-usdc pool'

'2PFvRYt5h88ePdQXBrH3dyFmQqJHTNZYLztE847dHWYz', -- 'dex bonk-usdc pool'

'DBR2ZUvjZTcgy6R9US64t96pBEZMyr9DPW6G2scrctQK', -- 'bonk dao wallet'

'4CUMsJG7neKqZuuLeoBoMuqufaNBc2wdwQiXnoH4aJcD', -- 'bonk team wallet'

'2yBBKgCwGdVpo192D8WZeAtqyhyP8DkCMnmTLeVYfKtA' -- 'bonk marketing wallet'

)

group by 1,2,3

),

transfers_to as (

select

date_trunc('day',block_timestamp) as date,

tx_id,

tx.tx_to as address,

sum(tx.amount) as n_tokens