amir007-Q63RX1Arbitrum NFT Mint (Base on Wallet)
    Updated 2023-03-05
    WITH arb_collection AS
    (
    SELECT lower('0x537581D9E92B4Fa13977e673daff3819067463f6') AS nft_address, 'Arbigans GALXE' AS nft_name UNION
    SELECT lower('0xA4200DE56D000eA6e6A2704379509Bb16b69158f'), 'Rainbow Element' UNION
    SELECT lower('0xE3FF1EE6Bd4534644BBfC0eB87709780384C17E7'), 'Arbitrum Opensea Voyage' UNION
    SELECT lower('0xA4A3458a76e42795106B74d10fA2648B39074385'), 'Galactic Gan Quest' UNION
    SELECT lower('0xDFaA5A0FdD7a32F5E666EF68a3236f9cED036148'), 'Arbinauts Quest' UNION
    SELECT lower('0x82d676Da3311da75dB7acBF7d46a8C877aeF1ca8'), 'Mortal Portals' UNION
    SELECT lower('0xC45c63b5991201fCB67920f7B74eEA25042e5957'), 'Arbigans' UNION
    SELECT lower('0x4c615aE86Fe09aC6B71ce4e10c06C011A427Eebb'), 'Arbinauts' UNION
    SELECT lower('0xC0F63bfDDf0594ec8173a5231c4Ed60098d502C5'), 'Cosmic Warriors' UNION
    SELECT lower('0x3E5E01290F2148305DB3DfcB2395B52d96b5871f'), 'Nitro Mandalas'
    ), mint AS
    (
    SELECT log.tx_hash
    , log.block_timestamp::date as date
    , nft_name
    , event_inputs:to AS minter
    , eth_value AS eth_value
    FROM arbitrum.core.fact_event_logs log
    JOIN arbitrum.core.fact_transactions trx ON log.tx_hash = trx.tx_hash
    JOIN arb_collection arb ON log.contract_address = arb.nft_address
    WHERE log.event_name = 'Transfer'
    AND event_inputs:tokenId IS NOT NULL
    AND log.event_inputs:from = '0x0000000000000000000000000000000000000000'
    AND log.tx_status = 'SUCCESS'
    )
    SELECT minter
    , count(tx_hash) AS count_mint
    FROM mint
    GROUP BY 1
    ORDER BY 2 DESC