shreexTop 10
Updated 2022-10-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
logs.contract_address as nft_collection,
address_name,
sum(amount) as collection_volume_eth
from optimism.core.fact_event_logs logs left join optimism.core.ez_eth_transfers transfers on transfers.tx_hash=logs.tx_hash
LEFT join optimism.core.dim_labels on logs.contract_Address=address
where logs.origin_to_address='0xc78a09d6a4badecc7614a339fd264b7290361ef1'
and transfers.eth_to_address='0xc78a09d6a4badecc7614a339fd264b7290361ef1'
and transfers.origin_to_address='0xc78a09d6a4badecc7614a339fd264b7290361ef1'
and contract_address != '0x4200000000000000000000000000000000000042'
GROUP BY nft_collection ,address_Name
ORDER by collection_volume_eth desc
LIMIT 10
Run a query to Download Data