[CONTRIBUTION] stablecoin_blacklist_events (USDT/USDC/PYUSD, ETH+Arb)

[beetle-new]

Summary

I’d like to add a new spell that unifies blacklist, unblacklist, and destroy events for USDT, USDC, and PYUSD on Ethereum and Arbitrum into a single table. This will make it easier to track sanctions-style events and downstream address status across these major stablecoins.

Subproject

• Proposed subproject: daily_spellbook

Details

• Blockchains: ethereum, arbitrum
• Tokens: USDT, USDC, PYUSD
• Data sources:
  • tether_ethereum.tether_usd_evt_addedblacklist
  • tether_ethereum.tether_usd_evt_removedblacklist
  • tether_ethereum.tether_usd_evt_destroyedblackfunds
  • tether_arbitrum.arbitrumextension_evt_blockplaced
  • tether_arbitrum.arbitrumextension_evt_destroyedblockedfunds
  • usdc_mk_v1_ethereum.fiattokenv2_1_evt_blacklisted
  • usdc_mk_v1_ethereum.fiattokenv2_1_evt_unblacklisted
  • circle_arbitrum.fiattokenv2_2_evt_blacklisted
  • circle_arbitrum.fiattokenv2_2_evt_unblacklisted
  • paypal_pyusd_ethereum.pyusdimplementation_evt_addressfrozen
  • paypal_pyusd_ethereum.pyusdimplementation_evt_addressunfrozen
  • paypal_arbitrum.pyusd_evt_freezeaddress
• Output granularity: one row per blacklist-related event
• Primary key suggestion: (blockchain, tx_hash, event_type, address)

Community benefit

• Centralizes blacklist-style events for major centralized stablecoins.
• Useful for compliance, investigations, and monitoring blacklist churn across chains.
• Can be reused by many dashboards instead of recreating the same unions per query.

Example usage

• SELECT * FROM spellbook.daily_spellbook.stablecoin_blacklist_events WHERE address = 0x...
• Aggregate per address to derive latest status, total destroyed amounts, etc.