SELECT

DECODED_LOG:floorToken as fl_token,

DECODED_LOG:collection as c_a

from

ethereum.core.ez_decoded_event_logs

where

contract_address = '0x3eb879cc9a0ef4c6f1d870a40ae187768c278da2'

and event_name = 'NewCollectionSupported'

),

price as (

SELECT

c_a,

date as day,

(avg(ETH_AMOUNT / NFT_TOKEN_AMOUNT)) * 1000000 as token_price

FROM

(

SELECT

block_timestamp :: date as date,

tx_hash,

CASE

when symbol_out = 'WETH' then AMOUNT_OUT

when SYMBOL_IN = 'WETH' then AMOUNT_IN

end as eth_amount,

CASE

when symbol_out = 'WETH' then TOKEN_IN

when SYMBOL_IN = 'WETH' then TOKEN_OUT

end as NFT_token,

CASE

when symbol_out != 'WETH' then AMOUNT_OUT

when symbol_in != 'WETH' then AMOUNT_IN

end as nft_token_amount

FROM

ethereum.defi.ez_dex_swaps

WHERE

TOKEN_IN in (