select

hour::date as date1,

avg(price) as price

from flipside_prod_db.ethereum_core.fact_hourly_token_prices

where token_address = lower('0xD31a59c85aE9D8edEFeC411D448f90841571b89c')

and hour::date >= '2022-08-01'

group by 1

)

select

a.block_timestamp::date as date,

'Solana' as blockchain,

count(DISTINCT tx_id) as sales_count,

sum(sales_count) over (order by date asc) as cum_sales_count,

count(DISTINCT PURCHASER) as unique_buyer,

sum(unique_buyer) over (order by date asc) as cum_user,

sum(SALES_AMOUNT * price) as volume,

sum(volume) over (order by date) as cum_volume

from solana.core.fact_nft_sales a join price b on a.block_timestamp::date = b.date1

where block_timestamp::date >= '2022-08-01'

group by 1

UNION

select

block_timestamp::date as date,

'Ethereum' as blockchain,

count(DISTINCT tx_hash) as sales_count,

sum(sales_count) over (order by date asc) as cum_sales_count,

count(DISTINCT BUYER_ADDRESS) as unique_buy ,

sum(unique_buy) over (order by date asc) as cum_user,

sum(PRICE_USD) as volume,

sum(volume) over (order by date) as cum_volume

from ethereum.core.ez_nft_sales

where block_timestamp::date >= '2022-08-01'

group by 1