HadisehFlow 4
Updated 2022-07-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with flow_whale as ( select buyer , count(DISTINCT(tx_id)) as total_buy , sum(price) as total_volume
from flow.core.fact_nft_sales
group by 1
order by 3 desc
limit 100),
flow as ( select nft_collection , count(DISTINCT(tx_id)) as total_buy
from flow.core.fact_nft_sales
where block_timestamp::date >= CURRENT_DATE - 60
and buyer in ( select buyer from flow_whale)
group by 1
order by 2 desc)
select CONTRACT_NAME as contract , total_buy
from flow.core.dim_contract_labels x join flow y on x.event_contract = y.nft_collection
where total_buy is not null
order by 2 desc
limit 5
Run a query to Download Data