date_trunc('day',block_timestamp) as day,

tx_id,

(instruction :parsed :info :amount ::double)/1e6 as amount

from solana.core.fact_events

where succeeded

and program_id = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'

and instruction :parsed :info :mint ::string = '2FPyTwcZLUg1MDrwsyoP4D6s1tM7hAkHYRjkNb5w6Pxk' --soETH

and event_type = 'mintTo'

union all

select

date_trunc('day',block_timestamp) as day,

tx_id,

(instruction :parsed :info :tokenAmount :amount ::double)/1e6 * -1 as amount

from solana.core.fact_events

where succeeded

and program_id = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'

and instruction :parsed :info :mint ::string = '2FPyTwcZLUg1MDrwsyoP4D6s1tM7hAkHYRjkNb5w6Pxk' --soETH

and event_type = 'burnChecked'