with rainbowbridge as

---lockToken

(select BLOCK_TIMESTAMP, 'lock' as tag, ORIGIN_FROM_ADDRESS as user,

SYMBOL, AMOUNT, AMOUNT_USD, tx_hash

from ethereum.core.ez_token_transfers

where ORIGIN_TO_ADDRESS='0x23ddd3e3692d1861ed57ede224608875809e127f'

and ORIGIN_FUNCTION_SIGNATURE='0x0889bfe7'

union all

---unlockToken

select BLOCK_TIMESTAMP, 'unlock' as tag, ORIGIN_FROM_ADDRESS as user,

SYMBOL, AMOUNT, AMOUNT_USD, tx_hash

from ethereum.core.ez_token_transfers

where ORIGIN_TO_ADDRESS='0x23ddd3e3692d1861ed57ede224608875809e127f'

and ORIGIN_FUNCTION_SIGNATURE='0x4a00c629')

select SYMBOL as "Token",

count(*) as "Bridges",

sum(AMOUNT) as "Volume",

sum(AMOUNT_USD) as "USD Volume",

avg(AMOUNT_USD) as "Average USD Volume"

from rainbowbridge

where BLOCK_TIMESTAMP>='{{starting_date}}' and AMOUNT_USD>0

group by 1

order by 4 desc

limit 20