mz0111stark 20
    Updated 2023-04-08
    with tab1 as (SELECT
    'ETH BRIDGE' AS "NAME",
    block_timestamp :: date as date1,
    count(DISTINCT TX_HASH ) as "bridge count",
    sum(AMOUNT_USD) as "USD out bridge amount"
    FROM ethereum.core.ez_eth_transfers
    WHERE ETH_TO_ADDRESS = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'
    And block_timestamp :: date >= current_date - {{period}}
    GROUP BY 2 ),

    tab2 as (SELECT
    'ETH BRIDGE' AS "NAME",
    block_timestamp :: date as date,
    count(DISTINCT TX_HASH ) as "bridge count",
    sum(AMOUNT_USD) as "USD in bridge amount"
    FROM ethereum.core.ez_eth_transfers
    WHERE ETH_FROM_ADDRESS = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'
    AND ORIGIN_FUNCTION_SIGNATURE = '0x00f714ce'
    And date >= current_date - {{period}}
    GROUP BY 2
    )

    SELECT
    date1,
    "USD out bridge amount"* -1 as "outflow",
    "USD in bridge amount" as "inflow",
    "inflow" + "outflow" as "netflow"
    from tab1 join tab2 on date1 = date
    group by 1 , 2 , 3