nft_tx AS (

SELECT DISTINCT

A.DAY,

A.TX_HASH,

A.CONTRACT,

A.SELLER,

A.BUYER,

A.NFT_ID,

B.MARKETPLACE,

B.PRICE / POW(10, 18) AS PRICE,

B.ROYALTY / POW(10, 18) AS ROYALTY

FROM

(

SELECT

DATE_TRUNC('DAY', TIMESTAMP) AS DAY,

TX_HASH,

CONTRACT,

PARAMETERS[0]:"value" AS SELLER,

PARAMETERS[1]:"value" AS BUYER,

PARAMETERS[2]:"value" [0]:"value" AS NFT_ID

FROM

external.tokenflow_starknet.decoded_events

WHERE

CHAIN_ID = 'mainnet'

AND NAME = 'Transfer'

AND SELLER != '0'

) A

INNER JOIN (

SELECT DISTINCT

P.TX_HASH,

R.MARKETPLACE,

R.NFT_CONTRACT,

P.PRICE,

R.ROYALTY,

P.NFT_ID