RamaharTOP 10 gained Lil Nouns in Secondary Sales
    Updated 2022-06-19
    with mint_metadata as (select
    block_number as mint_block,
    block_timestamp as mint_time,
    tx_hash as mint_hash,
    contract_address,
    tokenflow_eth.hextoint(topics[1])::integer as tokenID,
    tokenflow_eth.hextoint(substr(data,3,64)) as background,
    tokenflow_eth.hextoint(substr(data,67,64)) as body,
    tokenflow_eth.hextoint(substr(data,131,64)) as accessory,
    tokenflow_eth.hextoint(substr(data,195,64)) as head,
    tokenflow_eth.hextoint(substr(data,259,64)) as glasses
    from ethereum.core.fact_event_logs
    where
    contract_address = '0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b'
    and topics[0]::string = '0x1106ee9d020bfbb5ee34cf5535a5fbf024a011bd130078088cbf124ab3092478'),

    combined_details as (select *
    from ethereum.core.ez_eth_transfers
    inner join mint_metadata ON mint_hash = tx_hash),


    final_mint_details as (select
    c.mint_block,
    c.mint_time,
    c.mint_hash,
    c.contract_address,
    c.tokenid as mint_tokenid,
    c.amount as mint_price,
    c.amount_usd as mint_usd,
    nft_count,
    mint_price / nft_count as mint_per_NFT_price,
    mint_usd / nft_count as mint_usd_per_nft,
    background,
    body,
    accessory,
    Run a query to Download Data