drone-mostafaUntitled Query
Updated 2022-07-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with lst_top as (
select top 20
SIGNERS[0] as wallet
,(select min( LABEL) from solana.core.dim_labels where ADDRESS=SIGNERS[0]) as name
,sum(FEE/pow(10,9)) as amount_fee
from solana.core.fact_transactions
where block_timestamp::date>='2022-01-01'
and SUCCEEDED=false
group by 1,2
order by amount_fee DESC
)
select
block_timestamp::date as day
,SIGNERS[0] as wallet
,sum(FEE/pow(10,9)) as amount_fee
from solana.core.fact_transactions
where block_timestamp::date>='2022-01-01'
and SUCCEEDED=false
and wallet in (select wallet from lst_top)
group by 1,2
order by 1
Run a query to Download Data