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!

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

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!

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'

CEX

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

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

DEX

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

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'

NFT

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

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

Activity

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

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'

Wallet

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

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

PreviousFlotsam Label Type NextTable Freshness Targets

Last updated 11 months ago

Tags

Table of Contents

Token Standard

Contract

CEX

DEX

NFT

Activity

Wallet

Table of Contents

Token Standard

Contract

CEX

DEX

NFT

Activity

Wallet