BLOCK_TIMESTAMP::date as date,'USN'as title ,

count(distinct TXN_HASH ) as trans ,count(distinct TX_SIGNER) as wallets ,

sum(trans) over (order by date) as cum_trans, sum(wallets) over (order by date) as cum_wallets

from

(

select

TX:actions[0]:FunctionCall:method_name as method_name ,

TXN_HASH,TX_SIGNER,

BLOCK_TIMESTAMP

from flipside_prod_db.mdao_near.transactions

where TX:actions[0]:FunctionCall:method_name = 'ft_transfer_call' and TX_RECEIPT[0]:outcome:executor_id = 'usn' and TX_RECEIPT[1]:outcome:executor_id = 'aurora' )

group by 1,2

union

select

BLOCK_TIMESTAMP::date as date,'linear'as title ,

count(distinct TXN_HASH ) as trans ,count(distinct TX_SIGNER) as wallets ,

sum(trans) over (order by date) as cum_trans,sum(wallets) over (order by date) as cum_wallets

from

(

select

TX:actions[0]:FunctionCall:method_name as method_name ,

TXN_HASH,TX_SIGNER,

BLOCK_TIMESTAMP

from flipside_prod_db.mdao_near.transactions

where TX:actions[0]:FunctionCall:method_name = 'ft_transfer_call' and TX_RECEIPT[0]:outcome:executor_id = 'linear-protocol.near' and TX_RECEIPT[1]:outcome:executor_id = 'aurora'

)

group by 1,2

union