Alexaydelagation
Updated 2022-09-28Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- https://app.flipsidecrypto.com/velocity/queries/ff4775f8-c6b7-4a8c-8df8-8aa7b57231e1
WITH tab1 as ( SELECT ORIGIN_FROM_ADDRESS as users, sum(raw_amount / power(10, decimals)) as claim_volume
FROM optimism.core.fact_token_transfers
LEFT outer JOIN optimism.core.dim_contracts
ON address = contract_address
WHERE symbol LIKE 'OP'
AND from_address LIKE lower('0xFeDFAF1A10335448b7FA0268F56D2B44DBD357de')
AND ORIGIN_FUNCTION_SIGNATURE LIKE '0x2e7ba6ef'
GROUP BY 1 ),
tab2 as ( SELECT users, CASE WHEN DELEGATOR is null THEN 'Not-Delegators' ELSE 'Delegators' END as user_group
FROM tab1
LEFT outer JOIN optimism.core.fact_delegations
ON users = DELEGATOR)
SELECT user_group, count(*) as users
FROM tab2
GROUP BY 1
Run a query to Download Data