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
COUNT(all_transactions.TX_HASH) AS number_of_sales,
SUM(all_transactions.ETH_VALUE) AS volume,
SUM(all_transactions.TX_FEE) AS fees
FROM
all_transactions
INNER JOIN