SELECT tx_id

, block_timestamp

, mint

FROM solana.core.fact_transfers

WHERE block_timestamp >= DATEADD('days', -30, CURRENT_DATE)

AND mint IN (

'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC

-- ,'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' -- USDT

-- ,'2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo' -- PYUSD

-- ,'A1KLoBrKBde8Ty9qtNQUtq3C2ortoC3u7twggz7sEto6' -- USDY

-- ,'USDSwr9ApdHk5bvJKMjzff41FfuX8bSxdKcR81vTwcA' -- USDS

-- ,'9zNQRsGLjNKwCUU5Gq5LR8beUCPzQMVMqKAi3SSZh54u' -- FDUSD

-- ,'susdabGDNbhrnCa6ncrYo81u4s9GM8ecK2UwMyZiq4X' -- sUSD

-- ,'FrBfWJ4qE5sCzKm3k3JaAtqZcXUh4LvJygDeketsrsH4' -- ZUSD

-- -- ,'DEkqHyPN7GMRJ5cArtQFAWefqbZb33Hyf6s5iCwjEonT' -- USDe

-- ,'HzwqbKZw8HxMN6bF2yFZNrht3c2iXXzpKcFu7uBEDKtr' -- EURC

)

and amount > 0

GROUP BY 1, 2, 3

), t3 AS (

SELECT

'USDC' as Token

, e.program_id

, count(DISTINCT e.tx_id) as N_TXs

FROM t0

join solana.core.fact_events e

on t0.block_timestamp = e.block_timestamp

and t0.tx_id = e.tx_id

WHERE e.block_timestamp >= DATEADD('days', -30, CURRENT_DATE)

and e.program_id not in (

'ComputeBudget111111111111111111111111111111',

'11111111111111111111111111111111',

'ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL',

'GDDMwNyyx8uB6zrqwBFHjLLG3TBYk2F8Az4yrQC5RzMp',

'MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr',