Eman-RazNumber of Transactions Related to Token Deployment Over Time
Updated 2024-07-29
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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