Office Hours Week 1

metricsdaoOffice Hours Week 1

Updated 2023-01-13

-- 9. Which token contract does the first Ethereum transaction of 2023 sent from the address 0xe2c25d061d632b166f74f04fbdeba838966caea2 involve?This question is required. *

-- Hint: on Flipside, use the ethereum.core.fact_transactions table.

-- Don't forget to set a LIMIT 1 on your query results (for this question no requirement to order by nonce or position).

-- Then look up the transaction hash on Etherscan!

-- select *

-- from ethereum.core.fact_transactions

-- where block_timestamp::date = '2023-01-01'

-- and from_address = lower('0xe2c25d061d632b166f74f04fbdeba838966caea2')

-- order by block_timestamp

-- limit 1

-- 10. On which date did this a16z wallet 0x05E793cE0C6027323Ac150F6d45C2344d28B6019 conduct its last transaction of 2022 on Ethereum?This question is required. *

-- Hint: on Flipside, use the ethereum.core.fact_transactions table

-- select *

-- from ethereum.core.fact_transactions

-- where

-- from_address = lower('0x05E793cE0C6027323Ac150F6d45C2344d28B6019')

-- and block_timestamp::date < '2023-01-01'

-- order by block_timestamp desc

-- limit 1

-- 11. How many NFT mints occurred in block number 14666971 on Ethereum?This question is required. *

-- Hints: Use the ethereum.core.ez_nft_mints table on Flipside.

-- For this question, consider each row to be a separate NFT mint.

-- select count(*)

-- from ethereum.core.ez_nft_mints

-- where block_number = '14666971'

-- 12. How many unique decentralized exchange labels does Flipside Ethereum data contain?This question is required. *

-- Hint: Use the ethereum.core.dim_labels table on Flipside

-- select count(distinct label)

-- from ethereum.core.dim_labels

-- where label_type = 'dex'

-- 13. What is the address label for the following address - 0x8484Ef722627bf18ca5Ae6BcF031c23E6e922B30 ?This question is required. *

Run a query to Download Data

flipside

flipside