Office Hours Jan 20 2023

metricsdaoOffice Hours Jan 20 2023

Updated 2023-01-20

-- 9. How many transactions took place on Ethereum in October 2022?

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

-- 10. How many wallets were active on Ethereum in October 2022?This question is required. *

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

-- SELECT

-- count(tx_hash) as n_rows,

-- count(distinct tx_hash) as n_unique_tx,

-- count(from_address) as n_from_addresses,

-- count(distinct from_address) as n_unique_from_addresses

-- FROM ethereum.core.fact_transactions

-- WHERE DATE_TRUNC('month',block_timestamp) = '2022-10-01'

-- 11. How many NFT sales took place on Opensea in October 2022?This question is required. *

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

-- SELECT

-- count(*),

-- count(distinct tx_hash)

-- FROM ethereum.core.ez_nft_sales

-- WHERE platform_name = 'opensea'

-- AND DATE_TRUNC('month',block_timestamp) = '2022-10-01'

-- 12. What are the number of swap transactions that took place on Uniswap-v2 in October 2022?This question is required. *

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

-- select

-- count(tx_hash) as n_swaps,

-- count(distinct tx_hash) as n_distinct_txs

-- from ethereum.core.ez_dex_swaps

-- where DATE_TRUNC('month',block_timestamp) = '2022-10-01'

-- and platform = 'uniswap-v2'

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

-- select

-- count(distinct address)

-- from ethereum.core.dim_labels

Run a query to Download Data

flipside