eth_nft as

(

select

'ethereum' as chain,

date_trunc('{{granularity}}',block_timestamp) as time,

tx_hash as tx_hash,

coalesce(aggregator_name,platform_name) as marketplace,

seller_address as seller,

buyer_address as buyer,

project_name as project_name,

tokenId as token_id,

currency_symbol as currency,

price_usd as price

from ethereum.core.ez_nft_sales

where time between '{{start_date}}' and '{{end_date}}'

),

sol_price as

select date_trunc({{granularity}},recorded_hour) as time,avg(close) as usd from solana.core.fact_token_prices_hourly

where symbol='SOL'

group by time

),

sol_nft as

(

select

'solana' as chain,

date_trunc('{{granularity}}',block_timestamp) as time,

nft.tx_id as tx_hash,

nft.marketplace as marketplace,

seller,

purchaser as buyer,

ad.address_name as project_name,

'0' as token_id,

'sol' as currency,