eferV > Delgators
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
WITH delegators AS (
SELECT
BLOCK_TIMESTAMP::date AS date,
COUNT(DELEGATOR) AS delegators
FROM optimism.core.fact_delegations
WHERE DELEGATION_TYPE like 'First Time Delegator %'
AND date >= '2022-05-31'
GROUP BY date
)
SELECT * FROM delegators
ORDER BY date
Run a query to Download Data