distinct s.platform,

amount

From base.defi.ez_dex_swaps s

Left Join base.core.ez_token_transfers t ON s.tx_hash = t.tx_hash

Left Join base.core.ez_decoded_event_logs e ON s.tx_hash = e.tx_hash

WHERE t.contract_address = LOWER('0xe18c07D858fB1bbF8c06fD78c13b86AfD3d04e28')

AND e.tx_status = 'SUCCESS'

AND e.event_name = 'Approval'

AND e.block_timestamp >= '2024-08-24';

group by all

order by 2