nitsCRV from address names in the past 3 months by new users
    Updated 2022-01-09
    with addr_details as (select origin_address as addr, min(block_timestamp) as first_use from (select * from ethereum.udm_events
    where lower(contract_address) = lower('0xD533a949740bb3306d119CC777fa900bA034cd52'))
    group by 1 )
    select from_address_name , count(*) as total_actions_taken from
    (select * from (select * from ethereum.udm_events
    where lower(contract_address) = lower('0xD533a949740bb3306d119CC777fa900bA034cd52'))
    inner join addr_details
    on addr= origin_address and block_timestamp = first_use )
    where DATE(first_use) > CURRENT_DATE -93 and from_address_name is not NULL
    group by from_address_name
    order by total_actions_taken desc
    limit 100
    Run a query to Download Data