majidgholamiMost Popular destination from Solana
Updated 2022-07-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with A as (
select POST_TOKEN_BALANCES[1]:mint as aim,
sum (POST_TOKEN_BALANCES[1]:uiTokenAmount:uiAmount) as transfered_volume
from solana.core.fact_transactions
where inner_instructions[0]:instructions[2]:parsed:info:mint = 'BJUH9GJLaMSLV1E7B3SQLCy9eCfyr6zsrwGcpS2MkqR1'
and INNER_INSTRUCTIONS[0]:instructions[0]:parsed:type = 'transfer'
and INNER_INSTRUCTIONS[0]:instructions[1]:parsed:type = 'transfer'
and INNER_INSTRUCTIONS[0]:instructions[2]:parsed:type = 'mintTo'
group by aim
),
B as (
select ADDRESS_NAME , ADDRESS
from solana.core.dim_labels
where ADDRESS in (select aim from A))
select B.ADDRESS_NAME,
A.transfered_volume
from B
inner join A
on B.ADDRESS = A.aim
order by A.transfered_volume DESC
Run a query to Download Data