DEPOSITED | WITHDRAWN | NET | |
|---|---|---|---|
1 | 1898585.1334378 | 537260.6615964 | 1361324.4718414 |
Sbhn_NPcontinued-violet
Updated 2025-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with bs_d as (select sum(split(replace(replace(data_decoded:value::string, '[', ''), ']', ''), ' ')[0]/pow(10,7)) as deposited
from stellar.core.fact_contract_events
where topics_decoded:topics_decoded[0]:value = 'deposit'
and topics_decoded:topics_decoded[1]:value = 'CDVQVKOY2YSXS2IC7KN6MNASSHPAO7UN2UR2ON4OI2SKMFJNVAMDX6DP'
and contract_id = 'CAO3AGAMZVRMHITL36EJ2VZQWKYRPWMQAPDQD5YEOF3GIF7T44U4JAL3'),
bs_w as (
select sum(split(replace(replace(data_decoded:value::string, '[', ''), ']', ''), ' ')[0]/pow(10,7)) as withdrawn
from stellar.core.fact_contract_events
where topics_decoded:topics_decoded[0]:value = 'withdraw'
and topics_decoded:topics_decoded[1]:value = 'CDVQVKOY2YSXS2IC7KN6MNASSHPAO7UN2UR2ON4OI2SKMFJNVAMDX6DP'
and contract_id = 'CAO3AGAMZVRMHITL36EJ2VZQWKYRPWMQAPDQD5YEOF3GIF7T44U4JAL3'
)
select deposited,withdrawn,deposited-withdrawn as net
from bs_d,bs_w
Last run: 12 days ago
1
50B
4s