freemartianTop Buyers
Updated 2022-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
eth_from_address as top_buyers,
sum(amount) as sale_volume,
count(distinct tx_hash) as purchase_count
from optimism.core.ez_eth_transfers
where eth_to_address in (
'0x20975da6eb930d592b9d78f451a9156db5e4c77b',
'0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6',
'0x3f9da045b0f77d707ea4061110339c4ea8ecfa70')
and origin_to_address in (
'0x20975da6eb930d592b9d78f451a9156db5e4c77b',
'0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6',
'0x3f9da045b0f77d707ea4061110339c4ea8ecfa70')
and IDENTIFIER = 'CALL_ORIGIN'
group by top_buyers
order by sale_volume DESC
limit 10
Run a query to Download Data