SELECT

DATE_TRUNC('day', block_timestamp) AS date,

signer_id AS user,

CASE

WHEN predecessor_id = 'nearnvidia.near' THEN args:amount / 1e8

WHEN predecessor_id = 'token.lonkingnearbackto2024.near' THEN args:amount / 1e8

WHEN predecessor_id = 'token.0xshitzu.near' THEN args:amount / 1e18

WHEN predecessor_id = 'gear.enleap.near' THEN args:amount / 1e18

WHEN predecessor_id = 'chill-129.meme-cooking.near' THEN args:amount / 1e18

WHEN predecessor_id = 'blackdragon.tkn.near' THEN args:amount / 1e24

WHEN predecessor_id = 'benthedog.near' THEN args:amount / 1e9

WHEN predecessor_id = 'gp.token0.near' THEN args:amount / 1e18

WHEN predecessor_id = 'bean.tkn.near' THEN args:amount / 1e18

WHEN predecessor_id = 'kat.token0.near' THEN args:amount / 1e18

END AS adjusted_amount,

-- Token name mapping

CASE

WHEN predecessor_id = 'nearnvidia.near' THEN 'nearnvidia'

WHEN predecessor_id = 'token.lonkingnearbackto2024.near' THEN 'lonk'

WHEN predecessor_id = 'token.0xshitzu.near' THEN 'shitzu'

WHEN predecessor_id = 'gear.enleap.near' THEN 'gear'

WHEN predecessor_id = 'chill-129.meme-cooking.near' THEN 'chill'

WHEN predecessor_id = 'blackdragon.tkn.near' THEN 'blackdragon'

WHEN predecessor_id = 'benthedog.near' THEN 'bendog'

WHEN predecessor_id = 'gp.token0.near' THEN 'GP'

WHEN predecessor_id = 'bean.tkn.near' THEN 'bean'

WHEN predecessor_id = 'kat.token0.near' THEN 'kat'

END AS token_name

FROM near.core.fact_actions_events_function_call

WHERE method_name = 'ft_on_transfer'

AND receiver_id = 'meme-farming_011.ref-labs.near'

AND receipt_succeeded = 1

AND block_timestamp >= '2024-10-01'

),