select --date_trunc('day',block_timestamp) as day, -- amount_usd,
--to_address_name,
to_address_name as pool,
count(distinct(origin_address)) as new_addresses
--tx_id
from ethereum.udm_events
where to_label = 'sushiswap'
and origin_function_name ilike 'add%'
and to_address_name <> 'router'
and to_label_subtype <> 'swap_contract'
and amount_usd is not null
and block_timestamp >= '2021-11-14'
and block_timestamp <= '2021-12-13'
--and DATEDIFF('day', TO_DATE(block_timestamp), CURRENT_DATE()) <= 30
group by 1
order by 2 desc
limit 10
--6434629