flipside

    Grouping txns
    Afonso_DiazGrouping txns
    Updated 2024-07-27
    WITH t1 AS (
    SELECT
    block_timestamp::date AS dt,
    tx_hash,
    'Deposit' AS type,
    event_data:depositor AS depositor,
    event_data:amount/POW(10,8)::INT AS amount
    FROM
    aptos.core.fact_events
    WHERE
    success=TRUE
    AND payload_function='0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::stability_pool_scripts::deposit_mod'
    AND event_module='stability_pool'

    UNION ALL

    SELECT
    block_timestamp::date AS dt,
    tx_hash,
    'Withdraw' AS type,
    event_data:depositor AS depositor,
    event_data:amount/POW(10,8)::INT AS amount
    FROM
    aptos.core.fact_events
    WHERE
    success=TRUE
    AND payload_function='0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::stability_pool_scripts::withdraw_mod'
    AND event_module='stability_pool'
    ),

    distribution AS (
    SELECT
    type,
    CASE
    WHEN amount <= 10 THEN '0-10($MOD)'
    WHEN amount <= 50 THEN '10-50($MOD)'
    QueryRunArchived: QueryRun has been archived