nickpayiatis_Folks Finance App Call Transfer Volume by Asset
Updated 2022-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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