forgashUntitled Query
    Updated 2022-06-01
    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