with

prices as ( SELECT RECORDED_HOUR::date as datex, SYMBOL, avg(PRICE) as pr

from osmosis.price.ez_prices

where SYMBOL in ('SEI')

and RECORDED_HOUR::date >= '2023-08-01'

GROUP by 1,2

),

dag00 as (SELECT

tx_id as tx0,

split_part(attribute_value, ', ', 1) as token_id0,

split_part(attribute_value, ', ', 2) as nft0

FROM

sei.core.fact_msg_attributes

where

MSG_TYPE = 'wasm-set-exchange-message'

and ATTRIBUTE_KEY = 'nft'),

dag0 as (SELECT

ATTRIBUTE_VALUE as lister,

token_id0,

FROM

sei.core.fact_msg_attributes

join dag00 on tx_id=tx0

where

MSG_TYPE = 'coin_spent'

and ATTRIBUTE_KEY = 'spender'),

dag2 as

(SELECT BLOCK_TIMESTAMP::date as date2,

tx_id as tx2,