mcfemi6METRIC DAO QUIZ
Updated 2022-11-23
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
›
⌄
--What is the address label for the following address 0x8484Ef722627bf18ca5Ae6BcF031c23E6e922B30
SELECT address_name, label_type, label, label_subtype
FROM ethereum.core.dim_labels
where address = lower('0x8484Ef722627bf18ca5Ae6BcF031c23E6e922B30')
--What are the number of swap transactions that took place on uniswap-v2 in october 2022
SELECT count (tx_hash), count(DISTINCT tx_hash)
from ethereum.core.ez_dex_swaps
where block_timestamp::DATE BETWEEN '2022-10-01' AND '2022-10-31' AND Platform = 'uniswap-v2'
--How many NFT sale took place on Opensea in October 2022
SELECT count(tx_hash), count(distinct tx_hash)
FROM ethereum.core.ez_nft_sales
where PLATFORM_NAME = 'opensea' AND EVENT_TYPE = 'sale'AND block_timestamp::DATE BETWEEN '2022-10-01' AND '2022-10-31'
--How many wallets were active on ethereum in October 2022
SELECT count(from_address), count(DISTINCT from_address)
from ethereum.core.fact_transactions
where block_timestamp::DATE BETWEEN '2022-10-01' AND '2022-10-31'
--How many transactions took place on ethereum in October 2022
SELECT count(tx_hash), count(DISTINCT tx_hash)
from ethereum.core.fact_transactions
where block_timestamp::DATE BETWEEN '2022-10-01' AND '2022-10-31'
Run a query to Download Data