WITH ethereum AS(

SELECT

block_timestamp::date AS timestamp,

tx_hash,

origin_from_address AS wallet_address,

(CASE

WHEN event_name = 'Withdraw' THEN -decoded_log:value * POW(10, -18)

WHEN event_name = 'Deposit' THEN decoded_log:value * POW(10, -18)

END

) AS supply,

TO_TIMESTAMP(decoded_log:locktime)::date AS lock_time,

TIMEDIFF('month',timestamp,lock_time) AS lock_monthes,

'Ethereum' AS label

FROM

ethereum.core.ez_decoded_event_logs

WHERE

contract_name = 'veSTG'

AND event_name in ('Deposit','Withdraw')

ORDER BY block_timestamp DESC

),

optimism AS (

SELECT

block_timestamp::date AS timestamp,

tx_hash,

origin_from_address AS wallet_address,

(CASE

WHEN event_name = 'Withdraw' THEN -decoded_log:value * POW(10, -18)

WHEN event_name = 'Deposit' THEN decoded_log:value * POW(10, -18)

END

) AS supply,

TO_TIMESTAMP(decoded_log:locktime)::date AS lock_time,

TIMEDIFF('month',timestamp,lock_time) AS lock_monthes,

'Optimism' AS label

FROM

optimism.core.ez_decoded_event_logs