mattkstewMoving to Earn in the Bear Market 4
Updated 2022-07-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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(*)
from solana.core.fact_transfers
where mint in ('kiTkNc7nYAu8dLKjQFYPx3BqdzwagZGBUrcb7d4nbN5', 'GENEtH5amGSi8kHAtQoezp1XEXwZJ8vcuePYnXdKrMYz',
'7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx', 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB')
group by 1
Run a query to Download Data