flipside

    Untitled Query
    0xaimanUntitled Query
    Updated 2022-08-29
    with a as (select *, event_inputs:from as NFT_from_address, event_inputs:to as NFT_to_address, event_inputs:tokenId as token_Id from ethereum.core.fact_event_logs
    where tx_hash ='0xc157082862a9c7d445020f17636640a3e6ab273cf940f6b47640714cbb4d2756'),

    b as ( select tx_hash, eth_value as mint_price, tx_fee as txn_fee from ethereum.core.fact_transactions)

    select a.* , mint_price, txn_fee, count(tokenId) as
    from a inner join b on a.tx_hash=b.tx_hash


    Run a query to Download Data