a.origin_from_address as buyer,

ifnull(c.sei_address,contract_address) as collection_address,

'0x' || substr(topics[1]::string, 25 ) as seller,

livequery.utils.udf_hex_to_int(topics[3]::string) as tokenid,

a.tx_hash,

value as price

from sei.core_evm.fact_event_logs a join sei.core_evm.fact_traces b on a.tx_hash = b.tx_hash

left outer join sei.core.dim_address_mapping c on a.contract_address = c.evm_address

where a.origin_to_address = '0x0000000000000000000000000000000000001002'

and topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

and livequery.utils.udf_hex_to_int(topics[3]::string) is not null

and substr(topics[1]::string, 25 ) != '000000000000000000000000000000000000000000'

and livequery.utils.udf_hex_to_int(topics[3]::string) in (select token_id from sei.nft.ez_nft_sales)

and value != 0

and contract_address not in ('sei1u5y9zyskplm4a6y62sxdhftsat767l6hfmmjvm')

and a.block_timestamp::date >= CURRENT_DATE - INTERVAL '90 DAY'

and b.block_timestamp::date >= CURRENT_DATE - INTERVAL '90 DAY'

,

pallet as ( select block_timestamp::date as date,

tx_id,

seller_address as seller,

buyer_address as buyer,

amount as price,

amount_usd as price_usd,

nft_address as collection_address ,

project_name,

from sei.nft.ez_nft_sales

where tx_succeeded = 'TRUE'

and platform_name ilike '%pallet%'

and block_timestamp::date >= CURRENT_DATE - INTERVAL '90 DAY')

,

price_usd as (select date(recorded_hour) as date,

avg(price) as avg_price