Yousefi_1994Common platforms for NFT sales by Metamask users
    Updated 2022-06-26
    with metamask_wallet_address_list as (
    select
    distinct origin_from_address as user_address
    from ethereum.core.ez_dex_swaps
    where origin_to_address= '0x881d40237659c251811cec9c364ef91dc08d300c'
    and origin_function_signature = '0x5f575529'
    group by user_address
    )

    select
    block_timestamp::date as days,
    platform_name,
    count(distinct tx_hash) as number_of_tx
    from ethereum.core.ez_nft_sales
    where seller_address in (select user_address from metamask_wallet_address_list)
    group by days, platform_name
    Run a query to Download Data