flipside

    Session 1 Questions
    metricsdaoSession 1 Questions
    /*

    #1
    How many transactions took place on Ethereum in June 2022? Hint: use ethereum.core.fact_transactions table

    Ans - 31083501

    Query -

    select count(distinct tx_hash) as txs
    from ethereum.core.fact_transactions
    where
    date(block_timestamp) between '2022-06-01' and '2022-06-30'

    #2
    How many wallets were active on Ethereum in June 2022? Hint: use ethereum.core.fact_transactions table

    Ans - 4394906

    Query -
    select count(distinct from_address) as addresses
    from ethereum.core.fact_transactions
    where
    date(block_timestamp) between '2022-06-01' and '2022-06-30'

    #3
    How many successful NFT sales took place on Opensea in June 2022? Hint: use ethereum.core.ez_nft_sales table

    Ans - 1509559

    Query -

    #4
    What are the number of swap transactions that took place on Uniswap-v2 in June 2022? Hint: use ethereum.core.dex_swaps table

    Ans - 1058089
    Run a query to Download Data