with labels as (select * from

( values ( 'silo','defi','sei1e3gttzq5e5k49f9f5gzvrl0rltlav65xu6p9xc0aj7e84lantdjqp7cncc'),

('MRKT','nft','sei1jthjakeql58752e9c5d8p58gaeqk6zlfp8ntdam52kngagehu94qg8wm7u'),

('Kryptonite','defi','sei1ln7ntsqmxl8s502f83km9a475zyhcfhpj7v2fsm3pcmckdyys3tsktx9vk')

) as a (label, label_type, address)

select label,

label_type,

from sei.core.dim_labels

,

tx_id as ( select DISTINCT tx_id,

from sei.core.fact_msg_attributes a join labels b on a.attribute_value = b.address

where block_timestamp::date >= '2023-08-15'

select DISTINCT tx_id,

'nft' as label_type

from sei.core.fact_msg_attributes

where attribute_value = 'mint'

and attribute_key = 'action'

and block_timestamp::date >= '2023-08-15')

,

sei_v2 as ( select block_timestamp,

case when name ilike '%yei%' then 'Yei Finance'

when address = '0xe30fedd158a2e3b13e9badaeabafc5516e95e8c7' then 'WSEI'

when address = '0x00005ea00ac477b1030ce78506496e8c2de24bf5' then 'Seadrop'

when address = lower('0x00005ea00ac477b1030ce78506496e8c2de24bf5') then 'OpenSei'

when address = lower('0x71f6b49ae1558357bbb5a6074f1143c46cbca03d') then 'DragonSwap'

when address = lower('0x912ccb84b09b5dc1919692d94453124737dd97ee') then 'Redmilio'

when address = lower('0x99b85e9dfffed176e46a3be009ab9f9fe6ae59ed') then 'OpenSei'

when address = lower('0xfb43069f6d0473b85686a85f4ce4fc1fd8f00875') then 'Jellyverse'

when address = lower('0xcc11c2b7508a922319d49fa11dbc33c9b29e0934') then 'Jellyverse'