Updated 2023-04-13
    with
    avg as
    (SELECT
    sum(PRICE) as volume ,avg(PRICE) as prices , ' avg prices' as title , BLOCK_TIMESTAMP::date as date
    FROM ethereum.core.ez_nft_sales
    WHERE EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and LOWER(NFT_ADDRESS)=lower('0x960b7a6bcd451c9968473f7bbfd9be826efd549a')
    group by date,title)
    ,
    max as
    (SELECT
    sum(PRICE) as volume ,max(PRICE) as prices , 'max prices'as title , BLOCK_TIMESTAMP::date as date
    FROM ethereum.core.ez_nft_sales
    WHERE EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and LOWER(NFT_ADDRESS)=lower('0x960b7a6bcd451c9968473f7bbfd9be826efd549a')
    group by date,title)
    ,
    min as
    (SELECT
    sum(PRICE) as volume ,min(PRICE) as prices , 'min prices' as title , BLOCK_TIMESTAMP::date as date
    FROM ethereum.core.ez_nft_sales
    WHERE EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and LOWER(NFT_ADDRESS)=lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')
    group by date,title)
    select * from avg
    union
    select * from min
    union
    select * from max








    Run a query to Download Data