mucryptoA 2 Q 5
Updated 2023-01-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
distinct platform_name,
count(tx_hash) as "Number of Transactions"
from ethereum.core.ez_nft_sales
where
block_timestamp::DATE BETWEEN '2022-07-01' and '2022-07-31'
group by platform_name
order by "Number of Transactions" DESC
-- AND platform_name = 'opensea'
-- AND platform_name = 'sudoswap'
-- AND platform_name = 'larva labs'
-- AND platform_name = 'rarible'
-- AND platform_name = 'x2y2'
-- AND platform_name = 'looksrare'
-- AND platform_name = 'nftx'
Limit 10;
Run a query to Download Data