SELECT txn_hash,

((parse_json(args)):price) as price

from flipside_prod_db.mdao_near.actions_events_function_call

WHERE METHOD_NAME = 'nft_set_series_price'

HAVING txn_hash not in ('8M8ujPVTjX5iWHojTBKrEeoNoq6TwKqt6Dpb63KuYkBi',

'8M8ujPVTjX5iWHojTBKrEeoNoq6TwKqt6Dpb63KuYkBi',

'4BJykn1HKeHsW2kUKtrFBxHgznSPXRWQrUw9visX7Jk7',

'H3rJyDq1dCKAvkuyiCE3mHcgpVPCtaaFcgBfGgT8uH64',

'C8DRjewpcYcYqonCUvfLVNKVrUyKatrVsSRP9U2S8iDp',

'FsKTuiNTHDxnhQWkJCtN8CDDDT22bpC7nwgTh1WmMwy5',

'65VbCvihS9Qai5291ZiK8cPZ9YRcw4EvWsCniKjTL8Dq',

'5QGcZpTeAtokU8HT5fL2femYjDDSqgVhg8w7iKxKZ4Rj',

'BstHEqXp7d3kyRGXRKdG7x7NAdPZhx75oKehXqLE7ZGi',

'7WZondbhRZM6epZKkJppMpmL6X4v6YhAqL2AX1SsNFJz',

'hyK7u5E3i8A7XvnaYc1HxhBr7ox88GLFmmN2YHp2dvh',

'6Von6F9L2Fa9XzNw5H3oysNsc6G4cdpV3jXueKemcMer',

)

select A.BLOCK_TIMESTAMP::date as date ,A.tx_receiver as receiver,

count(DISTINCT(tx_hash)) as total_sales,

count(DISTINCT(receiver)) as buyer ,

count(DISTINCT(tx_signer)) as seller,

sum(price/pow(10,24)) as amount,

sum(total_sales) over (order by date asc) as cum_sales,

sum(buyer) over (order by date asc) as cum_buyer,

sum(seller) over (order by date asc) as cum_seller

from near.core.fact_transactions A join cte B on A.tx_hash = B.txn_hash

where date >= '2022-03-01' and date <> '2022-03-16'

group by 1,2