(select BLOCK_TIMESTAMP, NFT_TO_ADDRESS ,TOKENID ,MINT_PRICE_ETH ,MINT_PRICE_USD ,NFT_COUNT ,TX_FEE,tx_hash

from ethereum.core.ez_nft_mints

where NFT_ADDRESS=lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')

and EVENT_TYPE ='nft_mint'

and PROJECT_NAME='doodles'

and NFT_FROM_ADDRESS='0x0000000000000000000000000000000000000000')

select

count(distinct tx_hash) as "transactions" ,

'https://debank.com/profile/' || NFT_TO_ADDRESS as minter ,

count(distinct TOKENID) as "NFT minted" ,

sum(MINT_PRICE_ETH) as "ETH paid" ,

SUM(MINT_PRICE_USD) AS "USD paid" ,

SUM(TX_FEE) AS "FEE paid in ETH"

FROM MINT GROUP BY 2 order by 1 desc limit 10

# full_detailed tablel left 1

st.markdown('* **Top 10 Minter based on Transaction Number**')

response = requests.get("https://node-api.flipsidecrypto.com/api/v2/queries/77e4c9f2-c74d-47b8-a449-2d385e8a66b3/data/latest")

x = response.json()

def load_data() :

return pd.DataFrame(response.json())

load_data()

x = load_data()

x

#----------------------------------------------------------------------------------------------

# full_detailed tablel left 2

st.markdown('* **Top 10 minter based on Tokens Number**')

response = requests.get("https://node-api.flipsidecrypto.com/api/v2/queries/60e86b08-b17c-49cd-98f2-25812e55c923/data/latest")

x = response.json()