Query editor
WITH cutoff AS (SELECT MAX(block_slot) AS block_slotFROM solana.instruction_callsWHERE executing_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX'AND block_time < NOW() - INTERVAL '1' month),ns_create AS (SELECTblock_slot,ELEMENT_AT(account_arguments, 3) AS name_account,ELEMENT_AT(account_arguments, 4) AS owner_accountFROM solana.instruction_callsWHEREexecuting_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX' -- SPL name serviceAND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 0 -- createAND ELEMENT_AT(account_arguments, 6) = '58PwtjSDuFHuUkYjH9BYnnQKHfwo9reZhC2zMJv9JPkx' -- SOL root domain accountAND block_slot <= (SELECT block_slot FROM cutoff)),ns_delete AS (SELECTblock_slot,ELEMENT_AT(account_arguments, 1) AS name_account,TRY_CAST(NULL AS VARCHAR) AS owner_accountFROM solana.instruction_callsWHEREexecuting_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX' -- SPL name serviceAND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 3AND ELEMENT_AT(account_arguments, 1) IN (SELECT name_account FROM ns_create)AND block_slot <= (SELECT block_slot FROM cutoff)),ns_transfer AS (SELECTblock_slot,ELEMENT_AT(account_arguments, 1) AS name_account,TO_BASE58(BYTEARRAY_SUBSTRING(data, 2, 32)) AS owner_accountFROM solana.instruction_callsWHEREexecuting_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX' -- SPL name serviceAND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 2AND ELEMENT_AT(account_arguments, 1) IN (SELECT name_account FROM ns_create)AND block_slot <= (SELECT block_slot FROM cutoff)),untokenized_domains AS (SELECTMAX(block_slot) AS block_slot,name_account,MAX_BY(owner_account, block_slot) AS owner_accountFROM (SELECTblock_slot,name_account,owner_accountFROM ns_createUNION ALLSELECTblock_slot,name_account,