flipside

    Highest price
    piperHighest price
    WITH all_transactions AS (
    SELECT
    BLOCK_TIMESTAMP,
    TX_HASH,
    ETH_VALUE,
    TX_FEE
    FROM
    base.core.fact_transactions
    WHERE
    TO_ADDRESS = lower('0x00000000000000adc04c56bf30ac9d3c0aaf14dc')
    AND
    ETH_VALUE > 0
    AND
    STATUS = 'SUCCESS'
    ),

    all_nft_transfers AS (
    SELECT
    TX_HASH,
    NFT_ADDRESS,
    PROJECT_NAME,
    NFT_FROM_ADDRESS,
    TOKENID
    FROM
    base.core.ez_nft_transfers
    WHERE
    NFT_ADDRESS = lower('0xc16706ae5eed1805990d92241add1662724e50f2')
    )

    SELECT
    MAX(all_transactions.ETH_VALUE) AS price
    FROM
    all_transactions
    INNER JOIN
    all_nft_transfers
    ON
    Run a query to Download Data