from sei.core.fact_msg_attributes

where ATTRIBUTE_VALUE in ('sei152u2u0lqc27428cuf8dx48k8saua74m6nql5kgvsu4rfeqm547rsnhy4y9')

and ATTRIBUTE_KEY = '_contract_address'

and msg_type in ('wasm-buy_now','wasm-accept_bid')

and TX_SUCCEEDED = 'true'

and block_timestamp::date >= current_date - 31 and block_timestamp::Date <= current_date - 1

select DISTINCT tx_id

from sei.core.fact_msg_attributes

where attribute_value = 'sei1pdwlx9h8nc3fp6073mweug654wfkxjaelgkum0a9wtsktwuydw5sduczvz'

and tx_succeeded = 'true'

and attribute_key = '_contract_address'

and msg_type = 'wasm-execute-exchange'

and block_timestamp::date >= current_date - 31 and block_timestamp::Date <= current_date - 1)

select date(block_timestamp) as date,

case when receiver = 'sei1kdns9z8qm3euk0hnmgltqxlnldkqq3wza4eqwd' then 'Pallet' else 'Dagora' end as platform,

sum(amount/pow(10,6)) as platform_amount

from sei.core.fact_transfers

where RECEIVER in ('sei1kdns9z8qm3euk0hnmgltqxlnldkqq3wza4eqwd','sei15qlu5fxwp9umen3l7d7ju2p6lgn02c009zlst5')

and tx_id in (select tx_id from pallet)

and block_timestamp::date >= current_date - 31 and block_timestamp::Date <= current_date - 1

group by 1,2