MahrooUntitled Query
Updated 2022-11-15Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with claimerst as (
select block_timestamp as claimdate,
event_inputs:recipient as Claimer,
event_inputs:amount/1e18 as Claimed_Volume
from optimism.core.fact_event_logs
where origin_to_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
and origin_function_signature = '0x2e7ba6ef'
and event_name = 'Claimed')
select block_timestamp::date as date,
count (distinct delegator) as Delegators_Count
from optimism.core.fact_delegations t1 join claimerst t2 on t1.Delegator = t2.claimer
where status = 'SUCCESS'
and t1.block_timestamp > claimdate
group by 1
Run a query to Download Data