mucryptoNFT mints
    Updated 2023-03-31
    with mint_price as (select
    tx_hash,
    block_timestamp,
    origin_from_address as minter,
    event_inputs:amount/1e18 as total_eth_sent
    from ethereum.core.fact_event_logs
    where 1=1
    -- where nft_address = '0x5a0121a0a21232ec0d024dab9017314509026480'
    -- and tx_hash like '0x9a5de161ed21a2e4f2d61f86b9f617e51ba82076694ff75683b800d5470ce1b3'
    and origin_to_address = '0x6d2ef2196895beedcab281664fabbd894d5ec387' -- Finiliar contract, minting
    and contract_address = '0x5a0121a0a21232ec0d024dab9017314509026480'
    and event_name = 'PaymentReceived'), -- Finiliar token

    tokenid_list as (select
    tx_hash,
    event_inputs:tokenId/1e18 as tokenId
    from ethereum.core.fact_event_logs
    where 1=1
    -- where nft_address = '0x5a0121a0a21232ec0d024dab9017314509026480'
    -- and tx_hash like '0x9a5de161ed21a2e4f2d61f86b9f617e51ba82076694ff75683b800d5470ce1b3'
    and origin_to_address = '0x6d2ef2196895beedcab281664fabbd894d5ec387' -- Finiliar contract, minting
    and contract_address = '0x5a0121a0a21232ec0d024dab9017314509026480'
    and event_inputs:from = '0x0000000000000000000000000000000000000000'
    and event_name = 'Transfer'),

    tokenid_count as (select
    tx_hash,
    count (distinct event_inputs:tokenId) as total_tokenid
    from ethereum.core.fact_event_logs
    where 1=1
    -- where nft_address = '0x5a0121a0a21232ec0d024dab9017314509026480'
    -- and tx_hash like '0x9a5de161ed21a2e4f2d61f86b9f617e51ba82076694ff75683b800d5470ce1b3'
    and origin_to_address = '0x6d2ef2196895beedcab281664fabbd894d5ec387' -- Finiliar contract, minting
    and contract_address = '0x5a0121a0a21232ec0d024dab9017314509026480'
    and event_inputs:from = '0x0000000000000000000000000000000000000000'
    and event_name = 'Transfer'
    Run a query to Download Data