Query editor
-- Collector Crypt CARDS buybacks vs daily fees-- Fee definition follows the DefiLlama collector-crypt adapter (Solana only)-- Buyback bot: 3nGNwiz1qevPjhEoQi1dLj16oTkjmbevTnpV9piWY7Kq (active since 2026-04-19)-- A tx counts as a buyback when USDC leaves the bot AND CARDS arrives in the same tx-- Change DATE '2026-04-19' throughout to widen the window (fees exist from 2025-06-04)WITH team AS (SELECT wallet FROM (VALUES('BAxTk97HsaJqbnbFmTiQTaL4KSRvJ8Y65ArZCsP6vA5M'),('21KhtC7y2JGYvwc8dcGqTdbrudbM8fgMPJsVwxRQqdY8'),('DFEstpYN3fsz93AC9v2ujzPPngPgodqH2xxopuyfSsAE'),('HW2HRqN1pXQGH9GfP9xet4XwqtLqFyYGDNRKjUAVgh9u'),('HighJBfnAaqH9cKkeMErQFJZ4ATxQJwxqFupX6zaKTns'),('LGNDXqcm6U57QQ6Ad7icZ6oizkAVKRWrw97KwZy5nVf'),('EpicWWZspT1trKndbDDr29ULViN56rN5vofWSKZp8ePF'),('Mid9NeCpPNxP59fAdsLgMLy7BYexxXFw52ZP58Jrney'),('Lowq9dkpY43VpjfYeRjtKfGA6JtB7HaMmwQgXkjHLvN'),('Low6UekJP3QrFVMfNRTL8CPK2SiGFhvp57sgF2pkmVu'),('miDtj3vgdxVykHzRyFwyG8MXpvK8eQqamSLVdBr7WPt'),('HiGHqwYddP5N2waqUmXPdaASpMpUEvfqPr2fSawctEb'),('epiC3zkqa1RfcPMMM1Kc8m3GZGDwF2RmjbfA3g1BBjn'),('LGNDfXQFMiRMz3qqTNAREmRFQutMvazqqRrzn5i98uj'),('SPrT7eFrCM9UJ4j7Xf9iktKCoBwJjfykFbiNbRsKQm8'),('Cc4pHGnoaRWL1WnHsV517T3YvQn5gLDBMiuVXkF9rZhK'),('8373hLiAEXxaJ3oV7SRzx4KHwurEg9rEG98tUPj1sdtX'),('onePMfirJs2Rx3eixoPnjY6NHiaC74pkQ2k313K2Lxs'),('SportGmqffp9zC3VZV7Wwz6s2nCkEB5Q3nVwKGU4esD'),('DQPERZ9e86pNJ4mhUnCEP8V75yxZofsipoVrRWT5Wdxd'),('cc3novbXuNSe292qKH2gGhxToaWjuBvJbA7zQf8NVxi'),('GachaNgyXTU3zFogQ8Z5jR2BLXs8215X2AtEH18VxJq3'),('GachazZscHZ5bn3vnq1yEC4zpYdhAYJBzuKJwSJksc9z'),('96DULv1BqYfe5wyMr6pVUNC6Uyrtj6yr3tNi6VtfwW9s'),('jrS7Pbn38wKiPsXbyNhGCr3icfXuJxdytZr1N4TwdFu'), -- CC bot wallet('3nGNwiz1qevPjhEoQi1dLj16oTkjmbevTnpV9piWY7Kq') -- buyback bot) AS t(wallet)),-- 1. Gacha / royalty USDC flows, one scan of USDC transfersusdc_daily AS (SELECTt.block_date AS day,-- On-chain pack sales: non-team USDC into the gacha sinksSUM(CASE WHEN t.to_owner IN ('GachazZscHZ5bn3vnq1yEC4zpYdhAYJBzuKJwSJksc9z','GachaNgyXTU3zFogQ8Z5jR2BLXs8215X2AtEH18VxJq3')AND tf.wallet IS NULLTHEN CAST(t.amount AS double) ELSE 0 END) / 1e6 AS pack_sales_onchain,-- Fiat / credit-card rail: non-team USDC into the fiat wallet (bundled top-ups)SUM(CASE WHEN t.to_owner = '96DULv1BqYfe5wyMr6pVUNC6Uyrtj6yr3tNi6VtfwW9s'AND tf.wallet IS NULLTHEN CAST(t.amount AS double) ELSE 0 END) / 1e6 AS pack_sales_fiat,-- Marketplace royalties: all USDC into the royalty wallet (adapter applies no team filter)SUM(CASE WHEN t.to_owner = 'DQPERZ9e86pNJ4mhUnCEP8V75yxZofsipoVrRWT5Wdxd'THEN CAST(t.amount AS double) ELSE 0 END) / 1e6 AS royalties,-- Pack sell-back payouts: USDC from the gacha sinks to non-team walletsSUM(CASE WHEN t.from_owner IN ('GachazZscHZ5bn3vnq1yEC4zpYdhAYJBzuKJwSJksc9z','GachaNgyXTU3zFogQ8Z5jR2BLXs8215X2AtEH18VxJq3')AND tt.wallet IS NULLTHEN CAST(t.amount AS double) ELSE 0 END) / 1e6 AS pack_buyback_payouts,-- Buyback bot funding: USDC from the gacha sinks to the botSUM(CASE WHEN t.from_owner IN ('GachazZscHZ5bn3vnq1yEC4zpYdhAYJBzuKJwSJksc9z',