andurilDEFI Data - Programs
    Updated 2023-12-06
    -- forked from Solana DEFI Activity @ https://flipsidecrypto.xyz/edit/queries/3a97c79d-8128-4db1-a28b-4606d767fa87

    SELECT
    date_trunc('month',block_timestamp) as month,
    COUNT(DISTINCT tx_id) AS txs,
    COUNT(DISTINCT signers[0]) AS fee_payers,
    CASE
    WHEN program_id IN (
    'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68',
    '5fNfvyp5czQVX77yoACa3JJVEhdRaWjPuazuWgjhTqEH',
    'JD3bq9hGdy38PuWQ4h2YJpELmHVGPPfFSuFkpzAd9zfu'
    ) THEN 'Mango Markets'
    WHEN program_id IN (
    'J2NhFnBxcwbxovE7avBQCXWPgfVtxi5sJfz68AH6R2Mg',
    '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin',
    '22Y43yTVxuUkoRKdm9thyRhQ3SdgQS7c7kB6UNCiaczD',
    'EUqojwWA2rd19FZrzeBncJsm38Jm1hEhE3zsmX3bRc2o',
    'BJ3jrUzddfuSrZHXSCxMUUQsjKEyLmuuyZebkcaFp2fg',
    '4ckmDgGdxQoPDLUkDT3vHgSAkzA3QRdNq5ywwY4sUSJn'
    ) THEN 'Serum'
    WHEN program_id = 'srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX' THEN 'Openbook'
    WHEN program_id IN (
    'AMM55ShdkoGRB5jVYPjWziwk8m5MpwyDgsMWHaMSQWH6',
    'CURVGoZn8zycx6FXwwevgBTB2gVvdbGTEpvMJDbgs2t4'
    ) THEN 'Aldrin'
    WHEN program_id IN (
    'JUP6i4ozu5ydDCnLiMogSckDPpbtr7BJ4FtzYWkb5Rk',
    'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo',
    'JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph',
    'JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB',
    'jupoNjAxXgZ4rjzxzPMP4oxduvQsQtZzyknqvzYNrNu'
    ) THEN 'Jupiter Aggregator'
    WHEN program_id IN (
    'RVKd61ztZW9GUwhRbbLoYVRE5Xf1B2tVscKqwZqXgEr',
    '27haf8L6oxUeXrHrgEgsexjSY5hbVUWEmvv9Nyxg8vQv',
    '675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8',
    Run a query to Download Data