NO_CREATION | TOTAL_CREATION_FEE_USD | TOTAL_CREATORBID_FEE_USD | TOTAL_AGENT_FEE_USD | |
|---|---|---|---|---|
1 | 4428 | 437097.97 | 509.8011 | 1019.6022 |
MLDZMNCreator bid
Updated 2025-02-28
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
›
⌄
-- v1 and v2
with tb1 as (select
*
from base.core.fact_event_logs
where CONTRACT_ADDRESS = '0x6623206875c37bcecf67c362d4dd1c96bd5c34d8'
and TOPICS[0] = '0xf4c563a3ea86ff1f4275e8c207df0375a51963f2b831b7bf4da8be938d92876c'
),
--tx_hash = '0xd9b38057fffe2b4345fa945a5b902e581709ceaaae52ae467ceb16f09d09a1b8'
-----------------------------------------------------------------------------
tb2 as (select
tb1.tx_hash,
tb1.block_timestamp,
round(sum(amount),6) as creation_amt_eth,
sum(amount_usd) as creation_amt_usd,
round(max(amount),6) as mint_amt_eth,
max(amount_usd) as mint_amt_usd,
round(min(amount),6) as fee_amt_eth,
min(amount_usd) as fee_amt_usd,
round(0.01*(min(amount)),6) as creatorbid_fee_amt_eth,
0.01*(min(amount_usd)) as creatorbid_fee_amt_usd,
round(0.02*(min(amount)),6) as agent_fee_amt_eth,
0.02*(min(amount_usd)) as agent_fee_amt_usd
from base.core.ez_native_transfers b
left join tb1 on b.tx_hash = tb1.tx_hash
where b.tx_hash in (select tx_hash from tb1)
and b.FROM_ADDRESS = '0xe794f7eb7e644eb49056133373fb9b1ea39f22ad'
and b.TO_ADDRESS = '0x61925f12b4f6bbf23475986a685d4eba7b78ef91'
group by 1,2
)
select
count(*) as no_creation,
sum(creation_amt_usd) as total_creation_fee_usd,
sum(creatorbid_fee_amt_usd) as total_creatorbid_fee_usd,
Last run: about 2 months ago
1
37B
26s