AzinStats
    Updated 2 hours ago
    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 2 hours ago
    DATE
    Deposit
    Withdrawal
    Net flow
    Total Deposit
    Total Withdrawal
    TVL
    TVL_USD
    Active users
    TX_NUMBER
    Total TX
    1
    2025-02-15 00:00:00.000172067.931947-26585.42537145482.50657740526296.137418-2622471.02129137903825.11612717271849.973591349531422206
    2
    2025-02-14 00:00:00.0004651200.129676-16424.6906534634775.43902340354228.205471-2595885.59592137758342.6095516790186.280108867721422153
    3
    2025-02-13 00:00:00.00039760.847726-1512.65996638248.1877635703028.075795-2579460.90526833123567.17052714697706.53754951001422081
    4
    2025-02-12 00:00:00.00018534.981528-18136.217034398.76449435663267.228069-2577948.24530233085318.98276714836639.8320264951051421981
    5
    2025-02-11 00:00:00.00019849.502048-34754.221238-14904.7191935644732.246541-2559812.02826833084920.21827315107170.1002274951001421876
    6
    2025-02-10 00:00:00.0009334600.321243-22022.727329312577.59392335624882.744493-2525057.8070333099824.93746315972761.854571996991421776
    7
    2025-02-09 00:00:00.00081800.726547-451368.795663-369568.06911626290282.42325-2503035.0797123787247.3435411130373.168746295981421677
    8
    2025-02-08 00:00:00.000127910.85474-12187.087832115723.76690826208481.696703-2051666.28404724156815.4126569863458.229267841021041421579
    9
    2025-02-07 00:00:00.00017999.284653-10241.1955397758.08911426080570.841963-2039479.19621524041091.6457489856978.7990485878831421475
    10
    2025-02-06 00:00:00.000105331.664208-15074.23645590257.42775326062571.55731-2029238.00067624033333.5566349713473.3138618183911421392
    11
    2025-02-05 00:00:00.00053217.788645-307.45353852910.33510725957239.893102-2014163.76422123943076.12888110113279.01383571021071421301
    12
    2025-02-04 00:00:00.0001409762.496179-280.719491409481.77668925904022.104457-2013856.31068323890165.7937749795987.289187881091111421194
    13
    2025-02-03 00:00:00.00036405.433459-18300.19210118105.24135824494259.608278-2013575.59119322480684.0170858520146.45814436981041421083
    14
    2025-02-02 00:00:00.000121750.864407-2479.963965119270.90044224457854.174819-1995275.39909222462578.7757279315326.884253781241301420979
    15
    2025-02-01 00:00:00.00079328.434812-874.1439578454.29086224336103.310412-1992795.43512722343307.8752859455658.101743451721781420849
    16
    2025-01-31 00:00:00.00026779.225755-2048.14057924731.08517624256774.8756-1991921.29117722264853.5844237546567.292087881341431420671
    17
    2025-01-30 00:00:00.00062136.291822-514.831161621.46072224229995.649845-1989873.15059822240122.4992477893752.472353461601831420528
    18
    2025-01-29 00:00:00.00042977.624501-15382.45519127595.1693124167859.358023-1989358.31949822178501.0385257941708.147313962332521420345
    19
    2025-01-28 00:00:00.000109099.896839-12541.35407796558.54276224124881.733522-1973975.86430722150905.8692158315475.906026836322109281420093
    20
    2025-01-27 00:00:00.00066183.909976-17651.89167348532.01830324015781.836683-1961434.5102322054347.3264538581517.465914647012118111409165
    ...
    153
    22KB
    4s