superflyUntitled Query
Updated 2022-08-11
9
1
2
3
4
5
6
7
8
›
⌄
with saded as (select r.block_timestamp, r.tx_hash, r.event_inputs:from as seller, r.event_inputs:to as buyer, r.event_inputs:tokenId as token_id,amount_usd
from optimism.core.fact_event_logs r
inner join optimism.core.ez_eth_transfers u on u.tx_hash = r.tx_hash
where event_inputs:tokenId is not null and event_inputs:from <> '0x0000000000000000000000000000000000000000'
and event_inputs:to <>'0x0000000000000000000000000000000000000000' and event_name = 'Transfer' and tx_status = 'SUCCESS' and u.block_timestamp::date between '2022-07-01' and '2022-07-31')
select count(distinct seller) as "Sellers",count(distinct buyer) as "Buyers",count(tx_hash) as "Sales",count(distinct token_id) as "Total Tokens", sum(amount_usd) as "Cost Usd"
from saded
Run a query to Download Data