binhachonNEAR Tournament Round 1: The Arts District - Top 10 largest transactions on Paras
    Updated 2022-07-27
    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
    Run a query to Download Data