select

a.TX_ID,

b.block_timestamp,

d.value as signers,

instructions[0]:parsed:info:amount::float / POW(10,6) AS "Token amount",

post_token_balances[1]:mint::string as destination_address,

address_name,

a.program_id as contract_address,

ROW_NUMBER() OVER (partition by b.tx_id ORDER BY signers) as "row number"

from solana.core.fact_events a

inner join solana.core.fact_transactions b

on a.tx_id = b.tx_id

left join solana.core.dim_labels c on b.post_token_balances[1]:mint::string = c.address,

table(flatten(input => signers)) d

WHERE a.program_id = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'

and b.succeeded = 'TRUE'

and b.block_timestamp >= '2022-06-01'

)

select

date_trunc('day',block_timestamp) as days,

destination_address,

case when destination_address = 'BJUH9GJLaMSLV1E7B3SQLCy9eCfyr6zsrwGcpS2MkqR1' then 'SwimUSD Solana'

else address_name

end as token_name,

sum ("Token amount") AS total_amount,

count (Distinct tx_id) as total_transaction_volume

from table1

where "row number"=1

group by 1,2,3