nickpITS Deployed Tokens
    Updated 2025-06-30
    SELECT
    DISTINCT created_at :: date as date_deployed,
    --data [1],
    -- data,
    lower(
    data:interchain_token_deployment_started:destinationChain :: string
    ) as chain,
    data:interchain_token_deployment_started:tokenName :: string as name,
    data:interchain_token_deployment_started:tokenSymbol :: string as symbol,
    data:interchain_token_deployment_started:tokenDecimals as decimals,
    data:interchain_token_deployment_started:tokenId as tokenID
    FROM
    axelar.axelscan.fact_gmp
    where
    data:interchain_token_deployment_started:event = 'InterchainTokenDeploymentStarted'
    and data:approved:returnValues:contractAddress = '0xB5FB4BE02232B1bBA4dC8f81dc24C26980dE9e3C'
    and status = 'executed'
    and event = 'ContractCall'
    and simplified_status = 'received'
    and gas_status = 'gas_paid_enough_gas'
    and is_call_from_relayer = 'false'
    and is_invalid_call = 'false'
    and is_two_way = 'false'
    -- and data:interchain_token_deployment_started:tokenSymbol :: string = 'CHONK'
    -- and created_at :: date between '{{Start_Date}}'
    -- and '{{End_Date}}' --order by date_deployed desc
    order by date_deployed desc
    --registerCanonicalInterchainToken
    --https://axelarscan.io/resources/assets
    -- https://docs.axelar.dev/dev/send-tokens/interchain-tokens/intro/
    /*https://axelarscan.io/gmp/search?contractAddress=0xB5FB4BE02232B1bBA4dC8f81dc24C26980dE9e3C&contractMethod=InterchainTokenDeploymentStarted*/
    Last run: 25 days ago
    DATE_DEPLOYED
    CHAIN
    NAME
    SYMBOL
    DECIMALS
    TOKENID
    1
    2025-04-08 00:00:00.000binanceBonkers Meme Token$Bonkers
    18
    0x2f1cc49401339ac4e4c795cea3c972cd1ce2e6f92ba71d397a272bca074578f2
    2
    2025-04-08 00:00:00.000baseSpace Boy Token$SpaceBoy
    18
    0x890fbc8967d4841c894aac0ec31fd0beb299bf0be98dd6327cdb5da4abd41a25
    3
    2025-04-08 00:00:00.000binanceSpace Boy Token$SpaceBoy
    18
    0x890fbc8967d4841c894aac0ec31fd0beb299bf0be98dd6327cdb5da4abd41a25
    4
    2025-04-08 00:00:00.000baseBonkers Meme Token$Bonkers
    18
    0x2f1cc49401339ac4e4c795cea3c972cd1ce2e6f92ba71d397a272bca074578f2
    5
    2025-04-05 00:00:00.000binanceMaxCoin3MAX3
    18
    0x1270166a613bddaf8552afe56bb79dafc479501fdc457cf9e99658bc40635eb8
    6
    2025-04-04 00:00:00.000baseCosmosCOS
    18
    0x90d846ae4676a1bb02dbd586f4bdcca4701c739fec9c59348b5959246c22013d
    7
    2025-04-04 00:00:00.000baseSparkSPK
    18
    0x9cf7f370ff7844fa786ab07486fe38cf7e8c13f066312ad98f7678dba59a122f
    8
    2025-04-03 00:00:00.000arbitrumMaxCoin3MAX3
    18
    0x1270166a613bddaf8552afe56bb79dafc479501fdc457cf9e99658bc40635eb8
    9
    2025-04-03 00:00:00.000optimismMaxCoin3MAX3
    18
    0x1270166a613bddaf8552afe56bb79dafc479501fdc457cf9e99658bc40635eb8
    10
    2025-04-01 00:00:00.000immutableethtosuie2s
    18
    0x8cbe74b4d46ffdd2dac8b4060ca6fc2feed1aa9d3283920c3782a506f0d41abb
    11
    2025-04-01 00:00:00.000avalancheAids TokenAIDS
    18
    0xb59e9985a820e672c98fe0a70d16946f61d3afeeb548d1cd2cf6a9542cf17832
    12
    2025-04-01 00:00:00.000avalancheethtosuie2s
    18
    0x8cbe74b4d46ffdd2dac8b4060ca6fc2feed1aa9d3283920c3782a506f0d41abb
    13
    2025-04-01 00:00:00.000polygonAids TokenAIDS
    18
    0xb59e9985a820e672c98fe0a70d16946f61d3afeeb548d1cd2cf6a9542cf17832
    14
    2025-04-01 00:00:00.000optimismAids TokenAIDS
    18
    0xb59e9985a820e672c98fe0a70d16946f61d3afeeb548d1cd2cf6a9542cf17832
    15
    2025-04-01 00:00:00.000arbitrumAids TokenAIDS
    18
    0xb59e9985a820e672c98fe0a70d16946f61d3afeeb548d1cd2cf6a9542cf17832
    16
    2025-04-01 00:00:00.000blastAids TokenAIDS
    18
    0xb59e9985a820e672c98fe0a70d16946f61d3afeeb548d1cd2cf6a9542cf17832
    17
    2025-03-27 00:00:00.000baseBonkers Meme Token$Bonkers
    18
    0xd4f518eee95423029672193bd33254cef2938b7915175fcb477c540130efc9d1
    18
    2025-03-27 00:00:00.000optimismBonkers Meme Token$Bonkers
    18
    0xd4f518eee95423029672193bd33254cef2938b7915175fcb477c540130efc9d1
    19
    2025-03-27 00:00:00.000arbitrumBonkers Meme Token$Bonkers
    18
    0xd4f518eee95423029672193bd33254cef2938b7915175fcb477c540130efc9d1
    20
    2025-03-27 00:00:00.000polygonBonkers Meme Token$Bonkers
    18
    0xd4f518eee95423029672193bd33254cef2938b7915175fcb477c540130efc9d1
    ...
    3188
    403KB
    10s