nickpayiatis_Total Folks Finance App Calls
    Updated 2022-12-06
    with folks_app as (
    select app_name, app_id from algorand.core.dim_application
    where app_name ilike '%folks%'
    )
    ,raw_apps as(
    select ac.* from algorand.core.ez_transaction_application_call ac
    inner join folks_app fa
    on fa.app_id = ac.app_id
    )
    select count(*) as "Number of App Calls",
    count(distinct tx_sender) as "Number of Distinct Wallets Calling Applications"
    from raw_apps