SELECT

block_timestamp,

tx_hash,

depositor,

vault,

token_deposited,

symbol,

amount_deposited

FROM

ethereum.maker.ez_deposits

WHERE

1 = 1

AND symbol = 'WETH'

LIMIT 100

),

deposit_with_amount AS (

SELECT

d.block_timestamp,

d.tx_hash,

d.depositor,

d.vault,

d.token_deposited,

d.symbol,

t.amount,

t.amount_usd,

t.origin_function_signature,

t.from_address,

t.to_address

FROM

smpl_maker_deposit AS d

LEFT JOIN (

SELECT

*

FROM