nft_mints as (

SELECT

a.tx_hash,

a.block_timestamp,

a.block_number,

'nft_mints' as source,

a.event_type,

CONCAT(a.nft_address, '_', a.tokenid) as nft_id,

a.project_name,

a.nft_address,

a.tokenid,

a.erc1155_value,

a.nft_from_address,

a.nft_to_address,

'ETH' as currency_symbol,

a.mint_price_eth as price,

a.mint_price_usd as price_usd

FROM

ethereum.core.ez_nft_mints a

WHERE

a.nft_address = {{address}}

AND a.block_timestamp > {{start_date}}

AND a.block_timestamp < {{end_date}}

),

nft_sales as (

SELECT

b.tx_hash,

b.block_timestamp,

b.block_number,

'nft_sales' as source,

b.event_type,

CONCAT(b.nft_address, '_', b.tokenid) as nft_id,

b.project_name,

b.nft_address,

b.tokenid,