deevhynweekly trades and users
    Updated 2024-07-04
    SELECT
    date_trunc('week', block_timestamp) AS week,
    COUNT(DISTINCT tx_id) AS trades,
    COUNT(DISTINCT from_address) AS Users
    FROM thorchain.defi.fact_swaps
    WHERE date_part('quarter', block_timestamp) = 1
    AND date_part('year', block_timestamp) = 2024
    GROUP BY 1
    ORDER BY 1
    QueryRunArchived: QueryRun has been archived