tx_from as user,

from axelar.core.fact_transactions

UNION all

select BLOCK_TIMESTAMP,

SENDER as user,

from axelar.core.fact_transfers)

select case when extract(DOW FROM block_timestamp) = 0 THEN 'Sunday'

when extract(DOW FROM block_timestamp) = 1 THEN 'Monday'

when extract(DOW FROM block_timestamp) = 2 THEN 'Tuesday'

when extract(DOW FROM block_timestamp) = 3 THEN 'Wednesday'

when extract(DOW FROM block_timestamp) = 4 THEN 'Thursday'

when extract(DOW FROM block_timestamp) = 5 THEN 'Friday'

when extract(DOW FROM block_timestamp) = 6 THEN 'Saturday'

END AS "Day",

DATE_PART(hour, block_timestamp) AS "Hour",

count(DISTINCT user) as users,

count(DISTINCT tx_id) as total_tx

from users

group by 1,2