TOTAL STATS

Eman-RazTOTAL STATS

Updated 2024-07-30

with seri1 as (with final_table as (-------------arbitrum---------------

with arbitrum as (with table3 as (with table1 as (select block_timestamp, tx_hash, decoded_log:name as token_name, decoded_log:symbol as token_symbol,

decoded_log:destinationChain as registered_chain, 'Arbitrum' as deployed_chain

from arbitrum.core.fact_decoded_event_logs

where event_name='InterchainTokenDeployed'

--and (decoded_log:minter='0x83a93500d23fbc3e82b410ad07a6a9f7a0670d66' or decoded_log:minter='0xa57adce1d2fe72949e4308867d894cd7e7de0ef2')

and contract_address='0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c'),

table2 as (select block_timestamp, tx_hash, decoded_log:tokenName as token_name, decoded_log:tokenSymbol as token_symbol,

decoded_log:destinationChain as registered_chain, 'Arbitrum' as deployed_chain

from arbitrum.core.fact_decoded_event_logs

where event_name='InterchainTokenDeploymentStarted'

--and (decoded_log:minter='0x' or decoded_log:minter='0xa57adce1d2fe72949e4308867d894cd7e7de0ef2')

and contract_address='0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c')

select * from table1 union all

select * from table2)

select *

from table3

where registered_chain is not null

order by block_timestamp desc),

-------------avalanche---------------

avalanche as (with table3 as (with table1 as (select block_timestamp, tx_hash, decoded_log:name as token_name, decoded_log:symbol as token_symbol,

decoded_log:destinationChain as registered_chain, 'Avalanche' as deployed_chain

from avalanche.core.fact_decoded_event_logs