gayatridodmaniSecondary_sales
Updated 2022-12-06
9
1
2
3
4
5
6
›
⌄
select "TOKEN_ID","TOKEN_NAME","BLOCK_NUMBER","BLOCK_TIMESTAMP","TX_HASH","EVENT_TYPE","PLATFORM_ADDRESS","PLATFORM_NAME","PLATFORM_EXCHANGE_VERSION","AGGREGATOR_NAME","SELLER_ADDRESS","BUYER_ADDRESS","NFT_ADDRESS",s."PROJECT_NAME","ERC1155_VALUE","TOKENID",s."TOKEN_METADATA","CURRENCY_SYMBOL","CURRENCY_ADDRESS","PRICE","PRICE_USD","TOTAL_FEES","PLATFORM_FEE","CREATOR_FEE","TOTAL_FEES_USD","PLATFORM_FEE_USD","CREATOR_FEE_USD","TX_FEE_USD","ORIGIN_FROM_ADDRESS","ORIGIN_TO_ADDRESS","ORIGIN_FUNCTION_SIGNATURE"
from ethereum.core.dim_nft_metadata m
join ethereum.core.ez_nft_sales s on s.tokenid=m.token_id
where token_name like '%BAYC%' and s.event_type = 'sale'
limit 20000
--Removed the column Tx_Fee
Run a query to Download Data