tx_id,

attribute_value as address

from sei.core.fact_msg_attributes

where attribute_key in ('sender','fee_payer')

and tx_id not in (select DISTINCT tx_id from sei.core.fact_transactions

where fee = '0usei'

and block_timestamp::Date >= '2024-05-28')

UNION

select block_timestamp,

tx_id,

TX_FROM as address

from sei.core.fact_transactions

where fee != '0usei'

select block_timestamp,

tx_hash as tx_id,

from_address as address

from sei.core_evm.fact_transactions

where block_timestamp::Date >= '2024-05-28'

,

new as ( select min(block_timestamp) as date,

from users

group by 2

having date >= current_date - 30)

,

new_final as ( select count(DISTINCT address) as total_new

from new

where date >= current_date - 30)

,

total_users as ( select block_timestamp,

tx_id,

attribute_value as address

from sei.core.fact_msg_attributes