Eman-RazNumber of Transactions Related to Token Deployment Over Time
    Updated 2024-07-29
    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
    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived