FatemeTheLadySolana-open10-usdt
Updated 2022-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with a as(
select ADDRESS_NAME as address,
sum(amount) as toal_amount
from solana.core.fact_transfers t,solana.core.dim_labels l
where t.TX_TO = l.address
and mint= 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
group by 1
order by 2 DESC
limit 8
)
select
date_trunc('week',BLOCK_TIMESTAMP) as date
,case when ADDRESS_NAME in (select address from a ) then ADDRESS_NAME else 'others' end as address
,sum(amount) as Amount
from solana.core.fact_transfers t,solana.core.dim_labels l
where t.TX_TO = l.address
and mint= 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
group by 1,2
order by 1 asc
Run a query to Download Data