SELECT

BLOCK_TIMESTAMP,

TX_HASH,

NFT_TO_ADDRESS

FROM

polygon.nft.ez_nft_transfers

WHERE

NFT_ADDRESS = lower('0x436d5567f47e3723313a739d8cfb83d2acc35d15')

AND PROJECT_NAME = 'Squid Scholar'

AND INTRA_EVENT_INDEX = '1'

),

USDC_Transfers AS (

SELECT

TX_HASH,

AMOUNT_USD

FROM

polygon.core.ez_token_transfers

WHERE

SYMBOL = 'USDC'

AND TO_ADDRESS = lower('0xBd1979331AAd71A03c7A73CC1ef463605aFC9fd2')

SELECT

SUM(ut.AMOUNT_USD) AS TotalUSD

FROM

SquidSchool s

JOIN

USDC_Transfers ut ON s.TX_HASH = ut.TX_HASH;