Tags

Want to see what interesting addresses are up to? Have a list of addresses you want to analyze without pasting them into your where clause? Tags are for you.

Tags can be specific and provable, e.g. "OpenSea user", or simply a tool to group addresses and clean up your code. Your tags. Your rules.

Check back often as our list of tags is constantly being updated!

crosschain.core.address_tags table docs Don't see the perfect tag? Add your own!

Table of Contents

Tag Type

Token Standard

Tag_type 'token standard' is a set of tags that define the token standard of an address!

tag_name
description
blockchains

erc-20

An erc-20 address

ethereum

erc-721

An erc-721 address

ethereum

erc-1155

An erc-1151 address

ethereum

erc-4626

An erc-4626 address

ethereum

erc-6551

An erc-6551 address

ethereum

erc-6551 owner

A token address that owns an erc-6551

ethereum

Want to know the difference in behaviors of erc-721's vs. erc-1155's? Leveraging the 'token standard' tag_name will make this segmentation and subsequent analysis trivial!

The code below will find all erc-721s that are on Ethereum!

select 
  distinct address
from crosschain.core.address_tags 
where 
    tag_type = 'token standard' 
    and tag_name = 'erc-721'
    and creator = 'flipside'

Contract

Tag_type 'contract' is a group of tags that call out contract addresses! Contracts are discovered by looking through the blockchain's logs and tagged for you!

tag_name
description
blockchains

contract address

An address that is a contract

Ethereum

gnosis safe address

An address that is a gnosis safe contract

Ethereum

Leveraging the tag type 'contract' is a useful way to exclude contracts from your analysis, and only focus on externally owned addresses (EOAs). Add the below code to a where statement within your analysis to ensure you are not pulling in any contracts!

select 
  distinct address
from crosschain.core.address_tags 
where 
    tag_type = 'contract' 
    and tag_name = 'contract address'
    and creator = 'flipside'

back to top

CEX

Tag_type 'cex' is a group of tags pertaining to 'centralized exchanges' or 'cex' for short.

tag_name
description
blockchains

[cex name] user

Identifies an address that either sent or received funds from a particular centralized exchange

Ethereum

CEX tags can be used to group addresses based on which centralized exchange they use. Want to know which centralized exchange has the most addresses interacting with it? See below for code to get an ordered list!

select 
  tag_name, 
  count(distinct address) as num_addresses
from crosschain.core.address_tags 
where 
    tag_type = 'cex' 
    and tag_name like '% user'
    and creator = 'flipside'
group by tag_name
order by num_addresses desc

back to top

DEX

Tag_type 'dex' is a group of tags for 'decentralized exchanges' or 'dex' for short.

tag_name
description
blockchains

thorchain dex user

Identifies an address that has done a swap with thorchain

bitcoin, bitcoin cash, bsc, cosmos, dogechain, Ethereum, litecoin, terra, thorchain

thorchain liquidity provider

Identifies an address that has provided liquidity to thorchain

bitcoin, bitcoin cash, bsc, cosmos, dogechain, Ethereum, litecoin, terra, thorchain

Ever wondered what Ethereum addresses are providing liquidity to Thorchain? It has never been easier with the help of tags!:

select 
  distinct address
from crosschain.core.address_tags 
where 
    tag_type = 'dex' 
    and tag_name = 'thorchain liquidity provider'
    and creator = 'flipside'
    and blockchain = 'ethereum'

back to top

NFT

Tag_type 'nft' is a group of tags pertaining to nft usage!

tag_name
description
blockchains

[nft marketplace] user

Identifies addresses that use a particular nft marketplace

Ethereum

nft transactor top 1%

addresses that are in the top 1% of transactions involving an nft

Ethereum

nft transactor top 5%

addresses that are in the top 5% of transactions involving an nft

Ethereum

nft transactor top 10%

addresses that are in the top 10% of transactions involving an nft

Ethereum

Want to know which marketplace has the most addresses interacting with it? Tags can help you with a simple query:

select 
  tag_name, 
  count(distinct address) as num_addresses
from crosschain.core.address_tags 
where 
    tag_type = 'nft' 
    and tag_name like '% user'
    and creator = 'flipside'
group by tag_name
order by num_addresses desc

back to top

Activity

Tag_type 'activity' is for tags that describe an address's activity. General tags that are not protocol specific!

tag_name
description
blockchains

active on [blockchain] last 7

identifies an address that has sent at least 1 transaction on a blockchain in the last 7 days.

Arbitrum, Avalanche, Bsc, Ethereum, Optimism, Polygon

There are many use cases for an active tag! A simple one is to see what other EVM's an address is active on. Here is a query to see addresses that are active on both Ethereum and Arbitrum:

with eth_addresses as (
select 
    distinct address 
from crosschain.core.address_tags 
where tag_name = 'active on ethereum last 7'
    and creator = 'flipside'
)
select 
  distinct address
from crosschain.core.address_tags 
where 
    tag_name = 'active on arbitrum last 7'
    and address in (select distinct address from eth_addresses)
    and creator = 'flipside'

back to top

Wallet

Tag_type 'wallet' is for tags pertaining to the token contents of an address.

tag_name
description
blockchains

airdrop master

address is in the top 10% of airdrop recipients based on token value. Value of token is calculated at time of airdrop claim

Ethereum

eth billionaire

address has an ETH balance of at least $1,000,000,000

Ethereum

eth millionaire

address has an ETH balance of at least $1,000,000

Ethereum

eth top 1%

address has an ETH balance in the top 1% of all ETH holders

Ethereum

optimism airdrop 1 recipient

addresses that received the first optimism airdrop

Optimism

optimism airdrop 2 recipient

addresses that received the second optimism airdrop

Optimism

token billionaire

address has a non-eth token balance of at least $1,000,000,000

Ethereum

token millionaire

address has a non-eth token balance of at least $1,000,000

Ethereum

token top 1%

address has a non-eth token balance in the top 1% of all non-eth token holders

Ethereum

wallet billionaire

address has a total wallet (ETH and token) balance of at least $1,000,000,000

Ethereum

wallet millionaire

address has a total wallet (ETH and token) balance of at least $1,000,000

Ethereum

wallet top 1%

address has a total wallet (ETH and token) balance in the top 1% of all addresses

Ethereum

vested or locked token recipient

address has received vested/unlocked tokens from a protocol

Ethereum

Using wallet type in combination with some other tags can yield more interesting results. For example, let look at what nft platforms wallet millionaires use:

with wallet_millionaire as (
select 
    distinct address 
from crosschain.core.address_tags 
where tag_name = 'wallet millionaire'
    and creator = 'flipside'
)
select 
  tag_name, 
  count(distinct address) as num_addresses
from crosschain.core.address_tags 
where 
    tag_type = 'nft'
    and address in (select distinct address from wallet_millionaire)
    and creator = 'flipside'
group by tag_name
order by num_addresses desc

back to top

Last updated