kimkim NFT minting skill building bounty 5 - Finiliar nft mints
Updated 2022-08-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
-- and tx_hash = '0x9a5de161ed21a2e4f2d61f86b9f617e51ba82076694ff75683b800d5470ce1b3'
and origin_to_address = '0x6d2ef2196895beedcab281664fabbd894d5ec387' -- finiliar contract , minting
and contract_address = '0x5a0121a0a21232ec0d024dab9017314509026480' -- finiliar token
and event_name = 'PaymentReceived'
),
tokenid_list as (
select
tx_hash,
event_inputs:tokenId as tokenid
from ethereum.core.fact_event_logs
where 1 = 1
-- and tx_hash = '0x9a5de161ed21a2e4f2d61f86b9f617e51ba82076694ff75683b800d5470ce1b3'
and origin_to_address = '0x6d2ef2196895beedcab281664fabbd894d5ec387' -- finiliar contract , minting
and contract_address = '0x5a0121a0a21232ec0d024dab9017314509026480' -- finiliar token
and event_inputs:from = '0x0000000000000000000000000000000000000000'
and event_name = 'Transfer'
),
tokenid_count as (
select
tx_hash,
count (distinct event_inputs:tokenId) as total_tokenid
Run a query to Download Data