Mrfti2024-03-23 02:32 PM
Updated 2024-11-25
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 database AS
(with general as (
with tbl3 as (
with tbl as (
select
to_address as "Address",
sum(amount) as "Input"
from
base.core.ez_token_transfers
where
contract_address = lower ('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')
group by
1
),
tbl2 as (
select
from_address as "Address",
sum(amount) as "Output"
from
base.core.ez_token_transfers
where
contract_address = lower ('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')
group by 1
)
select
tbl."Address",
case
when "Input" is null then 0
else "Input"
end as "Input tokens",
case
when "Output" is null then 0
else "Output"
end as "Output tokens"
from
tbl
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived