0-MIDuser interaction poly
Updated 2023-08-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
31
32
33
34
35
36
›
⌄
with tab1 as (
select
TO_ADDRESS
from polygon.core.ez_token_transfers
where ORIGIN_TO_ADDRESS='0x88dcdc47d2f83a99cf0000fdf667a468bb958a78'
and ORIGIN_FUNCTION_SIGNATURE in ('0xcdd1b25d')
),
tab2 as (
select ADDRESS
,LABEL_TYPE
,PROJECT_NAME
from polygon.core.dim_labels
where PROJECT_NAME not in('celer network')
),
tab3 as (
select
TO_ADDRESS
,ORIGIN_TO_ADDRESS
,TX_HASH
from polygon.core.fact_token_transfers
)
select
LABEL_TYPE
,count(distinct TO_ADDRESS) as depositors
,count(distinct TX_HASH) as txs
from tab2
left join tab3
on tab2.ADDRESS=tab3.ORIGIN_TO_ADDRESS
where tab3.TO_ADDRESS in(select TO_ADDRESS from tab1)
group by 1
Run a query to Download Data