piperBased Rekt Chickens Mint - Mint price and fees
    Updated 2023-08-13
    WITH all_txs AS (
    SELECT
    TX_HASH
    FROM
    base.core.fact_event_logs
    WHERE
    ORIGIN_TO_ADDRESS = lower('0x07f4ae64f236eacf81b4d798f0c6daf9d29e9cf3')
    AND
    CONTRACT_ADDRESS = lower('0xc16706ae5eed1805990d92241add1662724e50f2')
    )

    SELECT
    SUM(ETH_VALUE) AS total_eth,
    SUM(TX_FEE) AS total_fees,
    total_eth/100 AS nft_price,
    total_fees/(SELECT count(DISTINCT(TX_HASH)) FROM all_txs) AS avg_fee
    FROM
    base.core.fact_transactions
    WHERE
    TX_HASH IN (SELECT TX_HASH FROM all_txs)
    Run a query to Download Data