flipside

    srtwingo | Flipside Analyst

    srtwingo

    Joined Mar 18, 2023
    //
    0Upvotes
    @romaro_twingo romario_twingo#0737
    DashboardsQueries
    Query
    Metrics_DAO_view_01
    ethereumethereum
    nft
    evm
    MAO_Having_week_example
    ethereumethereum
    nft
    evm
    fact_event_logs
    ethereumethereum
    evm
    ethereum_begginer ex02
    sushisushi
    curvecurve
    ethereumethereum
    uniswap
    evm
    Metrics_DAO_view_03
    ethereumethereum
    nft
    evm
    2023-04-06 02:21 PM
    ethereumethereum
    nft
    evm
    MDAO_Identify the top 10 wallets that minted the highest number of NFTs in July 2022. How many total mint transactions did these wallets have in the same month? Hint: use the ethereum.core.ez_nft_mints table
    ethereumethereum
    nft
    evm
    json_output_03
    ethereumethereum
    evm
    MDAO-How many ENS (Ethereum Name Service) mint transactions took place in July 2022? Hint: use the ethereum.core.ez_nft_mints table copy
    ethereumethereum
    nft
    evm
    What Sushiswap pool had the highest number of transactions in July 2022? Hint: use the ethereum.core.ez_dex_swaps table
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    ethereum_begginer_ex04 join copy
    sushisushi
    curvecurve
    ethereumethereum
    uniswap
    evm
    What was the average gas price on Ethereum in July 2022? Hint: Use the ethereum.core.fact_transactions table
    ethereumethereum
    evm
    json_output_02
    ethereumethereum
    evm
    MAO_Having_example
    ethereumethereum
    nft
    evm
    ethereum_begginer_ex04 join copy copy
    sushisushi
    curvecurve
    ethereumethereum
    uniswap
    evm
    MAO-GroupByExample
    ethereumethereum
    nft
    evm
    Chart the daily transaction volume using the ethereum.core.ez_nft_sales table for July 2022. How is transaction volume trending? Hint: Use flipside's ethereum.core tables
    ethereumethereum
    nft
    evm
    MDAO:What NFT platform on Ethereum had the second highest number of NFT sales transactions in July 2022?
    ethereumethereum
    nft
    evm
    ethereum_begginer_ex03 json
    ethereumethereum
    evm
    Ethereum_begginer EX01
    ethereumethereum
    evm
    MDAO-How many ENS (Ethereum Name Service) mint transactions took place in July 2022? Hint: use the ethereum.core.ez_nft_mints table
    ethereumethereum
    nft
    evm
    Comparin Two swaps pools
    sushisushi
    curvecurve
    ethereumethereum
    uniswap
    evm
    json_output
    ethereumethereum
    evm
    In July 2022, how many times (days) was the daily average gas price on Ethereum lower than 15 Gwei? Hint: Use the ethereum.core.fact_transactions table
    ethereumethereum
    evm
    Bounty Begginer: WBTC-WETH pool on Sushiswap from April 1 - April 15, 2022
    sushisushi
    curvecurve
    ethereumethereum
    uniswap
    evm
    Which of the 4 months below had the lowest number of transactions on Ethereum
    ethereumethereum
    evm