with base as (

select

from_address

,to_address

,amount_precise

from ronin.core.ez_token_transfers

where 1=1

and block_timestamp > '2025-03-19'

--and tx_hash = '0x67dac46a1c1ad81bf77958a46cc8f35ec90f7f04efad84ec98ef9f78310bb687' --first deposit

and contract_address = '0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2' --LRON contract

),

transfers_in as (

select

to_address as user

,sum(amount_precise) as received

from base

where 1=1

group by user

),

transfers_out as (

select

from_address as user

,sum(amount_precise) as sent

from base

where 1=1

group by user

),

balance as (

select

user

,coalesce(sent, 0) sentt

,coalesce(received, 0) receivedd