azerbaijanCopy of Untitled Query
Updated 2023-03-01
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
›
⌄
⌄
with finalt as (
select a.block_timestamp,
a.tx_id,
tx_from,
tx_to,
instructions[0]:programId as program
from solana.core.fact_transfers a join solana.core.fact_transactions b on a.tx_from = b.signers[0] and b.block_timestamp > a.block_timestamp
where tx_to ='yUJw9a2PyoqKkH47i4yEGf4WXomSHMiK7Lp29Xs2NqM')
select program,
/*case when program = 'DeJBGdMFa1uynnnKiwrVioatTuHmNLpyFKnmB5kaFdzQ' then 'Phantom Wallet Deployment Program'
when program = 'M2mx93ekafmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K' then 'Magic Eden V2'
when program = 'F6fmDVCQfvnEq2KR8hhfZSEczfM9JK9fWbCsYJNbTGn7' then 'Incinerator Contract'
when program = 'JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph' then 'Jupiter v3'
when program = 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo' then 'Jupiter v2'
when program in ('routeUGWgWzqBWFcrCfv8tritsqukccJPu3q5GPP3xS','EhhTKczWMGQt46ynNeRX1WfeagwwJd7ufHvCDjRxjo5Q') then 'Raydium'
when program = '4MNPdKu9wFMvEeZBMt3Eipfs5ovVWTJb31pEXDJAAxX5' then 'Serum Assert Depolyment'
when program = '8BYmYs3zsBhftNELJdiKsCN2WyCBbrTwXd6WG4AFPr6n' then '8BYmYs3zsBhftNELJdiKsCN2WyCBbrTwXd6WG4AFPr6n'
when program = 'hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk' then 'Auction House'
else initcap(label) end as project_name,*/
count (distinct tx_id) as txs,
count (distinct tx_from) as Users_Count
from finalt a full outer join solana.core.dim_labels b on a.program = b.address
where program is not null
and program not in ('11111111111111111111111111111111','TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA','ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL','ComputeBudgea11111111111111111111111111111')
group by 1
order by 3 desc
limit 10
Run a query to Download Data