with t0 as (

select

fe.block_timestamp,

fe.tx_hash as tx_id,

1 as action_count,

LOWER(sender_id) as address,

1 as quest_step,

'NEAR' as currency,

amount_usd as usd_amount,

case when usd_amount > 100000000 then usd_amount / ap.price / pow(10,12)

else usd_amount / ap.price

end as token_amount,

TRUE as valid,

coalesce(tx.gas_used * ap.price / pow(10, 16), 0) as fee_amount

FROM near.defi.ez_lending fe

left join near.core.fact_transactions tx

on fe.tx_hash = tx.tx_hash

LEFT JOIN (

select

*

from

NEAR.PRICE.EZ_PRICES_HOURLY

where

token_Address = 'wrap.near'

) ap ON date_trunc('hour', ap.hour) = date_trunc('hour', fe.block_timestamp)

fe.platform = 'burrow'

and fe.actions in ('increase_collateral', 'deposit', 'deposit_to_reserve')

and tx.tx_succeeded = TRUE

and fe.token_address in ('usdt.tether-token.near', '17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1', '853d955acef822db058eb8505911ed77f175b99e.factory.bridge.near')

-- and fe.block_timestamp > current_Date - 10