Airdrop dumpers

[benmillam]

When submitting, please include 3 items:

• Brief description of your tag (what are you trying to tag)?
  • Airdrop dumpers
• What is the cadence of refresh this needs?
  • Daily
• SQL query
  with claims as ( select ORIGIN_FROM_ADDRESS, (RAW_AMOUNT / 1e18) as claimed from ethereum.core.ez_token_transfers where FROM_ADDRESS = '0xb27198a99e3ae693f4dd14cfee89e98eaf413263' and CONTRACT_ADDRESS = '0x55b1e2d8b13e7acad03353fad58fc3fa065c5822' and ORIGIN_FROM_ADDRESS != '0x0fbb8d17027b16810795b12cbeadc65b252530c4' ), sent_received as ( with received as ( select TO_ADDRESS, sum(RAW_AMOUNT / 1e18) as received from ethereum.core.ez_token_transfers where CONTRACT_ADDRESS = '0x55b1e2d8b13e7acad03353fad58fc3fa065c5822' group by 1 ), sent as ( select from_ADDRESS, sum(RAW_AMOUNT / 1e18) as sent from ethereum.core.ez_token_transfers where CONTRACT_ADDRESS = '0x55b1e2d8b13e7acad03353fad58fc3fa065c5822' group by 1 ) select TO_ADDRESS as w, received, sent from received inner join sent on TO_ADDRESS = from_ADDRESS ) select ORIGIN_FROM_ADDRESS as wallet, claimed, case when received is null then 0 else received end as received, case when sent is null then 0 else sent end as sent, case when (claimed + received - sent) is null then claimed else (claimed + received - sent) end as held_FRZ, case when ( held_FRZ = claimed and sent != 0 ) then 'Holder_With_activity' when held_FRZ > claimed then 'Holder_Acquired_More' when held_FRZ < claimed then 'Holder_Not_Complete' when held_FRZ = 0 then 'Not_Holder' else 'Holder_With_No_Activity' end as situation from claims left join sent_received on ORIGIN_FROM_ADDRESS = w

[benmillam]

This was a test for a screen recording, closing