-- select *
-- from ethereum.core.ez_nft_sales
-- where platform_exchange_version like 'seaport_1_1'
-- limit 10
with comparison as (
select 'LOGS' as origin, event_name, count (distinct tx_hash) as txs
from ethereum.core.fact_event_logs
where block_timestamp::date = '2022-07-04'
and origin_to_address = '0x00000000006c3852cbef3e08e8df289169ede581'
group by origin, event_name
--order by block_timestamp desc
union all
select 'SALES' as origin, event_type as event_name, count (distinct tx_hash) as txs
from ethereum.core.ez_nft_sales
where block_timestamp::date = '2022-07-04'
and platform_address = '0x00000000006c3852cbef3e08e8df289169ede581'
group by origin, event_name
)
select * from comparison order by txs desc