NavidUntitled Query
    Updated 2022-11-10
    with near_buys as (
    select
    TX_RECEIVER as to_address,
    sum(DEPOSIT) as buy_amount
    from
    near.core.fact_transfers
    group by
    1
    ), near_sells as (
    select
    TX_SIGNER as from_address,
    sum(DEPOSIT) as sell_amount
    from
    near.core.fact_transfers
    group by
    1
    ), near_assets as (
    select
    b.to_address as address,
    iff(buy_amount is null, 0, buy_amount)-iff(sell_amount is null, 0, sell_amount) as amt
    from
    near_buys b full outer join near_sells s on b.to_address=s.from_address
    ), labled_assets as (
    select
    'Near' as type,
    address,
    amt,
    case
    when amt <= 10 then 'A: amt<=10'
    when amt > 10 and amt <= 100 then 'B: 10<amt<=100'
    when amt > 100 and amt <= 1000 then 'C: 100<amt<=1k'
    -- when amt > 10000 and amt <= 100000 then 'D: 1k<amt<=100k'
    else 'E: amt>1k'
    end as amt_label
    from
    near_assets
    Run a query to Download Data