zpencerETH-nft-helper
    Updated 2022-10-18
    -- select platform_name as marketplaces,
    -- platform_exchange_version,
    -- count(distinct tx_hash) as transactions,
    -- count(distinct nft_address) as collections,
    -- count(distinct tokenid) as nfts,
    -- count(distinct buyer_address) as buyers,
    -- count(distinct seller_address) as sellers,
    -- sum(price_usd) as volume,
    -- avg(price_usd) as price
    -- from
    -- ethereum.core.ez_nft_sales
    -- where
    -- block_timestamp::date between '2022-09-01' and '2022-09-30'
    -- and origin_function_signature = '0x9a2b8115'
    -- group by 1, 2

    select *
    from ethereum.core.ez_nft_sales
    where tx_hash = '0xfa7f95f9197c00589612f15b8da7f26402bdeef358838c50ecda9bed9baa978a'

    ;with txns as (
    select BLOCK_NUMBER, BLOCK_TIMESTAMP, PROJECT_NAME,
    TX_HASH, TOKENID, PRICE, CURRENCY_SYMBOL, PRICE_USD,
    ORIGIN_TO_ADDRESS, platform_name, platform_exchange_version, ORIGIN_FUNCTION_SIGNATURE,
    ROW_NUMBER() OVER(PARTITION BY tx_hash ORDER BY tokenid) as rownum
    from ethereum.core.ez_nft_sales
    where block_timestamp::date between '2022-09-17' and '2022-09-18'
    and origin_function_signature = '0x9a2b8115'
    and price_usd > 0
    and project_name != 'dreadfulz'
    and platform_name = 'sudoswap'
    )
    select *
    from txns
    where rownum > 1
    Run a query to Download Data