takamorimissed royalties by project
Updated 2022-12-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
sum(case when creator_fee = 0 and nft_address = '0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258' then 0.05 * price_usd END) as missed_otherdeed_royalties,
sum(case when creator_fee = 0 and nft_address = '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d' then 0.025 * price_usd END) as missed_bayc_royalties,
sum(case when creator_fee = 0 and nft_address = '0x60e4d786628fea6478f785a6d7e704777c86a7c6' then 0.025 * price_usd END) as missed_mayc_royalties,
sum(case when creator_fee = 0 and nft_address = '0x22c36bfdcef207f9c0cc941936eff94d4246d14a' then 0.025 * price_usd END) as missed_chemistry_royalties,
sum(case when creator_fee = 0 and nft_address = '0x7bd29408f11d2bfc23c34f18275bbf23bb716bc7' and
block_timestamp >= '2022-08-01' then 0.05 * price_usd END) as missed_meebit_royalties
from
ethereum.core.ez_nft_sales where block_timestamp >= '2022-12-01'
--where currency_symbol in ('ETH', 'WETH')
Run a query to Download Data