tx_id,

instruction:parsed:info:mint as token_address,

case when value:accountIndex = 2 then value:owner end as reciepient,

instruction:parsed:info:tokenAmount:uiAmount as Amount

from solana.events, lateral flatten(input => pretokenbalances)

WHERE token_address = 'EchesyfXePKdLtoiZSL8pBe8Myagyy8ZRqsACNCFGnvp' --fida token token address

AND reciepient = 'H8sMJSCQxfKiFTCfDR3DUMLPwcRbM61LGFJ8N4dK3WjS' --coinbase hot wallet

AND succeeded = 'TRUE'

AND block_timestamp between '2022-01-15' and CURRENT_DATE-1)

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

sum(amount) as fida_amount

from transfers

group by date

order by date