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

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

) as a (label, label_types, address)

select label,

case when label_type = 'dex' then 'defi' else label_type end as label_types,

from sei.core.dim_labels

where label_type in ('defi','dex','nft'))

,

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_types

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'

when name ilike '%dragon%' then 'DragonSwap'

when name ilike '%jly%' then 'Jellyverse'

when name = 'iSEI' then 'Silo'