collection_name, tokenid,

traits[0]:value as mouth_style,

traits[1]:value as fur_style,

traits[2]:value as earring_style,

traits[3]:value as background,

tokenid_image_url, traits

from ethereum.nft.dim_nft_collection_metadata

where nft_address = '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d'

and tokenid = '44'

# sales

select

block_number, block_timestamp, tx_hash,

nft_address, project_name, tokenid,

event_type as direct_sale_or_auction_accepted,

platform_address, platform_name, platform_exchange_version,

seller_address, buyer_address,

origin_from_address as tx_initiator,

origin_to_address as router_contract,

erc1155_VALUE as null_if_ERC721,

currency_symbol as token_symbol,

currency_address as note_raw_eth_has_no_contract,

price as price_in_token,

price_usd,

total_fees as platform_plus_creator_fees_not_including_tx_fee,

platform_fee as marketplace_revenue,

platform_fee_usd as marketplace_rev_in_usd,

creator_fee as royalty_revenue,

creator_fee_usd as royalty_revenue_in_usd,

tx_fee as tx_fee_for_the_tx_hash_beware_multiple_sales_in_one_tx

from ethereum.nft.ez_nft_sales