block_timestamp::date,

case

when payer like '0x18eb4ee6b3c026d2' then 'Dapper wallet'

when payer like '0x55ad22f01ef568a1' then 'Blocto'

when payer like '0x319e67f2ef9d937f' then 'Lilico'

end as providers,

count(distinct tx_id) as wallet

from flow.core.fact_transactions

where providers is not null

group by 1,2