0-MIDtotal bridge $ poly
    Updated 2023-09-14
    select date_trunc('week',BLOCK_TIMESTAMP) as week
    ,sum(case when ORIGIN_FUNCTION_SIGNATURE='0xcdd1b25d' then AMOUNT_USD end) as "BRIDGE VOLUME IN"
    ,sum(case when ORIGIN_FUNCTION_SIGNATURE='0xa5977fbb' then AMOUNT_USD end) as "BRIDGE VOLUME OUT"
    ,sum("BRIDGE VOLUME IN")over(order by week) as "TOTAL BRIDGE VOLUME IN"
    ,sum("BRIDGE VOLUME OUT")over(order by week) as "TOTAL BRIDGE VOLUME OUT"
    from polygon.core.ez_token_transfers
    where ORIGIN_TO_ADDRESS='0x88dcdc47d2f83a99cf0000fdf667a468bb958a78'
    and ORIGIN_FUNCTION_SIGNATURE in('0xa5977fbb','0xcdd1b25d')
    group by 1


    Run a query to Download Data