Query editor
WITH monthly_transfers AS (SELECTDATE_TRUNC('month', evt_block_time) AS month,"to" AS addressFROM floki_ethereum.FLOKI_evt_TransferWHEREcontract_address = FROM_HEX('cf0c122c6b73ff809c693db761e7baebe62b6a2e')UNIONSELECTDATE_TRUNC('month', evt_block_time) AS month,"from" AS addressFROM floki_ethereum.FLOKI_evt_TransferWHEREcontract_address = FROM_HEX('cf0c122c6b73ff809c693db761e7baebe62b6a2e')), monthly_holders AS (SELECTmonth,COUNT(DISTINCT address) AS total_holdersFROM monthly_transfersGROUP BYmonth), new_holders AS (SELECTmt.month,COUNT(DISTINCT mt.address) AS new_holdersFROM monthly_transfers AS mtLEFT JOIN (SELECT DISTINCT"to" AS address,DATE_TRUNC('month', evt_block_time) AS monthFROM floki_ethereum.FLOKI_evt_TransferWHEREcontract_address = FROM_HEX('cf0c122c6b73ff809c693db761e7baebe62b6a2e')UNIONSELECT DISTINCT"from" AS address,DATE_TRUNC('month', evt_block_time) AS monthFROM floki_ethereum.FLOKI_evt_TransferWHEREcontract_address = FROM_HEX('cf0c122c6b73ff809c693db761e7baebe62b6a2e')) AS prev_addressesON mt.address = prev_addresses.address AND prev_addresses.month < mt.monthWHEREprev_addresses.address IS NULLGROUP BYmt.month)SELECTmh.month,mh.total_holders,TRY_CAST(AVG(nh.new_holders) OVER (ORDER BY mh.month) AS DOUBLE) AS avg_new_holdersFROM monthly_holders AS mhLEFT JOIN new_holders AS nhON mh.month = nh.monthORDER BYmh.month