freemartianOP Distribution Based on Volume Categories
Updated 2023-06-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
to_address AS user,
sum(raw_amount)/pow(10,18) AS OP_Reward,
CASE when OP_Reward > 150 then 'Whale'
when OP_Reward >= 120 AND OP_Reward < 150 then 'shark'
when OP_Reward >= 80 AND OP_Reward < 120 then 'Dolphin'
when OP_Reward >= 40 AND OP_Reward < 80 then 'Salmon'
when OP_Reward >= 20 AND OP_Reward < 40 then 'Crab'
when OP_Reward < 20 then 'Nemo'
end AS Volume_Category
FROM optimism.core.fact_token_transfers
WHERE from_address in ('0xfcc293db3b7396a1c2477c9f24f5f948431ef6ec', '0x549406bc1370a7efe86e2ae71dea3b67fa08b43d','0xc37e1fb3d127d6194fc2f5fe18ec871c7366df63')
AND contract_address = '0x4200000000000000000000000000000000000042'
GROUP BY 1
Run a query to Download Data