denze-e7j2NUEVMs_Top ERC20s by Holders
Updated 2023-12-20
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
›
⌄
-- top 10 more popular erc20 on EVM: mainnet, polygon, base, optimism, arbitrum, gnosis chain
-- popular = largest # holders with value > $1
with
erc20_in as (
select
blockchain
, token_in as contract_address
, symbol_in as symbol
, trader as address
, sum(amount_in) AS value
, sum(amount_in_usd) as value_usd
from crosschain.defi.ez_dex_swaps
where true
-- and block_timestamp > current_timestamp - interval '1 day'
and blockchain in (
'ethereum'
, 'polygon'
, 'base'
, 'optimism'
, 'arbitrum'
, 'gnosis'
)
and amount_in is not null
group by 1,2,3,4
)
, erc20_out as (
select
blockchain
, token_out as contract_address
, symbol_out as symbol
, trader as address
, -1 * sum(amount_out) AS value
QueryRunArchived: QueryRun has been archived