kasadeghpercent of transactions that each app calls
Updated 2022-07-14
999
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_finance_group_ids as (
select distinct TX_GROUP_ID from flipside_prod_db.algorand.application_call_transaction
where APP_ID in ( 776179559,776176449,752770929,751285119,747239433,747237154,743685742,743679535,696044550,694464549,694405065,686876641,686875498,686862190,
686860954,686501760,686500844,686500029,686498781 -- Folks_finance )
)
),
folks_finance_TX_IDs as (
select TX_ID from flipside_prod_db.algorand.application_call_transaction
where APP_ID in
(
776179559,776176449,752770929,751285119,747239433,747237154,743685742,743679535,696044550,694464549,694405065,686876641,686875498,686862190,
686860954,686501760,686500844,686500029,686498781 -- Folks_finance
)
),
folks_finance_transactions as (
select 'folks_financ' as app_name,(count(distinct TX_ID)/(select count(distinct TX_ID) from flipside_prod_db.algorand.transactions ) ) * 100 as percent_of_transactions
from flipside_prod_db.algorand.transactions
where
TX_GROUP_ID in ( select * from folks_finance_group_ids
)
or TX_ID in (select * from folks_finance_TX_IDs)
)
,
-- ++++++++++++++++++++++++++++++++++++++++++++++++++
tinyman_group_ids as (
select distinct TX_GROUP_ID from flipside_prod_db.algorand.application_call_transaction
where APP_ID in ( 649588853,350338509,552635992
)
),
tinyman_TX_IDs as (
select TX_ID from flipside_prod_db.algorand.application_call_transaction
where APP_ID in
Run a query to Download Data