mcfemi6METRIC DAO ASS 2
Updated 2022-11-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
›
⌄
--NFT PLATFORM ON ETH HAD THE LOWEST NUMBER OF NFT SALES TRANSACTIONS IN OCTBER 2022
SELECT date_trunc('month', block_timestamp) "DATE", platform_name, count(distinct tx_hash) "Number of Tranactions"
FROM ethereum.core.ez_nft_sales
Where "DATE" between '2022-10-01' AND '2022-10-31'
group by 1,2
order by 3
--HOW MANY ENS MINT TRANSACTIONS TOOK PLACE IN OCTOBER 2022
SELECT date_trunc('month', block_timestamp) "DATE", count(distinct tx_hash) "Number of Tranactions"
FROM ethereum.core.ez_nft_MINTS
WHERE MINT_TOKEN_SYMBOL = 'ENS' AND "DATE" between '2022-10-01' AND '2022-10-31'
GROUP BY 1
--WHAT SUSHISWAP POOL HAD THE HIGHEST NUMBER OF TRANSACTIONS IN OCTOBER 2022
SELECT date_trunc('month', block_timestamp) "DATE", count(distinct tx_hash) "Number of Tranactions", pool_name
FROM ethereum.core.ez_dex_swaps
where platform = 'sushiswap' AND "DATE" between '2022-10-01' AND '2022-10-31'
group by 1,3
order by 2 desc
--HOW MANY UNIQUE ADDRESSES DOES THE "DIM_LABELS" TABLES ON FLIPSIDE CONTAIN
SELECT COUNT(DISTINCT ADDRESS)
FROM ETHEREUM.core.dim_labels
--IDENTIFY THE TOP 10 WALLETS THAT MINTED THE HIGHEST NUMBER OF NFTS IN OCTOBER 2022. HOW MANY TOTAL MINT TRANSCTIONS DID THESE WALLETS HAVE IN TEH SAME MONTH?
SELECT date_trunc('month', block_timestamp) "DATE", NFT_TO_ADDRESS, (NFT_COUNT) "NUMBER OF NFT MINTED"
FROM ethereum.core.ez_nft_MINTS
WHERE "DATE" between '2022-10-01' AND '2022-10-31'
GROUP BY 1, 2, 3
order by 3 desc
LIMIT 10
Run a query to Download Data