Web3 Analytics 101 - Segment 3 - Weekly Quiz

odin-krmWeb3 Analytics 101 - Segment 3 - Weekly Quiz

Updated 2022-12-01

-- What NFT platform on Ethereum had the lowest number of NFT sales transactions in October 2022?

-- SELECT

-- platform_name AS "platform", count(distinct tx_hash) as "Number of Transactions"

-- FROM ethereum.core.ez_nft_sales

-- WHERE block_timestamp::DATE BETWEEN '2022-10-1' AND '2022-10-31' and event_type = 'sale'

-- GROUP BY "platform"

-- ORDER BY "Number of Transactions";

-- How many ENS (Ethereum Name Service) mint transactions took place in October 2022?

-- SELECT COUNT(DISTINCT tx_hash) as "Number of Transactions"

-- FROM ethereum.core.ez_nft_mints

-- WHERE block_timestamp::DATE BETWEEN '2022-10-1' AND '2022-10-31'

-- and event_type = 'nft_mint'

-- and nft_address=lower('0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85') ;

-- What Sushiswap pool had the highest number of transactions in October 2022?

-- SELECT COUNT(DISTINCT tx_hash) as "Number of Transactions", pool_name AS "Pool Name"

-- FROM ethereum.core.ez_dex_swaps

-- WHERE block_timestamp::DATE BETWEEN '2022-10-1' AND '2022-10-31'

-- and platform = 'sushiswap'

-- GROUP BY "Pool Name"

-- order BY "Number of Transactions" DESC;

-- How many unique addresses does the "DIM_LABELS" table on Flipside contain?

-- SELECT COUNT(DISTINCT address) as "Unique Addresses"

-- FROM ethereum.core.dim_labels

-- Identify the top 10 wallets that minted the highest number of NFTs in October 2022. How many total mint transactions did these wallets have in the same month?

WITH top_addresses AS (SELECT nft_to_address AS "Wallet Address", COUNT(DISTINCT tx_hash) AS "Number of Transactions"

FROM ethereum.core.ez_nft_mints

WHERE block_timestamp::DATE BETWEEN '2022-10-1' AND '2022-10-31'

GROUP BY "Wallet Address"

HAVING "Number of Transactions" >800 )

SELECT sum("Number of Transactions") AS "Total" FROM top_addresses

Run a query to Download Data

flipside

flipside