with tensorswapt as (
select date_trunc ({{Date_Trunc}},mindate) as date,
count (distinct Purchaser) as New_Traders,
sum (New_Traders) over (order by date) as Total_Traders
from (
select purchaser,
min (block_timestamp) as mindate
from solana.core.fact_nft_sales
where marketplace ilike 'tensorswap'
and succeeded ilike 'TRUE'
group by 1)
group by 1),
blurt as (
select date_trunc ({{Date_Trunc}},mindate) as date,
count (distinct buyer_address) as New_Traders,
sum (New_Traders) over (order by date) as Total_Traders
from (
select buyer_address,
min (block_timestamp) as mindate
from ethereum.core.ez_nft_sales
where platform_name ilike 'blur'
group by 1)
group by 1),
tensorswapt1 as (
select *,
row_number () over (order by date) as Counter
from tensorswapt),
blurt1 as(
select *,
row_number () over (order by date) as Counter
from blurt)
select 'TensorSwap' as platform,