SELECT * FROM (

VALUES

('Bean V2', '#968a27'), -- Orange

('Uniswap V2', '#fa25f1'), -- Blue

('Ambient Finance', '#e10423'), -- Green

('Monorail Aggregator', '#baec70'), -- Yellow

('Bean Exchange', '#188657'), -- Purple

('Personal wallets', '#e3066a') -- Grey

) AS t(label, color)

),

fantasy_players AS (

SELECT DISTINCT '0x'||SUBSTRING(TOPICS[1], 27) AS wallet

FROM monad.testnet.fact_event_logs

WHERE

contract_address IN (

lower('0x9077D31A794D81c21b0650974d5F581F4000CD1a'),

lower('0x04edB399CC24a95672BF9B880EE550dE0b2D0B1e'),

lower('0xfA4D5a9ceA2822BA08d0266F121011aC527ced64')

)

AND tx_succeeded = 'true'

AND block_timestamp < '2025-03-12 19:27:00' -- Before upgrade

),

fusd_transfers AS (

SELECT

'0x'||SUBSTRING(TOPICS[1], 27) AS sender_wallet,

'0x'||SUBSTRING(TOPICS[2], 27) AS receiver_wallet,

CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 AS fusd_amount,

block_timestamp

FROM monad.testnet.fact_event_logs

WHERE

topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

AND contract_address = lower('0xBb444821e159dd6401bb92FB18C2Ac0A37113025') -- FUSD contract

AND tx_succeeded = 'true'

AND block_timestamp >= '2025-03-12 23:51:00' -- After maintenance

),