Afonso_Diaz2023-10-07 09:52 PM
Updated 2023-10-10
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
›
⌄
select
'Stars Arena' as type,
count(distinct tx_hash) as transactions,
count(distinct from_address) as users
from avalanche.core.fact_transactions
where block_timestamp::date >= '2023-09-20'
and to_address = lower ('0xA481B139a1A654cA19d2074F174f17D7534e8CeC')
group by 1
union all
select
'Post Tech' as type,
count(distinct tx_hash) as transactions,
count(distinct from_address) as users
from arbitrum.core.fact_transactions
where block_timestamp::date >= '2023-09-20'
and to_address = lower ('0x87da6930626Fe0c7dB8bc15587ec0e410937e5DC')
group by 1
union all
select
'Friend Tech' as type,
count(distinct tx_hash) as transactions,
count(distinct from_address) as users
from base.core.fact_transactions
where block_timestamp::date >= '2023-09-20'
and to_address = lower ('0xCF205808Ed36593aa40a44F10c7f7C2F67d4A4d4')
group by 1
Run a query to Download Data