superflygeneral tabel
Updated 2022-10-13
9
1
2
3
4
5
›
⌄
WITH assd as (select nft_id, play_type from flow.core.dim_topshot_metadata ) select date_trunc('day',block_timestamp) as daily, play_type, count(distinct tx_id) as tx_n, sum(price) as volume
from flow.core.fact_nft_sales s join assd a on s.nft_id=a.nft_id where block_timestamp>=CURRENT_DATE-INTERVAL '1 MONTH' group by 1,2 order by 1
--from flow.core.fact_nft_sales s join assd a on s.nft_id=a.nft_id where block_timestamp>=CURRENT_DATE-INTERVAL '1 MONTH' group by 1,2 order by 1
Run a query to Download Data