superflygeneral tabel
Updated 2022-10-13Copy Reference Fork
9
1
2
3
4
5
6
7
›
⌄
with assd as ( select TIMESTAMP::date as day, avg (price_usd) as flowprice from flow.core.fact_prices
where symbol ='FLOW' and source ='coinmarketcap' group by 1), table1 as ( select date_trunc (week, block_timestamp::date) as week, tx_id,
buyer, seller, a.nft_id, play_type, player, team, d.moment_stats_full:metadata:primaryPosition as Position,
case when a.currency ='A.1654653399040a61.FlowToken' then a.price * s.flowprice else a.price end as nftprice
from flow.core.ez_nft_sales a join assd s on a.block_timestamp::date = s.day join flow.core.dim_topshot_metadata d on a.nft_id = d.nft_id
where a.nft_collection = 'A.e4cf4bdc1751c65d.AllDay' and block_timestamp >= '2022-07-18' and tx_succeeded = 'TRUE')
select player, sum (nftprice) as Total_Volume from table1 group by 1 order by 2 desc limit 5
Run a query to Download Data