tx:actions[0]:FunctionCall:method_name as label,

count(DISTINCT tx_hash) as txs,

count(DISTINCT tx_signer) as users,

sum(transaction_fee/pow(10,24)) as fees,

rank() over (partition by date order by txs desc) as r

from near.core.fact_transactions

where tx_receiver like '%nearcrowd%'

and date>= CURRENT_DATE - 14

group by 1,2

qualify r<= 10