elvisDeltaPrime's GLP strategy users
Updated 2023-03-30
999
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 VaultCalls as ( -- Addresses in this query are for Avalanche contracts!
SELECT distinct tx_hash --, any_value(origin_to_address) origin_to_address, any_value(origin_function_signature) origin_function_signature
FROM avalanche.core.fact_event_logs
WHERE CONTRACT_ADDRESS = lower('0x9ab2De34A33fB459b538c43f251eB825645e8595')
AND block_timestamp > {{Starting_date}}
AND tx_status = 'SUCCESS'
--GROUP By tx_hash
),
input_Staking_AddLiquidity as (
SELECT *, origin_from_address as caller
FROM (
SELECT distinct tx_hash
FROM VaultCalls NATURAL LEFT JOIN avalanche.core.fact_event_logs
-- AddLiquidity event topic
WHERE topics[0] IN ('0x38dc38b96482be64113daffd8d464ebda93e856b70ccfc605e69ccf892ab981e')
) NATURAL LEFT JOIN avalanche.core.fact_event_logs
),
input_Staking_RemoveLiquidity as (
SELECT *, origin_from_address as caller
FROM (
SELECT distinct tx_hash
FROM VaultCalls NATURAL LEFT JOIN avalanche.core.fact_event_logs
-- RemoveLiquidity event topic
WHERE topics[0] IN ('0x87b9679bb9a4944bafa98c267e7cd4a00ab29fed48afdefae25f0fca5da27940')
) NATURAL LEFT JOIN avalanche.core.fact_event_logs
),
-- 1. Get add liquidity txs
Staking_Add_CollectSwapFees_1 as ( -- This is the CollectSwapFees event
-- This is a GMX Vault event
-- addr: 0x489ee077994B6658eAfA855C308275EAd8097C4A
SELECT tx_hash, block_timestamp, caller,
event_index,
'0x'||substr(substr(data, 3, 64), 25, 40) as tokenOut,
ethereum.public.udf_hex_to_int(substr(data, 67, 64))::int as SwapFeesRaw,
ethereum.public.udf_hex_to_int(substr(data, 131, 64))::int/1e30 as SwapFeesUsd
Run a query to Download Data