select --*

-- block_timestamp,

-- tx_id,

-- tx_from,

-- tx_to,

-- amount

-- date(block_timestamp) as date,

-- count(*) as tip_events,

-- sum(amount) as tip_volume_sol,

-- count(distinct tx_from) as tippers

tx_id as tx,

TX_FROM as sig,

block_id as b_id,

amount as amt

from solana.core.fact_transfers

where tx_to in (

'96gYZGLnJYVFmbjzopPSU6QiEV5fGqZNyN9nmNhvrZU5',

'HFqU5x63VTqvQss8hp11i4wVV8bD44PvwucfZ2bU7gRe',

'Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY',

'ADaUMid9yfUytqMBgopwjb2DTLSokTSzL1zt6iGPaS49',

'DfXygSm4jCyNCybVYYK6DwvWqjKee8pbDmJGcLWNDXjh',

'ADuUkR4vqLUMWXxW9gh6D6L8pMSawimctcNZ5pGwDcEt',

'DttWaMuVvTiduZRnguLF7jNxTgiMBZ1hyAumKUiL2KRL',

'3AVi9Tg9Uo68tJfuvoKvqKNWKkC5wPdSSdeBnizKZ6jT'

)

--where tx_id like '3hGTiVvtDXcj5ca8PKHDbU5EWUVUmgVTosRGsdfpLk2pazR2tUHpSHcVwXhxdqz6tXhfQh2dWerHN2YaTAfhD797'

--limit 100

and block_timestamp between '2024-10-10' and '2024-10-17'

and mint like 'So11111111111111111111111111111111111111111'

and index in (0, 1)

), tx_programs AS (

select

tx,

MAX(CASE WHEN program_id = 'CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK' THEN 1 ELSE 0 END) AS Raydium_cllm,