chrisfdSushi top holders
Updated 2023-12-15
999
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 dex_list(name, address) as (
select * from
values
('Uniswap Labs','0x1f9840a85d5af5bf1d1762f925bdaddc4201f984'),
('Curve DEX', '0xd533a949740bb3306d119cc777fa900ba034cd52'),
('Maverick Protocol', '0x7448c7456a97769f6cd04f1e83a4a23ccdc46abd'),
('SushiSwap', '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2'),
('DODO', '0x43dfc4159d86f3a37a5a4b3d4580b888ad7d4ddd'),
('PancakeSwap AMM', '0x152649ea73beab28c5b49b26eb48f7ead6d4c898'),
('Balancer', '0xba100000625a3754423978a60c9317c58a424e3d')
),
token_transaction as (
select
block_timestamp,
from_address as address,
symbol as ticker,
-1 * amount as value,
contract_address as token_address
from ethereum.core.ez_token_transfers
where exists (select 1 from dex_list where dex_list.address = ethereum.core.ez_token_transfers.contract_address)
union all
select
block_timestamp,
to_address as address,
symbol as ticker,
amount as value,
contract_address as token_address
from ethereum.core.ez_token_transfers
where exists (select 1 from dex_list where dex_list.address = ethereum.core.ez_token_transfers.contract_address)
),
Run a query to Download Data