select block_timestamp::date as date,

case when tx_receiver LIKE '%mintbase1.near' then 'Mintbase'

when tx_receiver LIKE '%fewandfar.near' then 'Few and Far'

when tx_receiver in ('comic.paras.near','x.paras.near') then 'Paras'

else null end as market,

count (distinct tx_hash) as Total_TX,

count (distinct tx_signer) as Total_Users,

sum (transaction_fee/ pow (10,24)) as TX_Fee

from near.core.fact_transactions

where market is not null and TX_SUCCEEDED = 'TRUE'

AND block_timestamp::date>='2024-01-01'

group by 1,2)

select

market,

avg (Total_TX) as AVG_Daily_TX,

avg (Total_Users) as AVG_Daily_Users,

avg (TX_Fee) as AVG_Daily_TX_Fee

from tbl

group by 1