drone-mostafaUntitled Query
Updated 2022-07-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select instructions[0]:programId as program_ID,
case when program_ID = 'FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe4975bi2epH' then 'pyth oracle'
when program_id ='9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' then 'serum dex v3'
when program_ID = 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo' then 'jupiter aggregator v2'
when program_ID = '11111111111111111111111111111111' then 'system program'
when program_ID = 'DtmE9D2CSB4L5D6A15mraeEjrGMm6auWVzgaD8hK2tZM' then 'switchboard oracle'
when program_ID = 'ComputeBudget111111111111111111111111111111' then 'Compute Budget Program'
when program_ID = 'cjg3oHmg9uuPsP8D6g29NWvhySJkdYdAo9D25PRbKXJ' then 'Chainlink Data Feeds Store Program'
when program_ID = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' then 'Mango Markets'
else program_ID end as program_name,
sum(fee/1e9) as Paid_Fee_SOL
from solana.core.fact_transactions
where block_timestamp >= '2022-01-01' and SUCCEEDED ='FALSE'
group by 1,2
order by 3 desc
limit 10
Run a query to Download Data