TYPE | Projects | Donators | Donates | Total Amount (Sei) | Avg Amount (Sei) | Median Amount (Sei) | Max Amount (Sei) | Min Amount (Sei) | Avg Donator Per Project | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | Round #1 - Creator Fund | 64 | 2832 | 6566 | 108726.245964 | 16.558977454 | 2.5 | 49999 | 1e-13 | 44.25 |
2 | Round #3- Developer Ecosystem | 73 | 2857 | 8114 | 107966.931585 | 13.306252352 | 4.97 | 2000 | 0.000015 | 39.136986 |
3 | Round #2 - Creative Media and IP Development | 191 | 24185 | 42211 | 274340.809081596 | 6.499272917 | 1 | 4887.5 | 1e-8 | 126.623037 |
4 | Round #4 - Supporting Web3 Gaming Creators | 196 | 3845 | 15959 | 167540.750780471 | 10.498198558 | 3 | 1500 | 0.000015 | 19.617347 |
hessTotal Per Round
Updated 2025-01-07
999
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 base as (select a.block_timestamp,
a.origin_from_address as donator,
a.tx_hash,
b.from_address,
b.to_address,
b.trace_index,
value as amount,
case when a.block_timestamp::Date < '2024-07-03' then 'Round #1 - Creator Fund' when a.block_timestamp::DAte >= '2024-08-13' and a.block_timestamp::date <= '2024-08-30' then 'Round #2 - Creative Media and IP Development' end as type
from sei.core_evm.ez_native_transfers a join sei.core_evm.fact_traces b on a.tx_hash = b.tx_hash AND a.to_address = b.to_address
where input = '0x'
--and b.to_address not in ('0x84e557dc4248e96cb697d760d6f93dc5a3b0e0bb','0x1e18cdce56b3754c4dca34cb3a7439c24e8363de','0x1133ea7af70876e64665ecd07c0a0476d09465a1',lower('0xf40f950d16388aeae12a77c7e29153612f087913'),lower('0xE195743480D1591B79106FF9B296A0cD38aDa807'),lower('0xf5cA96151d1a9998d234963433bfd3f6feC7aAc2'))
and type = 'CALL'
and a.block_timestamp::Date >= '2024-06-11' and a.block_timestamp < '2024-10-01'
and a.tx_hash in (select DISTINCT tx_hash from sei.core_evm.fact_event_logs
where origin_to_address in ('0x84e557dc4248e96cb697d760d6f93dc5a3b0e0bb','0x1133ea7af70876e64665ecd07c0a0476d09465a1','0x1e18cdce56b3754c4dca34cb3a7439c24e8363de' ))
and a.origin_from_address not in ('0xcbb290491680492077d8e395cacf99b5add1a15f','0x636da9bf416b662b5fedaf67d5937d07a34c6a2d')
and b.TX_STATUS = 'SUCCESS'
union all
select a.block_timestamp,
a.origin_from_address as donator,
a.tx_hash,
b.from_address,
b.to_address,
b.trace_index,
amount,
case when b.to_address in (lower('0xb9426d0d2af95b835347BFF3AFa36671d8aDE3e6'),lower('0xfBd69043c6D1953618E3165EBa10ACE0971b48B9'),lower('0xC4502AD76E8a7034c0F67Ed8501a8F25275C11FE'),
lower('0x5007c362F0e0436F055EaB41067A432A1ba0bDe0'),lower('0x6a81204C8F1fa1e1D1172d0B9daA2cE83ED4a10f'),lower('0x0f955e81a2Df0f4881c0D4ec9b184986460c14b5'),lower('0xb346f0521788c0f2d16e39e8d0c35a93dfd07e1d'),
lower('0x6cE678e4870d5551D818e0755D4e7A809B126ABa'),lower('0xe380E5EC635c6d93268BceB45aAFe68582096399'),lower('0x404Ac977f65f01D53af028e85bcf5BADE126B15b'),lower('0xd4ce625c3eba29358687f5d7953149fd8fa7b827'),
lower('0x8E15df9C89462b33CBEECBc80084B3d499ccfe6D'),lower('0x9c67fd725f23fbc7f0dd6d0aa3c5deaf6bff458d'),lower('0xb93afAED762c2Ab99B95E5C5a6Cf34e114665fA3'),lower('0xa937ba2383dc4ae3b9088f66910c11d3deafccab'),
lower('0xcFcAA9f471De05eA8E64E0C27B401C0e4D755Fc0'),lower('0x85643ee6D671a37f701A9Df0A29319CC0010d484'),lower('0xA8F47050Cd8368a742A11a9FC9Dc4ce5f869d9D2'),lower('0xdc2a26B763F4Ada2C6B6a5B98E6B7806ADD28a78'),
lower('0xebc26C5cF3d033CbBCED6fa23599a5AcA440D17F'),lower('0x04BE98EC2a9d76AEb4dd9E129ECeb0496071C88f'),lower('0x1810F6fDC29F1F33Ff59d98A1643E70018E8b03B'),lower('0x4Bd77F19ec0B8721A6aDFC9EA68dadf7AbE65B22'),
lower('0x071503ca0603Be168107F3210b48363ed499bDf7'),lower('0xA6e2b9741d74Bf9e2BfB9d405f715c886a1f8a53'),lower('0x616c857A1b8fF81E31610522241283281b16ABbc'),lower('0x91Ed81fA72AA855C8C176b46D145854514C603f9'),
lower('0x593d80833FDCc0C149a23C58A3617182F137672b'),lower('0xc7a82Fb41D61c6C16Bc4541Fb4Cb29F238B76972'),lower('0x104ded3be8b6a875d8bcd047eefcdf352b0e77a4'),lower('0x3c03f3b0d7c1e85147c63de6406a3bdd27ae888a'),
lower('0xc271F05610E5D9d88721978a6d70Dfa0bF1Be58f'),lower('0xe09164533Ac126eEE367924C67d42C19775307f4'),lower('0xb06a375Bd7FFF80a035c409A517822F50b00f8cB'),lower('0x71a3da31d78f81c7f549f8826c06e2229653002e'),
lower('0x171cA44C385b667AbAA2F74976d35da30a4924e9'),lower('0x7d25fDf8e00Bf272fF10e514d29e07761021E27A'),lower('0x7EF7991fFFe615d893452E3fBAeACE463C71fF8C'),lower('0x6994Dc15fC53628A5aBFC5617FB54E3e853604B6'),
lower('0x1448f7891da51e081c3a4198620def064785349c'),lower('0xb9f75cB1B7eC69529190d973eB12D796236a0E90'),lower('0x10f3cEC08497deEbEbE76Ac6A67aAE555B4bDBFc'),lower('0x79aec4efAb097F55C91A2AB9c38887C515084323'),
Last run: 3 months ago
4
431B
36s