NavidUntitled Query
Updated 2022-11-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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