TRC20 Token Transfers

select
    date_trunc('month', block_timestamp) as date,
    from_project,
    token_symbol,
    sum(amount) as volume
from
    (
        select
            block_timestamp,
            from_address,
            sender.project as from_project,
            sender.category as from_category,
            to_address,
            recipient.project as to_project,
            recipient.category as to_category,
            token_symbol,
            amount,
            usd_amount
        from
            tron.assets.trc20_token_transfers
            left join tron.identity.entities sender on sender.address = from_address
            left join tron.identity.entities recipient on recipient.address = to_address
        where
            1 = 1
            and block_timestamp >= '2021-01-01'
            and token_address in (
                'TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t', -- Tether USD
                'TEkxiTehnzSmSe2XqrBj4w32RUN966rdz8', -- Circle USDC
                'TUpMhErZL2fhh4sVNULAbNKLokS4GjC1F4' -- TrueUSD
            ) 
    )
group by 1,2,3