flipside

    stader - user count
    boomer77stader - user count
    Updated 2021-12-17
    with raw as (SELECT date_trunc('day', block_timestamp) as dt, msg_value:contract::string as protocol, count(distinct msg_value:sender::string) as users_count
    from terra.msgs
    where dt > '2021-11-12' and tx_status = 'SUCCEEDED' and protocol is not null
    group by 1,2),

    label as (select address, address_name
    from terra.labels
    where address in ('terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s', 'terra1mddcdx0ujx89f38gu7zspk2r2ffdl5enyz2u03', 'terra1r2vv8cyt0scyxymktyfuudqs3lgtypk72w6m3m', 'terra1g7jjjkt5uvkjeyhp8ecdz4e4hvtn83sud3tmh2'))

    select a.dt, a.protocol, b.address_name, a.users_count
    from raw a
    join label b on a.protocol = b.address

    --terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s anchor
    --terra1mddcdx0ujx89f38gu7zspk2r2ffdl5enyz2u03 orion
    --terra1r2vv8cyt0scyxymktyfuudqs3lgtypk72w6m3m stader
    --terra1g7jjjkt5uvkjeyhp8ecdz4e4hvtn83sud3tmh2 apollo
    Run a query to Download Data