hessSymbols
Updated 2023-06-01
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 whales AS( select DISTINCT to_address as whale
from avalanche.core.ez_token_transfers
where BLOCK_TIMESTAMP > CURRENT_DATE - 30
and to_address in ('0x5e12fc70b97902ac19b9cb87f2ac5a8593769779',
'0x400f854bff90914a2891472d414924e97b2f2f39',
'0x838d26b7324aefc725098111116d9732057aca26',
'0x40e832c3df9562dfae5a86a4849f27f687a9b46b',
'0x46f80018211d5cbbc988e853a8683501fca4ee9b',
'0xe0028eb5ae51384418e07cad373dae8f396ad707',
'0xcca0cffbf97fb10b08c1703f1dddcf7b48c69d69',
'0xeb825b8c57b3169c35acf5721d89aa6946da4e9c',
'0x9681319f4e60dd165ca2432f30d91bb4dcfdfaa2',
'0xdbd08d75a614567ff03f50e75b2a72ff9af35700',
'0x989536719a72cfd50348ccd5521256c7eb41a999',
'0xdf3e481a05f58c387af16867e9f5db7f931113c9',
'0xb715808a78f6041e46d61cb123c9b4a27056ae9c',
'0x89a415b3d20098e6a6c8f7a59001c67bd3129821',
'0x6d80113e533a2c0fe82eabd35f1875dcea89ea97'))
,
final_2 as ( select symbol, 'Ethereum' as chain, count(DISTINCT(tx_hash)) as total_tx, sum(amount_usd) as volume
from ethereum.core.ez_token_transfers a join whales b on a.from_address = b.whale
where block_timestamp::date >= '2022-01-01'
and amount_usd < 1e16
group by 1,2
UNION
select symbol, 'Avalanche' as chain, count(DISTINCT(tx_hash)) as total_tx, sum(amount_usd) as volume
from avalanche.core.ez_token_transfers a join whales b on a.from_address = b.whale
where block_timestamp::date >= '2022-01-01'
group by 1,2
UNION
select symbol, 'Polygon' as chain, count(DISTINCT(tx_hash)) as total_tx, sum(amount_usd) as volume
from polygon.core.ez_token_transfers a join whales b on a.from_address = b.whale
where block_timestamp::date >= '2022-01-01'
group by 1,2
UNION
select symbol, 'Optimism' as chain, count(DISTINCT(tx_hash)) as total_tx, sum(amount_usd) as volume
Run a query to Download Data