Query editor
WITH full_traces AS (select block_date, count(hash) as cnt_tx,count(distinct "from") as cnt_walletsFROM ink.transactionsgroup by 1),specific_traces AS (SELECT block_date,COUNT(distinct tx_hash) AS cnt_txFROM ink.traces t ---- 86400WHERE t."from" = 0xDeaDDEaDDeAdDeAdDEAdDEaddeAddEAdDEAd0001 and t."to" = 0x4200000000000000000000000000000000000015GROUP BY block_date)SELECT date_trunc('{{date_granularity}}', f.block_date) as dt,(86400=s.cnt_tx) as health_check,sum(f.cnt_wallets) as cnt_wallets,sum(f.cnt_tx) as cnt_full_tx,sum(f.cnt_tx - s.cnt_tx) as cnt_fitered_transactions,sum(s.cnt_tx) as cnt_setL1BlockValuesEcotoneFROM full_traces f left join specific_traces s on f.block_date = s.block_datewhere f.block_date > DATE '2024-12-06'group by 1,2order by 1