SELECT

DATE_TRUNC('day', block_timestamp) AS date,

tx_id,

signers[0] AS user_address

FROM

solana.core.fact_events

WHERE

succeeded

AND block_timestamp::DATE > CURRENT_DATE - INTERVAL '{{months}} months'

AND program_id IN (

'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW',

'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg',

'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2',

'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE',

'CRAFT2RPXPJWCEix4WpJST3E7NLf79GTqZUL75wngXo5',

'Cargo2VNTPPTi9c1vq1Jw5d3BWUNr18MjRtSupAghKEk',

'STAKEr4Bh8sbBMoAVmTDBRqouPzgdocVrvtjmhJhd65',

'SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6',

'Name2A6WDmJ8unSp12rTWTrp9gdYWPDrwdUKujDyEF6',

'pprofELXjL5Kck7Jn5hCpwAL82DpTkSYBENzahVtbc9',

'pFACSRuobDmvfMKq1bAzwj27t6d2GJhSCHb1VcfnRmq',

'pv1ttom8tbyh83C1AVh6QH2naGRdVQUVt3HY1Yst5sv',

'Cargo8a1e6NkGyrjy4BQEW4ASGKs9KSyDyUrXMfpJoiH',

'Craftf1EGzEoPFJ1rpaTSQG1F6hhRRBAf4gRo9hdSZjR',

'AtFeepWnrZzfLrkP5iCv3YJ8TQNuWxYYBvb9Yw9P846p',

'CREWiq8qbxvo4SKkAFpVnc6t7CRQC4tAAscsNAENXgrJ'

)

),

fee AS (

SELECT

DATE_TRUNC('day', t.block_timestamp) AS date,

SUM(t.fee / 1000000000) AS total_fees_sol

FROM

solana.core.fact_transactions t

WHERE