nickpayiatis_Folks Finance App Call Transfer Volume by Asset
    Updated 2022-12-06
    with folks_app as (
    select app_name, app_id from algorand.core.dim_application
    where app_name ilike '%folks%'
    )
    ,distinct_app as(
    select distinct ac.tx_group_id from algorand
    .core.ez_transaction_application_call ac
    inner join folks_app fa
    on fa.app_id = ac.app_id
    and block_timestamp::date > '2022-03-20'
    )
    ,asset_price_usd as (
    select
    block_hour::date as days,
    asset_id,
    asset_name,
    avg(price_usd) as asset_price_usd
    from algorand.defi.ez_price_pool_balances
    where price_usd > 0
    and block_hour::date > '2022-03-20'
    group by days, asset_id, asset_name
    )
    , asset_transfers as (
    select tran.tx_group_id, tran.block_timestamp, tran.asset_name, tran.asset_id, tran.amount from distinct_app da
    inner join algorand.core.ez_transfer tran
    on tran.tx_group_id = da.tx_group_id
    where asset_id <> 0
    and tran.amount > 0
    )
    ,algo_transfers as(
    select pay.tx_group_id, pay.block_timestamp, 'ALGO' as asset_name, 0 as asset_id, pay.amount from distinct_app da
    inner join algorand.core.ez_transaction_payment pay
    on pay.tx_group_id = da.tx_group_id
    where pay.amount > 0
    and pay.block_timestamp::date > '2022-03-20'
    )
    Run a query to Download Data