zero-ndoLtSSponsors and funds raised
Updated 2022-06-29
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 crowdfunds as (
select
tx_hash,
ORIGIN_FROM_ADDRESS as fund_requester,
ORIGIN_TO_ADDRESS as coin_address,
ETH_TO_ADDRESS,
eth_from_address,
case when ETH_TO_ADDRESS ='0x138c3d30a724de380739aad9ec94e59e613a9008' then 'treasury'
else 'eth_reciever'
end as user_type,
amount as amount
from ethereum.core.ez_eth_transfers
where tx_hash in
(
select tx_hash from ethereum.core.ez_eth_transfers
where eth_to_address=lower('0x138c3d30a724de380739aad9ec94e59e613a9008')
and origin_function_signature='0x31a3a506'
)
and origin_function_signature='0x31a3a506'
)
(
select 'total funds raised' as "metric", sum(amount) as "value" from crowdfunds
where user_type='treasury'
group by user_type
)
UNION
(select 'unique sponsors' as "metric", count(distinct eth_from_address) as "value" from crowdfunds
where user_type='treasury'
)
-- select * from ethereum.core.ez_eth_transfers where tx_hash=lower('0x85de63b23a9614ca87b657ff7a559521b611f4cffd4a88d10644aee1ba388970')
Run a query to Download Data