SELECT

tx_hash,

block_timestamp,

from_address,

to_address,

input,

output,

data,

'0x' || substr(input, 35, 40) AS "Wallet Address"

FROM

optimism.core.fact_traces

WHERE

(

INPUT ILIKE '0x1a378f0d%'

OR INPUT ILIKE '0xc2f04b0a%'

)

AND to_address = LOWER('0x45c55BF488D3Cb8640f12F63CbeDC027E8261E79')

AND tx_status = 'SUCCESS'

AND block_timestamp :: DATE >= '2022-02-01'

),

mintshare_burnshare_ev AS (

SELECT tx_hash, block_timestamp,

contract_address,

event_name,

decoded_log,

decoded_log:account::STRING AS "Wallet Address",

WHEN event_name = 'Burn' THEN -1*decoded_log:amount::DECIMAL*1e-18

WHEN event_name = 'Mint' THEN decoded_log:amount::DECIMAL*1e-18

END) AS "Minted Amount",

FROM optimism.core.ez_decoded_event_logs

WHERE contract_address = LOWER('0x45c55BF488D3Cb8640f12F63CbeDC027E8261E79')