freemartianFT Fork 1
Updated 2024-03-18
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
›
⌄
-- forked from Ario / Top 1000 Friend.Tech Creators Details @ https://flipsidecrypto.xyz/Ario/q/3ObMUAYrJeOS/top-1000-friend.tech-creators-details
with keys_price as (
select
*,
amount / lag(amount, 1) over(
order by
supply asc
) -1 as change_price
from
(
select
cast(decoded_log:supply as double) as supply,
cast(avg(decoded_log:ethAmount / 1e18) as double) as amount
from
base.core.ez_decoded_event_logs
where
decoded_log:shareAmount = 1
and contract_address = '0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4'
and TX_STATUS = 'SUCCESS'
group by
1
) a
qualify supply > 1
),
block as (
select
decoded_log:subject as subject,
'ETH' as symbol,
max(block_timestamp) as latest,
sum(cast(decoded_log:subjectEthAmount as double) / 1e18) as creator_earnings_eth
from
base.core.ez_decoded_event_logs
where contract_address = '0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4'
and TX_STATUS = 'SUCCESS'
group by
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived