Zanyar_98Number of users based on the number of Ops claimed
Updated 2022-11-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH CLAIMED_TOKENS AS (SELECT ORIGIN_TO_ADDRESS AS Address, (EVENT_INPUTS:amount)/'1e18' "Number of claimed tokens"
FROM optimism.core.fact_event_logs
WHERE ORIGIN_TO_ADDRESS = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de' AND Contract_Address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
AND EVENT_NAME = 'Claimed' AND ORIGIN_FUNCTION_SIGNATURE = '0x2e7ba6ef' AND BLOCK_TIMESTAMP::DATE < CURRENT_DATE AND TX_STATUS = 'SUCCESS'
)
SELECT COUNT("Number of claimed tokens"),
CASE
WHEN "Number of claimed tokens" < 100 THEN 'Less than 100 OPs claimed'
WHEN "Number of claimed tokens" >= 100 AND "Number of claimed tokens" < 500 THEN 'Between 100 and 500 Ops claimed'
WHEN "Number of claimed tokens" >= 500 AND "Number of claimed tokens" < 700 THEN 'Between 500 and 700 Ops claimed'
WHEN "Number of claimed tokens" >= 500 AND "Number of claimed tokens" < 1000 THEN 'Between 700 and 1000 Ops claimed'
WHEN "Number of claimed tokens" >= 100 THEN 'more than 1000 OPs claimed'
END AS "Type"
FROM CLAIMED_TOKENS
GROUP BY "Type"
Run a query to Download Data