-- volume amount is in club token amount
SELECT sum(case when direction='OUT' then amount_out when direction='IN' then amount_in end) as amount
from ethereum.dex_swaps
where pool_address = '0x66bd3cc6e52cb76696144df432393258f2cb2d66'
and token_address='0xf76d80200226ac250665139b9e435617e4ba55f9'