from sei.core.fact_msg_attributes

where attribute_value='sei1pdwlx9h8nc3fp6073mweug654wfkxjaelgkum0a9wtsktwuydw5sduczvz'

and attribute_key='_contract_address'

and msg_type='wasm-execute-exchange'

and tx_succeeded='true'),

tab2 as (select block_timestamp::date as date, attribute_value/pow(10,6) as price, tx_id

from sei.core.fact_msg_attributes

where attribute_key='exchange-token-amount' and tx_succeeded='true' and msg_type='wasm-accept-request')

select date, tab1.tx_id as tx_id, price

from tab1 left join tab2 on tab1.tx_id=tab2.tx_id),

tab4 as (select tx_id, attribute_value as seller

from sei.core.fact_msg_attributes

where ATTRIBUTE_KEY='seller' and msg_type='wasm-accept-request' and msg_index= 12)

select date, tab3.tx_id as tx_id, seller, price

from tab3 left join tab4 on tab3.tx_id=tab4.tx_id),

tab6 as (select tx_id, tx_from as buyer, split_part(fee,'u',1)/pow(10,6) as fee

from sei.core.fact_transactions)

select buyer as "Buyer", count(distinct tab5.tx_id) as "Purchase Count", sum(price) as "Purchase Volume (SEI)"

from tab5 left join tab6 on tab5.tx_id=tab6.tx_id

group by 1

order by 2 desc

limit 5