BlockTrackerdeposit -- withdraw based on defi
Updated 2023-10-04
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
›
⌄
-- solend (main pool) : 8PbodeaosQP19SjYFx855UMqWxH2HynZLdBXmsrbac36 -- So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo
-- port finance v1 : Port7uDYB3wk6GJAw4KT1WpTeMtSu9bTcChBHkX2LfR
--FranciumDeFi Lending : FC81tbGt6JWRXidaWYFXxGnTk4VgobhJHATvTRVMqgWj
-- nft_lending_v2 : A66HabVL3DzNzeJgcHYtRRNW1ZRMKwBfrdSR4kLsZ9DJ
-- Marginfi V2 : MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA
--
--vaults
-- sol : FERjPVNEa7Udq8CEv68h6tPL46Tq7ieE49HrE2wea3XT
--msol : 8p1VKP45hhqq5iZG5fNGoi7ucme8nFLeChoDWNy7rWFm
-- LST : DfB5LRqKZQNZF9rEki7bGzenHwdBidxnY2q7BWVBY2Es
--solto : 7zvBTS8sM25mY3MuS6z9k3S6zzpzFaQUUKwgTfR2z8uR
--USDC : 3ESUFCnRNgZ7Mn2mPPUMmXYaKU8jpnV9VtA17M7t2mHQ
--GOFX : CfHKHQ4oXU6HkM2m1AfG2TfCeyLC1drxN3MQfgBwzbEE
--UXD : 2dH3aSpt5aEwhoeSaThKRNtNppEpg2DhGKGa1C5Wecc1
-- stSOL : CGY4XQq8U4VAJpbkaFPHZeXpW3o4KQ5LowVsn6hnMwKe
--USDT : 5XCP3oD3JAuQyDpfBFFVUxsBxNjPQojpKuL4aVhHsDok
-- DARK : 9a7QPyMEohhrsRii3ThxBEKk1dfow3oXNxJgPyhEv4gS
--
with tx as (
SELECT
tx_id as tx,
SIGNERS[0] as user,
INSTRUCTION:accounts[5] as defi_address
FROM solana.core.fact_events
WHERE program_id = '24Uqj9JCLxUeoC3hGfh5W3s9FM9uCHDS2SG3LYwBpyTi'
AND block_timestamp::date >= current_date - 30
)
Run a query to Download Data