hessHeatmap
Updated 2024-09-08
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 contracts as ( select case when address = 'sei152u2u0lqc27428cuf8dx48k8saua74m6nql5kgvsu4rfeqm547rsnhy4y9' then 'Pallet' else label end as labels , label_type, address, address_name
from sei.core.dim_labels
where label != 'sei validator'
and label_type != 'cex'
UNION
select * from
( values ( 'silo','defi','sei1e3gttzq5e5k49f9f5gzvrl0rltlav65xu6p9xc0aj7e84lantdjqp7cncc','Mint and burn'),
('MRKT','nft','sei1jthjakeql58752e9c5d8p58gaeqk6zlfp8ntdam52kngagehu94qg8wm7u','Marketplace'),
('Kryptonite','defi','sei1ln7ntsqmxl8s502f83km9a475zyhcfhpj7v2fsm3pcmckdyys3tsktx9vk','Mint and Bunr')
) as a (labels, label_type, address,address_name)
)
,
fees as ( select DISTINCT tx_id -- remove Oracle txns
from sei.core.fact_transactions
where fee = '0usei'
and block_timestamp::date >= current_date - 31
)
,
users as ( select DISTINCT attribute_value as addresses,
tx_id
from sei.core.fact_msg_attributes
where attribute_key in ('sender','fee_payer')
and block_timestamp::date >= current_date - 31)
,
transactions as ( select a.block_timestamp,
a.tx_id,
labels,
label_type,
address,
address_name,
addresses as user,
a.block_id,
avg(split(fee,'usei')[0]/pow(10,6)) as fees,
avg(GAS_USED) as gas_use
from sei.core.fact_msg_attributes a full join contracts b on a.attribute_value = b.address
join sei.core.fact_transactions c on a.tx_id = c.tx_id
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived