select distinct tx_id

FROM solana.core.fact_transactions

where

instructions[0]:programId = 'EXpwP3pqPzA4arF8i89w7smtvxHzyYETmCpPspLPrR7J'

and SIGNERS[0] is not null

and block_timestamp < '2022-12-24'

and block_timestamp > '2022-04-17'

select distinct

tx_from as owner,

mint as nft_contract

from solana.core.fact_transfers

where block_timestamp < '2022-12-24'

and block_timestamp > '2022-04-17'

and tx_id in (select tx_id from aurorstakes)

and tx_to = 'ASGSU7Eeyz5wprVfqbKXQ5xB2sCqrCPUFFzmHggbX8Dm'