flipside

    ✅ projects: which dapps and addresses hold the majority of USN?
    elsina✅ projects: which dapps and addresses hold the majority of USN?
    Updated 2024-02-12
    with pars_in as (
    select receiver_id, replace(value, 'EVENT_JSON:') as log
    from near.core.fact_receipts, table(flatten(input => logs))
    where receiver_id = 'usn' and substr(status_value,3,7) = 'Success'
    ),
    s_r as (
    select
    parse_json(log):data[0]:old_owner_id as addr,
    -sum(parse_json(log):data[0]:amount/pow(10,18)) as amount,
    'send' as type
    from pars_in
    where
    check_json(log) is null and
    addr is not null
    group by 1

    union all
    select
    parse_json(log):data[0]:new_owner_id as addr,
    sum(parse_json(log):data[0]:amount/pow(10,18)) as amount,
    'receive' as type
    from pars_in
    where
    check_json(log) is null and
    addr is not null and
    parse_json(log):event = 'ft_transfer'
    group by 1
    )

    select addr as "Contract", sum(amount) as "USN amount"
    from s_r
    group by 1
    order by 2 desc
    limit 10
    Last run: over 1 year agoAuto-refreshes every 24 hours
    Contract
    USN amount
    1
    		usn-burn.near25807446.44
    2
    		usnpp-aurora.near11212969.5613975
    3
    		f1n.near4552262.78524944
    4
    		nbiv.near3827387.12028511
    5
    		contract.main.burrow.near1923057.30795389
    6
    34d25b01f399cac953765b11ca024aba5e3d2d91670dac132b8d794910664c21
    		1919025.59900943
    7
    e47ccbcd0113c12fe00664921c03955176d521af47e2ff41056c7c18370f52b0
    		1856971.12977967
    8
    		brchan.near1386552.88199701
    9
    		ampr.near1084899.4004917
    10
    73f62a7394bd113ba049d78af87852982fedf302aecc55901184e74db2d3fb00
    		1083221.03096557
    10
    499B
    364s