select *

from

ethereum.nft_metadata

where

token_metadata:collection_name::string = 'Chromie Squiggle by Snowfro'

),

info as (

select

created_at_timestamp as time,

token_id as id,

contract_address as contract

from squiggles

),

events as(

select

block_timestamp,tx_id,contract,id,price,price_usd

from info i

left join ethereum.nft_events n on i.contract = n.contract_address and i.id = n.token_id

where event_type = 'sale'

select

count(tx_id) as total_transactions,

max(price) as maximum_eth_price,

max(price_usd) as maximum_usd_value,

avg(price) as avg_eth_price,

avg(price_usd) as avg_usd_value,

median(price) as median_eth_price,

median(price_usd) as median_usd_value

from events