Abolfazl_771025total Uniswap , Gem & Blur Aggregator
Updated 2022-12-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
select
'Uniswap' as "Aggregator",
count(DISTINCT tx_hash) as "Total transactions count",
count(DISTINCT seller_address) as "Total sellers count",
sum(price) as "Total sales volume (ETH)",
sum(price_usd) as "Total sales volume (USD)"
from ethereum.core.ez_nft_sales
where ORIGIN_TO_ADDRESS = lower('0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b')
group by 1
union
select
'Gem' as "Aggregator",
count(DISTINCT tx_hash) as "Total transactions count",
count(DISTINCT seller_address) as "Total sellers count",
sum(price) as "Total sales volume (ETH)",
sum(price_usd) as "Total sales volume (USD)"
from ethereum.core.ez_nft_sales
where AGGREGATOR_NAME = 'Gem'
and block_timestamp >= '2022-11-29'
group by 1
union
select
'Blur' as "Aggregator",
count(DISTINCT tx_hash) as "Total transactions count",
count(DISTINCT seller_address) as "Total sellers count",
sum(price) as "Total sales volume (ETH)",
sum(price_usd) as "Total sales volume (USD)"
from ethereum.core.ez_nft_sales
where AGGREGATOR_NAME = 'Blur'
and block_timestamp >= '2022-11-29'
group by 1
Run a query to Download Data