mlhUntitled Query
    Updated 2022-08-02
    select
    count (distinct t1.contract_address) as number_of_Collections,
    count (Distinct event_inputs:tokenId) as number_of_NFTs,
    count (distinct t1.tx_hash) as number_of_sales,
    count (distinct t1.origin_from_address) as number_of_buyers,
    count (distinct event_inputs:from) as number_of_sellers,
    sum (amount_usd) as volume
    from optimism.core.fact_event_logs t1
    join optimism.core.ez_eth_transfers t2 on t1.tx_hash = t2.tx_hash
    where t1.event_name = 'Transfer'
    and t1.TX_STATUS = 'SUCCESS'
    and identifier = 'CALL_ORIGIN'
    and t1.contract_address !='0x4200000000000000000000000000000000000042'
    and t1.origin_to_address in ('0x3f9da045b0f77d707ea4061110339c4ea8ecfa70','0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6','0x20975da6eb930d592b9d78f451a9156db5e4c77b')
    and t1.origin_function_signature = '0x912d97fc'
    Run a query to Download Data