freemartianOP Distribution Based on Volume Categories
    Updated 2023-06-22
    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