first_yeetard_transaction AS (

SELECT MIN(block_timestamp) AS first_transaction_time

FROM arbitrum.nft.ez_nft_transfers

WHERE nft_address = '0x2e660787bceccd39f67b8190a5bc4fc3ad3b64f7' -- Yeetards

),

nft_transfer AS (

-- Negative transfer for sending tokens

SELECT

DATE_TRUNC('day', block_timestamp) AS day,

nft_from_address AS holder,

-COUNT(1) AS token_change,

nft_address

FROM

arbitrum.nft.ez_nft_transfers

CROSS JOIN first_yeetard_transaction fyt

WHERE

nft_address = '0x2e660787bceccd39f67b8190a5bc4fc3ad3b64f7' --Yeetards

OR

nft_address = lower('0xAF2A7Da72eb8bFC1c6A0B6b0217037E1C7eA8548') --BigFat

OR

nft_address = lower('0x136798606E85fb4086001AB065e5298fa0c37904') --Smilee

OR

nft_address = lower('0x3F979DDe509D2aedC99E9159f40e0D0D3E9DdB56') --Aut

OR

nft_address = lower('0x648cc6AbCf7fe24afb76E6c15CDd9DfB41e9BcdB') --Cub

OR

nft_address = lower('0x7c2f99C405fa3102519F2637f186C5A06C074a0F') --Honey

AND block_timestamp >= fyt.first_transaction_time -- Filter by first Yeetard transaction time

GROUP BY

1, 2, 4

UNION ALL

-- Positive transfer for receiving tokens

SELECT