select
block_timestamp::date as date,
COUNT(tx_hash) as num_tx,
case when contract_address = lower('0x3b3ee1931dc30c1957379fac9aba94d1c48a5405') then 'Foundation'
ELSE 'OpenSea' end as platform
from Ethereum_core.fact_event_logs
where contract_address = lower('0x3b3ee1931dc30c1957379fac9aba94d1c48a5405')
or contract_address = lower('0x495f947276749Ce646f68AC8c248420045cb7b5e')
and event_name in ('Transfer', 'TransferSingle', 'TransferBatch')
and block_timestamp::date >= '2022-01-22'
group by 1, 3
order by 1