Moonbirds Bounties (Unique Buyers and Sellers)

Description of work: To address this question, we use the ethereum schema to achieve the results. The first step is to extract the list of contracts related to the Moon Birds project from the nft_metadata table. The second step is to review these contracts on nft_events, which we filter based on event_type = 'sale', and finally extract the list of unique buyers and sellers at intervals.

1- All unique buyers and sellers address in the Moonbirds

In this section, we extract the list of unique addresses of sellers and buyers on Moon Birds First, we extract the list of Moon Birds contracts from the nft_metadata table -> where: project_name = 'Moonbirds' and contract_name = 'MOONBIRD' and creator_name = 'Moonbirds'

Then in the nft_events table we filter the list of unique addresses of buyers and sellers based on event_type = 'sale' which are related to the Moon Birds contract.

2- Number of unique buyers and sellers in the last three months

In the section, we extract the number of unique buyers and sellers who have participated in the contract related to Moon Birds in the last three months. To address this section, first, we extract the list of Moon Birds contracts from the nft_metadata table -> where: project_name = 'Moonbirds' and contract_name = 'MOONBIRD' and creator_name = 'Moonbirds'

Then in the nft_events table we filter the number of unique of buyers and sellers based on event_type = 'sale' which are related to the Moon Birds contract and has been done in last three months. Then we group according to days

3- Unique buyers and sellers by month

In the section, we extract the number of unique buyers and sellers who have participated in the contract related to Moon Birds and group them by month To address this section, first, we extract the list of Moon Birds contracts from the nft_metadata table -> where: project_name = 'Moonbirds' and contract_name = 'MOONBIRD' and creator_name = 'Moonbirds'

Then in the nft_events table we filter the number of unique of buyers and sellers based on event_type = 'sale' which are related to the Moon Birds contract and has been done after'2022-01-01'. Then we group according to month

Conclusion