SELECT

block_timestamp,

tx_hash,

origin_from_address,

event_inputs:value/1e18 as volume,

CASE WHEN contract_address = '0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' THEN 'DAI' end as Token

FROM polygon.core.fact_event_logs

WHERE origin_to_address in ('0xd8d177efc926a18ee455da6f5f6a6cfcee5f8f58', '0x65187fec6ecc4774c1f632c7503466d5b4353db1','0xf8a140db8b05bec52c7e86d0d40d72f8e54fe559')

and origin_function_signature in ('0x9aa7c0e5')

and event_name = 'Transfer'

and contract_address = '0x8f3cf7ad23cd3cadbd9735aff958023239c6a063'

and tx_status= 'SUCCESS'

SELECT --date_trunc ('day',block_timestamp) as date,

origin_from_address as Unique_users,

count (distinct tx_hash) as tx_count,

sum (volume) as total_amount_usd

from gns

group by Unique_users

order by total_amount_usd DESC

limit 100