Query editor
with arb_erc as(select day, 'ERC20 Bridges' as bridge, token_address, token_symbol as label, amount, amount_usd as token_amount_usdfrom erc20."view_token_balances_daily"where (wallet_address = '\xa3A7B6F88361F48403514059F1F16C8E78d60EeC' --Arbitrum L1 ERC20 Gatewayor wallet_address = '\xcEe284F754E854890e311e3280b767F80797180d' --Arbitrum Custom Gatewayor wallet_address = '\xA10c7CE4b876998858b1a9E12b10092229539400') --Arbitrum DAI Gatewayand day > '2021-05-01'),tokens(address,label,divisor) as (select address, label, 10^decimals as divisorfrom (select "contract_address" as address, symbol as label, CAST (decimals AS numeric) as decimalsfrom erc20."tokens") z),prices as (select date_trunc('day', minute) as day, avg(price) as price, symbol, contract_addressfrom prices."usd"where minute > '2021-01-01'group by 1, 3, 4),eth_arbitrum as (select p.day, bridge, token_address, label, token_amount as amount, token_amount * price as token_amount_usdfrom (select day, bridge, token_address, label, avg(token_amount) as token_amount, divisorfrom (SELECT day, 'ETH Bridge' as bridge, '\xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'::bytea as token_address, 'WETH' as label, SUM(transfer) over (order by day) as token_amount, 1 as divisorFROM (SELECT date_trunc('day', block_time) as day ,sum(CASE WHEN "to" != '\x2f06e43d850ac75926fa2866e40139475b58cb16' AND "to" != '\xcb0da32914a683286ed2d4890e8157ffecc9bd06'THEN -value/1e18WHEN "to" = '\x2f06e43d850ac75926fa2866e40139475b58cb16' OR "to" = '\xcb0da32914a683286ed2d4890e8157ffecc9bd06'THEN value/1e18END) as transferFROM ethereum."traces"WHERE "from" = '\x011B6E24FfB0B5f5fCc564cf4183C5BBBc96D515' --Arbitrum InboxGROUP BY 1) as net) wgroup by 1, 2 ,3, 4, 6) nleft join prices p on n.day = p.day and n.label = p.symbol),arb_tvl as (select * from arb_erc union allselect * from eth_arbitrum)select * from arb_tvlorder by token_amount_usd DESC-- {{Credit}} @eliasimos