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 tx_id from sei.core.fact_transactions where fee = '0usei')

and block_timestamp::Date >= current_date - 90

UNION

select block_timestamp,

tx_id,

TX_FROM as address

from sei.core.fact_transactions

where fee != '0usei'

and block_timestamp::Date >= current_date - 90

select block_timestamp,

tx_hash as tx_id,

from_address as address

from sei.core_evm.fact_transactions

where block_timestamp::Date >= current_date - 90

case

when extract(dow from block_timestamp) = 0 then '7. Sunday'

when extract(dow from block_timestamp) = 1 then '1. Monday'

when extract(dow from block_timestamp) = 2 then '2. Tuesday'

when extract(dow from block_timestamp) = 3 then '3. Wednesday'

when extract(dow from block_timestamp) = 4 then '4. Thursday'

when extract(dow from block_timestamp) = 5 then '5. Friday'

when extract(dow from block_timestamp) = 6 then '6. Saturday'

end as "Day",

date_part(hour, block_timestamp) as "Hour",

count(distinct address) as "users",

count(DISTINCT tx_id) as "Transactions"

from users