dannerUntitled Query
Updated 2022-07-29Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
platform_name,
CASE
WHEN nft_address = '0x9d5407c08febe35f3a747da422dc2da45ca30b61' THEN 'Apes'
WHEN nft_address = '0xf60762fe88da57b0c523f2b8f734dce9070ee4a4' THEN '8OKI'
WHEN nft_address = '0x9c310a63ee5352d1cdbec32439ce22f0e89d5e14' THEN 'Kingpins'
WHEN nft_address = '0xea3e8708e33b2072e7788aaa9159547749714e3a' THEN 'Knights'
ELSE 'Eres Idiota'
END as collection_name,
sum(case when CURRENCY_SYMBOL not in ('WETH','ETH') then 1 end) as non_eth_tx,
count(tx_hash) as transaction_count,
sum(price) as eth_amount,
sum(price_usd) as usd_amount,
sum(tx_fee_usd) as total_gas,
sum(creator_fee_usd) as fcf_revenue,
max(price) as max_price_eth,
max(price_usd) as max_price_usd
FROM ethereum.core.ez_nft_sales
WHERE nft_address in (
'0x9d5407c08febe35f3a747da422dc2da45ca30b61','0xf60762fe88da57b0c523f2b8f734dce9070ee4a4','0x9c310a63ee5352d1cdbec32439ce22f0e89d5e14','0xea3e8708e33b2072e7788aaa9159547749714e3a')
group by 1,2
Run a query to Download Data