Unique Holders | |
|---|---|
1 | 50789 |
Eman-RazUnique Holders
Updated 15 hours ago
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 final_table as (
with eth_table as (with tab2 as (
with tab1 as (select from_address as address, - amount as amount
from ethereum.core.ez_token_transfers
where contract_address = lower('0x0a6e7ba5042b38349e437ec6db6214aec7b35676')
union all
select to_address as address, amount as amount
from ethereum.core.ez_token_transfers
where contract_address = lower('0x0a6e7ba5042b38349e437ec6db6214aec7b35676'))
select address, sum(amount) as net_amount
from tab1
group by 1)
select address, 'Ethereum' as "Chain"
from tab2
where net_amount>0),
--------------------------------------------------------
swell_table as (with table4 as (
with table3 as (
with table1 as (with tab1 as (SELECT
block_timestamp, tx_hash, origin_from_address,
lower(PARSE_JSON(full_decoded_log):"address"::STRING) AS contract_address,
PARSE_JSON(full_decoded_log):"data"[0]:"value"::STRING AS from_address,
PARSE_JSON(full_decoded_log):"data"[1]:"value"::STRING AS to_address,
(PARSE_JSON(full_decoded_log):"data"[2]:"value"::NUMBER)/pow(10,18) AS amount
from swell.core.ez_decoded_event_logs
where tx_succeeded='TRUE' and event_name='Transfer')
select from_address as address, -amount as amount
from tab1
where contract_address=lower('0x2826D136F5630adA89C1678b64A61620Aab77Aea')),
Last run: about 15 hours ago
1
9B
13s