mattkstewMoving to Earn in the Bear Market 6
Updated 2022-07-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
Case
when mint like 'kiTkNc7nYAu8dLKjQFYPx3BqdzwagZGBUrcb7d4nbN5' then 'KI'
when mint like 'GENEtH5amGSi8kHAtQoezp1XEXwZJ8vcuePYnXdKrMYz' then 'GENE'
when mint like '7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx' then 'GMT'
when mint like 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' then 'GST'
END as token1,
count(distinct tx_from)
from solana.core.fact_transfers
where mint in ('kiTkNc7nYAu8dLKjQFYPx3BqdzwagZGBUrcb7d4nbN5', 'GENEtH5amGSi8kHAtQoezp1XEXwZJ8vcuePYnXdKrMYz',
'7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx', 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB')
group by 1
Run a query to Download Data