Query editor
-- Dune v2with nft_trades_raw as (select a.blockchain, a.project, a.block_time, a.tx_hash, a.nft_contract_address, a.token_id, a.number_of_items, a.currency_contract, a.amount_raw, a.buyer, a.seller, a.tx_from, a.tx_to, a.amount_usd,case when right(t.data,8) = '72db8c0b' then 'Gem'else aggregator_nameend as aggregator_namefrom nft.trades ainner join ethereum.transactions t on t.hash = a.tx_hashand t.block_time >= '2022-06-01'),nft_trades as (select a.blockchain, a.project, a.block_time, a.tx_hash, a.nft_contract_address, a.token_id, a.number_of_items, a.currency_contract, a.amount_raw, a.buyer, a.seller, a.tx_from, a.tx_to, a.amount_usd,case when aggregator_name = 'Gem' Then 'OpenSea Pro'else aggregator_nameend as aggregator_namefrom nft_trades_raw a),iv_daily as (select date_trunc('day',block_time) as day,aggregator_name,count(distinct tx_from) as unique_address,count(distinct tx_hash) as txn_cnt,count(1) as item_cnt,sum(amount_usd) as amount_usdfrom nft_tradeswhere blockchain = 'ethereum'and aggregator_name is not nulland aggregator_name <> ''group by 1,2)select a.*,txn_cnt / unique_address as txns_per_uniq_addr,item_cnt / unique_address as item_per_uniq_addr,amount_usd / unique_address as vol_per_uniq_addrfrom iv_daily awhereday >= now() - interval '30 days'order by 1 desc