SELECT *

FROM optimism.core.dim_labels

where project_name LIKE 'thales'

), cash_out_tx as (

SELECT DISTINCT tx_hash

FROM optimism.core.fact_event_logs

LEFT OUTER JOIN thales_ady

ON address = contract_address

WHERE contract_address IN (SELECT address FROM thales_ady)

--AND event_name LIKE 'Burned'

), tab1 as (

SELECT

tx_hash as tx1,

raw_amount/power(10, 18) as amt

FROM optimism.core.fact_token_transfers

WHERE tx_hash IN (SELECT * FROM cash_out_tx)

AND contract_address = lower('0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9')

AND origin_from_address = to_address

), tab2 as (

SELECT

tx_hash as tx2,

contract_address,

block_timestamp,

origin_from_address

FROM optimism.core.fact_token_transfers

WHERE tx_hash IN (SELECT * FROM cash_out_tx)

AND NOT contract_address = lower('0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9')

AND origin_from_address = from_address

GROUP BY 1,2,3,4

), tab3 as (

SELECT

contract_address,