Query editor
WITH inputs_addresses AS (SELECTDATE_TRUNC('day', block_time) AS day,i.script_pub_key.address AS addressFROM bitcoin.transactionsCROSS JOIN UNNEST(input) AS iWHERE i.script_pub_key.address IS NOT NULL),outputs_addresses AS (SELECTDATE_TRUNC('day', block_time) AS day,o.script_pub_key.address AS addressFROM bitcoin.transactionsCROSS JOIN UNNEST(output) AS oWHERE o.script_pub_key.address IS NOT NULL),all_addresses AS (SELECT day, address FROM inputs_addressesUNION ALLSELECT day, address FROM outputs_addresses)SELECTday,COUNT(DISTINCT address) AS active_addressesFROM all_addressesWHERE day >= CURRENT_DATE - INTERVAL '90' DAYGROUP BY 1ORDER BY 1 DESC