-- forked from Deebs-DeFi-I-Orbital-Command-j9fRbz / Single Protocol TX Count Arbitrum @ https://flipsidecrypto.xyz/Deebs-DeFi-I-Orbital-Command-j9fRbz/q/single-protocol-activity-arb-lGO2Rm
SELECT
FROM_ADDRESS,
count(DISTINCT TX_HASH)
FROM arbitrum.core.ez_token_transfers
WHERE CONTRACT_ADDRESS='0x912ce59144191c1204e64559fe8253a0e49e6548'
AND FROM_ADDRESS={{protocol_address}}
AND BLOCK_TIMESTAMP BETWEEN {{start_date}} AND {{end_date}}
Group BY 1
LIMIT 100