shreexTop 10
    Updated 2022-10-14
    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