MLDZMNmgf12
    Updated 2023-03-14
    select
    date_trunc('day',first_transaction_stamp) as date,
    games,
    count (distinct sender) as new_users
    from (
    select
    distinct signers[0] as sender,
    case
    when PROGRAM_ID in ('So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo') then 'Solend'
    when PROGRAM_ID in ('MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA') then 'MarginFi'
    when PROGRAM_ID in ('JPPooLEqRo3NCSx82EdE2VZY5vUaSsgskpZPBHNGVLZ') then 'Jet'
    end as games,
    min(block_timestamp) as first_transaction_stamp
    from solana.core.fact_events
    where SUCCEEDED='TRUE'
    and BLOCK_TIMESTAMP>='2023-01-01'
    group by 1,2 having games is not null
    )
    where first_transaction_stamp>='2023-01-01'
    group by 1,2
    Run a query to Download Data