CoinConverse$OP Airdrop daily deligators
Updated 2022-11-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with all_claimers as (select block_timestamp, origin_from_address as users, sum(raw_amount)/1e18 as amount_op
from optimism.core.fact_token_transfers
where contract_address = '0x4200000000000000000000000000000000000042' and origin_to_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
group by 1, 2)
select *
from(
select min_date::date as dt, delegation_type, count(distinct delegator) as delegator_count
from(select delegator, delegation_type, min(a.block_timestamp) as min_date
from optimism.core.fact_delegations as a
join all_claimers as b on
a.delegator = b.users and a.block_timestamp > b.block_timestamp
where status = 'SUCCESS'
group by 1, 2)
group by 1, 2)
order by delegation_type asc
Run a query to Download Data