, sum(case when contract_address = lower('0x0E09FaBB73Bd3Ade0a17ECC321fD13a19e81cE82') then amount_usd else 0 end) as "PancakeSwap (CAKE)"

, sum(case when contract_address = lower('0xcf6bb5389c92bdda8a3747ddb454cb7a64626c63') then amount_usd else 0 end) as "Venus (XVS)"

, sum(case when contract_address = lower('0x965f527d9159dce6288a2219db51fc6eef120dd1') then amount_usd else 0 end) as "BiSwap (BSW)"

, sum(case when contract_address = lower('0x8f0528ce5ef7b51152a59745befdd91d97091d2f') then amount_usd else 0 end) as "Alpaca Finance (ALPACA)"

from bsc.core.fact_token_transfers

join bsc.core.ez_bnb_transfers on fact_token_transfers.tx_hash = ez_bnb_transfers.tx_hash

where fact_token_transfers.block_timestamp::date between CURRENT_DATE-7 and CURRENT_DATE-1 -- because today not completed

group by 1

order by 1