DATE | DEPOSITED | -WITHDRAWN | NET | |
|---|---|---|---|---|
1 | 2025-02-04 00:00:00.000 | 6044.3411709 | -189.0263912 | 5855.3147797 |
2 | 2024-06-06 00:00:00.000 | 6882.1535213 | -5005 | 1877.1535213 |
3 | 2024-11-01 00:00:00.000 | 3795.7288572 | -15.2453568 | 3780.4835004 |
4 | 2024-11-22 00:00:00.000 | 6208.531657 | -268.2710306 | 5940.2606264 |
5 | 2025-03-14 00:00:00.000 | 8929.9945564 | -45460.2508468 | -36530.2562904 |
6 | 2024-07-07 00:00:00.000 | 9813.7201202 | ||
7 | 2024-06-01 00:00:00.000 | 8918.3934723 | ||
8 | 2025-03-11 00:00:00.000 | 10616.1938273 | ||
9 | 2024-11-25 00:00:00.000 | 8645.8394871 | -22.8086166 | 8623.0308705 |
10 | 2025-03-19 00:00:00.000 | 5123.1138117 | -25023.6373921 | -19900.5235804 |
11 | 2024-07-30 00:00:00.000 | 9638.8239895 | -5010 | 4628.8239895 |
12 | 2024-11-23 00:00:00.000 | 323533.5549448 | -529.8967326 | 323003.6582122 |
13 | 2024-06-20 00:00:00.000 | 6819.0774036 | -90 | 6729.0774036 |
14 | 2025-02-06 00:00:00.000 | 5215.8622526 | ||
15 | 2024-06-26 00:00:00.000 | 14986.5328948 | -110 | 14876.5328948 |
16 | 2024-07-15 00:00:00.000 | 8035.8854052 | -10 | 8025.8854052 |
17 | 2025-03-13 00:00:00.000 | 505.4055524 | -10081.0915649 | -9575.6860125 |
18 | 2025-02-22 00:00:00.000 | 5708.5287047 | -447.7981717 | 5260.730533 |
19 | 2024-07-17 00:00:00.000 | 55775.6366166 | -10 | 55765.6366166 |
20 | 2025-03-24 00:00:00.000 | 2419.0224661 |
Sbhn_NPsecure-plum
Updated 2025-04-02
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
›
⌄
with bs_d as (select date_trunc('day',block_timestamp) as date,
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'
group by 1),
bs_w as (
select date_trunc('day',block_timestamp) as date,
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'
group by 1
)
select date,
deposited,
-withdrawn,
deposited-withdrawn as net
from bs_d
full outer join bs_w using(date)
Last run: 14 days ago
...
147
9KB
3s