fact_events.*

from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)

WHERE program_id = 'SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6'

--AND succeeded = 'true'

AND value:parsed:type = 'transfer'

AND value:parsed:info:authority = 'BeDSWPmUb4znQffHjsGNgQq4Sbh1FcZeur611jZrXMGK'

--AND tx_id = '35gjyumTsW9wr7taN3rx8NeyDfKWFKofNGby6HXPt6eY8qZCXqnnnEkR4FtNXL64r6d4skEV1VTrGfhfX5hMrtue'

AND block_timestamp > '2023-09-22' --AND block_timestamp < current_date