PapasotAll Yieldly pools 2022
    Updated 2023-01-03
    -- 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