select date_trunc('day', block_timestamp) as date, tx_hash, from_address, to_address, l.project_name as from_addr, l2.project_name as to_addr, amount, amount_usd

from near.core.ez_token_transfers t

left join near.core.dim_address_labels l

on t.from_address = l.address

join near.core.dim_address_labels l2

on t.to_address = l2.address

where block_timestamp >= current_date() - interval '7 days' and symbol = 'wNEAR'

order by amount desc

limit 1000