date_trunc(week, block_timestamp)::date as date

,count(DISTINCT tx_hash) as buy_count

,count(DISTINCT tx:receipt[1]:outcome:executor_id) as nft_count

,count(DISTINCT TX_SIGNER) as wallets

,sum(tx:actions[0]:FunctionCall:deposit/1e24) as amount_near

,sum(buy_count) over(order by date) as growth_buy_count

,sum(wallets) over(order by date) as growth_wallets

,sum(amount_near) over(order by date) as growth_amount_near

,sum(nft_count) over(order by date) as growth_nft_count

from near.core.fact_transactions

-- where tx_hash='7Ghpvp3QfvndQ55CktMqUXfWripiw2C44pdEFu9CU8Nx'

where TX_RECEIVER='marketplace.paras.near'

and tx:actions[0]:FunctionCall:method_name='buy'

group by 1

order by 1