SELECT from_address, count(distinct tx_hash) as number_of_txns

FROM polygon.core.fact_transactions

WHERE 1=1

and block_timestamp > current_date - interval ' 6 months'

-- and chain_name='matic_mainnet'

and to_address in

(

(lower('0xcC1B9517460D8aE86fe576f614d091fCa65a28Fc')), -- pegaxy token

(lower('0xc1c93D475dc82Fe72DBC7074d55f5a734F8cEEAE')) -- pegaxy gov token

)

group by 1

select number_of_txns, count(distinct from_address) as add

from pegaxy group by 1 order by 2 desc