CHAINS | NUMBER_OF_USERS | |
|---|---|---|
1 | number of chains :1 | 10612267 |
2 | number of chains :2 | 590709 |
3 | number of chains :3 | 270582 |
4 | number of chains :4 | 290589 |
5 | number of chains :5 | 188376 |
6 | number of chains :6 | 80194 |
Flipside CommunityCross EVM NFT *
Updated 2025-02-04
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 NFT @ https://flipsidecrypto.xyz/Sandesh/q/4giV3gPpQkyn/cross-evm-nft
-- forked from Cross EVM Defi @ https://flipsidecrypto.xyz/edit/queries/42627402-f9de-46e0-b110-7aa88007c632
with acquired_eth_users_nft 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::date >= '2023-01-01' and block_timestamp::date < '2024-01-01'
group by 1,2 )
select distinct from_address,'ethereum' as chain, 1 as "yes"
from acquired_eth_users nu
inner join ethereum.nft.ez_nft_transfers sw on nu.from_address=sw.NFT_FROM_ADDRESS
where sw.block_timestamp::date < '2024-01-01'
UNION
select distinct from_address,'ethereum' as chain, 1 as "yes"
from acquired_eth_users nu
inner join ethereum.nft.ez_nft_mints mi on nu.from_address=mi.NFT_TO_ADDRESS
where mi.block_timestamp::date < '2024-01-01'
UNION
select distinct from_address,'ethereum' as chain, 1 as "yes"
from acquired_eth_users nu
inner join ethereum.nft.ez_nft_sales se on nu.from_address=se.SELLER_ADDRESS
where se.block_timestamp::date < '2024-01-01'
UNION
select distinct from_address,'ethereum' as chain, 1 as "yes"
from acquired_eth_users nu
inner join ethereum.nft.ez_nft_sales bu on nu.from_address=bu.BUYER_ADDRESS
where bu.block_timestamp::date < '2024-01-01'
-- group by 1,2,3
-- limit 5000
),
Last run: 3 months ago
6
188B
302s