Ali3NTensor's Rise on Solana VS Blur's Rise on Ethereum Over Time (New & Total Traders)
    Updated 2023-06-27
    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,
    Run a query to Download Data