greyswanreverse
    Updated 2023-12-13
    with raw as (
    select
    BLOCK_TIMESTAMP as ts,
    signers [0] as wallet,
    tx_id
    from
    solana.core.fact_events
    where
    PROGRAM_ID = 'LendY9EXmeiJLHipx1giNrpRVpqo68oWvzTjVYrKxQe'
    and block_timestamp >= current_date - 10
    and SUCCEEDED = 'true'
    and index = '1'
    )
    SELECT
    ts,
    case
    when wallet = 'FBf1J4Ljadu7oFwcxm2EJFmJewkiLGjVFP7uh4DeuR24' then '000'
    when wallet = '5EMr9jqZ4f7v4o3ekv2F7HLRxKSaqyimkKULQdxj1dtt' then '000'
    when wallet = 'EgBRLD8tV5JGWfFGRJ5UTTaWmGsFC6dA1j2Advn2VBDi' then '000'
    when wallet = 'S87Cnp4MxaMVzcTHWcrg8e9j4zN5pdbHrC4BZBuffEf' then '000'
    when wallet = 'Ds48oyaeRSGfoXGtGMqyVJZnmvq9qvhVLXy1LfjdTWfh' then '000'
    when wallet = 'D1PULdZYJZUMphULdYCkjfTD2n5LEuymoQTWvQiBW1No' then '000'
    when wallet = '8FkB9Voi51j4e7FtYnidvMBwTeQPFftHnABi1JwCDWaK' then '000'
    when wallet = 'EFEMQXXvM3qKKSkBGaakCAzfsWR5sfJhxf5KPduu82Yg' then '000'
    when wallet = '3Hd6fBPeTsMi5Zc5ngxy92MJYjWf5BkxfjHdB1nsYaAS' then '000'
    when wallet = 'KEKKkkVRcBA8zrskbGjGFxLppyUjYjYkhk6nCERkW5z' then '000'
    when wallet = 'DJ9JDZ8VcFqf3ftENX6PV3REXysk6QeR3XWjSMDx7RsW' then '000'
    when wallet = 'my4ANS9pg4CvdgHNTCqZfhhXTFMFzrhH9XaVcxp6Yrt' then '000'
    when wallet = '3BDRKt93Gkxnka3zoPT8Yt9pUxkP8xr2MgPXFRwZ5qKv' then '000'
    when wallet = 'MaxxxvVQ5QwVnAfhieZavdAdTqbkHMyVykfXUVPV4Ju' then '000'
    when wallet = 'Dimab8DQyv2tdFrQ7SomkqgeNdzpSD83HcLdeR1hs8yj' then '000'
    when wallet = 'U1Enj8mfM6Lybeu3km6hhPyKCbi8Gj5VZTT7wQHYPaJ' then '000'
    when wallet = '5z8iQPjSRe4163CFpyeSsNr8gQ1z73RSFr3fGABm1H1y' then '000'
    when wallet = 'H6EJh7pyygR8ghgPxe1j4NE3FC7BuzC4S2Cybw5fJMcg' then '000'
    when wallet = '9c1iycsWaVXssQSfCAN22jSubh87WVdjPjxXNLu8VXhc' then '000'
    else wallet
    Run a query to Download Data