select

tx_hash

,block_timestamp

,origin_from_address

,utils.udf_hex_to_int(right(data, 64))::int / 1e18 as LRON_amount

,iff(origin_to_address = '0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2', 'Scrow contract', origin_to_address) as origin_to_address --0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2 scrow contract

from ronin.core.fact_event_logs

where 1=1

and block_timestamp > '2025-03-19'

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

and contract_address = '0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2' --LRON contract

and topic_0 = '0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7' --deposit topic

count(distinct origin_from_address) as stakers

,count(distinct tx_hash) as deposits

,sum(lron_amount) as deposit_volume

,avg(lron_amount) as avg_deposit

,median(lron_amount) as median_deposit

,max(lron_amount) as max_deposit

,min(lron_amount) as min_deposit

from deposits