SELECT

tx_hash,

contract_name,

contract_address,

SPLIT_PART(contract_name, ' - ', 1) AS clean_name1,

SPLIT_PART(contract_name, ' - ', 2) AS clean_name2,

decoded_log:_amount0In::FLOAT AS amount_1_raw,

decoded_log:_amount1In::FLOAT AS amount_2_raw,

DATE_TRUNC('day', block_timestamp) AS swap_date,

CASE

WHEN decoded_log:_amount0In = 0 THEN SPLIT_PART(contract_name, ' - ', 2)

ELSE SPLIT_PART(contract_name, ' - ', 1)

END AS final_token,

CASE

WHEN decoded_log:_amount0In = 0 THEN decoded_log:_amount1In

ELSE decoded_log:_amount0In

END AS final_amount_raw

FROM ronin.core.ez_decoded_event_logs

WHERE event_name = 'Swap'

),

pool_data AS (

SELECT

POOL_ADDRESS,

POOL_NAME,

BASE_TOKEN_NAME,

BASE_TOKEN_SYMBOL,

BASE_TOKEN_DECIMALS,

BASE_TOKEN_PRICE_USD,

QUOTE_TOKEN_NAME,

QUOTE_TOKEN_SYMBOL,

QUOTE_TOKEN_DECIMALS,

QUOTE_TOKEN_PRICE_USD

FROM $query('4422053b-e73b-4bd7-a6f2-fade06098f13')