WITH mints AS (

SELECT

distinct case when xx.event_resource='TransferEvent' then xx.event_data:to end AS holder,

count(distinct case when x.event_resource='Mint' then x.event_data:index:value end) AS total_mints

FROM aptos.core.fact_events x

join aptos.core.fact_events xx on x.tx_hash=xx.tx_hash

join aptos.core.fact_events y on x.tx_hash=y.tx_hash

where date_trunc('day',x.block_timestamp)>'2025-05-01' and x.event_resource='Mint' and x.event_module='collection' and xx.event_resource='TransferEvent' and y.event_resource='DepositEvent'

and x.event_data:collection='0x94a3ca2ac92e61d3c91cf1873e88d9195c1103d242caaf2ee3eb08fb6aa4939a'

GROUP BY

holder

),

buys AS (

SELECT

BUYER_ADDRESS AS holder,

COUNT(distinct tokenid) AS total_buys

FROM

aptos.nft.ez_nft_sales

WHERE

PROJECT_NAME ilike '%Penguin Chronicles%'

GROUP BY

holder

),

sells AS (

SELECT

SELLER_ADDRESS AS holder,

COUNT(distinct tokenid) AS total_sells

FROM

aptos.nft.ez_nft_sales

WHERE

PROJECT_NAME ilike '%Penguin Chronicles%'

GROUP BY

holder

),

holder_nfts AS (