select

case

when {{n_days}} != 0 then dateadd(day, -{{n_days}}, current_date())

else to_timestamp('{{start_date}}')

end start_date,

case

when {{n_days}} != 0 then current_date()

else to_timestamp('{{end_date}}')

end end_date

,jito_tips as(

select

block_timestamp as dt,

tx_id,

block_id,

tx_from as searcher,

amount as tips

from solana.core.fact_transfers

join date_filter

on block_timestamp between start_date and end_date

where

(tx_to = '96gYZGLnJYVFmbjzopPSU6QiEV5fGqZNyN9nmNhvrZU5'

or tx_to = 'HFqU5x63VTqvQss8hp11i4wVV8bD44PvwucfZ2bU7gRe'

or tx_to = 'Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY'

or tx_to = 'ADaUMid9yfUytqMBgopwjb2DTLSokTSzL1zt6iGPaS49'

or tx_to = 'DfXygSm4jCyNCybVYYK6DwvWqjKee8pbDmJGcLWNDXjh'

or tx_to = 'ADuUkR4vqLUMWXxW9gh6D6L8pMSawimctcNZ5pGwDcEt'

or tx_to = 'DttWaMuVvTiduZRnguLF7jNxTgiMBZ1hyAumKUiL2KRL'

or tx_to = '3AVi9Tg9Uo68tJfuvoKvqKNWKkC5wPdSSdeBnizKZ6jT'

)