Query editor
WITH base_events AS (-- объединяем касты и реакцииSELECT fid, timestampFROM dune.neynar.dataset_farcaster_castsWHERE timestamp >= date_trunc('month', now() - interval '6' month)UNION ALLSELECT fid, timestampFROM dune.neynar.dataset_farcaster_reactionsWHERE timestamp >= date_trunc('month', now() - interval '6' month)),monthly_active AS (SELECTdate_trunc('month', timestamp) AS month,fidFROM base_events)SELECTmonth,COUNT(DISTINCT fid) AS mauFROM monthly_activeGROUP BY monthORDER BY month;