( values ('sei1qdlexq6sr2grvx0f6m638xs7e4kswa0jk63cqj0j5z99g2rz7xpq9n7lu8','Lighthouse','nft'),

('sei1kjgq9rq7d5k94rjrvp5gzz239wlqeq2wkg2mnmfsy0kv9spamsqst35p79','mushvro','nft'),

('sei152u2u0lqc27428cuf8dx48k8saua74m6nql5kgvsu4rfeqm547rsnhy4y9','Pallet','nft'),

('sei1e3gttzq5e5k49f9f5gzvrl0rltlav65xu6p9xc0aj7e84lantdjqp7cncc','Silostake','defi'),

('sei1hrndqntlvtmx2kepr0zsfgr7nzjptcc72cr4ppk4yav58vvy7v3s4er8ed','Seiyan','token'),

('sei170949pwl4h36neazkwmdgtrh6nuenh66462n34839e23e8he3pqsnm5r2v','Milli','token'),

('sei10knxlv9e54z0xcywdhtycc63uf970aefeec73ycqwd75ep9nu45sh66m6a','Seilor','token'),

('sei1ln7ntsqmxl8s502f83km9a475zyhcfhpj7v2fsm3pcmckdyys3tsktx9vk','Astroport','defi')

) as a (address, label, label_type)

select address,

label,

from sei.core.dim_labels)

,

base as (SELECT

block_timestamp,

tx_id,

attribute_value AS address

FROM sei.core.fact_msg_attributes

WHERE attribute_key IN ('sender', 'fee_payer')

AND tx_id NOT IN (

SELECT tx_id

FROM sei.core.fact_transactions

WHERE fee = '0usei'

)

AND block_timestamp::DATE >= CURRENT_DATE - INTERVAL '90 Days'

UNION ALL

SELECT

block_timestamp,

tx_id,

tx_from AS address