pimi1356-HdnUm3main events
Updated 2022-10-09
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
30
31
32
33
34
35
36
›
⌄
with burn as (
select count (distinct tx_id) as Burn_Count
from solana.core.fact_events
where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
and inner_instruction:instructions[0]:parsed:type = 'burn'
and succeeded = 'TRUE'),
Mint as (
select count (distinct tx_id) as Mint_Count
from solana.core.fact_events
where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
and inner_instruction:instructions[0]:parsed:type = 'mintTo'
and succeeded = 'TRUE'),
transfer as (
select count (distinct tx_id) as Transfers_Count
from solana.core.fact_events
where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
and inner_instruction:instructions[0]:parsed:type = 'transfer'
and succeeded = 'TRUE'),
alll as (
select count (distinct tx_id) as All_Count
from solana.core.fact_events
where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
and succeeded = 'TRUE')
select 'Burn Ratio' as Type, (Burn_Count/All_Count) * 100 as percent
from burn,alll
UNION
select 'Mint Ratio',(Mint_Count/All_Count) * 100
from mint,alll
UNION
select 'Transfers Ratio',(Transfers_Count/All_Count) * 100
from transfer,alll
Run a query to Download Data