superflyUntitled Query
Updated 2022-08-11
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with kiokio as (select a.block_timestamp::date , a.tx_hash, a.event_inputs:from as seller , a.event_inputs:tokenId as token_id,amount,amount_usd , contract_address as nft_address ,event_inputs:to as purchaser ,contract_address
from optimism.core.fact_event_logs a inner join optimism.core.fact_transactions b On b.tx_hash= a.tx_hash inner join optimism.core.ez_eth_transfers E on E.tx_hash=b.tx_hash
where eth_value> 0 and event_inputs:tokenId is not null and event_inputs:from <> '0x0000000000000000000000000000000000000000' and event_inputs:to <> '0x0000000000000000000000000000000000000000' and tx_status = 'SUCCESS' and event_name = 'Transfer'
and b.block_timestamp::date between '2022-07-01' and '2022-07-30' )
select case when contract_address = '0x5c9d55b78febcc2061715ba4f57ecf8ea2711f2c' then 'Motorheadz' when contract_address = '0xb8df6cc3050cc02f967db1ee48330ba23276a492' then 'OptiPunk'
when contract_address = '0x51e5426ede4e2d4c2586371372313b5782387222' then 'Apetimism' when contract_address = '0x69a68eb548a37ee475d9f89646945588558796d1' then 'Oliens'
when contract_address = '0x9b9f542456ad12796ccb8eb6644f29e3314e68e1' then 'OptiChads' when contract_address = '0x76c9fb6ae4151e00bbdbf9b771cf84de42a31636' then 'Oppa Bear Pixel'
when contract_address = '0x8e56343adafa62dac9c9a8ac8c742851b0fb8b03' then 'Bored Town' when contract_address = '0x9c7305eb78a432ced5c4d14cac27e8ed569a2e26' then 'veNFT'
when contract_address = '0x18a1bc18cefdc952121f319039502fdd5f48b6ff' then 'CryptoTesters' when contract_address = '0xbb1b0da320ccc7a677a2fe00871f422e2e505fb1' then 'Global Gans'
end as "collection Name" , count(distinct tx_hash) as sales, sum(amount_usd) as "Usd Sale Volume" , sum(amount) as "ETH Sales Volume"
from kiokio group by "collection Name" having "collection Name" is not null order by "Usd Sale Volume" desc
Run a query to Download Data