barbodsale3
Updated 2022-06-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with tx_ids as (
select
PROJECT_NAME,
-- SELLER_ADDRESS,
-- BUYER_ADDRESS,
sum (zeroifnull(PRICE_USD)) as volume
from flipside_prod_db.ethereum_core.ez_nft_sales
WHERe platform_name = 'nftx'
and EVENT_TYPE = 'redeem'
and BLOCK_TIMESTAMP::date >=CURRENT_DATE -60
group by 1 order by volume desc limit 3
)
select * from tx_ids
Run a query to Download Data