SELECT

tx_hash,

contract_name,

contract_address,

origin_from_address,

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

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

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'

AND block_timestamp >= CURRENT_DATE - INTERVAL '7 days'

),

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