Query editor
WITH sol_domains AS (SELECTDATE_TRUNC('day', block_time) AS day,element_at(account_arguments, 3) AS name_account -- domain accountFROM solana.instruction_callsWHERE executing_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX' -- Name ServiceAND element_at(account_arguments, 5) = '11111111111111111111111111111111'AND element_at(account_arguments, 6) = '58PwtjSDuFHuUkYjH9BYnnQKHfwo9reZhC2zMJv9JPkx'AND block_time >= DATE_ADD('day', -14, CURRENT_DATE)AND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 0 -- NameRegistryCreate),days AS (SELECT CAST(x AS date) AS dayFROM UNNEST(SEQUENCE(DATE_TRUNC('day', DATE_ADD('day', -14, CURRENT_DATE)),DATE_TRUNC('day', CURRENT_DATE),INTERVAL '1' day)) AS t(x))SELECTd.day,COUNT(DISTINCT s.name_account) AS sol_domain_registrationsFROM days dLEFT JOIN sol_domains s ON s.day = d.dayGROUP BY 1ORDER BY 1;