Flipside Docs
Search…
Featured Tags & SQL Examples
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! Don't see the perfect tag? Add your own! ​
​

Table of Contents

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.
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
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
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​

​

Copy link
On this page
Table of Contents
Contract
CEX
DEX
NFT
Activity
Wallet