SELECT RECORDED_HOUR::date as date, SYMBOL as token, avg(PRICE) as avg_price

from osmosis.price.ez_prices

where SYMBOL in ('SEI')

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

GROUP by 1,2),

pallet as (

select

DISTINCT tx_id, msg_type

from sei.core.fact_msg_attributes

where ATTRIBUTE_VALUE in ('sei152u2u0lqc27428cuf8dx48k8saua74m6nql5kgvsu4rfeqm547rsnhy4y9')

and ATTRIBUTE_KEY = '_contract_address'

and msg_type in ('wasm-buy_now','wasm-accept_bid')

and TX_SUCCEEDED = 'true'

AND ATTRIBUTE_INDEX = 0),

dagora as (

select

DISTINCT tx_id

from sei.core.fact_msg_attributes

where attribute_value = 'sei1pdwlx9h8nc3fp6073mweug654wfkxjaelgkum0a9wtsktwuydw5sduczvz'

and attribute_key = '_contract_address'

and msg_type = 'wasm-execute-exchange'

and tx_succeeded = 'true'),

pallet_seller as (

select

date(block_timestamp) as date,

tx_id,

msg_index,

ATTRIBUTE_VALUE as seller

from sei.core.fact_msg_attributes

where tx_id in (select tx_id from pallet)

and ATTRIBUTE_KEY = 'nft_seller'),