granadohoNumber of Transactions for each Protocol over time
Updated 2022-07-14
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 groupid as (
(select
'Folks Finance' as protocol,
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'))
union
(select
'Tinyman' as protocol,
tx_group_id
from flipside_prod_db.algorand.application_call_transaction
where app_id in
('649588853','350338509','552635992'))
union
(select
'AlgoFi' as protocol,
tx_group_id
from flipside_prod_db.algorand.application_call_transaction
where app_id in
('705663269','705657303','674527132','661247364','661207804','661204747','661199805','661193019','661192413','659678644','659677335','658337046',
'658336870','647785804','647785158','641500474','641499935','639747739','639747119','611869320','553866305','482625868','465814222','465814065',
'674526408','637795072','637793356','635866213','635864509','635863793','635860537','635813909','635812850','611867642','611804624','611801333',
'605753404','553869413','482608867','465818260','465814318','465814278','465814149','465814103'))
union
(select
'Algo Dex' as protocol,
tx_group_id
from flipside_prod_db.algorand.application_call_transaction
where app_id in
('354073718','354073834'))
), transactions as (
select
a.*,
b.protocol
Run a query to Download Data