lagandispenserSushiswap ETH Pool Unique Addresses
    Updated 2022-05-04
    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
    Run a query to Download Data