mehrancrypto-dxoepqQ66-7
Updated 2022-10-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT BLOCK_TIMESTAMP::date as daily , A.PLATFORM_NAME , count(tx_hash) as number ,
sum(PRICE_USD) as volume
from ethereum.core.ez_nft_sales A
where BLOCK_TIMESTAMP > '2022-07-01'
and CURRENCY_SYMBOL ilike '%ETH%'
and ( A.PLATFORM_NAME = 'x2y2' or A.PLATFORM_NAME = 'looksrare' or A.PLATFORM_NAME = 'opensea' )
and PLATFORM_FEE_USD > 0
GROUP by 1 , 2
Run a query to Download Data