<aside> 💡 Welcome aboard! You’ve landed on one of our evergreen education bounties - open for everyone at anytime.

</aside>

This particular guide is on creating on chain analysis on Minting NFTs and we’ll be using Galactic Punks NFT on Terra as our example. We take you on a step by step journey to look at the number of Galactic Punks minted, number who addresses who minted and finally, the distribution of addresses based on the number of punks minted.

At the end of this guide, we’ve included a challenge for you to apply what you’ve learnt to an NFT project of your choice. The estimated time to go through this bounty guide is 30 minutes - 1 hour.

First, we start with a sample transaction ID

For most cases, we would want to start with a transaction ID so that we can see how they look like in the tables. Different transaction types would show up differently in the tables.

• Before we begin, ensure that you have created an account over at https://app.flipsidecrypto.com/velocity and clicked on ‘NEW QUERY’.

Below is a sample transaction ID for the minting of Galactic Punks (GP) on the Random Earth marketplace:

• TX ID: A6A65A50E5AC8D150CA2C8387F97D0B004E2F18837033D59D81DEEEB86BAE987
• If we looked it up on ET Finder https://finder.extraterrestrial.money/mainnet/tx/A6A65A50E5AC8D150CA2C8387F97D0B004E2F18837033D59D81DEEEB86BAE987 , this is what we see:

• We see that in this single transaction ID, there are 3 events that took place, all on “reserving NFT” and sending Luna to a specific address.

We’ll deep dive further into this but for now, let’s query the transaction ID in the terra.msgs table.

1. Because we know the transaction ID, we can specify the line where tx_id = ....
2. For the terra.msgs table, the column with the most relevant information is usually the msg_value column. Hence, we can select to display only the msg_value column.
3. Note: To display all columns, simply use select * from terra.msgs.

select
msg_value
from terra.msgs 
where tx_id = 'A6A65A50E5AC8D150CA2C8387F97D0B004E2F18837033D59D81DEEEB86BAE987'

Fun fact: If you look at the left side panel, there is a Preview button to look a sample data for that table.