SELECT

block_timestamp,

post_balance.value:owner AS wallet,

post_balance.value:mint AS token,

post_balance.value:uiTokenAmount:uiAmount AS amount,

ROW_NUMBER() OVER (PARTITION BY wallet, token ORDER BY block_timestamp DESC) AS rank

FROM solana.core.fact_transactions,

LATERAL FLATTEN(input => post_token_balances) post_balance

WHERE SUCCEEDED = 'True'

AND post_balance.value:owner = wallet

AND post_balance.value:mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'

AND block_timestamp >= '2022-01-01'

ORDER BY 1,2,4

),

swap_from_dust as ( select

count(distinct(swapper)) as swappers

from solana.core.fact_swaps

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

and succeeded = True and swap_from_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'

),

swap_to_dust as ( select

count(distinct(swapper)) as swappers

from solana.core.fact_swaps

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

and succeeded = True and swap_to_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'

),

transfer_dust as ( select

count(distinct(tx_from)) as transfer

from solana.core.fact_transfers

where block_timestamp::date > '2022-01-01' and mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'

)