RamaharFPMMBuy WXDAI token
Updated 2024-12-20
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 fpmm_txns as (select *
from gnosis.core.ez_decoded_event_logs
where
-- tx_hash IN (
-- '0xdadc35b46a1e0377b7ab7e31a4425caa771281720101a3ac43086da18118b984',
-- '0x1f323d5927eb57929114b347c3c056336eb42353a2ea9031e814cc09018727fe',
-- '0xb4a825232f13394d8503417fff4d5f899117a483cd02a7f2402d83f65a85b20a',)
CONTRACT_ADDRESS = '0x113d61a74e276c85538d137edc9675c61db4e33c' --FPMM contract address
),
buy_txns as (select
a.*
from gnosis.core.ez_decoded_event_logs a
JOIN fpmm_txns b ON a.tx_hash = b.tx_hash
where a.event_name = 'FPMMBuy'
),
collateral_token as (select
a.block_timestamp,
a.tx_hash,
a.origin_from_address,
a.origin_to_address,
a.tx_status,
a.decoded_log:"amount" / POW(10, 18) AS collateral_token_amount,
a.decoded_log:"collateralToken" as collateral_token_address
from gnosis.core.ez_decoded_event_logs a
join buy_txns b on a.tx_hash = b.tx_hash
where a.event_name = 'PositionSplit'
)
select
origin_from_address,
collateral_token_address,
sum(collateral_token_amount) as user_collateral_token_amount,
sum(user_collateral_token_amount) over () as total_collateral_amount
from collateral_token
QueryRunArchived: QueryRun has been archived