select date(t.block_timestamp) dt

, date(date_trunc('MONTH',t.block_timestamp)) mth

, a.asset_id

, a.asset_name

, sum((t.tx_message:txn:aamt::integer) * 50) volume_usd

, count(distinct t.tx_id) tx_ct

from algorand.transactions t

inner join algorand.asset a

on t.asset_id = a.asset_id

where a.creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'

and a.asset_id != '237267329'

and date(t.block_timestamp) >= date('2021-06-01')

and t.tx_message:txn:aamt > 0

group by 1,2,3,4