0-MIDtotal bridge $ poly
Updated 2023-09-14
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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