nits2022 Yieldly pools
Updated 2022-05-23
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 prices as
(SELECT date(block_hour) as day, avg(price_usd) as avg_price
from algorand.prices_swap
where asset_id = '0'
GROUP by 1 )
SELECT * from
(select
date(block_timestamp) 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'
Run a query to Download Data