headitmanageractivities
Updated 2022-06-17
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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