DATE | Deposit | Withdrawal | Net flow | Total Deposit | Total Withdrawal | TVL | TVL_USD | Active users | TX_NUMBER | Total TX | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-06-08 00:00:00.000 | 6434.399407 | -959.538814 | 5474.860593 | 60783320.865353 | -5411656.593585 | 55371664.271768 | 10025088.6737544 | 21 | 22 | 1428535 |
2 | 2025-06-07 00:00:00.000 | 55065.244473 | -3.414837 | 55061.829636 | 60776886.465946 | -5410697.054771 | 55366189.411175 | 10030173.4775969 | 29 | 30 | 1428513 |
3 | 2025-06-06 00:00:00.000 | 8224.168323 | -22740.69823 | -14516.529907 | 60721821.221473 | -5410693.639934 | 55311127.581539 | 10021846.2528022 | 23 | 24 | 1428483 |
4 | 2025-06-05 00:00:00.000 | 68772.923714 | -85.152512 | 68687.771202 | 60713597.05315 | -5387952.941704 | 55325644.111446 | 10152924.21265 | 28 | 30 | 1428459 |
5 | 2025-06-04 00:00:00.000 | 72239.890798 | -1028.638796 | 71211.252002 | 60644824.129436 | -5387867.789192 | 55256956.340244 | 10153781.1526456 | 47 | 49 | 1428429 |
6 | 2025-06-03 00:00:00.000 | 19452.117956 | -17.173227 | 19434.944729 | 60572584.238638 | -5386839.150396 | 55185745.088242 | 10128398.4550622 | 20 | 22 | 1428380 |
7 | 2025-06-02 00:00:00.000 | 25026.162749 | -36690.558667 | -11664.395918 | 60553132.120682 | -5386821.977169 | 55166310.143513 | 10293909.3485817 | 39 | 41 | 1428358 |
8 | 2025-06-01 00:00:00.000 | 69192.533192 | -1746.107187 | 67446.426005 | 60528105.957933 | -5350131.418502 | 55177974.539431 | 10112584.6470374 | 49 | 50 | 1428317 |
9 | 2025-05-31 00:00:00.000 | 75607.203222 | -53.006867 | 75554.196355 | 60458913.424741 | -5348385.311315 | 55110528.113426 | 10061023.9378271 | 36 | 39 | 1428267 |
10 | 2025-05-30 00:00:00.000 | 37458.825739 | -464.909063 | 36993.916676 | 60383306.221519 | -5348332.304448 | 55034973.917071 | 10392137.1754409 | 34 | 42 | 1428228 |
11 | 2025-05-29 00:00:00.000 | 10555.440361 | -1962.720696 | 8592.719665 | 60345847.39578 | -5347867.395385 | 54997980.000395 | 11044057.2837443 | 47 | 51 | 1428186 |
12 | 2025-05-28 00:00:00.000 | 225356.292634 | -3469.752889 | 221886.539745 | 60335291.955419 | -5345904.674689 | 54989387.28073 | 11051427.9544596 | 51 | 53 | 1428135 |
13 | 2025-05-27 00:00:00.000 | 21186.064291 | -337.185025 | 20848.879266 | 60109935.662785 | -5342434.9218 | 54767500.740985 | 10424569.3179158 | 49 | 57 | 1428082 |
14 | 2025-05-26 00:00:00.000 | 48779.058881 | -20.289556 | 48758.769325 | 60088749.598494 | -5342097.736775 | 54746651.861719 | 10527327.2120202 | 43 | 46 | 1428025 |
15 | 2025-05-25 00:00:00.000 | 28948.889361 | -100.831376 | 28848.057985 | 60039970.539613 | -5342077.447219 | 54697893.092394 | 10520854.8514621 | 42 | 46 | 1427979 |
16 | 2025-05-24 00:00:00.000 | 11656.971073 | -147.115616 | 11509.855457 | 60011021.650252 | -5341976.615843 | 54669045.034409 | 11014470.9049532 | 39 | 40 | 1427933 |
17 | 2025-05-23 00:00:00.000 | 701472.979495 | -21.390276 | 701451.589219 | 59999364.679179 | -5341829.500227 | 54657535.178952 | 11404126.1876882 | 48 | 51 | 1427893 |
18 | 2025-05-22 00:00:00.000 | 2752640.574618 | -1463.866833 | 2751176.707785 | 59297891.699684 | -5341808.109951 | 53956083.589733 | 11355127.484734 | 49 | 50 | 1427842 |
19 | 2025-05-21 00:00:00.000 | 65564.999577 | -30206.333626 | 35358.665951 | 56545251.125066 | -5340344.243118 | 51204906.881948 | 10722094.1473012 | 44 | 44 | 1427792 |
20 | 2025-05-20 00:00:00.000 | 256046.299329 | -15765.597364 | 240280.701965 | 56479686.125489 | -5310137.909492 | 51169548.215997 | 10856506.5928595 | 50 | 54 | 1427748 |
barroncGetting Started
Updated 2025-04-14
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 T1 AS
( (SELECT
BLOCK_TIMESTAMP
, TX_ID
, 'deposit' AS Action
, SPLIT(INPUTS[0]['value'] , 'u')[0] / 1E6 AS Value
, SPLIT(INPUTS[1]['value'] , 'u')[0] / 1E6 AS Fee
, INPUTS[2]['value'] AS Account
FROM
aleo.core.fact_transitions
WHERE
PROGRAM_ID = 'pondo_protocol.aleo'
AND
FUNCTION = 'deposit_public_as_signer'
AND
SUCCEEDED = 'TRUE')
UNION ALL
(SELECT
BLOCK_TIMESTAMP
, TX_ID
, 'withdraw' AS Action
, SPLIT(INPUTS[0]['value'] , 'u')[0] / 1E6 AS Value
, 0 AS Fee
, SPLIT((SPLIT(OUTPUTS[0]['value'] , 'account:') [1]) ,',' )[0] AS Account
FROM
aleo.core.fact_transitions
WHERE
PROGRAM_ID = 'pondo_protocol.aleo'
AND
FUNCTION = 'instant_withdraw_public'
AND
SUCCEEDED = 'TRUE')
Last run: about 18 hours ago
...
266
38KB
5s