Elprognerd04 - n users and txs weekly
    Updated 2022-11-28
    with t1 AS (SELECT date_trunc('week', RECORDED_AT), address, symbol , avg(price) AS price_usd
    FROM osmosis.core.dim_labels x
    INNER JOIN osmosis.core.dim_prices y
    ON y.symbol = x.PROJECT_NAME
    GROUP BY 1, 2, 3)
    SELECT date_trunc('week', block_timestamp),
    CASE WHEN (TO_CURRENCY IS NULL OR TO_CURRENCY ILIKE '%gamm/pool%') THEN 'Dive in Headfirst'
    ELSE 'Wade in Carefully' END AS join_type,
    COUNT(*) AS n_tx,
    COUNT(DISTINCT trader) AS n_user,
    sum((from_amount*price_usd)/pow(10, FROM_DECIMAL)) AS tot_Amount_USD,
    avg((from_amount*price_usd)/pow(10, FROM_DECIMAL)) AS avg_Amount_USD
    FROM osmosis.core.fact_swaps a INNER JOIN t1 b ON a.FROM_CURRENCY = b.address
    WHERE TX_STATUS = 'SUCCEEDED'
    GROUP BY 1, 2
    ORDER BY 1 ASC
    Run a query to Download Data