date_trunc('day', block_timestamp::date) as date

,zeroifnull(sum(case when value:parsed:info:authority IN ('Afb3MooPpkZKs485FGT82fcvmHx3jex8eAKynbKy8FeA', '8dvios2LKQcKcvWodSZK33MNpp4N2EVpP4iYZhaJHFPL')

then value:parsed:info:amount

end)) as FRMWRK_amount

,zeroifnull(sum(case when value:parsed:info:authority IN ('BTSnmsD3UTVHR71QitMk9m28bsDHDF6awu69c2vhd3iM', '9ej2RgtmkcDzkkCrMJe2y8Kr2Rc9GtpgTzusQSqLcQhQ')

then value:parsed:info:amount

end)) as ELECTRO_amount

,zeroifnull(sum(case when value:parsed:info:authority IN ('ACxds7vRps6VZoUDME2dFm3d1axVmvQzQsKGRMJedpYF', '7pW7cuE4s5kUYnhZRocYqXqHYeNs9jNyZPosQqKciNQ5')

then value:parsed:info:amount

end)) as PWRSRC_amount

,zeroifnull(sum(case when value:parsed:info:authority IN ('59GmESqnCS28duoix5aDxb2csXsD46Ky9zVgqc9r9kCh', '4zWFbiy7sJSmus6R2oNDVbBtoMLnPZEfux7skW7aGPwr')

then value:parsed:info:amount

end)) as ELECMAG_amount

,sum(FRMWRK_amount) OVER (order by date) as FRMWRK_total_crafted

,sum(ELECTRO_amount) OVER (order by date) as ELECTRO_total_crafted

,sum(PWRSRC_amount) OVER (order by date) as PWRSRC_total_crafted

,sum(ELECMAG_amount) OVER (order by date) as ELECMAG_total_crafted

from solana.core.fact_events

,lateral flatten(input => inner_instruction:instructions)

WHERE program_id IN ('SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6', 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE')

AND succeeded = 'true'

AND value:parsed:type = 'transfer'

--AND tx_id = '35gjyumTsW9wr7taN3rx8NeyDfKWFKofNGby6HXPt6eY8qZCXqnnnEkR4FtNXL64r6d4skEV1VTrGfhfX5hMrtue'

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

group by 1