-- forked from mattkstew / PYUSD Swap Activity (Overall) @ https://flipsidecrypto.xyz/mattkstew/q/IpdzkYCfwdWm/pyusd-swap-activity-overall
select
case when SWAP_FROM_AMOUNT_USD is null then SWAP_TO_AMOUNT_USD
else SWAP_FROM_AMOUNT_USD end, *
from solana.defi.ez_dex_swaps
where (swap_from_mint like '2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo' or
swap_to_mint like '2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo')