mlhapp percentage
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
›
⌄
select 'folks finance' as app,
date_trunc('day', block_timestamp) as days,
(count(distinct tx_group_id) / (select count(distinct tx_group_id) from flipside_prod_db.algorand.application_call_transaction))*100 as percent
from 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
)
and days>='2022-01-01'
group by 1, 2
UNION
select 'tinyman' as app,
date_trunc('day', block_timestamp) as days,
(count(distinct tx_group_id) / (select count(distinct tx_group_id) from flipside_prod_db.algorand.application_call_transaction))*100 as percent
from algorand.application_call_transaction
where app_id in (
649588853, 350338509, 552635992
)
and days>='2022-01-01'
group by 1, 2
UNION
select 'algofi' as app,
date_trunc('day', block_timestamp) as days,
(count(distinct tx_group_id) / (select count(distinct tx_group_id) from flipside_prod_db.algorand.application_call_transaction))*100 as percent
from 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,
Run a query to Download Data