nickpayiatis_Folks Finance App Calls
Updated 2022-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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 distinct block_timestamp::date as date,
count(*) as "Number of App Calls",
count(distinct tx_sender) as "Number of Distinct Wallets Calling Applications"
from raw_apps
group by block_timestamp::date
order by date asc
Run a query to Download Data