BlockTrackertest
Updated 2025-02-24
99
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
›
⌄
-- select distinct project_name ,
-- ARRAY_AGG(address) WITHIN GROUP (ORDER BY address ASC) as address
-- from kaia.core.dim_labels
-- where label_type = 'games'
-- group by 1
-- contract : Zombie Power: ZP Token : 0x6009950e4b05fba0f95fe799ce47b56e2de4a34f
--tx_hash = '0x9e22c25e521b607e27507a5d55cc9dfc7d6ec5284da7146c3f02aa13b2d7336f'
-- method_id = '0x60c06040'
--
with data as (
select
project_name,
to_address
from kaia.core.fact_traces a
join kaia.core.dim_labels b on a.to_address = b.address
where type ilike '%CREATE%'
and label_type = 'games'
--and input ilike '0x3d602d80%'
and TX_SUCCEEDED
and block_timestamp::date >= '2024-08-29'
)
--where tx_hash = '0x683a68868befd258660a4d209b74d2855ad9b78d8e834c0bf1a426c05045e279'
-- select *
-- from kaia.core.dim_contracts
-- where address = '0x5094a196b1200961e2dca39bf3ecd5fa5abf9b02'
QueryRunArchived: QueryRun has been archived