(select
block_timestamp::date as date,
'Foundation' as platform,
count(distinct tx_hash) as token_transfer_vol
from ethereum_core.fact_event_logs
where contract_address = '0x3b3ee1931dc30c1957379fac9aba94d1c48a5405'
and event_name = 'Transfer'
group by 1
order by 1)
union
(select
block_timestamp::date as date,
'Opensea Shared Mint' as platform,
count(distinct tx_hash) as token_transfer_vol
from ethereum_core.fact_event_logs
where event_name = 'TransferSingle'
and contract_address = '0x495f947276749ce646f68ac8c248420045cb7b5e'
group by 1
order by 1)