WITH mintshare_burnshare AS

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

FROM ethereum.core.fact_traces

WHERE (INPUT ILIKE '0x1a378f0d%'

OR INPUT ILIKE '0xc2f04b0a%')

AND to_address = '0x89fcb32f29e509cc42d0c8b6f058c993013a843f'

AND tx_status = 'SUCCESS'

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

),

snx_price_feeds AS

(SELECT block_number, block_timestamp, tx_hash, decoded_log:current *1e-8 AS snx_price

FROM ethereum.core.ez_decoded_event_logs

WHERE contract_address = '0x06ce8be8729b6ba18dd3416e3c223a5d4db5e755'

AND event_name = 'AnswerUpdated'

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

ORDER BY block_timestamp),

sds_price_feeds AS

(SELECT block_number, block_timestamp, tx_hash, decoded_log:current *1e-27 AS sds_price

FROM ethereum.core.ez_decoded_event_logs

WHERE contract_address = '0xc7bb32a4951600fbac701589c73e219b26ca2dfc'

AND event_name = 'AnswerUpdated'

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

ORDER BY block_timestamp DESC),

snx_balance AS

(SELECT tx_hash, block_number, block_timestamp,'0x' || substr(input,35,40) AS "Wallet Address", ethereum.public.udf_hex_to_int(substr(output,3,64))::INTEGER*1e-18 AS "SNX Balance", trace_index

FROM ethereum.core.fact_traces

WHERE to_address = '0x5b1b5fea1b99d83ad479df0c222f0492385381dd'

AND input ILIKE '0x70a08231%'