date_trunc('day', block_timestamp::date) as date,

tx_receiver as token,

count(distinct(tx_hash)) as tx_num

from near.core.fact_transactions

where tx_status = 'Success'

and (

tx_receiver = 'token.sweat' or

tx_receiver = 'pixeltoken.near' or

tx_receiver = 'token.v2.ref-finance.near' or

tx_receiver = 'fusotao-token.near'

)

and block_timestamp::date >= '2022-06-15'

group by date, tx_receiver

order by date asc, tx_num desc