with new_users as ( select origin_from_address as neww, platform, min(block_timestamp::date) as min_date from avalanche.core.ez_dex_swaps group by 1,2 ) select 'Trader Joe' as type, date_trunc('{{Date}}',min_date) as date, count(DISTINCT neww) as users, sum(users) over (order by date) as total_users from new_users where date >= '{{Start_Date}}' and date<= '{{End_Date}}' and platform in ('trader-joe-v1','trader-joe-v2') group by 1,2 union all select 'Woofi' as type, date_trunc('{{Date}}',min_date) as date, count(DISTINCT neww) as users, sum(users) over (order by date) as total_users from new_users where date >= '{{Start_Date}}' and date<= '{{End_Date}}' and platform = 'woofi' group by 1,2 union all select 'Curve' as type, date_trunc('{{Date}}',min_date) as date, count(DISTINCT neww) as users, sum(users) over (order by date) as total_users from new_users where date >= '{{Start_Date}}' and date<= '{{End_Date}}' and platform = 'curve' group by 1,2 union all select 'Sushiswap' as type, date_trunc('{{Date}}',min_date) as date, count(DISTINCT neww) as users, sum(users) over (order by date) as total_users from new_users where date >= '{{Start_Date}}' and date<= '{{End_Date}}' and platform = 'sushiswap' group by 1,2 union all select 'Pangolin' as type, date_trunc('{{Date}}',min_date) as date, count(DISTINCT neww) as users, sum(users) over (order by date) as total_users from new_users where date >= '{{Start_Date}}' and date<= '{{End_Date}}' and platform = 'pangolin' group by 1,2 union all select 'GMX' as type, date_trunc('{{Date}}',min_date) as date, count(DISTINCT neww) as users, sum(users) over (order by date) as total_users from new_users where date >= '{{Start_Date}}' and date<= '{{End_Date}}' and platform = 'gmx' group by 1,2 union all select 'Kyberswap' as type, date_trunc('{{Date}}',min_date) as date, count(DISTINCT neww) as users, sum(users) over (order by date) as total_users from new_users where date >= '{{Start_Date}}' and date<= '{{End_Date}}' and platform in ('kyberswap-v1','kyberswap-v2') group by 1,2 union all select 'Frax' as type, date_trunc('{{Date}}',min_date) as date, count(DISTINCT neww) as users, sum(users) over (order by date) as total_users from new_users where date >= '{{Start_Date}}' and date<= '{{End_Date}}' and platform = 'fraxswap' group by 1,2 union all select 'Hashflow' as type, date_trunc('{{Date}}',min_date) as date, count(DISTINCT neww) as users, sum(users) over (order by date) as total_users from new_users where date >= '{{Start_Date}}' and date<= '{{End_Date}}' and platform = 'hashflow' group by 1,2 union all select 'Platypus' as type, date_trunc('{{Date}}',min_date) as date, count(DISTINCT neww) as users, sum(users) over (order by date) as total_users from new_users where date >= '{{Start_Date}}' and date<= '{{End_Date}}' and platform = 'platypus' group by 1,2

Avalanche Dex Tools