Sbhn_NPTotal $LUNA Supply
    Updated 2022-12-15
    with SEND as
    (select SENDER,
    sum(AMOUNT) as sent_amount
    from
    terra.core.ez_transfers
    WHERE
    CURRENCY ilike 'uluna'
    group by SENDER
    ),
    RECEIVE as
    (select RECEIVER,
    sum(AMOUNT) as received_amount
    from
    terra.core.ez_transfers
    WHERE
    CURRENCY ilike 'uluna'
    group by RECEIVER
    )

    select sum(received_amount)/1e4 as total_supply from RECEIVE r left join SEND s on r.RECEIVER=s.SENDER
    where sent_amount is null
    Run a query to Download Data