nits2022 Yieldly pools
    Updated 2022-05-23
    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