SandeshCross EVM users
Updated 2023-12-05
999
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
›
⌄
-- forked from Cross EVM Defi @ https://flipsidecrypto.xyz/edit/queries/42627402-f9de-46e0-b110-7aa88007c632
with new_eth_users_chain as
(
with new_eth_users AS
(
select 'ethereum' as chain , from_address, sum(1) as "yes" from ethereum.core.fact_transactions
where 1=1
-- and from_address in (lower('0x2c3C48dcFA3875b5D181033A5ffFe1584270462a'),lower('0x4838B106FCe9647Bdf1E7877BF73cE8B0BAD5f97'))
and nonce =0
and block_timestamp::date > '2023-01-01'
group by 1,2 )
select distinct from_address,'ethereum' as chain, 1 as "yes" from new_eth_users
),
new_poly_users_chain as
(
with new_poly_users AS
(
select 'polygon' as chain , from_address, sum(1) as "yes" from polygon.core.fact_transactions
where 1=1
-- and from_address in (lower('0x2c3C48dcFA3875b5D181033A5ffFe1584270462a'),lower('0x4838B106FCe9647Bdf1E7877BF73cE8B0BAD5f97'))
and nonce =0
and block_timestamp::date > '2023-01-01'
group by 1,2 )
select distinct from_address,'polygon' as chain, 1 as "yes" from new_poly_users
),
new_opti_users_chain as
(
with new_opti_users AS
(
select 'optimism' as chain , from_address, sum(1) as "yes" from optimism.core.fact_transactions
where 1=1
-- and from_address in (lower('0x2c3C48dcFA3875b5D181033A5ffFe1584270462a'),lower('0x4838B106FCe9647Bdf1E7877BF73cE8B0BAD5f97'))
and nonce =0
and block_timestamp::date > '2023-01-01'
Run a query to Download Data