Cross EVM Users

Updated 2025-02-04

-- forked from Cross EVM users bubbles heatmap @ https://flipsidecrypto.xyz/edit/queries/f20ab509-7785-4a7c-baf5-ed0e852685e2

-- forked from Cross EVM users bubbles @ https://flipsidecrypto.xyz/edit/queries/24218150-c655-42b8-8ceb-8216fc516052

-- 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('0x8c5A2E550934e57Eb17D8d0Cc113D3D5075F14a9'))

and nonce = 1

and block_timestamp >= '2023-01-01'

and block_timestamp < '2024-01-01'

group by

) -- select count(*) from acquired_eth_users

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

Last run: 2 months ago

	CHAIN	ETHEREUM	POLYGON	OPTIMISM	ARBITRUM	AVALANCHE	BASE
1	arbitrum	1587435	2036585	1859652	7378395	1415178	775201
2	avalanche	779269	1535975	1118445	1415178	2534441	503955
3	base	598961	629351	686685	775201	503955	1940910
4	polygon	1409096	15240523	1468252	2036585	1535975	629351
5	optimism	1032188	1468252	3335226	1859652	1118445	686685
6	ethereum	15408536	1409096	1032188	1587435	779269	598961

353B

181s