freemartianRewards Received while Depositing
Updated 2023-09-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- Received Reward while Depositing for the second time onwards (harvesting previous BLID rewards)
select
tx_hash,
decoded_log:from,
decoded_log:to as receiver,
decoded_log:value/pow(10,decimals) as reward_amount,
symbol as token_symbol
from bsc.core.ez_decoded_event_logs l
inner join bsc.core.dim_contracts c on c.address = l.contract_address
where event_name = 'Transfer'
and contract_address = '0x766afcf83fd5eaf884b3d529b432ca27a6d84617'
and origin_function_signature = '0x00f714ce'
and decoded_log:from in ('0x941ef9aaf3277052e2e6c737ae9a75b229a20988',
'0xed18f1ce58fed758c7937cc0b8be66cb02dc45c6',
'0x5d735e9ffe9664b80c405d16921912e5b989688c')
Run a query to Download Data