Query editor
WITH months AS (SELECT CAST(x AS date) AS monthFROM UNNEST(SEQUENCE(DATE_TRUNC('month', DATE_ADD('month', -11, CURRENT_DATE)),DATE_TRUNC('month', CURRENT_DATE),INTERVAL '1' MONTH)) AS t(x)),ns_create AS (SELECTblock_time,account_argumentsFROM solana.instruction_callsWHERE executing_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX' -- Name ServiceAND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 0 -- NameRegistryCreateAND block_time >= DATE_TRUNC('month', DATE_ADD('month', -11, CURRENT_DATE))),reverse AS (SELECTCASEWHEN VARBINARY_TO_BIGINT(VARBINARY_SUBSTRING(data, 1, 1)) = 1 THEN ELEMENT_AT(account_arguments, 5) -- createWHEN VARBINARY_TO_BIGINT(VARBINARY_SUBSTRING(data, 1, 1)) = 9 THEN ELEMENT_AT(account_arguments, 4) -- createV2WHEN VARBINARY_TO_BIGINT(VARBINARY_SUBSTRING(data, 1, 1)) = 13 THEN ELEMENT_AT(account_arguments, 3) -- createV3WHEN VARBINARY_TO_BIGINT(VARBINARY_SUBSTRING(data, 1, 1)) = 17 THEN ELEMENT_AT(account_arguments, 3) -- createWithNftWHEN VARBINARY_TO_BIGINT(VARBINARY_SUBSTRING(data, 1, 1)) = 20 THEN ELEMENT_AT(account_arguments, 3) -- createSplitV2ELSE NULLEND AS name_account,FROM_UTF8(VARBINARY_SUBSTRING(data, 6, VARBINARY_TO_INTEGER(VARBINARY_REVERSE(VARBINARY_SUBSTRING(data, 2, 4))))) AS domainFROM solana.instruction_callsWHEREexecuting_account = 'jCebN34bUfdeUYJT13J1yG16XWQpt5PDx6Mse9GUqhR'AND tx_success = TRUEAND VARBINARY_TO_BIGINT(VARBINARY_SUBSTRING(data, 1, 1)) IN (1, 9, 13, 17, 20)),domain_revenue AS (SELECTDATE_TRUNC('month', block_time) AS month,CASEWHEN LENGTH(r.domain) = 1 THEN 750WHEN LENGTH(r.domain) = 2 THEN 700WHEN LENGTH(r.domain) = 3 THEN 640WHEN LENGTH(r.domain) = 4 THEN 160ELSECASEWHEN DATE_TRUNC('month', block_time) BETWEEN DATE '2025-06-12' AND DATE '2025-08-14' THEN 1ELSE 20ENDEND AS priceFROM ns_create ncJOIN reverse rON element_at(account_arguments, 3) = r.name_accountWHERE element_at(account_arguments, 5) = '11111111111111111111111111111111'AND element_at(account_arguments, 6) = '58PwtjSDuFHuUkYjH9BYnnQKHfwo9reZhC2zMJv9JPkx' -- Direct parent is .sol TLD)