t1 as (

trunc(x.block_timestamp,'day') as date,

count(distinct x.tx_id) as transactions,

count(distinct x.signers[0]) as active_users,

transactions/active_users as avg_tx_per_user,

sum(fee/pow(10,6)) as fees,

avg(fee/pow(10,6)) as avg_tx_fee

from solana.core.fact_transactions x

where x.block_timestamp>=current_date-INTERVAL '1 MONTH'

group by 1

),

t2 as (

select

trunc(y.block_timestamp,'day') as date,

count(distinct y.tx_id) as swaps,

count(distinct swapper) as swappers,

swaps/swappers as avg_swaps_per_swapper

from solana.core.fact_swaps y

where y.block_timestamp>=current_date-INTERVAL '1 MONTH'

group by 1

),

t3 as (

select

trunc(z.block_timestamp,'day') as date,

count(distinct z.tx_id) as nft_sales,

count(distinct z.purchaser) as nft_buyers,

nft_sales/nft_buyers as nft_bought_per_user

from solana.core.ez_nft_sales z

where z.block_timestamp>=current_date-INTERVAL '1 MONTH'

group by 1

)

SELECT

t1.date, transactions,active_users,avg_tx_per_user,fees,avg_tx_fee,swaps,swappers,avg_swaps_per_swapper,

nft_sales,nft_buyers,nft_bought_per_user