PapasotAll Yieldly pools 2022
Updated 2023-01-03
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
›
⌄
-- Joining application_call_transaction with asset_transfer_transaction using(tx_group_id)
select
block_timestamp::date as date,
case when app_id =233725850 then 'YLDY/ALGO'
when app_id =385089192 then 'ARCC'
when app_id =393388133 then 'GEMS'
when app_id =424101057 then 'XET'
when app_id =447336112 then 'CHOICE'
when app_id =511597182 then 'AKITA'
when app_id =583357499 then 'ARCC pool_2'
when app_id =591414576 then 'DEFLY'
when app_id =593126242 then 'KTNC'
when app_id =593270704 then 'TINY'
when app_id =593289960 then 'TREES'
when app_id =596950925 then 'HDL'
when app_id =593324268 then 'BLOCK'
when app_id =604219363 then 'RIO'
when app_id =604373501 then 'AO'
when app_id =604392265 then 'CHIP'
when app_id =604411076 then 'FLAMINGO'
when app_id =609492331 then 'WBLN'
when app_id =604434381 then 'BIRDS'
when app_id =617707129 then 'DPANDA'
when app_id =618390867 then 'CURATOR'
when app_id =620458102 then 'ACORN'
when app_id =624919018 then 'CRSD'
when app_id =625053603 then 'NURD'
when app_id =620625200 then 'NEKOS'
when app_id =717256390 then 'ALCH'
when app_id =710518651 then 'COSG'
end as pool,
count(distinct tx_group_id) as num_actions,
sum(asset_amount/1e6) as Yieldly_amount,
count (distinct a.SENDER) as num_senders
from algorand.application_call_transaction a
Run a query to Download Data