Recipes

NFT transfers

Stream raw, real-time NFT transfers directly into your data warehouse or application.

Who is this for?

Anyone who wants to process NFT transfers in real-time. You could use this recipe to:

  • monitor today's / this month's / ... top NFT transfers
  • a specific NFT's transfer history
  • receive an alert when your favorite NFTs is transferred
  • ...

Architecture

This recipe combines:

Result

This solution provides two tables you can work with. Their schemas are documented below. Data from each table is also accessible via Goldsky GraphQL.

With SQL Transforms, you can add additional tables. These tables are fully materialized tables that will be updated as each transaction is seen on the blockchain.

Table nft_balance

Schema

NameType
balancenumeric
contract_idtext
idtext, primary key, unique
token_idtext
wallettext

Table token_transfer

Schema

NameType
vidbigint
blockinteger
idtext
contract_idtext
token_idtext
totext
fromtext
timestampnumeric
typetext
valuenumeric, nullable
block_numbernumeric
transaction_hashtext
operatortext, nullable
Previous
Overview