Kaia Team {&}Klaytn Klay Transfers
Updated 2024-07-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
BLOCK_TIMESTAMP,
case when FROM_ADDRESS = lower('{{wallet}}') then 'Sender' else 'Reciever' end as type,
FROM_ADDRESS as sender,
TO_ADDRESS as reciever,
--PROJECT_NAME as Name,
--count(distinct from_address) as users,
sum(AMOUNT) as amount
FROM kaia.core.ez_native_transfers
--left join kaia.core.dim_labels on ADDRESS = TO_ADDRESS
--from kaia.core.ez_token_transfers
WHERE ORIGIN_FUNCTION_SIGNATURE = '0x'
and (FROM_ADDRESS = lower('{{wallet}}') or TO_ADDRESS = lower('{{wallet}}') )
group by 1,2,3,4
order by 1 DESC
QueryRunArchived: QueryRun has been archived