count(origin_from_address) as bridgors_count,

count(distinct tx_hash) as number_of_transactions,

date_trunc('day', block_timestamp::date) as TIME,

sum(event_inputs:amount)/pow(10,18) as eth_volume

from ethereum.core.fact_event_logs

where origin_to_address = lower('0xb8901acB165ed027E32754E0FFe830802919727f')

and event_name = 'TransferSentToL2'

and event_inputs:chainId = '137'

and block_timestamp > CURRENT_DATE - 90

group by TIME

order by eth_volume DESC