superflygeneral tabel
    Updated 2022-10-13
    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