with paras_txs as (
select
distinct
txn_hash,
tx_signer as buyer
from flipside_prod_db.mdao_near.transactions
where 1=1 --txn_hash in ()
and substr(tx_receipt[0]:"outcome":"status",3,7) != 'Failure'
and tx_receiver = 'marketplace.paras.near'
),
paras_txs_1 as (
select
*
from flipside_prod_db.mdao_near.actions_events_function_call
where method_name = 'buy'
),
paras_txs_2 as (
select
block_timestamp,
buyer,
paras_txs.txn_hash,
deposit/1e24 as price,
parse_json(args) as parsed_args,
parsed_args:nft_contract_id as nft_contract,
parsed_args:token_id as token_id
from paras_txs_1
inner join paras_txs on (paras_txs.txn_hash = paras_txs_1.txn_hash)
),
paras_txs_3 as (
select
nft_contract,
min(block_timestamp) as min_time
from paras_txs_2
group by 1
)
select