KaskoazulForefront Curators update April 19th
    Updated 2022-04-21
    with curators as (
    select balance_date::date as fecha,
    count(distinct user_address) as curators
    from ethereum.erc20_balances
    where fecha >= '2022-01-01'
    and contract_address = lower('0x7E9D8f07A64e363e97A648904a89fb4cd5fB94CD')
    and user_address != '0x2fb9f0ef424b24a8d293999298f392a33fe6a8b5' -- Treasury
    and balance >= 1000
    group by 1
    order by 1 desc
    ),

    centurions as (
    select balance_date::date as fecha,
    count(distinct user_address) as centurions
    from ethereum.erc20_balances
    where fecha >= '2022-01-01'
    and contract_address = lower('0x7E9D8f07A64e363e97A648904a89fb4cd5fB94CD')
    and balance >= 100
    and user_address != '0x2fb9f0ef424b24a8d293999298f392a33fe6a8b5' -- Treasury
    group by 1
    order by 1 desc
    )

    select c.fecha,
    c.curators,
    --(c.curators - 223) / 223 as perc_diff_curators,
    h.centurions
    --(h.centurions - 993) / 993 as perc_diff_centurions
    from curators c
    inner join centurions h
    on c.fecha = h.fecha
    order by 1 desc
    Run a query to Download Data