greyswanreverse
Updated 2023-12-13
99
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
›
⌄
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