Query editor
with txnsCount as (select distinct(call_tx_hash) as hash,date_trunc('day', call_block_date) as time, cardinality(es.txns) as txCount from ambirewallet_ethereum.Identity_call_executeBySender esunion allselect distinct(call_tx_hash) as hash,date_trunc('day', call_block_date) as time, cardinality(es.txns) as txCount from ambirewallet_ethereum.Identity_call_execute esunion allselect distinct(call_tx_hash) as hash, date_trunc('day', call_block_date) as time,cardinality(calls) as txCount from ambirewallet_v2_multichain.ambireaccount_call_execute es),daily_ops_made as (selecttime, sum(txCount) as daily_opsfrom txnsCountGROUP by 1)selecttime, daily_ops, cum_daily_ops, weekly_daily_ops, monthly_daily_ops, daily_ops_30mafrom (selecttime, daily_ops, sum(daily_ops) over (order by time) as cum_daily_ops, sum(daily_ops) over (order by time ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as weekly_daily_ops, sum(daily_ops) over (order by time ROWS BETWEEN 30 PRECEDING AND CURRENT ROW) as monthly_daily_ops, avg(daily_ops) over (order by time ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) as daily_ops_30mafrom daily_ops_madewhere time < date_trunc('day', now()))xorder by 1 desc