adambalaNew Active Users
Updated 2021-12-15
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
›
⌄
with recent_adresses as (select from_address from ethereum.transactions where
block_timestamp >= CURRENT_DATE -60
and (
to_address = '0xf92c1ad75005e6436b4ee84e88cb23ed8a290988'
)
GROUP by from_address
UNION
(select from_address from polygon.transactions where
block_timestamp >= CURRENT_DATE -60
and (
to_address = '0xDEF171Fe48CF0115B1d80b88dc8eAB59176FEe57'
or to_address = '0x90249ed4d69D70E709fFCd8beE2c5A566f65dADE'
)
GROUP by from_address
)
),
prev_adressess as (
select from_address from ethereum.transactions where
block_timestamp < CURRENT_DATE -60
and (
to_address = '0xf92c1ad75005e6436b4ee84e88cb23ed8a290988'
Run a query to Download Data