greyswan Rain defi lending users
    Updated 2024-01-22
    select
    date_trunc('day', block_timestamp) as day,
    count (distinct signers [0])
    from
    solana.core.fact_events
    where
    program_id = 'RtokEFPPbXqDrzAHJHt16fwN6hZmepfPpSvW7y47g5r'
    and block_timestamp >= current_date - 30
    and succeeded = 'true'
    group by
    date_trunc('day', block_timestamp)
    order by
    date_trunc('day', block_timestamp) desc
    QueryRunArchived: QueryRun has been archived