princefarzamUsers that have deposited BTC into the friktion BTC covered call volt what other Defi protocols have interacted with since Jan 28th
    Updated 2022-03-27
    WITH addresses AS (
    SELECT
    DISTINCT INNER_INSTRUCTION:instructions[0]:parsed:info:source::string AS unique_addresses
    FROM solana.events
    WHERE INSTRUCTION:parsed:info:mint::string='3BjcHXvyzMsjmeqE2qFLx45K4XFx3JPiyRnjJiF5MAHt'
    AND INDEX=0
    AND block_timestamp >= '2022-01-28'
    AND SUCCEEDED =TRUE
    )
    SELECT
    CASE
    WHEN POST_MINT ='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' THEN 'BTC'
    WHEN POST_MINT ='4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2' THEN 'fcSOL'
    WHEN POST_MINT ='3BjcHXvyzMsjmeqE2qFLx45K4XFx3JPiyRnjJiF5MAHt' THEN 'fcBTC'
    WHEN POST_MINT ='6UA3yn28XecAHLTwoCtjfzy3WcyQj1x13bxnH8urUiKt' THEN 'fcmSOL'
    WHEN POST_MINT ='GjnoPUjQiEUYWuKAbMax2cM1Eony8Yutc133wuSun9hS' THEN 'fcETH'
    WHEN POST_MINT ='7wDh4VCTPwx41kvbLE6fkFgMEjnqw7NpGJvQtNabCm2B' THEN 'fcFTT'
    WHEN POST_MINT ='5SLqZSywodLS8ih6U2AAioZrxpgR149hR8SApmCB7r5X' THEN 'fcSRM'
    WHEN POST_MINT ='4sTuzTYfcE2NF7zy6Sy8XhVcNLa6JQSLrx3roy97n4sD' THEN 'fcMNGO'
    WHEN POST_MINT ='95sn4kgeJnnBfRCD8S2quu4HS9Y6vb7JDuXrarnmEjYE' THEN 'fcLUNA'
    WHEN POST_MINT ='SoAnGsHVqSyaN4MjWoPCcftC1V6oSeNxLJjF5TXrtuL' THEN 'fcRAY'
    WHEN POST_MINT ='KgV1GvrHQmRBY8sHQQeUKwTm2r2h8t4C8qt12Cw1HVE' THEN 'AVAX (Wormhole)'
    WHEN POST_MINT ='5VmdHqvRMbXivuC34w4Hux9zb1y9moiBEQmXDrTR1kV' THEN 'fcscnSOL'
    WHEN POST_MINT ='DPMCwE9z9jXaDVDti5aKhdgCWGgsvioz6ZvB9eZjH7UE' THEN 'fcSBR'
    ELSE NULL
    END AS Volts,
    COUNT(TR.TX_FROM_ADDRESS) AS Users_transactions
    FROM solana.transactions TR INNER JOIN addresses A ON TR.TX_FROM_ADDRESS = A.unique_addresses
    WHERE POST_MINT IS NOT NULL
    GROUP BY 1
    HAVING Users_transactions < 600
    ORDER BY 2 DESC
    Run a query to Download Data