select

count(distinct pool) as total_pools,

count(distinct case when is_liquid = true then pool end) as liquid_pools,

sum(tvl_usd) as total_tvl_usd

from ton.defi.fact_dex_pools

where project = 'ston.fi'

and block_timestamp_last_updated >= '2022-11-19'

),

trading_stats as (

select

count(*) as total_trades,

count(distinct trader_address) as unique_traders,

sum(volume_usd) as total_volume_usd

from ton.defi.fact_dex_trades

where project = 'ston.fi'

and block_timestamp >= '2022-11-19'

select

p.total_pools as "total pools",

p.liquid_pools as "liquid pools",

round(p.total_tvl_usd,2) as "total TVL (USD)",

t.total_trades as "total trades",

t.unique_traders as "unique traders",

round(t.total_volume_usd,2) as "total volume (USD)"

from pool_stats p

cross join trading_stats t

;