date(a.BLOCK_TIMESTAMP) as date,

a.TX_HASH,

a.SIGNER_ID as sender,

c.ADDRESS_NAME as sender_name,

c.LABEL_TYPE as sender_label,

ARGS:receiver_id as receiver,

d.ADDRESS_NAME as receiver_name,

d.LABEL_TYPE as receiver_label,

ARGS:amount/pow(10,6) as volume

from near.core.fact_actions_events_function_call a

inner join near.core.fact_transactions b on a.tx_hash = b.tx_hash

left join near.core.dim_address_labels c on a.SIGNER_ID = c.ADDRESS

left join near.core.dim_address_labels d on ARGS:receiver_id = d.ADDRESS

where RECEIVER_ID = 'usdt.tether-token.near'

and METHOD_NAME in ('ft_transfer','ft_transfer_call','ft_transfer_call')

and args:amount is not NULL

and args:amount != 'NaN'

and TX_STATUS = 'Success'

and a.BLOCK_TIMESTAMP > current_date - {{Interval_Days}}

order by 1 desc )

select

sender_label,

count(*) as transfers_count,

count(distinct sender) as senders_count,

sum(volume) as usdt_volume

from base

group by 1

order by 4 desc