block_timestamp,

tx_hash,

origin_from_address AS Borrower,

symbol,

event_inputs:value/power(10,decimals) AS amount,

(event_inputs:value/power(10,decimals))*PRICE AS USD_amount

from optimism.core.fact_event_logs inner join

optimism.core.fact_hourly_token_prices on

contract_address = token_address and date_trunc('HOUR', block_timestamp)=HOUR

where EVENT_NAME='Transfer' and event_inputs:to=origin_from_address

and origin_to_address = lower('0x794a61358d6845594f94dc1db02a252b5b4814ad')

and origin_function_signature = '0xd5eed868')

select

borrower,

sum(USD_amount) AS borrow_amount

from tab1

group by 1 order by 2 desc limit 20