*

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

--sum(zeroifnull(value:instructions[0]:parsed:info:amount)) / POW(10,8) AS rewards_plocker

from solana.core.fact_transactions, lateral flatten(input => inner_instructions) --, lateral flatten(input => pre_token_balances)

WHERE --instructions[2]:programId = 'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2'

value:instructions[0]:parsed:info:authority = '2Jo8wqijXveVjra1DAknfoH1imS7XaJqLA1eQF5hzRUE'

--AND inner_instructions:owner = signers[0]::string

AND log_messages::string LIKE '%ClaimRewards%'

--AND tx_id = '4kAoxC3kSpyL6aMRi4YyQVbTHyvbXakS1isvCHzP3vjs2vGEF6o5WTPD66GuiCS91Qtcji2xnRV1AAeXb5f8XbFy'

AND date_trunc('day', block_timestamp) > '2023-02-15' --AND date_trunc('day', block_timestamp) < '2022-10-05'