lower(address_name) like '%bonkbot%'

or lower(address_name) like '%bonkrewards%'

or lower(address_name) like '%bonkcoin%'

or lower(address_name) like '%bonkmark%'

or lower(address_name) like '%bonkswap%'

or lower(address_name) like '%popperscooper%'

or lower(address_name) like '%hornyswap%'

dim_labels_id = 'd40417d46022b35aae58d335567ba410'

WITH transfers_to_bonk_rewards AS (

SELECT fe.tx_id

,tx_to

,tx_from AS user

,DATE_TRUNC('hour', fe.block_timestamp) AS date_hour

,amount AS bonk_amount

,mint

FROM

solanaUpdateUpdateUpdateUpdateUpdate.core.fact_transfers fe

WHERE true

AND mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263' -- this is the bonk that is transfered

AND tx_to = '9AdEE8AAm1XgJrPEs4zkTPozr3o4U5iGbgvPwkNdLDJ3'

AND tx_id = '3qWWpRw6GBsMasQJF7FtrHPzHyLm1arGvPcm61F3QJ9wzqTtE95o3m1ZW9BVDHPSCe4uigwEUwdGirk1CGE2xpFs'

AND (fe.block_timestamp::DATETIME BETWEEN '{{start_date}} 00:00:00.000' AND '{{end_date}} 23:59:59.000')

),

mint_actions AS (