Untitled Query

NavidUntitled Query

Updated 2022-10-18

-- with nfts as (

-- select

-- NFT_ADDRESS

-- from

-- near.core.ez_nft_mints

-- group by 1

-- )

select

tx:actions[0]:FunctionCall:method_name, *

from

near.core.fact_transactions

where

TX like '%feraniz.near%'

-- TX_RECEIVER in (select NFT_ADDRESS from nfts) and

and date(block_timestamp) >= CURRENT_DATE - 30

and tx:actions[0]:FunctionCall:method_name = 'buy'

-- group by

-- TX_RECEIVER

limit 10

-- possible values for tx:actions[0]:FunctionCall:method_name

-- nft_mint

-- buy

-- confirm

-- ft_transfer

-- nft_approve

-- nft_create_series

-- empty

Run a query to Download Data

flipside