select block_timestamp,

tx_hash,

decoded_log:token as token_in,

token_address,

decoded_log:amount as raw_amount,

price,

decimals,

decoded_log:amount*price/pow(10,decimals) as amountUSD,

from ethereum.core.ez_decoded_event_logs a

left join ethereum.price.ez_prices_hourly p

on decoded_log:token = token_address and date_Trunc('hour',block_timestamp) = hour

where event_name = 'Deposit'

and contract_address = '0xa1e2481a9cd0cb0447eeb1cbc26f1b3fff3bec20'

and block_timestamp::date = '2025-01-14'

by amountUSD desc