headitmanageractivities
    Updated 2022-06-17
    with swaps_for as (select count(*), contract_name from flow.core.fact_swaps inner join flow.core.dim_contract_labels
    on flow.core.fact_swaps.token_out_contract=flow.core.dim_contract_labels.event_contract
    group by contract_name)
    , swaps_from as (select count(*), contract_name from flow.core.fact_swaps inner join flow.core.dim_contract_labels
    on flow.core.fact_swaps.token_in_contract=flow.core.dim_contract_labels.event_contract
    group by contract_name)
    ,activites as (select count(*),event_type from flow.core.fact_events
    group by event_type
    order by count(*) desc)
    ,swapping as (select count(*), block_timestamp::date from flow.core.fact_swaps
    group by block_timestamp::date)
    select * from activites
    Run a query to Download Data