andurilDEFI Data - Programs
Updated 2023-12-06
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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