WITH t0 AS (

SELECT date_trunc (hour, block_timestamp) AS date

, COUNT(DISTINCT CASE WHEN swap_from_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' THEN swapper ELSE NULL END) AS unique_sellers

, COUNT(DISTINCT CASE WHEN swap_to_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' THEN swapper ELSE NULL END) AS unique_buyers

, COUNT(DISTINCT swapper) AS unique_swappers

, SUM(CASE WHEN swap_from_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' THEN -swap_from_amount ELSE swap_to_amount END) AS net_swap_amout

, SUM(CASE WHEN swap_from_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' THEN swap_from_amount ELSE 0 END) AS swap_from_amount

, SUM(CASE WHEN swap_to_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' THEN swap_to_amount ELSE 0 END) AS swap_to_amount

, SUM(CASE WHEN swap_to_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' THEN swap_to_amount ELSE swap_from_amount END) AS swap_volume

FROM solana.defi.fact_swaps

WHERE date >= '2024-01-22'

AND (

swap_from_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk'

OR swap_to_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk'

)

AND swap_from_mint <> swap_to_mint

GROUP BY 1

), t1 AS (

SELECT COUNT(DISTINCT CASE WHEN swap_from_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' THEN swapper ELSE NULL END) AS unique_sellers_total

, COUNT(DISTINCT CASE WHEN swap_to_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' THEN swapper ELSE NULL END) AS unique_buyers_total

, COUNT(DISTINCT swapper) AS unique_swappers_total

, SUM(CASE WHEN swap_from_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' THEN -swap_from_amount ELSE swap_to_amount END) AS net_swap_amout_total

, SUM(CASE WHEN swap_from_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' THEN swap_from_amount ELSE 0 END) AS swap_from_amount_total

, SUM(CASE WHEN swap_to_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' THEN swap_to_amount ELSE 0 END) AS swap_to_amount_total

, SUM(CASE WHEN swap_to_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' THEN swap_to_amount ELSE swap_from_amount END) AS swap_volume_total

FROM solana.defi.fact_swaps

WHERE block_timestamp >= '2024-01-22'

AND (

swap_from_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk'

OR swap_to_mint = 'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk'

)

AND swap_from_mint <> swap_to_mint

SELECT *