marketplace_label AS ( -- Get Labels for NFT Transfers

SELECT

program_id as program_id_label,

marketplace as marketplace_label,

count(distinct tx_id) as tx_Count

FROM

solana.core.fact_nft_sales

WHERE

SUCCEEDED = TRUE

AND block_id >= 151881904

GROUP BY

1,

2

),

nft_sol_transfers AS ( -- Filter out Hadeswap Transfers -- spl and Sol

SELECT

*

FROM

solana.core.fact_transfers

WHERE

tx_id IN (

SELECT distinct

tx_id

FROM

solana.core.fact_nft_sales

WHERE

1 = 1

AND SUCCEEDED = TRUE

AND program_id = 'hadeK9DLv9eA7ya5KCTqSvSvRZeJC3JgD5a9Y3CNbvu'

AND block_id >= 151881904 -- First block for Hadeswap Transactions

)

),

NFT_TRANSFERS AS ( -- Find NFT Transfers for Hadeswap Transactions

SELECT

tx_id as tx_id0,