SELECT

sum( b.amount_in ) AS sum_in

, sum( b.amount_out ) AS sum_out

, sum( b.amount_in_usd ) AS sum_in_usd

, sum( b.amount_out_usd ) AS sum_out_usd

, sum_in - sum_out AS sum_amount

, sum_in_usd - sum_out_usd AS sum_usd

FROM

ethereum.core.fact_event_logs a

INNER JOIN

ethereum.core.ez_dex_swaps b

ON a.contract_address = b.contract_address

WHERE

a.origin_function_signature = '0x18fccc76'

,

list_total_pool AS

SELECT

a.pool_name AS pool_name

, count( a.pool_name ) AS count_tx

, sum( a.amount_in_usd ) AS sa_in

, sum( a.amount_out_usd ) AS sa_out

, sa_in - sa_out AS sum_amount_usd