date_trunc('week',block_timestamp) as time,

project_name,

CASE WHEN FROM_AMOUNT*PRICE >50000 THEN 'WHALE'

ELSE 'EVERYDAYUSER' END AS TYPE,

COUNT (DISTINCT TX_ID) AS SWAPS

FROM osmosis.core.fact_swaps,osmosis.core.dim_prices,osmosis.core.dim_labels

WHERE block_timestamp>CURRENT_DATE-30 and osmosis.core.fact_swaps.from_currency=osmosis.core.dim_labels.address

and osmosis.core.dim_labels.project_name=osmosis.core.dim_prices.symbol

and date_trunc('week',osmosis.core.fact_swaps.block_timestamp)=date_trunc('week',osmosis.core.dim_prices.recorded_at)

GROUP BY time,project_name,TYPE order by time