winnie-fsCross EVM Users copy
Updated 2024-08-13
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 Sandesh / Cross EVM Users @ https://flipsidecrypto.xyz/Sandesh/q/kugwUnl6F3u8/cross-evm-users
-- forked from Cross EVM users bubbles @ https://flipsidecrypto.xyz/edit/queries/3ff61efe-22d0-4052-8ecc-10adc6aece8b
-- forked from Cross EVM users @ https://flipsidecrypto.xyz/edit/queries/f8444600-61ef-48fd-844f-58e59d0850a1
-- forked from Cross EVM Defi @ https://flipsidecrypto.xyz/edit/queries/42627402-f9de-46e0-b110-7aa88007c632
with acquired_eth_users_chain as
(
with acquired_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 =1
and block_timestamp >= '2023-01-01'
and block_timestamp < '2024-01-01'
group by 1,2 )
select distinct from_address,'ethereum' as chain, 1 as "yes" from acquired_eth_users
),
acquired_poly_users_chain as
(
with acquired_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 =1
and block_timestamp >= '2023-01-01'
and block_timestamp < '2024-01-01'
group by 1,2 )
select distinct from_address,'polygon' as chain, 1 as "yes" from acquired_poly_users
),
acquired_opti_users_chain as
QueryRunArchived: QueryRun has been archived