AntonidasBridge Txns - Per Blockchain
    Updated 2023-09-22
    -- forked from 7d57de99-3dab-40d0-8cee-35c708d919d8

    select
    date_trunc('week', block_timestamp) as day_date,
    blockchain,
    sum(IFF(direction='inbound', amount, 0)) as inflow_to_chain,
    sum(IFF(direction='outbound', -amount, 0)) as outflow_from_chain,
    inflow_to_chain + outflow_from_chain as net_flow
    from flow.core.ez_bridge_transactions
    where block_timestamp > current_date - 90
    and block_timestamp > '2023-02-01'
    group by 1,2





    Run a query to Download Data