Total reward | |
|---|---|
1 | 377.48 |
Flipside Teammemebase rewards
Updated 9 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with tb1 as (
select
BLOCK_TIMESTAMP,
tx_hash,
concat('0x',substring(topics[3], 26+1, 40)) AS multisig,
concat('0x',substring(topics[2], 26+1, 40)) AS owner,
ethereum.public.udf_hex_to_int(TOPICS[1])::float as serviceId,
ethereum.public.udf_hex_to_int(substring(data, 128+3, 64))::float as reward
from base.core.fact_event_logs
where (CONTRACT_ADDRESS = lower('0xc653622fd75026a020995a1d8c8651316cbbc4da')
OR contract_address = lower('0x6011e09e7c095e76980b22498d69df18eb62bed8')
OR contract_address = lower('0xfb7669c3adf673b3a545fa5acd987dbfda805e22')
OR contract_address = lower('0xca61633b03c54f64b6a7f1f9a9c0a6feb231cc4d')
)
and TOPICS[0] = '0x6d789d063e079a4c156e77a20008529fc448dca2cd7e5e7a20abf969fffb9226'
)
select
round(sum(reward/1e18),3) as "Total reward"
from tb1
--group by 1 having "Total reward" > 0
Last run: 9 days ago
1
10B
27s