mucryptoNFT mints
Updated 2023-03-31
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
34
35
36
›
⌄
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