0x137d9174D3bd00F2153DcC0Fe7AF712d3876a71EMarketplacesFlow
Updated 2022-09-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with flowpricet as (
select TIMESTAMP::date as date, avg(price_usd) as flowprice
from flow.core.fact_prices
where symbol ='FLOW' and source ='coinmarketcap'
group by 1)
select marketplace,
count (distinct tx_id) as Sales_Count,
sum (case when currency ='A.1654653399040a61.FlowToken' then price*flowprice else price end) as Total_Sale_Volume
from flow.core.ez_nft_sales t1
join flowpricet t2 on t1.block_timestamp::date = t2.date
where tx_succeeded = 'TRUE'
and buyer is not null
group by 1
order by Sales_Count DESC
Run a query to Download Data