CoinConverseDEG Shark and Whale activity outflow
Updated 2024-05-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with inflow_tab as (select to_address as users, sum(amount) as inflow
from base.core.ez_token_transfers
where contract_address = lower('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed') and
to_address not in (lower ('0x704Ec5C12Ca20a293C2C0B72B22619A4231f3c0d'),
lower ('0x4F0Fd563BE89ec8C3e7D595bf3639128C0a7C33A'),
lower ('0x7d00D30269fC62Ab5fAb54418feeDBdc71FDb25f'),
lower ('0x02552167c63222E3C9d27dDF42420Ac0EA6cE7BF'),
lower ('0xc9034c3E7F58003E6ae0C8438e7c8f4598d5ACAA'),
lower ('0x9F07F8A82cB1af1466252e505b7b7ddee103bC91'),
lower ('0xe2505985D2308d40A415d02a46B8dabDFd0b05Ed'),
lower ('0x7134ddcd6Bc3d3f29643Ec8882cd4d7d0b38379D'),
lower ('0x4DCD1B2DE4f2a18dC55e8e182E92dbd391e5211f'))
group by 1),
outflow_tab as (select from_address as users, sum(amount) as outflow
from base.core.ez_token_transfers
where contract_address = lower('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed') and
from_address not in (lower ('0x704Ec5C12Ca20a293C2C0B72B22619A4231f3c0d'),
lower ('0x4F0Fd563BE89ec8C3e7D595bf3639128C0a7C33A'),
lower ('0x7d00D30269fC62Ab5fAb54418feeDBdc71FDb25f'),
lower ('0x02552167c63222E3C9d27dDF42420Ac0EA6cE7BF'),
lower ('0xc9034c3E7F58003E6ae0C8438e7c8f4598d5ACAA'),
lower ('0x9F07F8A82cB1af1466252e505b7b7ddee103bC91'),
lower ('0xe2505985D2308d40A415d02a46B8dabDFd0b05Ed'),
lower ('0x7134ddcd6Bc3d3f29643Ec8882cd4d7d0b38379D'),
lower ('0x4DCD1B2DE4f2a18dC55e8e182E92dbd391e5211f'))
group by 1),
concat_tab as (select a.users, case
when inflow is null then 0
else inflow
end as total_inflow,
case
when outflow is null then 0
else outflow
end as total_outflow
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived