alirsTest-2
    Updated 2022-07-14
    WITH DeFi_App_Calls AS
    (
    SELECT
    case
    when app_id in (
    649588853 , -- Tinyman Staking
    350338509, -- Tinyman AMM V1.0
    552635992 -- Tinyman AMM V1.0
    ) then 'Tinyman'
    when app_id in (
    354073718 , -- AlgoDEX - Buy (Order book)
    354073834 -- AlgoDEX - Sell (Order book)
    ) then 'AlgoDEX'
    when app_id in (
    776179559,
    776176449,
    752770929,
    751285119,
    747239433,
    747237154,
    743685742,
    743679535,
    696044550,
    694464549,
    694405065,
    686876641,
    686875498,
    686862190,
    686860954,
    686501760,
    686500844,
    686500029,
    686498781
    ) then 'Folks finance'
    when app_id in
    (
    Run a query to Download Data