-- count(distinct origin_from_address) as num_user,

-- count(distinct tx_hash) as tx_cnt,

-- sum(amount) as total_stake,

-- sum(amount_usd) as total_stake_usd,

-- min(block_timestamp),

-- min(amount) as min_eth,

-- min(amount_usd) as min_usd,

-- max(amount) as max_eth,

-- max(amount_usd) as max_usd,

-- avg(amount) as avg_eth,

-- avg(amount_usd) as avg_usd,

-- median(amount) as med_eth,

-- median(amount_usd) as med_usd

*

-- block_timestamp::date as date,

-- tx_hash,

-- origin_from_address as address,

-- amount,

-- amount_usd

from

ethereum.core.ez_eth_transfers

where 1=1

-- and origin_to_address = lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58')

-- and not identifier = 'CALL_ORIGIN'

and tx_hash = '0xa7094feed683cbff21a79bd410c6305008be125fbadbd7d3496c79ed7c8652f3'

-- block_timestamp < CURRENT_DATE

and eth_to_address = lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58')

-- and (eth_from_address in ('0x3bdc69c4e5e13e52a65f5583c23efb9636b469d6', '0xae78736cd615f374d3085123a210448e74fc6393')

-- or origin_from_address in ('0x3bdc69c4e5e13e52a65f5583c23efb9636b469d6', '0xae78736cd615f374d3085123a210448e74fc6393'))

order by

block_timestamp desc