SELECT

date_trunc('day', recorded_at) as day,

median(price) as price

FROM osmosis.core.dim_prices

WHERE symbol like 'OSMO'

GROUP BY 1

SELECT

CASE WHEN pool_ids[0] = '812' then 'One Pool Swap' ELSE 'Two Pool Swap' END,

count(DISTINCT tx_id) as events,

count(DISTINCT TRADER) as users

-- date_trunc('day', block_timestamp) as day,

FROM osmosis.core.fact_swaps

LEFT outer JOIN tab1

ON day = date_trunc('day', block_timestamp)

-- LEFT outer JOIN osmosis.core.dim_labels

-- ON TO_CURRENCY = ADDRESS

-- OR FROM_CURRENCY = ADDRESS

--WHERE PROJECT_NAME LIKE 'AXL'

WHERE pool_ids[0] LIKE '812'

OR pool_ids[1] LIKE '812'

GROUP BY 1