mlhUntitled Query
Updated 2022-08-02Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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