amir007-Q63RX1Arbitrum NFT Mint (Base on Wallet)
Updated 2023-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
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