forgashUntitled Query
Updated 2022-06-01Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with list as (
select event_contract, count(1) as popularity from flow.core.fact_events
where block_timestamp::date >= '2022-05-09'
group by event_contract
order by popularity desc
limit 10
)
select event_contract, count(1) as popularity_per_day, date_trunc('day', block_timestamp::date) as date from flow.core.fact_events
where block_timestamp::date >= '2022-05-09'
and event_contract in (select event_contract from list)
group by date, event_contract
order by date, popularity_per_day desc
Run a query to Download Data